Lottery Addon For The Store Hack

Info:
This addon for the store hack gives you the ability to add a Lottery on your store. A lottery with the same principles as a normal lottery. Users buy a lottery ticket in the store and after the specified enddate you or any other admin execute the lottery script in the admincp wich search for a random user from the database and checks if the user bought a ticket and if so then he will receive the jackpot if not then the lottery stays online.

The jackpot will be increased with the amount of the lottery ticket everytime when a new member buy's a ticket.

What to do:
2 Query's: 1 new table, 1 new row.
3 File Edit's: Admin/Index.php, Store.php & Storeadmin.php
1 Template Edit: Store_bit
2 New Templates: store_lottery_error & store_lottery_updated

Some Features:
- A new action on the store: Lottery
- Winner will be picked randomly
- Winner will be pm'ed with a winner's message
- Losers will be pm'ed with a loser's message
- Define Start Date of the lottery
- Define End Date of the lottery
- Define title of the lottery
- Define the amount of a ticket
- Maximum of 1 Ticket Per User
- And more....

This lottery addon will only work with the latest version of the store hack and is compatible with any Vbulletin 2.*.* version.

Have fun with the addon,
Lesane.

[Alfo]

GReat Hack Lesane.

Thanks again

[trainer]

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...

[-=Sniper=-]

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!

[ULTIMATESSJ]

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

[Peace]

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

[Itworx4me]

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

[Peace]

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

[MrBojangle1]

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

[CHoooo]

Like they said before "God of Hacks"

[Limpkinw]

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