Displaying latest threads on homepage

[Jaycee29]

I know this has been covered a lot, but all the solutions I've seen have been using RSS/JS and external.php. I would much rather embed PHP/SQL into my non-forum scripts to access the data directly. This would give me much more flexibility in the display of the threads.

I could write the SQL to pull the data I need, but I need the code vBulletin uses to parse bbcode and truncate longer posts correctly without causing bbcode fragments (eg: opening a bold tag without closing it, etc.).

Any help or links to other threads would be much appreciated.