graham_w
03-24-2009, 06:32 AM
Hi
I run some competitions on my forum, where the only stipulation is that the user replies to the thread to enter. What I would like to be able to do, is create a list of all the usernames who have replied to a particular thread by using something perhaps as simple as an SQL query.
What I currently do is go through the thread and cut and paste names of people who have replied and enter them into a randomizer of some description and pick a random winner. This request for a list of names will cut down on the manual work.
Is someone able to assist with the necessary SQL syntax to use to create this list ? Or suggest another way to do what I am after ?
Thanks
Graham
--------------- Added 1237880957 at 1237880957 ---------------
After a bit more searching, i can't believe how easy this is.
Click on the number of replies and it brings up a list of users and the number of times they have replied. I've used vBulletin for a few years now and never realised that existed :)
I run some competitions on my forum, where the only stipulation is that the user replies to the thread to enter. What I would like to be able to do, is create a list of all the usernames who have replied to a particular thread by using something perhaps as simple as an SQL query.
What I currently do is go through the thread and cut and paste names of people who have replied and enter them into a randomizer of some description and pick a random winner. This request for a list of names will cut down on the manual work.
Is someone able to assist with the necessary SQL syntax to use to create this list ? Or suggest another way to do what I am after ?
Thanks
Graham
--------------- Added 1237880957 at 1237880957 ---------------
After a bit more searching, i can't believe how easy this is.
Click on the number of replies and it brings up a list of users and the number of times they have replied. I've used vBulletin for a few years now and never realised that existed :)