I'd like to display the hottest/newest threads on the main page of my site from my message boards. Right now, I'm having to manually update them on a weekly basis. How would I go about doing this? Something like SitePoint does on their main page would be close to what I'm looking for. Thank you.
Right where you would expect it: on the vBulletin.com Support Forums. :) I think this should help - buried in there should be what you're looking for.
The hack is called Active Topics. vBulletin.org might have a later version, or a direct link - havn't checked. If it isn't quite what you're looking for, just search for "active topics" in the vBulletin Code Hacks forum.
EDIT: I think this belongs in one of the other forums - either Advanced Internet Development, or PHP/MySQL. :)