a_zone_num Error

[Validation]

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]

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]

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]

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]

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]

"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]

Ok! Thanks Karmel! I apologize for taking your time.

[Nikolee]

#closed since you got your answer.

If you want me to reopen this topic just write a PM.

[Sutz]

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