Show Random Thread from a Category on a non-vb page

[smdani]

I would like to build a 'quote of the day' system with vb.
I would like to select randomly a thread from a category and show his title on an non-vb page.
Does anyone help me?
Thanks a lot!!

[smdani]

any idea?

[Andreas]

[sql]
SELECT * FROM thread
LEFT JOIN post ON (post.postid = thread.firstpostid)
WHERE forumid IN (1,2,3,4)
ORDER BY RAND()
LIMIT 1
[/sql]

Where 1,2,3,4 are the ForumIDs where the thread should come from.
If you don't need the actual post you can leave out the join.

[GuppyWithAGun]

how would you mkae it so that the bb code will show?

[Andreas]

parse_bbcode2() in functions_bbcodeparse.php

[smdani]

it works like a charm!!
What I do is to make a .php file that obtains a random thread from a category, and download that file with a cron entry day by day into an html file. So, I obtain a 'quote of the day system'.

Thanks a lot