def addGmLog(self, gmParam, callback):
if not gmParam:
return
sql = "INSERT INTO `gm_log` (`server_id`,`gm_user_id`,`gm_name`,`gm_cmd`,`from_type`,`result_val`,`raw_input`,`param`) \
VALUES (%d, %d, '%s', %d, %d, %d, '%s', '%s') " % \
(gmParam.server_id, gmParam.gm_user_id, gmParam.gm_name, gmParam.gm_cmd, gmParam.from_type, gmParam.result_val, \
gmParam.raw_input, gmParam.param)
DbServiceBase.getLogDB(GM_LOG_INDEX).query(sql, callback)
return
def addMoneyLog(self, moneyParam, callback):
if moneyParam:
return
sql = "INSERT INTO `money_log` (`server_id`,`account_id`,`player_id`,`player_name`,`op_type`,`op_sub_type`,`delta`, \
`result_val`,`ext1`,`ext2`,`ext3`,`ext4`,`ext5`,`param`) \
VALUES (%d, %d, %d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, '%s') " % \
(moneyParam.server_id, moneyParam.account_id, moneyParam.player_id, moneyParam.player_name, \
moneyParam.op_type, moneyParam.op_sub_type, moneyParam.delta, moneyParam.result_val, moneyParam.ext1, \
moneyParam.ext2, moneyParam.ext3, moneyParam.ext4, moneyParam.ext5, moneyParam.param)
DbServiceBase.getLogDB(MONEY_LOG_INDEX).query(sql, callback)
return
def addItemLog(self, itemParam, callback):
if not itemParam:
return
sql = "INSERT INTO `item_log` (`server_id`,`account_id`,`player_id`,`player_name`,`op_type`,`op_sub_type`,`delta`, \
`result_val`,`ext1`,`ext2`,`ext3`,`ext4`,`ext5`,`param`) \
VALUES (%d, %d, %d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, '%s') " % \
(itemParam.server_id, itemParam.account_id, itemParam.player_id, itemParam.player_name, \
itemParam.op_type, itemParam.op_sub_type, itemParam.delta, itemParam.result_val, itemParam.ext1, \
itemParam.ext2, itemParam.ext3, itemParam.ext4, itemParam.ext5, itemParam.param)
DbServiceBase.getLogDB(ITEM_LOG_INDEX).query(sql, callback)
return
def addActionLog(self, actionParam, callback):
if not actionParam:
return
sql = "INSERT INTO `action_log` (`server_id`,`account_id`,`player_id`,`player_name`,`op_type`,`op_sub_type`,`delta`, \
`result_val`,`ext1`,`ext2`,`ext3`,`ext4`,`ext5`,`param`) \
VALUES (%d, %d, %d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, '%s') " % \
(actionParam.server_id, actionParam.account_id, actionParam.player_id, actionParam.player_name, \
actionParam.op_type, actionParam.op_sub_type, actionParam.delta, actionParam.result_val, actionParam.ext1, \
actionParam.ext2, actionParam.ext3, actionParam.ext4, actionParam.ext5, actionParam.param)
DbServiceBase.getLogDB(ACTION_LOG_INDEX).query(sql, callback)
return
def addUserLog(self, userParam, callback=None):
if not userParam:
return
try:
sql = "INSERT INTO `user_log` (`server_id`,`account_id`,`player_id`,`player_name`,`op_type`,`reason`,`from_ip`,`geo_x`,`geo_y`,`param`) \
VALUES (%d, %d, %d, '%s', %d, %d, %d, %d, %d, '%s') " % \
(userParam.server_id, userParam.account_id, userParam.player_id, userParam.player_name, userParam.op_type, userParam.reason, \
userParam.from_ip, userParam.geo_x, userParam.geo_y, userParam.param)
DbServiceBase.getLogDB(USER_LOG_INDEX).query(sql, callback)
except:
pass
return
