<?  
$ip="127.0.0.1";    // IP доступа к серверу (реалмлист)  
$gameport="8085";                    // Порт игрового сервера 8085 или 8086  
$dbip="127.0.0.1";                     // IP к mysql  
$dbport="3306";                   // порт к mysql  
$dblogin="mangos";    // Логин для mysql  
$dbpass="mangos";                  // Пароль для mysql  
$dbm="mangos";     // Имя базы мира (mangos)  
$dbc="characters";    // Имя базы персонажей              
$dbr="realmd";     // Имя базы аккаунтов  
$dbc2="characters2"                            // Для тех у кого два мира  
?>

<?  
include('config.php');  
$fp1 = @fsockopen('$ip', $gameport, $errno, $errstr, 1);  
$onoff200=($fp1?"Включен":"Выключен");            
          ?>  
<b>Статус сервера:</b>
  
<?echo " $onoff200"; ?>
</p>

<?  
include('config.php');  
mysql_connect("$ip", "$dblogin", "$dbpass");  
mysql_select_db ("$dbc");  
$human = mysql_query ("select count(*) from characters where race = 1");  
$human = mysql_result ($human,0);  
$dwarv = mysql_query ("select count(*) from characters where race = 3");  
$dwarv = mysql_result ($dwarv,0);  
$night = mysql_query ("select count(*) from characters where race = 4");  
$night = mysql_result ($night,0);  
$gnome = mysql_query ("select count(*) from characters where race = 7");  
$gnome = mysql_result ($gnome,0);  
$draenei = mysql_query ("select count(*) from characters where race = 11");  
$draenei = mysql_result ($draenei,0);  
$orc = mysql_query ("select count(*) from characters where race = 2");  
$orc = mysql_result ($orc,0);  
$undead = mysql_query ("select count(*) from characters where race = 5");  
$undead = mysql_result ($undead,0);  
$tauren = mysql_query ("select count(*) from characters where race = 6");  
$tauren = mysql_result ($tauren,0);  
$troll = mysql_query ("select count(*) from characters where race = 8");  
$troll = mysql_result ($troll,0);  
$blood = mysql_query ("select count(*) from characters where race = 10");  
$blood = mysql_result ($blood,0);  
$druid = mysql_query ("select count(*) from characters where class = 11");  
$druid = mysql_result ($druid,0);  
$hunter = mysql_query ("select count(*) from characters where class = 3");  
$hunter = mysql_result ($hunter,0);  
$mage = mysql_query ("select count(*) from characters where class = 8");  
$mage = mysql_result ($mage,0);  
$paladin = mysql_query ("select count(*) from characters where class = 2");  
$paladin = mysql_result ($paladin,0);  
$priest = mysql_query ("select count(*) from characters where class = 5");  
$priest = mysql_result ($priest,0);  
$rogue = mysql_query ("select count(*) from characters where class = 4");  
$rogue = mysql_result ($rogue,0);  
$shaman = mysql_query ("select count(*) from characters where class = 7");  
$shaman = mysql_result ($shaman,0);  
$warlock = mysql_query ("select count(*) from characters where class = 9");  
$warlock = mysql_result ($warlock,0);  
$warrior = mysql_query ("select count(*) from characters where class = 1");  
$warrior = mysql_result ($warrior,0);  
$death = mysql_query ("select count(*) from characters where class = 6");  
$death = mysql_result ($death,0);  
echo "Людей: $human<br>";  
echo "Дварфов: $dwarv<br>";  
echo "Ночных Эльфов: $night<br>";  
echo "Гномов: $gnome<br>";  
echo "Дренейев: $draenei<br>";  
echo "Орков: $orc<br>";  
echo "Нежити: $undead<br>";  
echo "Тауренов: $tauren<br>";  
echo "Троллей: $troll<br>";  
echo "Эльфов Крови: $blood<br><br>";  
echo "Друидов: $druid<br>";  
echo "Охотников: $hunter<br>";  
echo "Магов: $mage<br>";  
echo "Паладинов: $paladin<br>";  
echo "Жрецов: $priest<br>";  
echo "Разбойников: $rogue<br>";  
echo "Шаманов: $shaman<br>";  
echo "Чернокнижников: $warlock<br>";  
echo "Воинов: $warrior<br>";  
echo "Рыцарей Смерти: $death<br>";  
?>

