Latest Threads as forum block/sidebar
 

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.

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.

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?