[Romeos Tune]

Thanks C! What an awesome hack.... These were all ok..... threadid, forumid, title, replycount, lastposter, postuserid, postusername. It was the "thread" that needed to be changed and I must've been tired last night because I was changing it or so I thought... Changed it again this morning and it works perfectly! Thanks again!

Originally Posted by C.Birch

in marquee.php

find:

// connect to the database and pull the info we need.

$latestposts = $DB_site->query("
SELECT threadid, forumid, title, replycount, lastposter, postuserid, postusername
FROM thread
ORDER BY lastpost
DESC LIMIT " . THREAD_LIMIT . ""
);

and if your prefix it vb3 replace the above with:

// connect to the database and pull the info we need.

$latestposts = $DB_site->query("
SELECT vb3_threadid, vb3_forumid, vb3_title, vb3_replycount, vb3_lastposter, vb3_postuserid, vb3_postusername
FROM thread
ORDER BY lastpost
DESC LIMIT " . THREAD_LIMIT . ""
);