白日门对接网关平台内充语句

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=1002,paynum = (DATE_FORMAT(NOW(),’%Y%m%d%H%i%S’)) ,paytouser = ‘{account}’,paygold = {money},paymoney=0, paytime = now(), status = 1, ticket = 1

复制代码