vb.org Archive - Latest Threads on Forum Page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Latest Threads on Forum Page (https://vborg.vbsupport.ru/showthread.php?t=213738)

youssef87

05-15-2009 06:26 AM

Latest Threads on Forum Page

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

05-15-2009 02:18 PM

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

youssef87

05-20-2009 08:07 PM

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 :)

Code:

        $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

05-26-2009 02:48 AM

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.

All times are GMT. The time now is 08:16 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01623 seconds Memory Usage 1,715KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: