vb.org Archive - Latest Discussions...

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

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

- - Latest Discussions... (https://vborg.vbsupport.ru/showthread.php?t=180091)

nando99

05-22-2008 01:05 AM

Latest Discussions...

I've found mods for 3.6.8 that allow you to show the latest posts and latest threads but they're not what I'm looking for.

The latest thread shows the newest thread only and the latest posts shows the latest post but shows the post twice (or as many times as its been replied to) if its the latest post.

I'm looking for something that shows the latest post without showing the same post twice, only show the latest post of that post...

Let me know if I confused you :confused:, thanks in advance...

nando

Dismounted

05-22-2008 05:54 AM

[sql]SELECT threadid, title, lastposter
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
ORDER BY lastpost DESC
LIMIT 10[/sql]

nando99

05-22-2008 05:13 PM

Quote:

Originally Posted by Dismounted (Post 1527630)

[sql]SELECT threadid, title, lastposter
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
ORDER BY lastpost DESC
LIMIT 10[/sql]

Umm..... not to sound like total noob - but what do i do with that?

MoT3rror

05-22-2008 07:56 PM

That is the sql you need to run to get the latest threads on a page not including posts.

nando99

05-23-2008 12:35 AM

Still not understanding what I need to do....

I run this in phpmyadmin? or? Please explain from start to finish as I'm having a mindfart and have no idea what I should do... thanks.

Dismounted

05-23-2008 09:51 AM

You need to run that query to fetch the information you want. You will need at least some PHP knowledge.

All times are GMT. The time now is 04:56 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01612 seconds Memory Usage 1,716KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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: