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.

[Peace]

Originally posted by Peace
I'm getting errors and the "lottery Option" link/Page in the AdminCP can't be found. I followed the directions carefully. Help me solve these problems.


Parse error: parse error in /home/www/theonlinelounge/forums/store.php3 on line 2

Parse error: parse error in /home/www/theonlinelounge/forums/admin/storeadmin.php3 on line 3


When I click on "Lottery Options" in the AdminCP, I get this error

The page cannot be found

Hi, Lesane, can I get some help with these errors? Thanks.

[Lesane]

Originally posted by LightBringer
Hey Lesane... Great hack.

For some feedback, I'd like to let you know that a small bug is found with the "starting Jackpot" count.

I started the count with 5000 and then bought one ticket.

Since I was the only user that bought it...I won.

Well..I was awarded the cost of the ticket...not the cost of the ticket + the starting Jackpot

My understanding was the inital jackpot count would be given...if this is incorrect..please let me know.

Thanks.

Ieek, didn't thought about the starting jackpot amount.

Here is the fix, open admin/storeadmin.php and find:

PHP Code:

$totalp = $DB_site->query_first("SELECT COUNT(userid) AS usert FROM storelottery WHERE lotnumber=2");
$usertotaal = number_format($totalp[usert]);
        $kutje=$usertotaal*$costt; 


And Replace It With:

PHP Code:

$jack=$DB_site->query_first("SELECT * FROM storelottery WHERE lotnumber=1");
$kutje=$jack[jackpot]; 


Thanks for letting me know, Txt file in 1st post is updated.

[Lesane]

Originally posted by Lovaboye
never mind its cool, but if we wanted to change the ammount of tickets a person can buy what do we change?

It's made so that an user can buy 1 ticket per lottery. There is no purpose for buying more tickets since it takes a random user from the user table and the winner will only get rewarded once. The only difference is that when someone bought more tickets, for example 3, the he will be pm'ed 3 times.

[Lesane]

Originally posted by Itworx4me
This Query doesn't work:
INSERT INTO store VALUES (NULL, 'lottery', 'Buy A Ticket For The Lottery Entitled: ', '20', '0', 'lottery.gif', 'Buy a lottery ticket and hope that you will win the jackpot.', 'N','0');

Get this error when applying to database:
SQL-query :

INSERT INTO store VALUES (NULL, 'lottery', 'Buy A Ticket For The Lottery Entitled: ', '20', '0', 'lottery.gif', 'Buy a lottery ticket and hope that you will win the jackpot.', 'N','0')

MySQL said:


Column count doesn't match value count at row 1

I suggest you to upgrade to the latest store version

Meanwhile, use this query:

PHP Code:

INSERT INTO store VALUES (NULL, 'lottery', 'Buy A Ticket For The Lottery Entitled: ', '20', '0', 'lottery.gif', 'Buy a lottery ticket and hope that you will win the jackpot.', 'N') 


[Lesane]

Originally posted by Peace
I'm getting errors and the "lottery Option" link/Page in the AdminCP can't be found. I followed the directions carefully. Help me solve these problems.

Parse error: parse error in /home/www/theonlinelounge/forums/store.php3 on line 2

Parse error: parse error in /home/www/theonlinelounge/forums/admin/storeadmin.php3 on line 3


When I click on "Lottery Options" in the AdminCP, I get this error

The page cannot be found

That's because you are using a .php3 version.

Open admin/index.php and find:

PHP Code:

makenavoption("Lottery Options","storeadmin.php?action=lottery"); 


And change it to:

PHP Code:

makenavoption("Lottery Options","storeadmin.php3?action=lottery"); 


[Lesane]

Thanks everyone for the feedback. Thumbsup.

[Peace]

Thanks

Lesane, I did that and I'm still getting these errors

Parse error: parse error in /home/www/theonlinelounge/forums/admin/storeadmin.php3 on line 3


Parse error: parse error in /home/www/theonlinelounge/forums/store.php3 on line 2



Can you identify line 3 in storeadmin and line 2 in store and give me examples of the correct code and I'll compare it to the codes in those files? Maybe I'm missing something.

[LightBringer]

Lesane, thanks for the starting jackpot fix! Works like a champ now.

[N9ne]

YAY! IT'S FINALLY OUT! OMG **INSTALLS!**

hacker of the lifetime: Lesane!!

[BigJohnson]

Could there be a area in someones profile that will say how many bought tickets and how many wins that user has. That would be pretty cool.