Скрипт Гм статуса

if (!defined("C_LOADED")) exit();

function set_players_page()
{
    global $conf, $game_server, $serv, $conf_cache;

    $races=array(
        0 => "Все расы",
        1 => "Human",
        2 => "Elf",
        3 => "Dark Elf",
        4 => "Orc",
        5 => "Dwarf",
        6 => "Kamael"
    );

    $types=array(
        0 => "Игроки в онлайне",
    
    );

    $serv = intval(get_query_var("serv"));
    if (!isset($game_server[$serv])) $serv=0;

    $t = intval(get_query_var("t"));
    $r = intval(get_query_var("r"));

    $limit=intval($conf['ratings_limit']);

    $server_select="";
    for ($i=0; $i<count($game_server); $i++)
        $server_select.="<option value=".$i." ".(($i==$serv)?"selected":"").">".$game_server[$i]['name']."</option>";

    $types_select="";
    foreach ($types as $k=>$v)
        $types_select.="<option value=".$k." ".(($k==$t)?"selected":"").">".$v."</option>";

    $races_select="";
    foreach ($races as $k=>$v)
        $races_select.="<option value=".$k." ".(($k==$r)?"selected":"").">".$v."</option>";

/*
    $races_select="";
    switch($t)
    {
        case 6:
            $races_select.="<option value=0>Все рассы</option>";
        break;
        default:
            foreach ($races as $k=>$v) {
                $races_select.="<option value=".$k." ".(($k==$r)?"selected":"").">".$v."</option>";
            }
        break;
    }
*/

    $table="";

    $conn=db_connect($game_server[$serv]['host'], $game_server[$serv]['user'], $game_server[$serv]['pass']) or db_error("Can't connect to database");
    db_select($game_server[$serv]['db'], $conn) or db_error("Can't select database ".$game_server[$serv]['db']);

    // Запросы

    $u_query="players1".$t.$r.$serv;

    switch($t)
    {
        case 0:   // Игроки в онлайне
            $query=db_query("SELECT karma, character_subclasses.level, exp, onlinetime, char_name, (select clan_name from clan_data WHERE clan_data.clan_id=characters.clanId) as clan_name, (select clan_id from clan_data WHERE clan_data.clan_id=characters.clanId) as clan_id, pvpkills, pkkills, sex, ClassName AS class FROM characters, char_templates, character_subclasses WHERE accesslevel<'5' ".(($r!=0)?" AND RaceId='".($r-1)."'":"")." AND characters.obj_Id=character_subclasses.char_obj_id AND character_subclasses.class_id = char_templates.ClassId AND active=1 AND online=1 ORDER BY `exp` DESC", $conn, true, $conf_cache['mod_players_0'], $u_query) or db_error("Не удалось получить данные из базы", $conn);
        break;

}

// Таблица

    switch($t)
    {
        case 0:   // Игроки в онлайне
            $a = array("№", "Игровой ник");
            if ($conf['mod_ratings_show_lvl']) array_push($a, "LvL");
            array_push($a, "Класс", "Пол", "Клан", "Время в игре", "PvP/PK");
            $table.=html_table1("head", $a);

            $i=1;
            while($row=db_respond($query, "assoc", $u_query)) {
                $sex=($row['sex']==0)?"М":"Ж";
                $clan=(empty($row['clan_name']))?"-":html_link_cmd_id(html($row['clan_name']), "clan", $serv, $row['clan_id']);
                $char_name=($row['karma']>0)?"<font color=red>".html($row['char_name'])."</font>":html($row['char_name']);

                $a = array($i, $char_name);
                if ($conf['mod_ratings_show_lvl']) array_push($a, $row['level']);
                array_push($a, $row['class'], $sex, $clan, format_time1($row['onlinetime']), $row['pvpkills']."/<font color=red>".$row['pkkills']."</font>");
                $table.=html_table1("element", $a);

                $i++;
            }
            $table.=html_table1("end");
        break;
default:
        break;
    }

    db_close($conn);

    return t_parse(skn("players.html"),get_defined_vars());
}

