PDA

View Full Version : Raffle for forums members


SVTBlackLight01
02-04-2003, 11:55 AM
I did a search, but coudn't find anything.

Is there a hack that would allow a random drawing from the member database so that forum members can win prizes?

I want to set up a system where my members can win gift certificates etc. from some of my sponsers.

filburt1
02-04-2003, 02:01 PM
It's really simple so I don't know if you even want a hack. Just try this query:

SELECT userid, username FROM user ORDER BY RAND() LIMIT 1

SVTBlackLight01
02-04-2003, 08:41 PM
That was too easy.

Here is a challenge. How would you make it so that the "odds of winning" would increase by post count?

SVTBlackLight01
02-12-2003, 02:40 AM
Come on!! Nobody wants to give it a try? I think this would be cool. :cool:

EchoHype.com
02-12-2003, 05:27 PM
Hey SVT

I am working on a custom mod for my boards which will take into account(and increase their chances of being pulled) by: referrals, posts, threads started, activeness on the boards, etc. It will also deduct a percentage for spamming, warnings, problems, etc.

So if I decide to release it publicly I"ll let you know!

SVTBlackLight01
02-12-2003, 09:35 PM
That sounds great! Exactly what I was looking for. Let me know when you get it working. :banana:

SVTBlackLight01
04-17-2003, 11:15 PM
02-12-03 at 07:27 PM EchoHype.com said this in Post #5 (https://vborg.vbsupport.ru/showthread.php?postid=353446#post353446)
Hey SVT

I am working on a custom mod for my boards which will take into account(and increase their chances of being pulled) by: referrals, posts, threads started, activeness on the boards, etc. It will also deduct a percentage for spamming, warnings, problems, etc.

So if I decide to release it publicly I"ll let you know!

Any update on this? :)

Alien
04-20-2003, 12:23 AM
I'd love to see this too. :)