function ShowVirWealthLog_MarketBuyOrder($var, $gm) { global $tbl_log_db, $tbl_sys_msg, $tbl_event_type, $tbl_serv_db, $tbl_market_buy_order, $tbl_sys_msg, $page_main; LastLogTime(); $server_id = $var["serverid"]; $role_id = ArgRoleId(); if (!$role_id) { return true; } echo "<table class='list_table'>\n"; printf("<tr><th style='width:120px;'>%s</th><th>%s</th><th>%s</th><th>%s</th></tr>\n", $tbl_sys_msg["time"], $page_main["item"], $page_main["number"], $page_main["UnitPrice"]); $qs = "select le_dtDateTime, lmbo_sItemName, lmbo_uCount, lmbo_uPrice, lmos_uId from tbl_log_market_buy_order_static lmbo, tbl_log_player_giver lpg, tbl_log_event le where le.le_uId = lpg.le_uId and lpg.le_uId = lmbo.le_uId and lpg.lcs_uId = {$role_id} " . getDateLimit($var, $server_id) . " order by le_dtDateTime"; $result = MySQLQuery($qs, "Log", $server_id); while ($row = mysql_fetch_row($result)) { printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $row[0], Lan_Item_GetDisplayName(Local2UTF8($row[1])), $row[2], money_to_string($row[3])); $qs = "select le_dtDateTime, lc.lc_sName, count(*) from tbl_log_char lc, tbl_log_market_item lmi, tbl_log_player_giver lpg, tbl_log_item_giver lig, tbl_log_event le where lpg.lcs_uId = lc.lcs_uId and le.le_uId = lmi.le_uId and le.le_uId = lpg.le_uId and le.le_uId = lig.le_uId and lmi.mos_uId = " . $row[4] . " group by le.le_uId order by le.le_uId"; $rs = MySQLQuery($qs, "Log", $server_id); $count = 0; while ($r = mysql_fetch_row($rs)) { $count += $r[2]; printf("<tr style='color:#888;'><td>%s</td><td colspan='3'>%s</td></tr>\n", $r[0], sprintf($tbl_market_buy_order[0], $r[1], $r[2])); } if ($count > 0) { printf("<tr style='color:#888;'><td></td><td colspan='3'>" . $tbl_market_buy_order[1] . "</td></tr>\n", $count); } $qs = "select le_dtDateTime, let_uEventType from tbl_log_market_item lmi, tbl_log_player_taker lpt, tbl_log_event le, tbl_log_event_type let where le.le_uId = lmi.le_uId and le.le_uId = lpt.le_uId and le.le_uId = let.le_uId and lmi.mos_uId = " . $row[4]; $rs = MySQLQuery($qs, "Log", $server_id); if ($r = mysql_fetch_row($rs)) { printf("<tr style='color:#888;'><td>%s</td><td colspan='3'>" . $tbl_market_buy_order[2] . "</td></tr>\n", $r[0], $tbl_market_buy_order[3][$r[1]]); } } echo "</table>\n"; ReturnAndBack(); return true; }
function JointSales_ItemList($var, $gm) { global $page_main, $tbl_sys_msg, $tbl_joint_sales_status, $page_action_name; $js_str = <<<_js_str <script> function toEdit(id){ \tdocument.form1.action_name.value = "267"; \tdocument.form1.id.value = id; \tdocument.form1.flag.value = "edit"; \tdocument.form1.submit(); } function toDelete(id){ \tdocument.form1.action_name.value = "267"; \tdocument.form1.id.value = id; \tdocument.form1.flag.value = "delete"; \tdocument.form1.submit(); } function toStatus(id,statue){ \tdocument.form1.action_name.value = "271"; \tdocument.form1.id.value = id; \tdocument.form1.flag.value = statue; \tdocument.form1.submit(); } function toSN(id){ \tdocument.form1.action_name.value = "268"; \tdocument.form1.id.value = id; \tdocument.form1.submit(); } function toLog(id){ \tdocument.form1.action_name.value = "270"; \tdocument.form1.id.value = id; \tdocument.form1.submit(); } </script> _js_str; echo $js_str . "\n"; form($var, $gm); echo "<input type='hidden' name='id' />\n"; echo "<input type='hidden' name='flag' />\n"; echo "</form>\n"; $qs = "select jsi.jsi_sItemName, jsi.jsi_uPrice, jsi.jsi_uState, jsi_uId, jsi_uSmallIcon, jsi_sTooltips from tbl_joint_sales_items jsi"; $rs = MySQLQuery($qs, "GMS"); echo "<table class='list_table'>\n"; printf("<tr><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th><th>%s</th></tr>\n", $page_main["item"], "SmallIcon", $page_main["price"], $page_main["number"], $tbl_sys_msg["status"], $tbl_sys_msg["detail"], $page_action_name["268"], $page_action_name["270"], $tbl_sys_msg["act"]); while ($row = mysql_fetch_row($rs)) { $qs = "select count(*) from tbl_joint_sales_sn where jsi_uId = " . $row[3]; $result = MySQLQuery($qs, "GMS"); if ($r = mysql_fetch_row($result)) { $count = $r[0]; } if ($row[2] == 0) { $str = "<button onclick='toStatus(" . $row[3] . ",1);'>" . $tbl_joint_sales_status[1] . "</button><button onclick='toEdit(" . $row[3] . ");'>" . $tbl_sys_msg["edit"] . "</button><button onclick='toDelete(" . $row[3] . ");'>" . $tbl_sys_msg["delete"] . "</button>"; } else { $str = "<button onclick='toStatus(" . $row[3] . ",0);'>" . $tbl_joint_sales_status[0] . "</button>"; } printf("<tr><td>%s</td><td>%d</td><td>%s</td><td>%d</td><td>%s</td><td><button onclick='toDetal(%d);'>%s</button></td><td><button onclick='toSN(%d);'>%s</button></td><td><button onclick='toLog(%d);'>%s</button></td><td>%s</td></tr>\n", $row[0], $row[4], money_to_string($row[1]), $count, $tbl_joint_sales_status[$row[2]], $row[3], $tbl_sys_msg["detail"], $row[3], $page_action_name["268"], $row[3], $page_action_name["270"], $str); printf("<tr><td colspan='9'>%s</td></tr>\n", $row[5]); } echo "</table>\n"; echo "<table class='list_table'>\n"; echo "<tr><td><button onclick='toEdit(0);'>" . $tbl_sys_msg["insert"] . "</button></td></tr>\n"; echo "</table>\n"; return true; }