gms.php

<?php
include('../includes/header.php');
?>

<div class="bg-1">
    <div class="main">
        <div class="container_24">
            <div class="wrapper">
                <article class="grid_24">
                    <h3 class="border-bot"></h3>
                    <div class="post">
                        <center>
                            <?php

                            include ("../configs/config.php");

                            $connect = ($GLOBALS["___mysqli_ston"] = mysqli_connect($host, $user, $pass)) or die('Нет подключения к базе данных');
((bool)mysqli_query( $connect, "USE " . $cdb)) or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
$sql = mysqli_query($GLOBALS["___mysqli_ston"], "SET NAMES cp1251");
$sql = mysqli_query( $connect, "SELECT * FROM `$cdb`.`characters` c INNER JOIN `auth`.`account_access` a ON a.id = c.account WHERE a.gmlevel <> 0 AND a.RealmID = 1 AND c.online = 1 ORDER BY a.gmlevel DESC") or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
print "<h2 align=\"center\">Администрация онлайн</h2>
<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\"><tr>
<th width=\"30\">№</th>
<th>Имя</th>
<th width=\"30\">Лвл</th>
<th width=\"120\">Раса</th>
<th width=\"120\">Класс</th>
<th width=\"100\">Сторона</th>
<th width=\"150\">Ранг</th>
</tr></table>";
$id = 1;
while ($result = mysqli_fetch_array($sql)){
    $name = $result['name'];
    $level = $result['level'];
    $rang = $result['gmlevel'];

    switch ($rang){
        case 1: $rang = 'Модератор';break;
        case 2: $rang = 'Гейм мастер';break;
        case 3: $rang = 'Администратор мира';break;
        default: $rang = 'Администратор сервера';break;
    }

    if ($result['race'] == 1 || $result['race'] == 3 || $result['race'] == 4 || $result['race'] == 7 || $result['race'] == 11){
        $side = 'Альянс';
        $style_side = 'blue';
    }
    else{
        $side = 'Орда';
        $style_side = 'red';
    }

    switch ($result['race']){
        case 1: $race = 'Человек';break;
        case 2: $result['gender'] == 0 ? $race = 'Орк' : $race = 'Орчиха';break;
        case 3: $race = 'Дворф';break;
        case 4: $result['gender'] == 0 ? $race = 'Ночной эльф' : $race = 'Ночная эльфийка';break;
        case 5: $result['gender'] == 0 ? $race = 'Отрекшийся' : $race = 'Отрекшаяся';break;
        case 6: $race = 'Таурен';break;
        case 7: $race = 'Гном';break;
        case 8: $result['gender'] == 0 ? $race = 'Тролль' : $race = 'Троллиха';break;
        case 10: $result['gender'] == 0 ? $race = 'Эльф крови' : $race = 'Эльфийка крови';break;
        case 11: $result['gender'] == 0 ? $race = 'Дреней' : $race = 'Дренейка';break;
    }

    if ($result['class'] == 1){
        $class = 'Воин';
        $style_class = '#C79C6E';
    }
    if ($result['class'] == 2){
        $class = 'Паладин';
        $style_class = '#F58CBA';
    }
    if ($result['class'] == 3){
        $class = 'Охотник';
        $style_class = '#ABD473';
    }
    if ($result['class'] == 4){
        $class = 'Разбойник';
        $style_class = '#FFF569';
    }
    if ($result['class'] == 5){
        $class = 'Жрец';
        $style_class = '#FFFFFF';
    }
    if ($result['class'] == 6){
        $class = 'Рыцарь смерти';
        $style_class = '#C41F3B';
    }
    if ($result['class'] == 7){
        $class = 'Шаман';
        $style_class = '#0070DE';
    }
    if ($result['class'] == 8){
        $class = 'Маг';
        $style_class = '#69CCF0';
    }
    if ($result['class'] == 9){
        $class = 'Чернокнижник';
        $style_class = '#9482C9';
    }
    if ($result['class'] == 11){
        $class = 'Друид';
        $style_class = '#FF7D0A';
    }

    print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\" id=\"border\"><tr>
    <td align=\"center\" width=\"30\">$id</td>
    <td align=\"center\">$name</td>
    <td align=\"center\" width=\"30\">$level</td>
    <td align=\"center\" width=\"120\">$race</td>
    <td align=\"center\" width=\"120\"><font color=\"$style_class\">$class</font></td>
    <td align=\"center\" width=\"100\"><font color=\"$style_side\">$side</font></td>
    <td align=\"center\" width=\"150\">$rang</td>
    </tr></table>";
$id++;
}
((is_null($___mysqli_res = mysqli_close($connect))) ? false : $___mysqli_res);
?>
                        </center>
                    </div>
                </article>
            </div>
        </div>
    </div>
</div>

<?php
include('../includes/body.php');
include('../includes/footer.php');
?>