^

I did this.

And I added $jackpot to forumhome.

And I have an active lottery going.

And nothing shows up on forumhome.

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.

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?

Ahh cant someone help me :(

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

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

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

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
Anywhere in the root/store.php file.

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