function DelItemInTongDepot($var, $gm)
{
$gm_name = mysql_escape_string($gm);
$reason = $var["reason"];
$page = $var["uPage"];
$pos = $var["pos"];
$item_num = intval($var["num"]);
GetItemInfo(mysql_escape_string($var["item_name"]), $item_type, $item_name);
$reason = mysql_escape_string($reason);
$serverid = intval($var["serverid"]);
$action = "";
global $tbl_tong_page, $DelItemInTongDepot;
$param = array();
$param["page"] = $page;
$param["pos"] = $pos;
$param["tong_name"] = $var["tong_name"];
$param["msg"] = sprintf($DelItemInTongDepot, $tbl_tong_page[$page], $item_num, $item_name);
$action = array("tong" => $var["tong_name"], "item" => $item_name, "number" => $item_num, "reason" => $reason);
global $tbl_game_server;
$gas_host = $tbl_game_server[$serverid][0];
$gas_port = $tbl_game_server[$serverid][1];
$ret = PostData($gas_host, $gas_port, "DelItemInTongDepot", $param);
if (intval($ret) != 200) {
PrintNotice(LogInfo($action, false, $ret));
BackAndRefresh();
return true;
}
if (LogGMCommand($gm_name, $var["action_name"], $action, $serverid)) {
PrintNotice(LogInfo($action, true));
BackAndRefresh();
return true;
}
return false;
}
function ShowVirWealthLog_Item($var, $gm)
{
global $tbl_log_db, $tbl_sys_msg, $tbl_log_item_flow, $tbl_event_type, $tbl_serv_db, $tbl_log_desc, $tbl_sys_msg, $page_main;
if ($var["download"] == "true") {
$tname = gmmktime();
$filename = "../../" . $tname . ".csv";
$file = fopen($filename, "w");
} else {
LastLogTime();
}
$server_id = $var["serverid"];
$role_id = ArgRoleId();
if (!$role_id) {
return true;
}
$event_type = $var["event_type"];
$str = "";
if ($event_type != 0) {
$str = " and let.let_uEventType = {$event_type}";
}
$item_name = $var["item_name"];
if ($item_name != "") {
GetItemInfo(mysql_escape_string($item_name), $item_type, $item_name);
$str .= " and lis.lis_sName = '" . UTF82Local($item_name) . "'";
}
if ($var["download"] == "true") {
fwrite($file, "\"" . UTF82Local(implode("\",\"", array($tbl_sys_msg["time"], $page_main["event_type"], $page_main["item"], $page_main["item_id"], $page_main["number"], $tbl_sys_msg["desc"], $tbl_sys_msg["detail"])) . "\"\n"));
} else {
echo "<table class='list_table'>\n";
echo "<tr><th style='width:120px;'>" . $tbl_sys_msg["time"] . "</th><th style='width:30px;'>" . $page_main["event_type"] . "</th><th>" . $page_main["item"] . "</th><th style='width:30px;'>" . $page_main["item_id"] . "</th><th>" . $page_main["number"] . "</th><th>" . $tbl_sys_msg["desc"] . "</th><th>" . $tbl_sys_msg["detail"] . "</th></tr>\n";
}
$date_limit = getDateLimit($var, $server_id);
$qs = "(select le.le_dtDateTime, 1, lis.lis_sName, count(*), let.let_uEventType, le.le_uId, lig.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_player_giver lpg, tbl_log_event le, tbl_log_event_type let, tbl_log_item_giver lig ";
$qs .= "left join tbl_log_item_static lis on lig.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "lig.le_uId = lpg.le_uId and ";
$qs .= "lig.le_uId = le.le_uId and ";
$qs .= "lig.le_uId = let.le_uId and ";
$qs .= "lpg.lcs_uId = {$role_id}{$str} {$date_limit} ";
$qs .= "group by le.le_uId,lis.lis_sName) ";
$qs .= "union ";
$qs .= "(select le.le_dtDateTime, 0, lis.lis_sName, count(*), let.let_uEventType, le.le_uId, lit.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_player_taker lpt, tbl_log_event le, tbl_log_event_type let, tbl_log_item_taker lit ";
$qs .= "left join tbl_log_item_static lis on lit.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "lit.le_uId = lpt.le_uId and ";
$qs .= "lit.le_uId = le.le_uId and ";
$qs .= "lit.le_uId = let.le_uId and ";
$qs .= "lpt.lcs_uId = {$role_id}{$str} {$date_limit} ";
$qs .= "group by le.le_uId,lis.lis_sName) ";
$qs .= "union ";
$qs .= "(select le.le_dtDateTime, 1, lis.lis_sName, count(*), let.let_uEventType, le.le_uId, lid.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_player_giver lpg, tbl_log_event le, tbl_log_event_type let, tbl_log_item_del lid ";
$qs .= "left join tbl_log_item_static lis on lid.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "lid.le_uId = lpg.le_uId and ";
$qs .= "lid.le_uId = le.le_uId and ";
$qs .= "lid.le_uId = let.le_uId and ";
$qs .= "let.let_uEventType <> 2 and ";
$qs .= "lpg.lcs_uId = {$role_id}{$str} {$date_limit} ";
$qs .= "group by le.le_uId,lis.lis_sName) ";
if ($event_type == 0 || $event_type == 85) {
$qs .= "union ";
$qs .= "(select le.le_dtDateTime, if(lpt.lpt_uToCharId = {$role_id},0,1), lis.lis_sName, count(*), 85, le.le_uId, lpt.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_event le, tbl_log_player_trade lpt ";
$qs .= "left join tbl_log_item_static lis on lpt.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "(lpt.lpt_uFromCharId = {$role_id} or lpt.lpt_uToCharId = {$role_id}) and ";
$qs .= "lpt.le_uId = le.le_uId and lpt.lis_uId <> 0 {$date_limit} ";
$qs .= "group by le.le_uId, lis.lis_sName) ";
}
$qs .= "union ";
$qs .= "(select le.le_dtDateTime, 1, lis.lis_sName, count(*), let.let_uEventType, le.le_uId, lig.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_player_giver lpg, tbl_log_event le, tbl_log_event_type let, tbl_log_item lig ";
$qs .= "left join tbl_log_item_static lis on lig.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "lig.le_uId = lpg.le_uId and ";
$qs .= "lig.le_uId = le.le_uId and ";
$qs .= "lig.le_uId = let.le_uId and ";
$qs .= "lpg.lcs_uId = {$role_id}{$str} {$date_limit} ";
$qs .= "group by le.le_uId,lis.lis_sName) ";
$qs .= "union ";
$qs .= "(select le.le_dtDateTime, 0, lis.lis_sName, count(*), let.let_uEventType, le.le_uId, lit.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_player_taker lpt, tbl_log_event le, tbl_log_event_type let, tbl_log_item lit ";
$qs .= "left join tbl_log_item_static lis on lit.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "lit.le_uId = lpt.le_uId and ";
$qs .= "lit.le_uId = le.le_uId and ";
$qs .= "lit.le_uId = let.le_uId and ";
$qs .= "lpt.lcs_uId = {$role_id}{$str} {$date_limit} ";
$qs .= "group by le.le_uId,lis.lis_sName) ";
if ($event_type == 0) {
$qs .= "union ";
$qs .= "(select le.le_dtDateTime, ltd.ltd_uType-1, lis.lis_sName, count(*), 10001, le.le_uId, ltd.lis_uId ";
$qs .= "from ";
$qs .= "tbl_log_event le, tbl_log_tong_depot ltd ";
$qs .= "left join tbl_log_item_static lis on ltd.lis_uId = lis.lis_uId ";
$qs .= "where ";
$qs .= "ltd.le_uId = le.le_uId and ";
$qs .= "ltd.ltd_uExecutorId = {$role_id} {$date_limit} ";
$qs .= "group by le.le_dtDateTime,lis.lis_sName) ";
}
$qs .= "order by le_uId";
$result = MySQLQuery($qs, "Log", $server_id);
while ($row = mysql_fetch_row($result)) {
$des = ShowVirWealthLog_Desc($row[4], $row[5], $server_id);
if ($var["download"] == "true") {
fwrite($file, UTF82Local("\"" . implode("\",\"", array($row[0], $tbl_log_item_flow[$row[1]], Lan_Item_GetDisplayName(Local2UTF8($row[2])), $row[6], $row[3], $tbl_event_type[intval($row[4])], $des)) . "\"\n"));
} else {
echo sprintf("<tr" . ($i++ % 2 == 0 ? "" : " class='even'") . "><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $row[0], $tbl_log_item_flow[$row[1]], Lan_Item_GetDisplayName(Local2UTF8($row[2])), $row[6], $row[3], $tbl_event_type[intval($row[4])], $des);
}
}
if ($var["download"] == "true") {
global $page_action_name;
fclose($file);
echo "<script>\n";
echo "window.location.href='../../cgi-bin/gm_tools/download.php?file={$tname}&display=" . $page_action_name[$var["action_name"]] . "';\n";
echo "</script>\n";
} else {
echo "</table>\n";
echo "<table class='list_table'><tr><td><a href='" . get_http_args() . "&download=true' target='_blank'>" . $tbl_sys_msg["download"] . "</a></td></tr></table>\n";
ReturnAndBack();
}
return true;
}
function ReqAddItemToTong($var, $gm)
{
$tong_name = $var["tong_name"];
$serverid = $var["serverid"];
$num = $var["num"];
$item_info = $var["item_name"];
$page = $var["uPage"];
GetItemInfo($item_info, $item_type, $item_name);
$reason = $var["reason"];
$arg1 = $item_info . "_" . $num;
$arg2 = $page;
$reason = $var["reason"];
global $bid2type, $tbl_tong_page;
$opertion = array("tong" => $tong_name, "item" => $item_name, "type" => $bid2type[$item_type], "pos" => $tbl_tong_page[$page], "number" => $num, "reason" => $reason);
if (SaveReqAction($gm, $var["action_name"], $tong_name, $serverid, $arg1, $arg2, $opertion)) {
LogGMCommand($gm, $var["action_name"], $opertion, $serverid);
PrintNotice(LogInfo($opertion, true));
} else {
PrintNotice(LogInfo($opertion, false));
}
BackAndClose();
return true;
}
function AddItem($var, $gm, $role_name, $arg1, $arg2, $reason)
{
global $tbl_gm_db, $tbl_sys_msg;
$gm_name = mysql_escape_string($gm);
$serverid = intval($var["serverid"]);
$param = array();
$param["num"] = $arg1;
$param["item_info"] = UTF82Local($arg2);
$param["role_name"] = $role_name;
global $tbl_game_server;
$gas_host = $tbl_game_server[$serverid][0];
$gas_port = $tbl_game_server[$serverid][1];
GetItemInfo($arg2, $item_type, $item_name);
$ret = PostData($gas_host, $gas_port, "AddItem", $param);
if (intval($ret) != 200) {
PrintNotice(LogInfo($reason, false, $ret));
BackAndRefresh($tbl_sys_msg["success"]);
return true;
}
if (LogGMCommand($gm_name, $var["action_name"] . ".0039", $reason, $serverid)) {
PrintNotice(LogInfo($reason, true));
BackAndRefresh($tbl_sys_msg["success"]);
return true;
}
return false;
}
