3. SQL

1. OMG GAMEARG改成不使用大厅

sql

UPDATE `games` SET `is_lobby` = '0' WHERE `games`.`id` = 44;
UPDATE `game_subs` SET `pic_url` = 'assets/images/game/omg/gameart/140360.png' WHERE `game_subs`.`id` = 1279;

查看用户退水规则

sql

SELECT * FROM `retreat_rules` WHERE user_id in(SELECT id FROM users WHERE username='cpoe011');
-- 查看退水详情
SELECT * FROM `retreat_rule_detail_game` WHERE retreat_rule_detail_id in(SELECT id FROM `retreat_rule_detail_game` WHERE retreat_rule_id='retreat_rules.id'));