[Boofo]

Originally Posted by surfhog

funny you say that boofo, i suspected as much myslef after i posted here.
yes I have seen these on several vb3 boards, so it must work and i do feel it would be a worth while modification to have on any board, hence my persistance.

i wonder if i am the only one having/had problems with these?
okay i will disable for now and await further instructions
thank you

Here's your fix for this hack. It seems that this only affects those with table prefixes and since I don't use a table prefix as well as a lot of others, I didn't have any problem with this query. This will take care of it for you.

Replace the top poster code in the forumdisplay.php with this:

PHP Code:

    $topposter = $DB_site->query_first("
        SELECT user.userid, user.username, COUNT(post.postid) AS postcount
        FROM " . TABLE_PREFIX . "post
        LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
        WHERE thread.forumid=$forumid
        GROUP BY post.userid
        ORDER BY postcount DESC
        LIMIT 1
    "); 


Again, thanks to NTLDR for filling me in on this.