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;
}
