trying to return the first shoutid as a number from the shoutbox hack

[sabret00the]

php tags are you're friend, but only cos i'm incompetant and it's late.

anyway from what i read before i started getting confused, you can do it all in two queries

PHP Code:

$shoutbox_num = $DB_site->query("SELECT MIN(shoutid) AS min, SELECT MAX(shoutid) AS max FROM shoutbox_posts");
$shoutbox_posts = $DB_site->query("
    SELECT s.*, u.username AS absusername
    FROM shoutbox_posts AS s 
    LEFT JOIN user AS u ON (s.userid = u.userid) 
    WHERE (deleted = 0 OR deleted IS NULL)
    AND shoutid > (($shoutbox_num[max] + shoutbox_num[min]) - $vboptions[shoutbox_numberofforumhomeshouts])
    ORDER BY shoutid ASC
"); 


==================================

you don't need the below code

==================================


you're problem here is that

PHP Code:

$firstshoutid = mysql_query('SELECT shoutid from shoutbox_posts LIMIT 1'); 


should've been

PHP Code:

$firstshoutid = $DB_site->query_first('SELECT shoutid from shoutbox_posts LIMIT 1'); 


you need to conform to vBulletin querying methodlogy is that even a word