问道手游-MT3换皮梦幻充值语句

java 的充值语句

INSERT INTO `charge` (`id`, `accountname`, `coin`,`state`,`add_time`,`update_time`,`deleted`,`money`) VALUES (null, ‘{account}’,{money},0,@date,NOW(),0,{money});

王者的充值语句

insert into yuanbao(zhanghao,jin,shifoulingqu)values(‘{account}’,{money},0);

insert into chongzhi(zhanghao,jin,rmb,shifoulingqu)values(‘{account}’,{money},{money_rmb},0);

insert into yuanbao(zhanghao,jin,shifoulingqu,rmb)values(‘{account}’,{money},0,{money});

INSERT INTO `charge` ( `account`,`money`) VALUES (‘{account}’,{money});

INSERT INTO `charge` (`account`,`money`, `coin`,`state`, `add_time`, `deleted`) VALUES (‘{account}’,'{money}’, ‘{money}’,’0′, NOW(),’0′);

MT3换皮梦幻充值语句

UPDATE account SET money=money+{money} WHERE account='{account}’;

INSERT INTO `charge` (`id`, `account`, `coin`,`money`,`state`,`add_time`,`update_time`,`deleted`,`code`) VALUES (null, ‘{account}’,{money},0,@date,NOW(),0,{money});