>
New Topic
>
Reply<
Esato Forum Index
>
General discussions >
Esato forum
> Random thread
Bookmark topic
Garbage threads are included.
A simple SQL statement did the trick: "SELECT id FROM topics ORDER BY RAND() LIMIT 1" in addition to some access restriction stuff for the mod forum. Deleted threads will not turn up.
--
Posted: 2004-01-21 20:11:58
Edit :
Quote
Now Ima play 'gamble' until I turn a real old fun garbage thread up
thnx laffen
another potentially boring evening saved
(oh god I am pathetic
)
--
Posted: 2004-01-21 20:17:32
Edit :
Quote
oh yes, I never had a commercial use for the rand function in 15 years of RDB sql programming so didn't even think of that!
nice solution!
I guess I'll have to try harder to catch you out next time
--
Posted: 2004-01-21 20:27:19
Edit :
Quote
This random function will really help me through boring days at work
It sure helped a lot today
A link to the random topic function should only be added to the forum homepage.
That way even people like Deanlambert that doesnt use search will find it too
@Deanlambert: You should try the search.. its really addictive
--
Posted: 2004-01-21 23:03:54
Edit :
Quote
here is a random answer dont
This message was posted from a WAP device
--
Posted: 2004-01-23 17:41:45
Edit :
Quote
Quote:
On 2004-01-21 11:14:22, laffen wrote:
Try this one
http://www.esato.com/board/randomtopic.php
Hi,
I'm looking for a thread randomizing script (php) to use on my board. I found yours using google. Is it possible to get a copy of this script? Thanks.
--
Posted: 2004-03-12 04:45:32
Edit :
Quote
New Topic
Reply
