the bets way to have the last 10 posts

[pablo]

on vb2.x someone made a cool script to get the last ten threads that had been posted to. called last10.php or something.

Well i want the same effect on my forum home. It seems that with the external.php included with vb3.x you only get the last new threads, as it it is not updated when someone replies to an existing thread.

I've gone looking around the place @ tonyshawk's one and others. What do people use/recommend ?

thanks,
p

[pablo]

Originally Posted by pablo

on vb2.x someone made a cool script to get the last ten threads that had been posted to. called last10.php or something.

Well i want the same effect on my forum home. It seems that with the external.php included with vb3.x you only get the last new threads, as it it is not updated when someone replies to an existing thread.

I've gone looking around the place @ tonyshawk's one and others. What do people use/recommend ?

thanks,
p

anyone ??? *bump*

[g-force2k2]

[sql]SELECT DISTINCT t.threadid, t.title,
p.userid, p.username, p.postid
FROM " . TABLE_PREFIX . "post p
LEFT JOIN " . TABLE_PREFIX . "thread t USING (threadid)
ORDER BY dateline DESC LIMIT 10[/sql]

Perhaps a query like this? Haven't tested it though.

Cheers,
g-forcek2k2

[pablo]

cheers g-forcek2k2,
But how would i make a php file that I could include it just to call this query and order it in some nice fashion.

I must say I am surprised that nobody has released such a hack yet.