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.

[deathemperor]

Lesane, is it work for 2.3.0 ?
I tried to install this 3 times, but it doesnt work. the error is:
Parse error: parse error, expecting `T_VARIABLE' or `'$'' in ***\www\vb2\store.php on line 110

I wanna slove this, cuz the lottery add-on is cool

[SavgeDusk]

The lottery info in the store isn't showing up properly. It doesn't list how much is in the jackpot or the start/end dates. And when I bought a ticket, it wouldn't show up either. o.o;

[Darnell 0216]

Originally Posted by deathemperor1st

Lesane, is it work for 2.3.0 ?
I tried to install this 3 times, but it doesnt work. the error is:
Parse error: parse error, expecting `T_VARIABLE' or `'$'' in ***\www\vb2\store.php on line 110

I wanna slove this, cuz the lottery add-on is cool

Have you gone over your edits with a fine tooth comb? And did you check line 110 to see if anything was wrong...

Originally Posted by SavgeDusk

The lottery info in the store isn't showing up properly. It doesn't list how much is in the jackpot or the start/end dates. And when I bought a ticket, it wouldn't show up either. o.o;

If it doesn't appear properly, doublecheck your table edits. If you can't see the ticket purchase appearing then you more than likely have made a mistake in your edits. The only problem this hack really has from the getgo are jackpot errors and the solution is posted.

[deathemperor]

yes, i did look the 110 line, that is the line of lottery add-on. And sure i did follow the instructions of Lesance, but it shows that error
what do i have to deal with ? I cant find out myself what's wrong due to my bad knowledge of php. Hope u could

[Darnell 0216]

Originally Posted by deathemperor1st

yes, i did look the 110 line, that is the line of lottery add-on. And sure i did follow the instructions of Lesance, but it shows that error
what do i have to deal with ? I cant find out myself what's wrong due to my bad knowledge of php. Hope u could

PM Sent.

[Lostnode]

Just installed the lottery hack...
Went to test it out and I got this MySQL error

MySQL is version 4.0.11a-gamma

Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: UPDATE user SET storep=storep+ WHERE userid='1'
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid='1'' at line 1

mysql error number: 1064

Date: Friday 14th of November 2003 12:38:52 AM
Script: http://test.brothers-in-arms.com/for...A-r%20Lostnode
Referer: http://test.brothers-in-arms.com/for...min/index.php?

What is the syntax error... It doesnt seem to want to read the varialbale $kutje, it was 2000 for this, and the error would have read

UPDATE user SET storep=storep+2000 WHERE userid='1'

I think it has to do with that, but what?

[dstruct2k]

Anyone got a copy of the templates that WEREN'T fu**ed over by vbulletin.org? Attaching txt files makes vBorg parse them as PHP and replace stuff like {firstaltcolor} with vBorg's {firstaltcolor} replacement. Kinda pi**ing me off.

[sabret00the]

how would i go about making sure this always selects a winner and that it's done via cron?

[xxxsaint]

Your instructions say

Open file: root/store.php
**********************************

--------
Find:
--------

if($showimg=="Y") {

--------
Add BEFORE it:
--------

if ($aw[action]=='lottery') {
$lok=$DB_site->query_first("SELECT * FROM storelottery WHERE lotnumber='1'");
$lotname=$lok[lotname];
$startdate=vbdate($dateformat,$lok[startdate]);
$enddate=vbdate($dateformat,$lok[enddate]);
$lottery="<br><b>Start Date:</b> $startdate <br><b>End Date:</b> $enddate<br><b>Money in jackpot:</b> $lok[jackpot]";
} else {
$lotname="";
$lottery="";
}

but in the new store.php , it doesn't find if($showimg=="Y") {



so where does that go ?

[SavgeDusk]

It would go before this line:
if($store_img=="1") {