Forum Home Enhancements - Latest Thread - Forum Home

Latest Thread - Forum Home

What this does?

This will latest x thread on to your forum home

Modifications Info Plugin : 3
Phrases : 28
Template : 2
Setting : 8

v1.0 - First release
v1.0.1 - small change

[StormLily]

The download link isn't even working.

[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.

[scratchit]

thank you very much

[Markets Where]

I have install the plugin, but every thread show 2 times.
http://www.glasses123.net/forums/

[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.

[Oria]

I try to show this code not at the HOMEPAGE, but i don't know how.

how i can put this at any page in my forum ?

[vtck]

If there is a text box to insert url where this latest x threads to be display then this mod would be very popular.

[NinjaKane]

Seems like this is dead, anyone reading this? how could you move the position of the table? right now it pops up right under the nave bar...can you point me in the right direction to move it?

[s.sami]

can auto refresh ?

[mapleleaffans]

Great mod! Installed, thank you!