白日门传奇手游角色名语句
set names GBK;INSERT INTO pay_info SET channelId=(DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')),serverid=1001,paynum = (DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')) ,paytouser = (select account from octgame.player where chrname='{account}'),paygold = {money},paymoney=0, paytime = now(), status = 1, ticket = 1,chrname='{account}';
账号语句
INSERT INTO pay_info SET channelId=(DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')),serverid=1001,paynum = (DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')) ,paytouser = '{account}', paygold = {money},paymoney=0, paytime = now(), status = 1, ticket = 1
测试区账号语句
INSERT INTO pay_info SET channelId=(DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')),serverid=1001,paynum = (DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')) ,paytouser = CONCAT('test_','{account}'), paygold = {money},paymoney=0, paytime = now(), status = 1, ticket = 1 |