<?            
include('config.php');  
$fp1 = @fsockopen ("$ip","8085",$errno,$errstr,1);  
if ($fp1) {           
mysql_connect("$dbip","$dblogin","$dbpass");  
mysql_selectdb ("$dbc");            
$online_tmp = mysql_query ("select count(guid) as kol from characters where online = 1");            
$online_kol = mysql_fetch_array($online_tmp);  
$online1 = $online_kol['kol'];  
}  
else $online1 = 0;  
$fp2 = @fsockopen ("localhost","8086",$errno,$errstr,1);  
if ($fp2) {          
mysql_connect("$dbip","$dblogin","$dbpass");  
mysql_selectdb ("$dbc2");           
$online_tmp = mysql_query ("select count(guid) as kol from characters where online = 1");  
$online_kol = mysql_fetch_array($online_tmp);  
$online2 = $online_kol['kol'];          
}  
else $online2 = 0;  
$online=$online1 + $online2;            
echo $online;            
?>        

<?php        

$config = array (  

        // Names of DBs  
        'wname'   => 'mangos', // база мира  
        'rname'   => 'realmd', // база реалмов  
        'cname'   => 'characters', // база чаров  
        // DB settings  
        'host' => '127.0.0.1', // адрес БД  
        'user' => 'mangos', // логин к БД  
        'pass' => 'mangos', // пароль к БД  
        'port' => '3306', // порт к БД  
);  

$db1 = "realmd";                     
$db2 = "mangos";                
$db3 = "characters";         

<?php  
$realm = $realmdDB -> selectrow("SELECT * FROM `realmlist` WHERE `id` = ?d;", $CONF['realmID']);  

$realmOnline = testRealm($realm);  

