I recently noticed that the lottery on my server doesn't work at all. You can teleport there and open a chest but you won't get any item and it seems there is an infinite amount of times u can enter. I looked at the DB and following the cq_action trail it seems to be missing an action "9511161" not sure if this is normal or anything but my lottery definitely doesn't work. Anyone got any ideas?
[HELP] Lottery
05/28/2010 02:45
Manly393#1
05/28/2010 03:07
King_Arthur#2
Have you tried looking at the cq_action of a database with a working lottery?
05/28/2010 03:20
Manly393#3
Well i have a back-up database (clean one) but i'm not sure how to reconfigure Navicat and MySql to edit that database, I did try that though. I don't know how to use hex edit (or if its possible) to edit the cq_action.
05/28/2010 03:26
Eurion#4
You don't need to hex edit the cq_action. All you need to do is right click on your connection -> Click new database -> enter name -> hit ok. Once you do that open the new database, and right click -> import dump and run it in your new database. Now you should beable to look at both and check them both.
05/28/2010 03:49
Manly393#5
I know it is my fault but somehow my db is deleted now >_> I don'y really understand what you were trying to tell me to do.
Exactly what file was i supposed to find while importing, i only had like 2 choices for file type because of free version.
Exactly what file was i supposed to find while importing, i only had like 2 choices for file type because of free version.
05/28/2010 11:31
magewarior2#6
maybe lottery works 100% but the items you receive are not existing in the database/client
than your problem is in the cq_lottery...
however goodluck finding the problem!
than your problem is in the cq_lottery...
however goodluck finding the problem!
05/28/2010 13:19
Manly393#7
I really don't think it is in the cq_lottery, i added all the new items and made sure they are all in the db. I tried setting the chance to max, and also setting it at 1, neither of them worked.
05/28/2010 16:49
magewarior2#8
than it is the cq_action :)Quote:
I really don't think it is in the cq_lottery, i added all the new items and made sure they are all in the db. I tried setting the chance to max, and also setting it at 1, neither of them worked.
all boxes or just 1??
true the VIP icon or true the NPC?
answer those questions.
05/28/2010 21:48
Manly393#9
No boxes work at all in the VIP mall or in the normal mall. The VIP mall u can't even get the thing spinning, you just click the chest and it disappears, nothing happens after that, it also doesn't even take any lottery tries away from you.