| fogjuice |
05-17-2009 04:11 AM |
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:
Code:
$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. |
More Information