Esempio n. 1
0
function GetFriends($var, $gm)
{
    global $tbl_role_all_detail;
    echo "<h1>{$tbl_role_all_detail['16']}</h1>\n";
    ReturnAndBack();
    Reload();
    $role_id = ArgRoleId();
    echo "<table class='list_table'>\n";
    echo sprintf("<tr><td>{$tbl_role_all_detail['18']}</td></tr>\n", ArgRoleName() . "(" . $role_id . ")");
    echo "</table>\n";
    global $tbl_role_friends, $tbl_camp, $tbl_class, $tbl_sex, $tbl_sys_msg;
    $serverid = $var["serverid"];
    if (!$role_id) {
        return true;
    }
    echo "<h1>" . $tbl_role_friends[0] . "</h1>\n";
    echo "<table class='list_table'>\n";
    printf("<tr><th>%s</th><th>%s</th><th style='width:100px;'>%s</th><th style='width:100px;'>%s</th><th style='width:100px;'>%s</th><th style='width:100px;'>%s</th></tr>\n", $tbl_role_friends[1][0], $tbl_role_friends[1][1], $tbl_role_friends[1][2], $tbl_role_friends[1][3], $tbl_role_friends[1][4], $tbl_role_friends[1][5]);
    $rs = MySQLQuery("select c.c_sName, cs.cs_uCamp, cs.cs_uClass, cb.cb_uLevel, cs.cs_uSex, fc.fc_sName from tbl_player_friends pf, tbl_friends_class fc, tbl_char c, tbl_char_basic cb, tbl_char_static cs where pf.fc_uId = fc.fc_uId and pf.cs_uId = fc.cs_uId and pf.pf_uFriendId = c.cs_uId and fc.fc_uId<>2 and pf.cs_uId='{$role_id}' and cb.cs_uId = c.cs_uId and cs.cs_uId = c.cs_uId", "Game", $serverid);
    while ($row = mysql_fetch_row($rs)) {
        if ($row[5] == UTF82Local($tbl_role_friends[1][6])) {
            $row[5] = $tbl_role_friends[1][6];
        }
        printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $row[5], $row[0], $tbl_camp[$row[1]], $tbl_class[$row[2]], $row[3], $tbl_sex[$row[4]]);
    }
    echo "</table>\n";
    echo "<h1>" . $tbl_role_friends[2] . "</h1>\n";
    echo "<table class='list_table'>\n";
    printf("<tr><th>%s</th><th style='width:100px;'>%s</th><th style='width:100px;'>%s</th><th style='width:100px;'>%s</th><th style='width:100px;'>%s</th></tr>\n", $tbl_role_friends[3][0], $tbl_role_friends[3][1], $tbl_role_friends[3][2], $tbl_role_friends[3][3], $tbl_role_friends[3][4]);
    $rs = MySQLQuery("select c.c_sName, cs.cs_uCamp, cs.cs_uClass, cb.cb_uLevel, cs.cs_uSex from tbl_player_friends pf, tbl_char c, tbl_char_basic cb, tbl_char_static cs where pf.pf_uFriendId = c.cs_uId and pf.cs_uId='{$role_id}' and pf.fc_uId=2 and cb.cs_uId = c.cs_uId and cs.cs_uId = c.cs_uId", "Game", $serverid);
    while ($row = mysql_fetch_row($rs)) {
        printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $row[0], $tbl_camp[$row[1]], $tbl_class[$row[2]], $row[3], $tbl_sex[$row[4]]);
    }
    echo "</table>\n";
    echo "<h1>" . $tbl_role_friends[4] . "</h1>\n";
    echo "<table class='list_table'>\n";
    printf("<tr><th>%s</th><th>%s</th><th>%s</th></tr>\n", $tbl_role_friends[5][0], $tbl_role_friends[5][1], $tbl_role_friends[5][2]);
    $rs = MySQLQuery("select fg.fg_sName,gm1.gm_uIdentity,count(*) from tbl_group_manager gm1,tbl_group_manager gm2,tbl_friends_group fg where gm1.cs_uId='{$role_id}' and gm1.fg_uId = gm2.fg_uId and gm1.fg_uId = fg.fg_uId group by gm2.fg_uId", "Game", $serverid);
    while ($row = mysql_fetch_row($rs)) {
        printf("<tr><td>%s</td><td>%s</td><td>%d</td></tr>\n", $row[0], $tbl_role_friends[5][3][intval($row[1])], $row[2]);
    }
    echo "</table>\n";
    echo "<h1>" . $tbl_role_friends[6] . "</h1>\n";
    echo "<table class='list_table'>\n";
    printf("<tr><th>%s</th><th>%s</th><th>%s</th></tr>\n", $tbl_role_friends[7][0], $tbl_role_friends[7][1], $tbl_role_friends[7][2]);
    $rs = MySQLQuery("select t.t_sName, mt1.mt_sPosition, count(*) from tbl_member_tong mt1, tbl_tong t, tbl_member_tong mt2 where mt1.t_uId = t.t_uId and t.t_uId = mt2.t_uId and mt1.cs_uId = '{$role_id}' group by t.t_uId", "Game", $serverid);
    while ($row = mysql_fetch_row($rs)) {
        global $tbl_tong_pos;
        printf("<tr><td>%s</td><td>%s</td><td>%d</td></tr>\n", $row[0], $tbl_tong_pos[intval($row[1])], $row[2]);
    }
    echo "</table>\n";
    return true;
}
Esempio n. 2
0
function SearchTaskInfo($var, $gm)
{
    global $tbl_list_task;
    $serverid = $var["serverid"];
    $role_id = ArgRoleId();
    if (!$role_id) {
        return true;
    }
    $query_string = "select q_sName,q_state,FROM_UNIXTIME(q_tAcceptTime),FROM_UNIXTIME(q_tFinishTime) from tbl_quest where cs_uId=" . $role_id . " and q_sName = '" . UTF82Local($var["quest_name"]) . "'";
    $result = MySQLQuery($query_string . " order by q_tAcceptTime", "Game", $serverid);
    $tbl_content = array();
    while ($row = mysql_fetch_row($result)) {
        $row[1] = $tbl_list_task[intval($row[1])];
        $tbl_size = count($tbl_content);
        $tbl_content[$tbl_size] = $row;
    }
    if (!IsDownload($var)) {
        RetGetTaskInfo($tbl_content, $role_name, $role_id);
        return true;
    }
    return true;
}
Esempio n. 3
0
function MoneyLog_3_7($var, $gm)
{
    global $circulation, $tbl_event_type, $tbl_serv_db, $tbl_sys_msg, $page_main;
    echo "<table class=\"list_table\" style=\"text-align:right;\">\n";
    echo "<tr style=\"text-align:center;\"><th>" . $tbl_sys_msg["time"] . "</th><th>" . $page_main["event_type"] . "</th><th>" . $page_main["number"] . "</th><th>" . $tbl_sys_msg["desc"] . "</th></tr>\n";
    $day = $var["day"];
    $date = date("Y-m-d", time() - $day * 24 * 60 * 60);
    $server_id = $var["serverid"];
    $tbl = array();
    $role_id = ArgRoleId();
    if (!$role_id) {
        return true;
    }
    $qs = "select lm.le_uId, le.le_dtDateTime, let.let_uEventType, lm.lm_uMoney from tbl_log_money lm, tbl_log_event le force index(le_dtDateTime), tbl_log_event_type let where lm.le_uId = le.le_uId and le.le_uId = let.le_uId and let.let_uEventType in ({$circulation}) and le.le_dtDateTime > '{$date} 00:00:00' and lm.lcs_uId = {$role_id}";
    $result = MySQLQuery($qs, "Log", $server_id);
    while ($row = mysql_fetch_row($result)) {
        $le_uId = $row[0];
        $event_type = $row[2];
        $str = "";
        switch ($event_type) {
            case 114:
                //订单被成功购买邮件
                break;
            case 165:
                //代工成功
                break;
            case 81:
                //玩家邮件提取钱
                break;
            case 85:
                //玩家交易
                break;
            case 152:
                //拍卖平均分钱
                break;
        }
        printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $row[1], $tbl_event_type[$row[2]], number_to_string($row[3]), $str);
    }
    echo "</table>\n";
    return true;
}
Esempio n. 4
0
function GetRoleAllDetail($var, $gm)
{
    global $tbl_role_all_detail, $tbl_sys_msg;
    $serverid = $var["serverid"];
    $js_str = <<<_js_str
<script type="text/javascript">
function toItem(){
\tdocument.form1.action_name.value = "201";
\tdocument.form1.submit();
}
function toFriend(){
\tdocument.form1.action_name.value = "199";
\tdocument.form1.submit();
}
function toRealTime(){
\tdocument.form1.action_name.value = "204";
\tdocument.form1.submit();
}
</script>
_js_str;
    echo $js_str . "\n";
    echo "<h1>{$tbl_role_all_detail['10']}</h1>\n";
    ReturnAndBack();
    Reload();
    form($var, $gm);
    $role_id = ArgRoleId();
    echo "<input type='hidden' name='role_str' value='" . $var["role_str"] . "'/>";
    echo "<input type='hidden' name='role_item' value='" . $var["role_item"] . "'/>";
    echo "<table class='list_table'>\n";
    echo sprintf("<tr><td>{$tbl_role_all_detail['0']}</td></tr>\n", ArgRoleName() . "(" . $role_id . ")");
    echo "<tr><td><a href='#' onclick='toItem()'>{$tbl_role_all_detail['15']}</a></td></tr>\n";
    echo "<tr><td><a href='#' onclick='toFriend()'>{$tbl_role_all_detail['16']}</a></td></tr>\n";
    echo "</table>\n";
    echo "</form>\n";
    echo "<h2>{$tbl_role_all_detail['1']}</h2>\n" . GetRoleDetail($role_id, $serverid);
    echo "<h2>{$tbl_role_all_detail['19']}</h2>\n" . GetRoleLogin($role_id, $serverid);
    echo "<h2>{$tbl_role_all_detail['2']}</h2>\n" . GetRoleLocation($role_id, $serverid);
    echo "<h2>{$tbl_role_all_detail['11']}</h2>\n" . GetRoleSort($role_id, $serverid);
    echo "<h2>{$tbl_role_all_detail['12']}</h2>\n" . GetRoleAppellation($role_id, $serverid);
    echo "<h2>{$tbl_role_all_detail['6']}</h2>\n" . GetRoleSkill($role_id, $serverid);
    return true;
}
Esempio n. 5
0
function GetRoleTeamLog($var, $gm)
{
    global $tbl_sys_msg, $page_main, $tbl_log_db, $tbl_serv_db, $tbl_team_log;
    $server_id = $var["serverid"];
    LastLogTime();
    $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["type"], $page_main["role_name"], $tbl_sys_msg["status"]);
    $qs = "select le.le_dtDateTime, let.let_uTeamId ";
    $qs .= "from tbl_log_player lp, tbl_log_event le, tbl_log_enter_team let ";
    $qs .= "where le.le_uId = lp.le_uId and le.le_uId = let.le_uId and ";
    $qs .= "lp.lcs_uId = '{$role_id}' " . getDateLimit($var, $server_id) . " ";
    $qs .= "order by le.le_uId";
    $result = MySQLQuery($qs, "Log", $server_id);
    while ($row = mysql_fetch_row($result)) {
        $team_member = array();
        printf("<tr><td>%s</td><td colspan='3'></td></tr>\n", $row[0]);
        $qs = "(select le.le_dtDateTime, 0, lp.lcs_uId from tbl_log_enter_team let, tbl_log_event le, tbl_log_player lp where let.le_uId = le.le_uId and lp.le_uId = le.le_uId and let.let_uTeamId = " . $row[1] . ")";
        $qs .= "union";
        $qs .= "(select le.le_dtDateTime, 1, lp.lcs_uId from tbl_log_leave_team llt, tbl_log_event le, tbl_log_player lp where llt.le_uId = le.le_uId and lp.le_uId = le.le_uId and llt.let_uTeamId = " . $row[1] . ")";
        $qs .= "order by le_dtDateTime";
        $rs = MySQLQuery($qs, "Log", $server_id);
        while ($r = mysql_fetch_row($rs)) {
            $role_name = GetRoleName($r[2], $server_id);
            if ($r[1] == "0") {
                $type = $tbl_sys_msg["enter"];
                array_push($team_member, $role_name);
            } else {
                $type = $tbl_sys_msg["leave"];
                $index = array_search($role_name, $team_member);
                unset($team_member[$index]);
            }
            printf("<tr style='color: #888;'><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $r[0], $type, $role_name, implode(", ", $team_member));
        }
    }
    echo "</table>\n";
    return true;
}
Esempio n. 6
0
function ChannelChatAllLog($var, $gm)
{
    global $tbl_serv_db, $tbl_sys_msg, $page_main, $tbl_channel, $channel_id;
    echo "<script type='text/javascript' src='/js/page.js'></script>\n";
    echo "<script type='text/javascript' src='/js/checkbox.js'></script>\n";
    $serverid = $var["serverid"];
    $role_id = ArgRoleId();
    if (!$role_id) {
        return true;
    }
    $str = "";
    if ($var["begin_time"] != null && $var["begin_time"] != "") {
        $str .= " and lcc_dtChatTIme >= '" . $var["begin_time"] . "'";
    }
    if ($var["end_time"] != null && $var["end_time"] != "") {
        $str .= " and lcc_dtChatTIme <= '" . $var["end_time"] . "'";
    }
    $qs = "select lcc_sMsg, lcc_dtChatTime, lcc_sChannelName from tbl_log_channel_chat where cs_uId = " . $role_id . $str;
    $rs = MySQLQuery($qs, "GameLog", $serverid);
    echo "<table class='list_table'>\n";
    printf("<tr><th>%s</th><th>%s</th><th>%s</th></tr>\n", $tbl_sys_msg["time"], $page_main["content"], $page_main["channel"]);
    while ($row = mysql_fetch_row($rs)) {
        printf("<tr><td>%s</td><td>%s</td><td>%s</td></tr>\n", $row[1], ChannelString($row[0]), $tbl_channel[$channel_id[$row[2]]]);
    }
    echo "</table>\n";
    return true;
}