a_zone_num Error
#4

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



Messages In This Thread
[No subject] - by Validation - 04-20-2015, 10:38 PM
[No subject] - by Karmel - 04-21-2015, 01:23 PM
[No subject] - by Validation - 04-21-2015, 01:28 PM
[No subject] - by fonsy84 - 04-21-2015, 01:34 PM
[No subject] - by Validation - 04-21-2015, 01:40 PM
[No subject] - by Karmel - 04-21-2015, 01:41 PM
[No subject] - by Validation - 04-21-2015, 01:44 PM
[No subject] - by Nikolee - 04-21-2015, 03:06 PM
[No subject] - by Sutz - 04-24-2015, 04:00 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)