?>

if (!defined("C_LOADED")) exit();

function set_players_page()
{
    global $conf, $game_server, $serv, $conf_cache;

    $races=array(
        0 => "Все расы",
        1 => "Human",
        2 => "Elf",
        3 => "Dark Elf",
        4 => "Orc",
        5 => "Dwarf",
        6 => "Kamael"
    );

    $types=array(
        0 => "Игроки в онлайне",
    
    );

    $serv = intval(get_query_var("serv"));
    if (!isset($game_server[$serv])) $serv=0;

    $t = intval(get_query_var("t"));
    $r = intval(get_query_var("r"));

    $limit=intval($conf['ratings_limit']);

    $server_select="";
    for ($i=0; $i<count($game_server); $i++)
        $server_select.="<option value=".$i." ".(($i==$serv)?"selected":"").">".$game_server[$i]['name']."</option>";

    $types_select="";
    foreach ($types as $k=>$v)
        $types_select.="<option value=".$k." ".(($k==$t)?"selected":"").">".$v."</option>";

    $races_select="";
    foreach ($races as $k=>$v)
        $races_select.="<option value=".$k." ".(($k==$r)?"selected":"").">".$v."</option>";

/*
    $races_select="";
    switch($t)
    {
        case 6:
            $races_select.="<option value=0>Все рассы</option>";
        break;
        default:
            foreach ($races as $k=>$v) {
                $races_select.="<option value=".$k." ".(($k==$r)?"selected":"").">".$v."</option>";
            }
        break;
    }
*/

    $table="";

    $conn=db_connect($game_server[$serv]['host'], $game_server[$serv]['user'], $game_server[$serv]['pass']) or db_error("Can't connect to database");
    db_select($game_server[$serv]['db'], $conn) or db_error("Can't select database ".$game_server[$serv]['db']);

    // Запросы

    $u_query="players1".$t.$r.$serv;

    switch($t)
    {
        case 0:   // Игроки в онлайне
            $query=db_query("SELECT karma, character_subclasses.level, exp, onlinetime, char_name, (select clan_name from clan_data WHERE clan_data.clan_id=characters.clanId) as clan_name, (select clan_id from clan_data WHERE clan_data.clan_id=characters.clanId) as clan_id, pvpkills, pkkills, sex, ClassName AS class FROM characters, char_templates, character_subclasses WHERE accesslevel>'5' ".(($r!=0)?" AND RaceId='".($r-1)."'":"")." AND characters.obj_Id=character_subclasses.char_obj_id AND character_subclasses.class_id = char_templates.ClassId AND active=1 AND online=1 ORDER BY `exp` DESC", $conn, true, $conf_cache['mod_players_0'], $u_query) or db_error("Не удалось получить данные из базы", $conn);
        break;

}

// Таблица

    switch($t)
    {
        case 0:   // Игроки в онлайне
            $a = array("№", "Игровой ник");
            if ($conf['mod_ratings_show_lvl']) array_push($a, "LvL");
            array_push($a, "Класс", "Пол", "Клан", "Время в игре", "PvP/PK");
            $table.=html_table1("head", $a);

            $i=1;
            while($row=db_respond($query, "assoc", $u_query)) {
                $sex=($row['sex']==0)?"М":"Ж";
                $clan=(empty($row['clan_name']))?"-":html_link_cmd_id(html($row['clan_name']), "clan", $serv, $row['clan_id']);
                $char_name=($row['karma']>0)?"<font color=red>".html($row['char_name'])."</font>":html($row['char_name']);

                $a = array($i, $char_name);
                if ($conf['mod_ratings_show_lvl']) array_push($a, $row['level']);
                array_push($a, $row['class'], $sex, $clan, format_time1($row['onlinetime']), $row['pvpkills']."/<font color=red>".$row['pkkills']."</font>");
                $table.=html_table1("element", $a);

                $i++;
            }
            $table.=html_table1("end");
        break;
default:
        break;
    }

    db_close($conn);

    return t_parse(skn("players.html"),get_defined_vars());
}

?>