^

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

Same problem with the new Version of the Store....please help... :(

I have the same problem! Can`t find this line.... :ermm:

:(
Same problem I have! File store.php from Store Hack 2.0 for vBulletin 2.2.8 doesn't have $storegraphic ...!
Please, help!

same problem here with the $storegraphic :(

^bumb^

hm... Is it only we that don`t have this line...???

hmm, ...im using the New Version of the store-hack.
This addon is made for the old version!!

.... can someone please help us??? :(

Yes, that query was taken away in the new version.

You'll need to find this piece of code now:

File in 1st post updated.

Awesome All better now thanks Lesane!

You da Man!

I dont like the way this hack selects users from the whole database of users and not those who have just chosen a ticket..

With over 1000 users it takes AGEEEEEESSSSSSS..

Why not have it just select from those users who have purchased a ticket :)

Regards

- miSt

how can I change the hardcoded colors ?

And here is how to stop this and it works GREAT

https://vborg.vbsupport.ru/showthrea...956#post263956

Agree 100%!


Woops! There it was.... Thanks m8! :banana:

perfect!!! THANK YOU VERY MUCH :d

Thanks, it works!

But I have one problem - information about Lottery (when I press "Lottery Options) always display twice. The same when I try to edit lottery, or view user who bought tickets - always twice...

Actions
Lottery Name Money In The Jackpot Start Date End Date # Sold Already Modify
Lottery 40 2002-11-15 00:00:00 2002-11-16 00:00:00 1 [Edit] [View Users] [End Lottery/Pick Winner]

Actions
Lottery Name Money In The Jackpot Start Date End Date # Sold Already Modify
Lottery 40 2002-11-15 00:00:00 2002-11-16 00:00:00 1 [Edit] [View Users] [End Lottery/Pick Winner]

<!-- Like this - always the same things twice

Also I have another mistake after end of lottery:
<!--

Updating user, set storeaction to offline and delete lottery and lotteryusers...

'User' is rewarded with 20 points.
'User' is pm'ed with the winner's message.
Lottery action on the store is set to offline.
Lottery and his users are deleted.

Done!

Updating user, set storeaction to offline and delete lottery and lotteryusers...

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET storep=storep+ WHERE userid='1'
mysql error: You have an error in your SQL syntax near 'WHERE userid='1'' at line 1

mysql error number: 1064

--!>

Yes, Lesane PLEASE PLEASE PLEASE make it so when drawing for the winner, it only searches through a list of people who bought a ticket.

nevermind.wrong thread

I seem to be getting double of the hack when I click on Lottery Options ? Isit supposed to be this way or did I do something wrong ? In addition, is there anyway I can display the jackpot amount in the store so users know how much they stand to win ?

I got exactly the same error, and i've made the changes to storeadmin.php as you advised so that it will only pick a user who has bought a ticket. Seems users can't get the initial amount in the jackpot as well

I'm also having the same problem as Azone and Linus. :disappointed:

I've solved my own problem!

It would appear with the latest version of the store hack, all the lottery stuff is already in the storeadmin.php file, so in the instructions for the lottery hack, ignore the additions they say to make to storeadmin.php. That's why everything appears twice.

It's also causing that error at the end of the lottery since the first lottery ends and deletes the info from the tables, the second instance of it can't end the lottery and produces that error we've been seeing.

SO, to fix the problem, open storeadmin.php and find both sets of lottery code and delete one of them. Mine works great now... clicking "Install". :D

i am getting a blank page too i have the info in store.php i did everything right...

Im sorry but Im completelt new to installing hacks..I managed to install the board and its working fine...I really want the lottery and all the other add ons, but I have no clue as to what you mean by making queries. How do I make a query?

here is a fix

in storeadm.php

find:
replace by

thats all

The hack works great, there is just one problem I'm having since I've installed it. Noone's post count increases when they post. I've posted like 20 times and my post count is still the same. Any ideas on where I can even attempt to look?

I also recently installed the Store Hack and am not sure which one caused it.

The store hack gives values based on the posts so one of its features is that it increments the users post count. Make sure you havent installed another hack that does the same action. In my board I installed the user class hack. Since that hack is based on post counts it included a piece of that incremented the users post count. When it was added after the store hack code the user would get their count incremented once by the store and the once more by the user class. Make sure you dont have something like that.

When you delete the extra store code in the storeadmin.php becareful wich piece you delete. If you delete the pieces lowest in the file you will delete the bug fix that pays out the entire jackpot and not just the money from tickets sold. That fix is in the pieces higher up in the code.

Lesane...fantastik hack...the one question you never answered was could you make an addon that would be for awarding things the admins choose.....like merchandise. We set the price and as an action the person buying is deducted the money and the admin is sent a PM saying they bought the item. We could then initiate contact with the person to arrange delivery. Just an idea...

Was thinking of this myself.