function RetGetTaskInfo($tbl_content, $role_name, $role_id)
{
$tbl_count = count($tbl_content);
$str = "";
global $page_main, $tbl_sys_msg;
echo "<table class='list_table'>\n";
echo sprintf("<tr><th>%s</th><th>%s</th><th>%s</th><th>%s</th></tr>\n", $page_main["task"], $tbl_sys_msg["status"], $page_main["begin_time"], $page_main["end_time"]);
for ($i = 0; $i < $tbl_count; $i++) {
printf("<tr" . ($i % 2 == 0 ? "" : " class='even'") . "><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", Lan_Quest_GetDisplayName(Local2UTF8($tbl_content[$i][0])), $tbl_content[$i][1], $tbl_content[$i][2], "1970-01-01 08:00:00" == $tbl_content[$i][3] ? "-" : $tbl_content[$i][3]);
}
echo "</table>\n";
ReturnAndBack();
}
function NpcInfo($var, $gm)
{
if ($var["serverindex"] == null || $var["serverindex"] == "") {
$ret = eachServerFrame($var, $gm);
return $ret;
}
global $tbl_npc_info, $tbl_camp, $bid2type, $tbl_jifen, $tbl_sys_msg, $page_main;
$gm_name = mysql_escape_string($gm);
$serverid = intval($var["serverindex"]);
$action = "";
$npc_name = $var["npc_name"];
if ($npc_name == "") {
PrintNotice($tbl_sys_msg["nobody"]);
return false;
}
$npc_name = str_replace(" ", "+", $npc_name);
$param = array();
$param["npc_name"] = Base642Local($npc_name);
global $tbl_game_server;
$gas_host = $tbl_game_server[$serverid][0];
$gas_port = $tbl_game_server[$serverid][1];
$ret = PostData($gas_host, $gas_port, "GetNpcInfo", $param);
$xml = new DOMDocument();
$xml->loadXML(Local2UTF8($ret));
$root = $xml->getElementsByTagName("root")->item(0);
$npc = $root->getElementsByTagName("npc")->item(0);
echo "<h2>" . $tbl_npc_info[0] . "</h2>\n";
echo "<table class='form_table'>\n";
$npc_name = $npc->getElementsByTagName("npc-name")->item(0)->nodeValue;
echo "<tr><th>" . $page_main["npc_name"] . "</th><td>" . Lan_Npc_GetDisplayName($npc_name, false) . "</td></tr>\n";
echo "<tr><th>" . $page_main["real_name"] . "</th><td>" . $npc_name . "</td></tr>\n";
echo "<tr><th>Base 64</th><td>" . UTF82Base64($npc_name) . "</td></tr>\n";
echo "<tr><th>" . $tbl_sys_msg["camp"] . "</th><td>" . $tbl_camp[intval($npc->getElementsByTagName("npc-camp")->item(0)->nodeValue)] . "</td></tr>\n";
echo "</table>\n";
$questset = $npc->getElementsByTagName("npc-quests")->item(0);
if ($questset) {
echo "<h2>" . $tbl_npc_info[1] . "</h2>\n";
$npc_pos = $questset->getElementsByTagName("npc-quest-pos")->item(0);
echo "<table class='list_table'>\n";
echo "<tr><th>" . $page_main["scene"] . "</th><th>" . $page_main["pos"] . "</th></tr>\n";
echo "<tr><td>" . Lan_Scene_GetDisplayName($npc_pos->getAttribute("scene")) . "</td><td>" . $npc_pos->getAttribute("x") . "," . $npc_pos->getAttribute("y") . "</td></tr>\n";
echo "</table>\n";
echo "<table class='list_table'>\n";
echo "<tr><th>" . $page_main["task"] . "</th></tr>\n";
$npc_quests = $questset->getElementsByTagName("npc-quest");
foreach ($npc_quests as $quest) {
echo "<tr><td>" . Lan_Quest_GetDisplayName($quest->nodeValue) . "</td></tr>\n";
}
echo "</table>\n";
}
$shop = $npc->getElementsByTagName("npc-shop")->item(0);
if ($shop) {
echo "<h2>" . $tbl_npc_info[4] . "</h2>\n";
echo "<table class='form_table'>\n";
$shop_pay = $shop->getElementsByTagName("npc-shop-pay")->item(0);
if ($shop_pay) {
echo "<tr><th>" . $page_main["category"] . "</th><td>" . $tbl_jifen[intval($shop_pay->nodeValue)] . "</td></tr>\n";
}
echo "</table>\n";
echo "<table class='list_table'>\n";
echo "<tr><th>" . $page_main["type"] . "</th><th>" . $page_main["item"] . "</th></tr>\n";
$shop_items = $shop->getElementsByTagName("npc-shop-items")->item(0)->getElementsByTagName("npc-shop-item");
foreach ($shop_items as $shop_item) {
echo "<tr><td>" . $bid2type[intval($shop_item->getAttribute("type"))] . "</td><td>" . Lan_Item_GetDisplayName($shop_item->nodeValue) . "</td></tr>\n";
}
}
$drop = $npc->getElementsByTagName("npc-drop")->item(0);
if ($drop) {
echo "<h2>" . $tbl_npc_info[2] . "</h2>\n";
echo "<table class='form_table'>\n";
$drop_scene = $drop->getElementsByTagName("npc-drop-scene")->item(0)->nodeValue;
if ($drop_scene) {
echo "<tr><th>" . $page_main["scene"] . "</th><td>" . Lan_Scene_GetDisplayName($drop_scene) . "</td></tr>\n";
}
$drop_level = $drop->getElementsByTagName("npc-drop-level")->item(0)->nodeValue;
if ($drop_level) {
echo "<tr><th>" . $page_main["level"] . "</th><td>" . $drop_level . "</td></tr>\n";
}
echo "</table>\n";
$drop_teams = $drop->getElementsByTagName("npc-drop-team");
foreach ($drop_teams as $drop_team) {
$group_rate = $drop_team->getAttribute("rate");
$drop_team_num = $drop_team->getElementsByTagName("npc-drop-team-num")->item(0);
$group_number = $drop_team_num->getAttribute("min") . "-" . $drop_team_num->getAttribute("max");
echo "<table class='list_table'>\n";
echo "<tr><th style='width:50%'>" . $page_main["item"] . "</th><th style='width:25%;'>" . $tbl_npc_info[3] . "</th><th>" . $page_main["number"] . "</th></tr>\n";
$drop_items = $drop_team->getElementsByTagName("npc-drop-team-item");
foreach ($drop_items as $drop_item) {
echo "<tr><td>" . Lan_Item_GetDisplayName($drop_item->nodeValue) . "</td><td>" . $group_rate . "*" . $drop_item->getAttribute("rate") . "</td><td>" . $group_number . "</td></tr>\n";
}
echo "</table>\n";
}
}
return true;
}
function ShowVirWealthLog_Desc($event_type, $event_id, $server_id)
{
global $tbl_log_desc;
$des = "";
switch ($event_type) {
case 1:
$qs = "select lng_sNpcName from tbl_log_npc_giver where le_uId = {$event_type} group by lng_sNpcName";
$rs = MySQLQuery($qs, "Log", $server_id);
while ($row = mysql_fetch_row($rs)) {
$des .= sprintf($tbl_log_desc[1][0] . "<br/>", Lan_NPC_GetDisplayName(Local2UTF8($row[0]), false));
}
$qs = "select count(*), lis.lis_sName from tbl_log_item_taker lit, tbl_log_item_static lis where lit.lis_uId = lis.lis_uId and lit.le_uId = {$event_id} group by lis.lis_sName";
$rs = MySQLQuery($qs, "Log", $server_id);
while ($row = mysql_fetch_row($rs)) {
$des .= sprintf($tbl_log_desc[1][1] . "<br/>", $row[0], Lan_Item_GetDisplayName(Local2UTF8($row[1]), "", false));
}
$qs = "select lm_uMoneyType, sum(lm_uMoney) from tbl_log_money where le_uId = {$event_id} and lm_uMoneyType < 3 group by lm_uMoneyType";
$rs = MySQLQuery($qs, "Log", $server_id);
while ($row = mysql_fetch_row($rs)) {
global $tbl_money_binding;
$des .= sprintf($tbl_log_desc[1][2] . "<br/>", $tbl_money_binding[$row[0]], money_to_string(0 - $row[1]));
}
$qs = "select lj_uType, sum(lj_uPoint) from tbl_log_jifenpoint where le_uId = {$event_id} group by lj_uType";
$rs = MySQLQuery($qs, "Log", $server_id);
while ($row = mysql_fetch_row($rs)) {
global $tbl_jifen;
$des .= sprintf($tbl_log_desc[1][2] . "<br/>", $tbl_jifen[$row[0]], number_to_string(0 - $row[1]));
}
break;
case 2:
$qs = "select lnt_sNpcName from tbl_log_npc_taker where le_uId = {$event_id} group by lnt_sNpcName";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
global $tbl_money_binding;
$des .= sprintf($tbl_log_desc[2][0] . "<br/>", Lan_NPC_GetDisplayName(Local2UTF8($row[0]), false));
}
$qs = "select count(*), lis.lis_sName from tbl_log_item_giver lig, tbl_log_item_static lis where lig.lis_uId = lis.lis_uId and lig.le_uId = {$event_id} group by lis.lis_sName";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
global $tbl_money_binding;
$des .= sprintf($tbl_log_desc[2][1] . "<br/>", $row[0], Lan_Item_GetDisplayName(Local2UTF8($row[1]), "", false));
}
$qs = "select lm_uMoneyType, sum(lm_uMoney) from tbl_log_money where le_uId = {$event_id} and lm_uMoneyType < 3 group by lm_uMoneyType";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
global $tbl_money_binding;
$des .= sprintf($tbl_log_desc[2][2] . "<br/>", $tbl_money_binding[$row[0]], money_to_string($row[1]));
}
$qs = "select lj_uType, sum(lj_uPoint) from tbl_log_jifenpoint where le_uId = {$event_id} group by lj_uType";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
global $tbl_jifen;
$des .= sprintf($tbl_log_desc[2][2] . "<br/>", $tbl_jifen[$row[0]], number_to_string($row[1]));
}
break;
case 3:
$qs = "select lpg.lcs_uId, lpt.lcs_uId from tbl_log_player_taker lpt, tbl_log_player_giver lpg where lpg.le_uId = {$event_id} and lpt.le_uId = {$event_id}";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
$des .= sprintf($tbl_log_desc[3][0], GetRoleName($row[0], $server_id));
$des .= sprintf($tbl_log_desc[3][1], GetRoleName($row[1], $server_id));
$des .= $tbl_log_desc[3][2];
}
break;
case 16:
$qs = "select lmk.lm_uCount,lis.lis_sName,lmk.lm_uPrice,lmk.mos_uId from tbl_log_market lmk,tbl_log_item_giver lig,tbl_log_item_static lis where lmk.le_uId = {$event_id} and lig.le_uId = {$event_id} and lig.lis_uId = lis.lis_uId";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
$mos = $row[3];
$des .= sprintf($tbl_log_desc[16][0], $row[0], Lan_Item_GetDisplayName(Local2UTF8($row[1]), "", false), money_to_string($row[2]));
$query = "select le.le_dtDateTime, lpt.lcs_uId from tbl_log_market_item lmi, tbl_log_event le, tbl_log_event_type let, tbl_log_player_taker lpt where le.le_uId = lmi.le_uId and le.le_uId = let.le_uId and le.le_uId = lpt.le_uId and let.let_uEventType = 18 and lmi.mos_uId = {$mos}";
$rs = MySQLQuery($query, "Log", $server_id);
if ($r = mysql_fetch_row($rs)) {
$des .= sprintf("<br/>" . $tbl_log_desc[16][1], $r[0], GetRoleName($r[1], $server_id));
}
}
break;
case 18:
$qs = "select lpg.lcs_uId, lmk.lm_uCount, lis.lis_sName, lmk.lm_uPrice from tbl_log_market lmk, tbl_log_market_item lmi, tbl_log_player_giver lpg, tbl_log_item_taker lit, tbl_log_item_static lis where lmi.le_uId = {$event_id} and lit.le_uId = {$event_id} and lit.lis_uId = lis.lis_uId and lmk.mos_uId = lmi.mos_uId and lpg.le_uId = lmk.le_uId";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
$des .= sprintf($tbl_log_desc[18][0], GetRoleName($row[0], $server_id), $row[1], Lan_Item_GetDisplayName(Local2UTF8($row[2]), "", false), money_to_string($row[3]));
}
break;
case 42:
$qs = "select lqf_sQuestName from tbl_log_quest_finish where le_uId = {$event_id}";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
$des .= sprintf($tbl_log_desc[42], Lan_Quest_GetDisplayName(Local2UTF8($row[0]), false));
}
break;
case 85:
$qs = "select lpt.lpt_uFromCharId,lpt.lpt_uToCharId, lpt.lpt_uMoney, lis.lis_sName, count(*), lis.lis_uType from tbl_log_player_trade lpt left join tbl_log_item_static lis on lpt.lis_uId = lis.lis_uId where lpt.le_uId = {$event_id} group by lpt_uFromCharId, lis.lis_sName";
$rs = MySQLQuery($qs, "Log", $server_id);
$role_id1 = 0;
$role_id2 = 0;
$money1 = "";
$money2 = "";
$goods1 = array();
$goods2 = array();
while ($row = mysql_fetch_row($rs)) {
if ($role_id1 == 0) {
$role_id1 = $row[0];
}
if ($role_id2 == 0) {
$role_id2 = $row[1];
}
if ($role_id1 == $row[0]) {
if ($money1 == "" && $row[2] != 0) {
$money1 = sprintf($tbl_log_desc[85][3], money_to_string($row[2]));
}
if ($row[3] != NULL) {
array_push($goods1, sprintf($tbl_log_desc[85][2], $row[4], Lan_Item_GetDisplayName(Local2UTF8($row[3]), $row[5], false)));
}
} else {
if ($money2 == "" && $row[2] != 0) {
$money2 = sprintf($tbl_log_desc[85][3], money_to_string($row[2]));
}
if ($row[3] != NULL) {
array_push($goods2, sprintf($tbl_log_desc[85][2], $row[4], Lan_Item_GetDisplayName(Local2UTF8($row[3]), $row[5], false)));
}
}
}
if ($money1 != "") {
array_push($goods1, $money1);
}
if ($money2 != "") {
array_push($goods2, $money2);
}
$role_name1 = GetRoleName($role_id1, $server_id);
$role_name2 = GetRoleName($role_id2, $server_id);
$des .= sprintf($tbl_log_desc[85][0], $role_name1, $role_name2) . sprintf($tbl_log_desc[85][1], implode($tbl_log_desc[85][4], $goods1), implode($tbl_log_desc[85][4], $goods2));
case 153:
$qs = "select lng_sNpcName, count(*), lis.lis_sName, lm_uMoneyType, sum(lm_uMoney) from tbl_log_npc_giver lng, tbl_log_money lm, tbl_log_item_taker lit, tbl_log_item_static lis where lng.le_uId = lm.le_uId and lm.le_uId = lit.le_uId and lit.lis_uId = lis.lis_uId and lm.le_uId = {$event_id} and lm_uMoneyType < 3 group by lm.le_uId";
$rs = MySQLQuery($qs, "Log", $server_id);
if ($row = mysql_fetch_row($rs)) {
global $tbl_money_binding;
$des .= sprintf($tbl_log_desc[153], Lan_NPC_GetDisplayName(Local2UTF8($row[0]), false), $row[1], Lan_Item_GetDisplayName(Local2UTF8($row[2]), "", false), $tbl_money_binding[$row[3]], money_to_string(abs($row[4])));
}
break;
case 10002:
$des = $tbl_log_desc[10002];
break;
default:
$des .= "";
break;
}
return $des;
}
