- INSERT INTO `pay_record` (`account_name`, `order_id`, `product_id`, `pay_fee`, `gift_diamond`,`server_id`,`time`,`used`,`platform_id`,`device_id`) VALUES ('{account}',(DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')), '3', {money}, {money}, '1', NOW(), '1', '99999', '1');UPDATE `uw_user` SET `diamond`=diamond+{money},`vipScore`={money}/10,`lastRechargeTime`=now() where accountname='{account}';
复制代码
|