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]

^

[Cold Steel]

Originally posted by Lesane
You're welcome.

The forumhome code on this post works great, it's tested.
https://vborg.vbsupport.ru/showthrea...353#post284353

You can add the code before:

PHP Code:

// get newest member 


I did this.

And I added $jackpot to forumhome.

And I have an active lottery going.

And nothing shows up on forumhome.

[jitzs]

is there a way to put the last winners name and the amount they won on the homepage? I'd want to keep a history of all the winners also. I'm a VB programmer, but i've never used php before. So I know what needs to be done, but just not how to do it.

[Pancreas Paul]

Umm lesane, when I click the lottery, it takes me to a blacnk screen which is http://bw.xtreme-host.net/vb/store.php?action=;ottery

or something. its just like al white. can someone help me fix this?

[Pancreas Paul]

Ahh cant someone help me

[girlzclan]

I don't know what went wrong, I finally got the hack working, but why is it showing in the store twice?

http://girlz.reactionzero.com/store.php

[Pancreas Paul]

Make sure there is only 1 lottery going and in the store.php you dident add the variable twice.

[sklwer]

I just installed the Hack and as an admin i used the end lottery pick a winner and this is what I am getting.. Help Help

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT * FROM user ORDER BY RAND() desc LIMIT 1
mysql error: You have an error in your SQL syntax near 'RAND() desc LIMIT 1' at line 1

mysql error number: 1064

[girlzclan]

I'm useing the store version that was posted here and when i try to install the lottery addon ::

I can't seem to find this

PHP Code:

$storegraphic = $DB_site->query_first("SELECT showimg FROM storeadmin"); 


Anywhere in the root/store.php file.

[pgowder]

I just tried to end and pick winners of my first lottery.

Here is the error?

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT * FROM user ORDER BY RAND() desc LIMIT 1
mysql error: You have an error in your SQL syntax near 'RAND() desc LIMIT 1' at line 1

mysql error number: 1064

Date: Friday 08th of November 2002 09:12:19 AM
Script: http://www.powwows.com/gathering/gat...tion=lotwinner
Referer: http://www.powwows.com/gathering/adm...action=lottery