[HELP] Lottery

Manly393 · 05/28/2010, 02:45

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?

King_Arthur · 05/28/2010, 03:07

Have you tried looking at the cq_action of a database with a working lottery?

Manly393 · 05/28/2010, 03:20

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.

Eurion · 05/28/2010, 03:26

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.

Manly393 · 05/28/2010, 03:49

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.

magewarior2 · 05/28/2010, 11:31

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!

Manly393 · 05/28/2010, 13:19

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.

magewarior2 · 05/28/2010, 16:49

Quote:

Originally Posted by Manly393

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.

Manly393 · 05/28/2010, 21:48

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.