<center><I><B><SPAN style="color:red">Ip баны</SPAN></B></I><center>
<meta http-equiv="Content-Type" content="text/html; charset= ansi" />
<?php  

// You Should Write here your MySQL Server information !  

$host = 'localhost'; // Host adress  
$user = 'trinity'; //Username  
$password = 'trinity'; //Password  
$realmdb = 'realmd'; // the name of realmd database  

echo "<center><table border=1><tr><th>IP:</th><th>Причина</th><th>Бан дал</th><th>Дата Бана</th><th>Дата Разбана</th></tr>";  
$connection = mysql_connect($host, $user, $password) or die ("Can't connect with $host");  
mysql_select_db($realmdb, $connection);  
$sql = "SELECT `ip`,`banreason`, `bannedby`, `bandate`, `unbandate` FROM `ip_banned`";  
$result = mysql_query($sql, $connection);  

while ($vystup = mysql_fetch_array($result))  
{  
echo "<tr><td align=\"center\">".$vystup["ip"]."</td>";  
echo "<td align=\"center\">".$vystup["banreason"]."</td>";  
echo "<td align=\"center\">".$vystup["bannedby"]."</td>";  
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["bandate"])."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["unbandate"])."</td>";  
   
echo "</tr>";  

}  
mysql_close($connection);  
echo "</table></center>";  
?>
<br>
<br>

<center><I><B><SPAN style="color:red">Аккаунт баны</SPAN></B></I><center>
<?php  

// You Should Write here your MySQL Server information !  

echo "<center><table border=1><tr><th>acc ID:</th><th>Аккаунт:</th><th>Причина:</th><th>Бан дал</th><th>Дата Бана</th><th>Дата Разбана</th></tr>";  
$connection = mysql_connect($host, $user, $password) or die ("Can't connect with $host");  
mysql_select_db($realmdb, $connection);  
$sqle = "SELECT `id`,`banreason`, `bannedby`, `bandate`, `unbandate` FROM `account_banned`";  
$sql = "SELECT `ab`.*, `a`.`username` FROM `account_banned` as `ab` "
."LEFT JOIN `account` as `a` ON `a`.`id` = `ab`.`id`;";

$result = mysql_query($sql, $connection);  

while ($vystup = mysql_fetch_array($result))  

{  
echo "<tr><td align=\"center\">".$vystup["id"]."</td>";  
echo "<td align=\"center\">".$vystup["username"]."</td>";  
echo "<td align=\"center\">".$vystup["banreason"]."</td>";
echo "<td align=\"center\">".$vystup["bannedby"]."</td>";  
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["bandate"])."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["unbandate"])."</td>";  
   
echo "</tr>";  

}  
mysql_close($connection);  
echo "</table></center>";  
?>

<?  
mysql_selectdb ($rdb);  
$acc = mysql_query ("select count(*) from account");  
$acc = mysql_result ($acc,0);  
mysql_selectdb ("$cdb");  
$char = mysql_query ("select count(*) from characters");  
$char = mysql_result ($char,0);  
$alliance = mysql_query ("select count(*) from characters where race in (1,3,4,7,11)");  
$alliance = mysql_result ($alliance,0);  
$horde = mysql_query ("select count(*) from characters where race in (2,5,6,8,10)");  
$horde = mysql_result ($horde,0);  
$guild = mysql_query ("select count(*) from guild");  
$guild = mysql_result ($guild,0);  
echo "Аккаунтов: $acc<br>";  
echo "Персонажей: $char<br>";  
echo "Альянса: $alliance<br>";  
echo "Орды: $horde<br>";  
echo "Гильдий: $guild<br>";  
?>

<?  
mysql_select_db ("$rdb");  
$uptime = mysql_query ("select max(`starttime`) from `uptime`");  
$uptime = time()-mysql_result ($uptime,0);  
$sec = $uptime%60;  
$uptime = intval ($uptime/60);  
$min = $uptime%60;  
$uptime = intval ($uptime/60);  
$hours = $uptime%24;  
$uptime = intval($uptime/24);    
$days = $uptime;  
echo "Время Работы: $days д $hours ч $min м $sec с<br>";  
?>

<?  
mysql_selectdb ("$cdb");  
$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>";  
?>

$wowdbip           ="";           // IP mysql
$wowdbport         ="3306";                // порт mysql
$wowdblogin        ="";               // логин mysql
$wowdbpass         ="";            // пароль mysql
$wowcdb            ="characters";          // название базы characters

mysql_connect ("$wowdbip:$wowdbport","$wowdblogin","$wowdbpass");
mysql_selectdb ("$wowcdb");
mysql_query ('set names cp1251');
$result = mysql_query("SELECT `name`, `race`, `class`, `gender`, `level`, (SUBSTRING_INDEX( SUBSTRING_INDEX( `data` , ' ' , 1252) , ' ' , -1 )+0) AS `honor`, (SUBSTRING_INDEX( SUBSTRING_INDEX( `data` , ' ' , 1203) , ' ' , -1 )+0) AS `kills`, `money` FROM `characters` ORDER BY `honor` DESC LIMIT 100;");

  while ($row = mysql_fetch_array ($result))
    {
       if($row['race']=="1" or $row['race']=="3" or $row['race']=="4" or $row['race']=="7" or  $row['race']=="11")
           {$faction = "alliance";}
        else{$faction = "horde";}

   echo "
     <tr>
        <td><b>".$row['name']."</b></td>
        <td><div align='center'><b>".$row['kills']."</b></div></td>
        <td>".$row['honor']."</td>
        <td>".$faction."</td>
     </tr>