- 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
|
