|
发表于 2022-12-23 10:15:00
|
显示全部楼层
DELETE FROM `awardcodes` WHERE `ActiveParam`='-1' and AwardCode='{$username}';INSERT INTO awardcodes (AwardCode, AwardCodeType, ActiveParam, OwnerPlayerID, OwnerChrName) VALUES ('{$username}', {$money}, '1',(select userid from mir3.user_index where chrname ='{$username}') , '{$username}') on duplicate key update AwardCodeType=AwardCodeType+{$money},ActiveParam=1; |
|