[HELP] Lottery

05/28/2010 02:45 Manly393#1
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?
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.
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!
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
Quote:
Originally Posted by Manly393 View Post
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.
than it is the cq_action :)

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.