public static void doReport(Map<String, String> params) throws Exception {
if (params != null) {
String time = params.containsKey("time") ? params.get("time") : HawkTime.getTimeString();
String value =
String.format(
"'%s', '%s', '%s', '%s', '%s', '%s', %s, %s, %s, '%s', %s, %s, '%s', '%s'",
params.get("game"),
params.get("platform"),
params.get("server"),
CollectorServices.getChannelFromPuid(params.get("puid")),
params.get("puid"),
params.get("device"),
params.get("playerid"),
params.get("playerlevel"),
params.get("changetype"),
params.get("changeaction"),
params.get("goldtype"),
params.get("gold"),
time,
time.substring(0, 10));
String sql =
String.format(
"INSERT INTO gold(game, platform, server, channel, puid, device, playerid, playerlevel, changetype, changeaction, goldtype, gold, time, date) VALUES(%s);",
value);
DBManager.getInstance().executeSql(params.get("game"), sql);
HawkLog.logPrintln("report_gold: " + value);
}
}
