+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: a_zone_num Error (/showthread.php?tid=3392)
- Validation - 04-20-2015
Hey guys,
So I am incorporating online time cash into my server at the moment. I know it would all work if a_zone_num (in the table t_users) actually switched whilst a player was online, but it stays at -1.
Things I have tried so far:
- Re-executing the newproject_db_user.sql file into the corresponding database.
- [CeNsOrEd] around (never a good thing) with different values and such.
- Re-executing every DB file
None of these was able to actively change a Player's online status.
It was working before I committed a lot of changes..but I have no idea what is causing it to not work.
Thanks!!!
- Karmel - 04-21-2015
Again ?
SET GLOBAL event_scheduler = ON;
CREATE EVENT `OnlineCashAdd`
ON SCHEDULE
EVERY 5 MINUTE STARTS '2014-08-06 00:34:11'
ON COMPLETION PRESERVE
ENABLE
COMMENT ''
DO UPDATE newproject_auth.bg_user SET cash = cash + 50 WHERE user_code IN (SELECT a_portal_index FROM newproject_auth.t_users WHERE a_zone_num != -1);
2
- Validation - 04-21-2015
I have done that. I have done my research haha. It is just that my a_zone_num in t_users table will not change when a player is online.
- fonsy84 - 04-21-2015
DO UPDATE newproject_auth.bg_user SET cash = cash + 50 WHERE user_code IN (SELECT a_portal_index FROM newproject_auth.t_users WHERE a_zone_num != -1); change for it
DO UPDATE newproject_auth.bg_user SET cash = cash + 50 WHERE user_code IN (SELECT a_portal_index FROM newproject_auth.t_users WHERE a_zone_num > -1); this must work
- Validation - 04-21-2015
I also have tried that. Hmm...i have never run into this problem developing on other servers..I really have no idea what the problem could be >.<
- Karmel - 04-21-2015
"It was working before I committed a lot of changes"
So what changes ? It not say a lot.
Try to use original t_users table, truncate it, restart server, login into game, and check again, if changes are in server bins, we cannot help a lot cuz we dont know what changes you do ...
- Validation - 04-21-2015
Ok! Thanks Karmel! I apologize for taking your time.
- Nikolee - 04-21-2015
#closed since you got your answer.
If you want me to reopen this topic just write a PM.
- Sutz - 04-24-2015
Hi there.
As your topic has been answered, and from this topic you can solve your problem or already have I am going to move this topic into our Solved section database.
Thankyou,
-LCKB Staff