vb.org Archive - Last 10 Posts

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

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

- - Last 10 Posts - Please help (https://vborg.vbsupport.ru/showthread.php?t=62270)

uasound

03-08-2004 01:09 AM

Last 10 Posts - Please help

I've searched the forums hundred times and didn't find the hack that would do this

I needd to show last 10 threads with the latest posts.

I have this SQL

Code:

SELECT DISTINCT thread.threadid, 

post.postid, post.username, thread.title FROM post, thread WHERE thread.threadid = post.threadid ORDER BY post.dateline DESC LIMIT 10

But it will repeat the threads and the list will show same thread several times.

How do I make this work?

Thanks, appreciate your help!

uasound

03-08-2004 12:19 PM

Anyone?

Pimboli

03-12-2004 04:05 AM

I need it too :(

heynurse

03-12-2004 06:32 PM

I am also looking for an easy way to show the last 10 post etc... I am using vb3, when i used vb2, there was a cool hack that would display the last XXX amount of post on a non-vb page, I haven't found one of those for vb3 yet, I'm sure it's around, just haven't located it yet :)

Found the hack: https://vborg.vbsupport.ru/showthrea...&highlight=vb3

EDITED TO ADD: I just found out that this same script can work with VB3, just need to modify the paths in the config file.

Mhaddy

03-18-2004 09:13 PM

Yep - I'm running vB3 RC 4 and with a little modification of the paths, this works :).

All times are GMT. The time now is 04:47 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01193 seconds Memory Usage 1,714KB 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 (5)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: