[Boofo]

Originally Posted by dndog

Logician, my forum tables have the prefix vB3_. Your hack assumes there is no prefix and can't find the post table. I sifted through the code but can't figure out what I need to change to fix this. What should I do?

Change this:

PHP Code:

 $post_db=$DB_site->query("SELECT p.dateline, p.title, p.pagetext, p.userid, user.username from post p LEFT JOIN user on user.userid=p.userid WHERE threadid=$threadid AND visible=1 ORDER BY dateline ASC"); 


To this:

PHP Code:

$post_db=$DB_site->query("SELECT p.dateline, p.title, p.pagetext, p.userid, user.username from " . TABLE_PREFIX . "post p AS post p LEFT JOIN " . TABLE_PREFIX . "user AS user on user.userid=p.userid WHERE threadid=$threadid AND visible=1 ORDER BY dateline ASC");