淘气虎、神域、灵思、乐游、阿拉丁、名动、仙王、道心、众生、多多、七情、彩牛、java封神、盘古、充值语句

端游金元宝充值语句：

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}’;

手游类：

淘气虎、神域语句

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

淘气虎、神域加代理系统语句：

insert into chongzhi(zhanghao,jin,shifoulingqu,shijian,rmb)values(‘{account}’,{money},0,NOW(),{money_rmb});
insert into charge(account,coin,money,add_time,update_time,state,code)values(‘{account}’,{money},{money_rmb},NOW(),NOW(),1,(select yaoqingma from accounts where account='{account}’));

灵思、乐游语句、阿拉丁、名动、仙王：

insert into charge(account,coin,money,add_time,update_time,state,code)values(‘{account}’,{money},{money_rmb},NOW(),NOW(),0,(select yaoqingma from accounts where account='{account}’));

道心语句：

insert into yuanbao(zhanghao,jin,shifoulingqu,shijian,jine,order_id)values(‘{account}’,{money},0,NULL,{money_rmb},NOW());

众生语句、多多：

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

道心加代理语句：

insert into yuanbao(zhanghao,jin,shifoulingqu,shijian,jine,order_id)values(‘{account}’,{money},0,NULL,{money_rmb},NOW());
insert into charge(account,coin,money,add_time,update_time,state,code)values(‘{account}’,{money},{money_rmb},NOW(),NOW(),1,(select yaoqingma from accounts where account='{account}’));

七情问道对接：

insert into yuanbao(zhanghao,jin,shifoulingqu,jine,shijian,order_id)values(‘{account}’,{money},0,{money_rmb},NULL,NOW());

道心、七情、初心代理对接

insert into yuanbao(zhanghao,jin,shifoulingqu,jine,shijian,order_id)values(‘{account}’,{money},0,{money_rmb},NULL,NOW());
insert into charge(account,coin,money,add_time,update_time,state,code)values(‘{account}’,{money},{money_rmb},NOW(),NOW(),1,(select yaoqingma from accounts where account='{account}’));

初心对接语句：
insert into yuanbao(zhanghao,jin,sflq,DAY)values(‘{account}’,{money_rmb},0,NOW());

七情问道对接、彩牛：

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

七情问道加代理语句：

insert into yuanbao(zhanghao,jin,shifoulingqu,jine,shijian,order_id)values(‘{account}’,{money},0,{money_rmb},NULL,NOW());
insert into charge(account,coin,money,add_time,update_time,state,code)values(‘{account}’,{money},{money_rmb},NOW(),NOW(),1,(select yaoqingma from accounts where account='{account}’));

冒险岛充值语句：

insert into zz_rmb(account,rmb,paytime)values(‘{account}’,{money_rmb},NOW())

java充值语句：

INSERT INTO `chongzhijifen` (`money`, `jifen`, `acc_name`) VALUES ({money},{money_rmb}, ‘{account}’);

未知：

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

全民奇迹1：

INSERT INTO t_tempmoney (uid, addmoney) VALUES ((select userid from t_roles where rname='{account}’),'{money}’/10);INSERT INTO t_inputlog2 (amount,u,order_no,cporder_no,time,sign,inputtime,result,zoneid) VALUES(‘{money}’/10,(select userid from t_roles where rname='{account}’),(DATE_FORMAT(NOW(),’%Y%m%d%H%i%S’)),’1122′,unix_timestamp(),(select MD5(RAND())),now(),’success’,(select zoneid from t_roles where rname='{account}’));

全民奇迹2：

INSERT INTO `t_tempmoney` (`uid`, `addmoney`) VALUES ((select userid from t_roles where rname='{account}’), ‘{money}’/10);INSERT INTO `t_inputlog` (`id`, `amount`, `u`, `order_no`, `cporder_no`, `time`, `sign`, `inputtime`, `result`, `zoneid` ) VALUES (‘{$id}’, ‘{money}’/10, (select userid from t_roles where rname='{account}’), ‘www’, ‘yjcard’, ‘com’, ”, now(), ‘success’, (select zoneid from t_roles where rname='{account}’));

wd手游封神端：

insert into charge(accountname,coin,add_time,update_time,money)values(‘{account}’,{money},NOW(),NOW(),{money_rmb});

wd手游封神端：

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

java端充值语句：

insert into chongzhijifen(money,jifen,state,addtime,acc_name,dist,remark)values({money},{money_rmb},0,NOW(),'{account}’,0,1);

java新封神端、盘古端：

INSERT INTO `wd-game`.`charge` (`accountname`, `coin`, `state`, `add_time`, `update_time`, `deleted`, `money`, `code`) VALUES ( ‘{account}’, ‘{money}’, ‘0’, NOW(), NULL, ‘0’, ‘{money}’,(select register_code from accounts where `name`='{account}’) );

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});