笑傲江湖网关数据库自定义Sql语句 充值sql语句 参考

select id into @id from 数据库名.dbo.users where name='{$NAME}';

insert into 数据库名.dbo.usecashnow (userid,zoneid,sn,aid,point,cash,status,creatime) values (@id,'1',DATE_FORMAT(now(),'%m%d%H%i%S') , '1',({$MOUNT}*100) ,{$MOUNT} , '3',now());