Posted by floke
I'm a bit bored at work and have now read most esato threadtitles of the last 24h without finding something really intresting...
What about having a link you can click to get a random old thread.
It would be one way of killing some time
What do you think about it?
Posted by Deanlambert
Not a bad idea. But don't think it would work.
Posted by floke
I cant see why it wouldnt work. I've seen other sites having this function... cant think of anyone rightnow though...
Posted by laffen
Try this one http://www.esato.com/board/randomtopic.php
Posted by BobaFett
Yes, why not?!? Contact 1 of d moderators and ask if its poss. Reg
Posted by Deanlambert
Still can't see it work, but then again i'm often wrong.
Posted by masseur
guys, laffen posted a link providing your random thread 3 replies back in this topic! pay attention
Posted by Deanlambert
Oh well. Don't know why i can't see it working, but you never know.....
Posted by floke
@laffen: thanks for the link. You'se saved my day
Never seen that before is it new?
Search didnt give any result on "random topic"
Posted by Deanlambert
Do you use the search option! I'VE FOUND THE PERSON! What do i win?
Posted by laffen
@floke
Yes, it's new
Posted by stewie
great idea floke and @laffen
tnx.nice job... :)
Posted by Deanlambert
At least on this site the people behind the scenes actually respond to requests. Unlike some other sites i could mention.
Posted by tranquil
On this site the people behind the scenes are there to do our best to help as best we can.
I'm sure other sites are the same thoug.
Posted by evoke
nice idea!
Posted by Deanlambert
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.
Posted by pachy
@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
Posted by Vlammetje
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?
Posted by masseur
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
Posted by Deanlambert
In other words anything i have posted! See I've said it before you :-D
Posted by laffen
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 by Vlammetje
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 by masseur
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 by floke
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 by marlonxp
here is a random answer dont
Posted by kurt04
| Quote: |
|
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.