[JasonGD]

Originally Posted by fogjuice

I tried to mod this so it shows latest threads with replies rather than just the newest posts but I now have a problem with the caching. Everytime a new reply shows up, it goes to the top of the list and that is fine but after the I read the thread it still stays bold with this mod until I log out and log in again.

Code to show latest thread with replies, not just newest posts:

$gthreads = $db->query_read("SELECT 
        thread.title, thread.taglist, thread.prefixid, thread.taglist as tag, thread.threadid, thread.attach, icon.title AS icontitle, icon.iconpath, thread.lastpost, thread.lastpostid, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, forum.title_clean as forum_title 
        FROM " . TABLE_PREFIX . "thread AS thread 
        LEFT JOIN  " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter) 
        LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid) 
        LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = thread.iconid) 
        WHERE NOT ISNULL(thread.threadid) 
        $excludedforums AND thread.visible = 1 ORDER BY lastpost DESC LIMIT 0, $tvpano_lt_max");

Where it says ORDER BY you have to change it to lastpost, previously it said dateline.

That worked perfect, thanks! Installed.