Log in

View Full Version : Topics Anywhere for vBulletin ?!


f-body
02-08-2005, 05:25 PM
Hello!

Where can I find a mod/script like phpBB Topics Anywhere for vBulletin ?!
http://www.afsvlaanderen.be/topics_anywhere/download.php

I'd like to display the latest 5 posts, topic titles, author username and time/date on my front page.

Andreas
02-08-2005, 05:37 PM
SELECT * FROM post
LEFT JOIN thread ON (thread.threadid = post.threadid)
ORDER BY post.dateline DESC
LIMIT 5


But keep in mind that this does not take care of permissions and deleted posts/threads.
If you want to take care of this it will get a bit more difficult.