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.

[BBR-APBT]

https://vborg.vbsupport.ru/showthread.php?t=176297

That works for the error every one is having just change the following code.

Change this.
ORDER BY lastpost DESC $tlimited");

to this
ORDER BY dateline DESC $tlimited");