Latest Threads on Forum Page

[youssef87]

Hello,

Running vB 3.8

Wanted to know if anyone can point me to a mod that will display the latest threads on the front page

[Lynne]

Did you try a search on "thread*" in "all mods" "titles only"?

[youssef87]

Yes but I can't really find anything.

What I want is to put on the right side of my forum "Latest Posts"

I have that now, but this is how it looks.

Topic 1
By: User1

Topic 1
By: User 2

I want it to just show the topic, with the latest user post. Not to keep showing the same thread by a different user. Such as,

Topic 1
By: User 1

Here is the query, if anyone knows how to edit this so that it can work how I want it, would really help :)

$query = $vbulletin->db->query_read("
SELECT post.postid, post.pagetext, post.userid, post.username, post.visible, thread.forumid, thread.title as thread_title, thread.threadid, forum.forumid, forum.title as forum_title
FROM " . TABLE_PREFIX . "post as post
LEFT JOIN " . TABLE_PREFIX . "thread as thread on (post.threadid = thread.threadid)
LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid)
WHERE post.visible = 1 AND $latest_and AND $latest_and_1
ORDER BY postid DESC
LIMIT $limit"

[fogjuice]

I too have been searching for a mod that does this but cannot find it. Before I converted to vBulletin, I was using a phpBB mod that did just this. At the top of the forum it would display X amount of the latest threads. I've seen a few mods on here that show the newest threads but from my experience, users want to be able to see threads that have latest replies.