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.

[Dean C]

I dont like the way this hack selects users from the whole database of users and not those who have just chosen a ticket..

With over 1000 users it takes AGEEEEEESSSSSSS..

Why not have it just select from those users who have purchased a ticket

Regards

- miSt

[Schorsch]

how can I change the hardcoded colors ?

[Limpkinw]

Originally posted by Mist
I dont like the way this hack selects users from the whole database of users and not those who have just chosen a ticket..

With over 1000 users it takes AGEEEEEESSSSSSS..

Why not have it just select from those users who have purchased a ticket

Regards

- miSt

And here is how to stop this and it works GREAT

https://vborg.vbsupport.ru/showthrea...956#post263956

[partang2]

Originally posted by Mist
I dont like the way this hack selects users from the whole database of users and not those who have just chosen a ticket..

With over 1000 users it takes AGEEEEEESSSSSSS..

Why not have it just select from those users who have purchased a ticket

Regards

- miSt

Agree 100%!

Originally posted by Limpkinw


And here is how to stop this and it works GREAT

https://vborg.vbsupport.ru/showthrea...956#post263956

Woops! There it was.... Thanks m8! :banana:

[girlzclan]

Originally posted by Lesane
Yes, that query was taken away in the new version.

You'll need to find this piece of code now:

PHP Code:

if($showimg=="Y") { 


File in 1st post updated.

perfect!!! THANK YOU VERY MUCH :d

[AZone]

Thanks, it works!

But I have one problem - information about Lottery (when I press "Lottery Options) always display twice. The same when I try to edit lottery, or view user who bought tickets - always twice...

[AZone]

Actions
Lottery Name Money In The Jackpot Start Date End Date # Sold Already Modify
Lottery 40 2002-11-15 00:00:00 2002-11-16 00:00:00 1 [Edit] [View Users] [End Lottery/Pick Winner]

Actions
Lottery Name Money In The Jackpot Start Date End Date # Sold Already Modify
Lottery 40 2002-11-15 00:00:00 2002-11-16 00:00:00 1 [Edit] [View Users] [End Lottery/Pick Winner]

<!-- Like this - always the same things twice

[AZone]

Also I have another mistake after end of lottery:
<!--

Updating user, set storeaction to offline and delete lottery and lotteryusers...

'User' is rewarded with 20 points.
'User' is pm'ed with the winner's message.
Lottery action on the store is set to offline.
Lottery and his users are deleted.

Done!

Updating user, set storeaction to offline and delete lottery and lotteryusers...

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET storep=storep+ WHERE userid='1'
mysql error: You have an error in your SQL syntax near 'WHERE userid='1'' at line 1

mysql error number: 1064

--!>

[traekwon]

Yes, Lesane PLEASE PLEASE PLEASE make it so when drawing for the winner, it only searches through a list of people who bought a ticket.

[AsedaH]

nevermind.wrong thread