| Author |
Random thread |
Deanlambert
Joined: Sep 10, 2003
Posts: 466
From: East Yorkshire
PM |
No arguments from me on that 1. I've never had a problem on here. I honestly thought that the random thread wouldn't work on here. Looks like i was wrong. The only reason why i stay on this site is because problems are quickly sorted out. I know we all have a joke when the site goes down etc, but you have to have a laugh now and then. I've been proved wrong. I admit it.
This message was posted from a T300 |
|
|
pachy
Joined: Nov 05, 2002
Posts: > 500
PM |
@Deanlambert, i thought you said RANSOM, lucky i checked again, i was on the verge of sending you ONE MILLION POUNDS IN USED NOTES to free the hostages in time for Easter, those poor souls need a shave & a hot meal, ....can i recommend a dish of Chicken Malabar £5.75;
(specialy cooked in North Kerala this Southern Indian tender chicken meal is cooked in roasted coconut sauce with tomato, spices & curry leaves),
Maybe with a Alo parata bread £1.75 (hot bread stuffed with Potato & herbs).
Best order 5 meals as this will easily serve 6 people.
Ask for a jug of tap water as the beer is a complete stitch 
Reminder; milk, sugar, crisps, post letter. |
Vlammetje
Joined: Mar 01, 2003
Posts: > 500
From: Den Haag
PM, WWW
|
 pachy 
Laffen thanks...... although not necessarily useful I have just 'zapped' myself an Apple Theme thread and a thread for Siemens S55 users (Kerry where art thou?? ) so that was good fun
How did you do that so fast? 
This is fun. Are garbage threads included in the random draw? 
|
masseur
Joined: Jan 03, 2003
Posts: > 500
From: Sydney, London
PM |
well I don't know php but I guess it was just a matter of generating a random number between 1 and n where n is the current maximum topic number and then appending that number to
http://www.esato.com/board/viewtopic.php?topic=
to give the final url for the random thread.
It occurred to me that some threads have been deleted so I have been trying to foil it but so far no luck maybe it was coded a bit cleverer to loop until a succesful thread was found 
|
Deanlambert
Joined: Sep 10, 2003
Posts: 466
From: East Yorkshire
PM |
In other words anything i have posted! See I've said it before you :-D
This message was posted from a T300 |
laffen
Joined: Aug 07, 2001
Posts: > 500
From: Oslo, Norway
PM |
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. |
Vlammetje
Joined: Mar 01, 2003
Posts: > 500
From: Den Haag
PM, WWW
|
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  )
|
masseur
Joined: Jan 03, 2003
Posts: > 500
From: Sydney, London
PM |
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
|
floke
Joined: Jan 23, 2002
Posts: > 500
From: Sweden
PM, WWW
|
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 |
marlonxp
Joined: Dec 11, 2003
Posts: > 500
From: Somewhere
PM, WWW
|
here is a random answer dont
This message was posted from a WAP device |
kurt04
Joined: Mar 12, 2004
Posts: 1
From: Vermont, USA
PM |
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-01-21 12:25
