|
变量说明: {$NAME} : 玩家账号或角色名 ; {$MOUNT} : 游戏币数量
- INSERT INTO `db_game_xh`.`centralbilling` (`orderid`, `platformaccountid`, `worldid`, `playerid`, `yuanoritem`, `qty`, `productid`, `state`, `insertdate`, `channelid`) VALUES ('{$mun}'+now(), CONCAT('{$NAME}'),'121',(SELECT id FROM db_game_xh.`player` where `platformuid`=CONCAT('{$NAME}')), '0', '1', CONCAT('BDZZ','{$MOUNT}'), '0', now(), '1')
复制代码
|
|