Latest Threads as forum block/sidebar

[laebshade]

I've been searching high and low to find a way to do this: scouring this board/mods, but also on Google. I've found a way to include the latest threads in a non-vbulletin/plain html page, but that isn't what I want to do; I want to display the latest threads on the forum sidebar.

See, the ride forum I belong to, http://zzrbikes.com , used phpnuke previously. I migrated the site (still working out kinks) to vbulletin 4.0 suite. One of the issues the members have is the sidebar doesn't show the latest threads. The way phpnuke/phpbb2 showed the latest threads was it showed only the threads, not individual posts, and the person that last posted to the thread, and the date/time of the last post.

Is it possible to do this with vBulletin 4.0?

To recap: show on forum sidebar, 20 latest threads, not individual posts, that either have no reply or replies, in chronological order, and shows the last person who replied next to/below it, along with date/time.

is this doable?

Edit: you can view the way it currently shows by going to http://zzrbikes.com/forum.php and looking on the left sidebar. It shows the last 20 posts, not threads, and multiple posts from the same thread will show up in the sidebar.

[Lynne]

Yes, it's doable. If you don't want to use the existing New Threads forum blocks (which doesn't allow you to only show replyless threads), then just create a PHP block and write your own query to grab the threads with that criteria.

[laebshade]

Thank you for the quick reply. Do you have on hand a query that will do this, or can you tell me which table/fields I need to query to get the data?