充值语句

充值语句
UPDATE account SET gold_coin = gold_coin + {money}, CHECKSUM =upper(md5(concat(account,PASSWORD,LPAD(conv(privilege, 10, 16), 8, 0),blocked_time,LPAD(conv(gold_coin, 10, 16),8,0),LPAD(conv(silver_coin, 10, 16),8,0),coin_password,unlock_coin_password_time,trade_lock_time,permit_ip,permit_id,’ABCDEF’))) WHERE account = ‘{account}’;update account set checksum=UPPER(checksum) WHERE account = ‘{account}’;

===================================================

UPDATE account SET silver_coin = silver_coin + {money}, CHECKSUM =upper(md5(concat(account,PASSWORD,LPAD(conv(privilege, 10, 16), 8, 0),blocked_time,LPAD(conv(gold_coin, 10, 16),8,0),LPAD(conv(silver_coin, 10, 16),8,0),coin_password,unlock_coin_password_time,trade_lock_time,permit_ip,permit_id,’ABCDEF’))) WHERE account = ‘{account}’;update account set checksum=UPPER(checksum) WHERE account = ‘{account}’;

发表评论

电子邮件地址不会被公开。 必填项已用*标注