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.

[BluSmurf]

I've added another lottery and the query result as below
mysql> SELECT * FROM storelottery WHERE lotnumber='1';
+----+-----------+--------------------------------+---------+------------+------------+--------+----------+
| id | lotnumber | lotname | jackpot | startdate | enddate | userid | username |
+----+-----------+--------------------------------+---------+------------+------------+--------+----------+
| 1 | 1 | SoccerMamak Weekend Lottery #2 | 200 | 1029297600 | 1029643200 | 0 | 0 |
+----+-----------+--------------------------------+---------+------------+------------+--------+----------+
1 row in set (0.00 sec)

But I'm still unable to buy a lottery because the page is blank

[Mr_P]

Lesane if u do get around to reading this id like to thank you for all teh support u gave in this post but like to know one more thing regarding this hack.

How do we get it to show on main index page how many have been sold for the current draw.

I have on main page how much is in the lottery so the 2 would go nice together.

Anyone got a decent lotto Gif ?????//

[DestyNova]

Originally posted by Mr_P
Lesane if u do get around to reading this id like to thank you for all teh support u gave in this post but like to know one more thing regarding this hack.

How do we get it to show on main index page how many have been sold for the current draw.

I have on main page how much is in the lottery so the 2 would go nice together.

Anyone got a decent lotto Gif ?????//

ditto, I want to know how to get that display on forumhome

[Mr_P]

im back again with another small idea - for such a small hack the ideas are endless

Ok on index page how about the winners avator being displayed till the next lottery is won ? where it is then replaced by the new winners and if the winner dont have an avator then we can use a pre made one.

This on front page with money in lottery and how many tickets sold would look smart in a nice little box i got for it.
I mean come on if you won and you got the ugliest avator everyone is forced to see it for a week (hmm and i do have a sense of humour,so is this possible Lesane)

[Lesane]

Originally posted by BluSmurf
Hi Lesane,

here's the result of the query
mysql> SELECT * FROM storelottery WHERE lotnumber='1';
Empty set (0.00 sec)

and attachment of my store.php

BluSmurf, you don't have the lottery code in the store.php so it never can function properly. Look on the instructions again.

[Lesane]

Originally posted by Mr_P
Lesane if u do get around to reading this id like to thank you for all teh support u gave in this post but like to know one more thing regarding this hack.

How do we get it to show on main index page how many have been sold for the current draw.

I have on main page how much is in the lottery so the 2 would go nice together.

Anyone got a decent lotto Gif ?????//

If you have the code in root/index.php wich i gave before, on this post: https://vborg.vbsupport.ru/showthrea...353#post284353

Then find this line:

PHP Code:

$jackpot="Current Lottery Fund is now: $lot[jackpot]"; 


And change it to:

PHP Code:

$cost = $DB_site->query_first("SELECT * FROM store WHERE action='lottery'");
$jackpot="Current Lottery Fund is now: $lot[jackpot]<br>Ticket's sold: $cost[sold]"; 


[Mr_P]

Excellant and works a treat - wish there was someway to rate a hacker on this board not just for his hacks but also for the feedback they give to other users as theres some good ones on here.

Anyway thanks a million Lesane,it may only have been a small thing but once i did it i seen the amount of tickets sold from 12 to 33.

Goes to show - Its all in the packaging.

Karmed m8 if i could.

[tpearl5]

Originally posted by Lesane


Wich mysql version are you using?

http://degster.com/phpinfo.php

3.22.32

I had a feeling it had something to do with that.

[Lesane]

Originally posted by tpearl5


http://degster.com/phpinfo.php

3.22.32

I had a feeling it had something to do with that.

You are using an old mysql version wich don't support that way of choosing a random user. Mysql version 3.23+ supports the "order by rand" function.

Try this way:

Open the file: admin/storeadmin.php

Find:

PHP Code:

$findus=$DB_site->query_first("SELECT * FROM user ORDER BY RAND() desc LIMIT 1"); 


And change it to:

PHP Code:

$findus=$DB_site->query_first("select *, rand() as r from user order by r limit 1;"); 


[Lesane]

Originally posted by Mr_P
Excellant and works a treat - wish there was someway to rate a hacker on this board not just for his hacks but also for the feedback they give to other users as theres some good ones on here.

Anyway thanks a million Lesane,it may only have been a small thing but once i did it i seen the amount of tickets sold from 12 to 33.

Goes to show - Its all in the packaging.

Karmed m8 if i could.

You're welcome Mr_p