Advertisement
existence_dev92

Untitled

Mar 22nd, 2019
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. -- deleting data from mysql for logged of player and login player simultaneously
  2. query_sql( "DELETE FROM acc_reg_num` WHERE `key` = '#daily_minute_count' AND `account_id` IN ( SELECT `account_id` FROM `char` WHERE `login` = 0 GROUP BY `account_id` ) " );
  3. addrid(0);
  4. #daily_minute_count = -1;
  5.  
  6. query_sql("SELECT `char_id` from `char` WHERE `account_id` IN (SELECT `account_id` FROM `login` WHERE `group_id` >= 10) GROUP BY `account_id`")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement