GReat Hack Lesane.

Thanks again

ok have a question... my site has over 10k members and about 1/2 are not active. is there a way to pick a winny out of the tickets sold rather then from all the members. couple be weeks before someone wins.

also how does this stop people from creating bogus accounts just to buy another ticket?

great idea just thinking aloud...

ok this is a great hack, will be using it in the near future!
would it not be better to create another table, which contains all the people who enter, so a user may get multiple entrys into the lottery! simply his user name will go into the table, and the script will choose, that way the more tickets a users buys the more chance he/she has off wining!

also I have another idea, a bit like the above but instead it would be like entrying points to win a DVD, A Game, or something! you can create your own prize, where people enter their points to win stuff...

thanks for the great hack!

whenever i try to buy a lottery ticket it always says this

Invalid SQL: UPDATE store SET quantity=quantity-1 WHERE id=10
mysql error: Unknown column 'quantity' in 'field list'

mysql error number: 1054

Date: Thursday 20th of June 2002 06:10:37 PM
Script: http://www.animexplosion.com/forums/forums/store.php
Referer: http://www.animexplosion.com/forums/...action=lottery

Lesane, I fixed the error problems. Thanks for the nice hack and your help.

My start dates are set wrong. Like in 1969. The money in the Jackpot don't show up either. How do I fix this?

Lesane, a question, what's the postbit or link code for "richest" person? I want to display the "richest person" on my forum home.

well I am also having probs even with the new sql query code

Like they said before "God of Hacks" :D

Great hack!

Question...

When the lottery is ended is there a way to reset the tickets purchased so the ones in the previous Lotto have to buy again?

Hopefully I am clear about what I mean... Just tring to keep it interesting for the people "in" cause if for exp. it takes a month for anyone to win they won't be able to participate for a month