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.

[Darnell 0216]

Make sure you don't have errors in the the following lines:

PHP Code:

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


Your error says that it's trying to add nothing (storep=storep+ WHERE) to the current storepoints which implies kutje is returning an empty value.

BTW I'm running 2.2.9 and haven't had any errors other than choosing from only those who have bought a ticket and the fact he hardcoded the colors and bullet images in which were all rectified...

[dstruct2k]

Anyone feel like telling me the meaning of "kutje"? I tried translating it to no avail....

[vurton]

everything worked fine until i picked a winner

Database error in vBulletin Control Panel 2.3.0:

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

hmmmhhhhhhhhhhhhhh

[Zelda-King]

Mine's ok on 2.3.0 but I want to change the userid of the winner/loser PM sender (I use Admin-Bot for jobs like this. ).

[Darnell 0216]

Today at 07:22 AM Zelda-King said this in Post #214
Mine's ok on 2.3.0 but I want to change the userid of the winner/loser PM sender (I use Admin-Bot for jobs like this. ).

Find in storeadmin.php

PHP Code:

$pmwinner="Congratulations $username,\n\n You won the lottery named $lotop[lotname]. Your amount of points is increased with $kutje points.\n\n Thanks for your participation on this lottery.";
$pmw = $DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title,message,dateline,messageread,folderid) VALUES (NULL,'$userid','$userid','$bbuserinfo[userid]','You Won The Lottery','".addslashes($pmwinner)."',".time().",0,0)"); 


Replace $bbuserinfo[userid] with the userid you wish the message to come from.

[Zelda-King]

Yeah, I knew that had to be the key. I just wasn't sure if you just stick the userid on its own or whatnot.

Right, I've now replaced '$bbuserinfo[userid]' with '192' and done the same for the loser PM. I'll see how that goes when the next lottery ends in a week.

Thanks a lot!

On another note, with the last lottery the jackpot was over 30000 but the lottery awarded little over 1000. Maybe the jackpot just went over the maximum at the last minute? I've made the jackpot for the current lottery less to see if this one goes better.

[Darnell 0216]

There's a fix mentioned earlier in the thread regarding award issues... You might wanna doublecheck that problem if you haven't already corrected it. I've got my lottery to award over $10,000,000...

[mcyates]

http://www.myfootballforum.com/myfoo...action=lottery

When i try to buy a ticket i click on the buy button BUT it does nothing.. Below is the code for it which i'm using.


template: store_lottery

<html>
<head>
<title>$storename - Buy A Lottery Ticket</title>
$headinclude
</head>
<body>
$header
<table cellpadding="2" cellspacing="0" border="0" width="95%"  align="center">
<tr>
        <td width="100%"><img src="https://vborg.vbsupport.ru/images/vb_bullet.gif" alt="" border="0" align="absmiddle">
        <normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> &gt;
        <a href="store.php?s=$session[sessionhash]">$storename</a> &gt; Buy A Lottery Ticket</b></normalfont></td>
</tr>
</table>
<br>
<p><form action="store.php"  name="name" method="post">
<input type="hidden" name="action" value="lotteryupdate">
<input type="hidden" name="cost" value="$cost">
<input type="hidden" name="storeid" value="$storeid">
<br>
<table cellpadding="0" align=center cellspacing="0" border="0" width="90%"><tr><td>
<table cellpadding="0" align=center cellspacing="1" border="0" bgcolor="#0A293E" width="90%">
<tr>
<td colspan="2" bgcolor="#1D6AA0"><normalfont color="#EEEEFF"><b>Verify:</b></normalfont></td>
</tr>
<tr bgcolor="#13486D" valign='top'>
<td><p><normalfont color="#000000">Buying a lottery ticket costs:</p></td>
<td><p><normalfont color="#000000">$cost</p></td>
</tr>
<tr bgcolor="#13486D" valign='top'>
<td><p><normalfont color="#000000">$pointname you have:</p></td>
<td><p><normalfont color="#000000">$points</p></td>
</tr>
<tr bgcolor="#13486D" valign='top'>
<td><p><normalfont color="#000000">$pointname after buying the lottery ticket:</p></td>
<td><p><normalfont color="#000000">$need</p></td></tr>
<tr>
<td bgcolor="#1D6AA0" colspan='2' align='center'><p id='submitrow'><input type="submit" value="Ok, Buy The Lottery Ticket">
</p></td>
</tr>
</table>
</form>
</td></tr>
</table>
$footer
</body>
</html>

Any help would be welcomed. Thanks in advance

[Nur1]

getting problem.. well dunno if its a problem or not, but the lotto insert is appearing twice in admin

check attached gif

[007]

Nur1 I also have that problem. It doesn't seem to mess anything up, just shows everything twice though. I just ignore it.

I also have the same problem as you vurton. Members still get their money, but I get your error along with a nice vbulletin error email. I hate those LOL!

But yeah I get this too in 2.2.9. Anyone know what could be wrong?

05-01-03 at 10:00 PM vurton said this in Post #213
everything worked fine until i picked a winner

Database error in vBulletin Control Panel 2.3.0:

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

hmmmhhhhhhhhhhhhhh