if ($realmOnline) {  
         if (isset($_GET['id'])) {  
             $guild = $charactersDB -> selectrow(  
                 "SELECT `c`.`name` as `lname`, `g`.`name`, `g`.`createdate`, `g`.`BankMoney`, `g`.`info`, `g`.`motd` ".  
                 "FROM `guild` as `g` ".  
                 "LEFT JOIN `characters` as `c` ON `c`.`guid` = `g`.`leaderguid` ".  
                 "WHERE `g`.`guildid` = ?d;", $_GET['id']);  
                  
             $members = $charactersDB -> select(  
                 "SELECT `c`.`name`, `c`.`race`, `c`.`class`, `c`.`account`, `g_m`.`pnote`, `g_m`.`offnote`, `g_r`.`rname`, ".  
                 "CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`c`.`data`, ' ', 54), ' ', -1) AS UNSIGNED) as `level`, ".  
                 "CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`c`.`data`, ' ', 23), ' ', -1) AS UNSIGNED) as `gender` ".  
                 "FROM `guild_member` as `g_m` ".  
                 "LEFT JOIN `characters` as `c` ON `c`.`guid` = `g_m`.`guid` ".  
                 "LEFT JOIN `guild_rank` as `g_r` ON (`g_r`.`rid` = `g_m`.`rank` AND `g_r`.`guildid` = `g_m`.`guildid`) ".  
                 "WHERE `g_m`.`guildid` = ?d", $_GET['id']);  
                      
?>  
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">  
<tr>  
         <td class="top">Название: </td>  
         <td><?php echo $guild['name']; ?></td>  
</tr>  
<tr>  
         <td class="top">Гильдмастер: </td>  
         <td><?php echo $guild['lname']; ?></td>  
</tr>  
<tr>  
         <td class="top">Дата создания: </td>  
         <td><?php echo date("d.m.Y H:m", $guild['createdate']); ?></td>  
</tr>  
<tr>  
         <td class="top">Денег в банке: </td>  
         <td><?php echo gold($guild['BankMoney']); ?></td>  
</tr>  
<tr>  
         <td class="top">Информация: </td>  
         <td><?php echo $guild['info']; ?></td>  
</tr>  
<tr>  
         <td class="top">Девиз: </td>  
         <td><?php echo $guild['motd']; ?></td>  
</tr>  
</table>  
<br>  
<h2>Участники гильдии:</h2>  
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">  
         <tr>  
             <td class="top">#</td>  
             <td class="top">Имя</td>  
             <td class="top">Уровень</td>  
             <td class="top">Звание в гильдии</td>  
             <td class="top">Раса</td>  
             <td class="top">Класс</td>  

         </tr>  
<?php  
             $i = 1;  
             foreach ($members as $member) {  
                      
                 $member['aname'] = $realmdDB -> selectcell("SELECT `username` FROM `account` WHERE `id` = ?d;", $member['account']);  
?>  
         <tr>  
             <td><?php echo $i; ?></td>  
             <td><?php echo $member['name']; ?></td>  
             <td><?php echo $member['level']; ?></td>  
             <td><?php echo $guild['lname']==$member['name']?"Guild Master":$member['rname']; ?></td>  
             <td><?php echo "<img src=\"./img/".$member['race']."-".gender($member['gender']).".gif\" alt=\"".$CONF['races'][$member['race']]."\">"; ?></td>  
             <td><?php echo "<img src=\"./img/".$member['class'].".gif\" alt=\"".$CONF['classes'][$member['class']]."\">"; ?></td>  

         </tr>  
<?php  
                 $i++;  
             }  
             echo "</table>\n";  
                  
         } else {  
             !isset($_GET['sb'])? $_GET['sb'] = 'name': $_GET['sb'];  
             !isset($_GET['sc'])? $_GET['sc'] = 'ASC': $_GET['sc'];  
                  
             if ($_GET['sc'] != 'ASC' && $_GET['sc'] != 'DESC') $_GET['sc'] = 'DESC';  
                  
             $guilds = $charactersDB -> select(  
                 "SELECT `c`.`name` as `lname`, `g`.`name`, `g`.`createdate`, `g`.`BankMoney`, `g`.`guildid` ".  
                 "FROM `guild` as `g` ".  
                 "LEFT JOIN `characters` as `c` ON `c`.`guid` = `g`.`leaderguid` ".  
                 "ORDER BY ?# ".$_GET['sc'].";", $_GET['sb']);  
                  
             $i = 1;  
?>  
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">  
         <tr>  
             <td class="top">#</td>  
             <td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=name&sc=".(($_GET['sc']=='ASC' && $_GET['sb']=="name")? "DESC": "ASC");?>">Название</a></td>  
             <td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=lname&sc=".(($_GET['sc']=='ASC' && $_GET['sb']=="lname")? "DESC": "ASC");?>">Гильдмастер</a></td>  
             <td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=createdate&sc=".(($_GET['sc']=='DESC' && $_GET['sb']=="createdate")? "ASC": "DESC");?>">Дата создания</a></td>  
             <td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=BankMoney&sc=".(($_GET['sc']=='DESC' && $_GET['sb']=="BankMoney")? "ASC": "DESC");?>">Денег в банке</a></td>  
         </tr>  
<?php  
             foreach ($guilds as $guild) {  
?>  
         <tr>  
             <td><?php echo $i; ?></td>  
             <td><?php echo "<a href=\"?page=guilds&id=".$guild['guildid']."\">".$guild['name']."</a>"; ?></a></td>  
             <td><?php echo $guild['lname']; ?></td>  
             <td><?php echo date("d.m.Y H:m", $guild['createdate']); ?></td>  
             <td><?php echo gold($guild['BankMoney']); ?></td>  
         </tr>  
<?php  
                 $i++;  
             }  
             echo "</table>\n";  
         }  
} else {  
         echo $realm['name']." выключен.<br>\n";  
}  
?>    

<?  
include('config.php');   
mysql_selectdb ("$dbr");  
$max = mysql_query ("select max(`maxplayers`) from uptime");      
$max = mysql_result ($max,0);  
echo "Максимальный онлайн:$max <br>";  
?>