Pull usernames from thread

[jason559]

I want to run a contest where users reply to a thread I started and then I randomly choose a winner from the list of users who posted. I can't seem to find a way to do this. Can anyone point me in the right direction on how to do it or a module that I can get that would?

Thank You

[Millenium IT]

I guess this is a bit of an unorthadox sullotion, but heck its a sullotion non the less. What your gonna have to do, is go through your thread, and copy + paste all the usernames who replied into the text file called 'names.txt' , ensuring that each name is copied line by line. In other words, its username + enter + username + enter and so on. After that, just run this app and it'll randomly select a username and it will be the winner :)

[Ducks]

You could also select directly from the database, not exactly sure how it should looks but something like:


SELECT `username`,`userid` FROM `vb_posts` WHERE `threadid` = $threadid LIMIT 1 ORDER BY RAND()

[jason559]

Thanks for the replies. I'm not sure exactly how to use that PHP code, I have PHPMySQLAdmin, can someone tell me how I could do it in that?

I'm up to about 13 pages of entries and I'm going to paste the usernames into randomizer.org, I like to use that because it is an unrelated third party and people can see who they are, etc...