<?         
$ip             ="127.0.0.1";           // IP сервера         
$dbip           ="127.0.0.1";           // IP mysql         
$dbport         ="3306";                // порт mysql         
$gameport       ="8085";                // игровой порт         
$dblogin        ="login";               // логин mysql         
$dbpass         ="password";            // пароль mysql         
$mdb            ="mangos";              // название базы mangos         
$rdb            ="realmd";              // название базы realmd         
$cdb            ="characters";          // название базы characters         
?>

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

<?php      

if($_POST['ok'])      
{      
if(!ereg("^[a-zA-Z0-9]+$", $_POST["login"]))      
{      
$err[] = '<b>Имя аккуанта:</b> введены запрещенные символы или поле пустое.';      
}      
if(empty($_POST["oldpass"]))      
{      
$err[] = '<b>Старый пароль:</b> поле пустое.';      
}      
if(empty($_POST["newpass"]))      
{      
$err[] = '<b>Новый пароль:</b> поле пустое.';      
}      
if(empty($_POST["newspasss"]))      
{      
$err[] = '<b>Новый пароль ещё:</b> поле пустое.';      
}      
$login = $_POST["login"];      
$pass = $_POST["oldpass"];      
$newpass = $_POST["newpass"];      
$newpasss = $_POST["newspasss"];      
$hashpass = sha1(strtoupper($login).":".strtoupper($pass));      
$query = mysql_query("SELECT `username`,`sha_pass_hash` FROM `account` WHERE `username`='".$login."'");      
$arr = mysql_fetch_array($query);      
if($arr['username'] != $login){      
$err[] = 'Введён неверный логин';      
}      
if($hashpass != $arr['sha_pass_hash']){      
$err[] = 'Введён невеный старый пароль';      
}      
if($newpass != $newpasss){      
$err[] = 'Введённые пароли не совподают';      
}      
if(count($err) == 0){      
mysql_query("UPDATE `account` set sha_pass_hash = SHA1(CONCAT(UPPER('$login'),':',UPPER('$newpass'))) where username = \"".$login."\";");      
header("location: ?change=ok");      
}else{      
$err[] = $error;      
}      
}      
foreach ($err as $error){      
echo '<div align="center">'.$error."</div>";      
}      

if( $_GET["change"] == null ){      
echo '<form method="POST" enctype="multipart/form-data">      
<table align="center" border="0" width="" cellpadding="0" cellspacing="0">      
<tr><td>Имя аккуанта:</td></tr>      
<tr><td align="center"><input type="text" name="login" align="center"></td></tr>      
<tr><td>Старый пароль:</td></tr>      
<tr><td align="center"><input type="password" name="oldpass" align="center"></td></tr>      
<tr><td>Новый пароль:</td></tr>      
<tr><td align="center"><input type="password" name="newpass" align="center"></td></tr>      
<tr><td>Новый пароль ещё:</td></tr>      
<tr><td align="center"><input type="password" name="newspasss" align="center"></td></tr>      
<tr><td align="center"><input type="submit" name="ok" value="Сменить пароль"></td></tr>      
</table>      
</form>';      
}else{      
echo "<meta http-equiv=\"refresh\" content=\"5; url=test.php\" />";      
echo '<div align="center" style="color: green; font-weight: bold;" >Пароль сменён успешно !</div>';      
}      
?>

<?     
$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>";     
?>

<?     
$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>";     
?>

<?php     
        echo "<TABLE>";     
        echo "<TR><TD colSpan=5>Список заблокированных</TD></TR>";     
            echo "<TR><TD width=10%>Аккаунт</TD><TD>Забанил</TD><TD>Причина</TD><TD>Был забанен</TD><TD>Будет разбанен</TD></TR>";     
$getban = mysql_query("SELECT * FROM account_banned WHERE active='1'");     
while($banid = mysql_fetch_array($getban))     
{     
$id = "".$banid['id']."";     
$who = "".$banid['bannedby']."";     
$unbandate = date("d.m.Y", $banid['unbandate']);     
$bandate = date("d.m.Y", $banid['bandate']);     
$reason = "".$banid['banreason']."";     
$getbanned = mysql_query("SELECT username FROM account WHERE id='$id'");     
while($banned = mysql_fetch_array($getbanned))     
{     
$acc = "".$banned['username']."";     
        echo "<TR><TD width=10%>$acc</TD><TD>$who</TD><TD width=45%>$reason</TD><TD width=20%>$bandate</TD><TD width=25%>$unbandate</TD></TR>";     
}     
}     
        echo "</TABLE>";     

?>

<?php  
$fp = fsockopen("0we.ru", 8080, $errno, $errstr, 30);  
if($fp){  
$im = imagecreatefrompng("online.png");  
}else{  
$im = imagecreatefrompng("offline.png");  
}  
header('Content-type: image/png');  
imagepng($im);  
imagedestroy($im);  
?>

<?         
$fp = @fsockopen ("$ip","$gameport",$errno,$errstr,1);         
if ($fp)         
echo "Статус Сервера: online<br>";         
else         
echo "Статус Сервера: offline<br>";         
?>

<?         
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>";         
?>

<table border="0">         
<tr>         
<td><strong>Имя:</strong></td>         
<td><strong>Раса:</strong></td>         
<td><strong>Класс:</strong></td>         
<td><strong>Уровень:</strong></td>         
</tr>         
<?         
mysql_selectdb ("$cdb");         
mysql_query ('set names cp1251');         
$result = mysql_query ("select name, race, class, data from characters where online = 1");         
$class = array         
(1=>"Воин",2=>"Паладин",3=>"Охотник",4=>"Разбойник",5=>"Жрец",6=>"Рыцарь Смерти",7=>"Шаман",8=>"Маг",9=>"Чернокнижник",11=>"Друид");         
$race = array         
(1=>"Человек",2=>"Орк",3=>"Дворф",4=>"Ночной Эльф",5=>"Нежить",6=>"Таурен",7=>"Гном",8=>"Тролль",10=>"Эльф Крови",11=>"Дреней");         
while ($row = mysql_fetch_array ($result))         
{         
$ch_name = $row['name'];         
$ch_race = $row['race'];         
$ch_class = $row['class'];         
$char_data = explode(' ',$row['data']);         
$ch_lvl = $char_data[53];         
echo "<tr><td><strong>$ch_name</strong></td>";         
echo "<td><strong>$race[$ch_race]</strong></td>";         
echo "<td><strong>$class[$ch_class]</strong></td>";         
echo "<td><strong>$ch_lvl</strong></td></tr>";         
}         
?>         
</table>

define("DBHOST", "localhost");       
define("DBUSER", "root");       
define("DBPASS", "mangos");       
define("COLLATE", "utf8");       
define("CDB", "characters");       

function conventNormTime($nSec) {      
                      $d = floor( $nSec / (3600*24) );      
              $nSec = ($nSec - $d * 3600 * 24);      
              $h = floor( $nSec / 3600 );      
              $nSec = ($nSec - $h * 3600);      
              $m = floor( $nSec / 60 );      
             return "{$d}д.  {$h}ч.  {$m}м.";      
              }      

            $class = array (                         
                             1=>"Воин",       
                             2=>"Паладин",       
                             3 = >"Охотник",       
                             4=>"Разбойник",       
                             5=>"Жрец",                    
                             6  =>"Рыцарь Смерти",       
                             7=>"Шаман",       
                             8=>"Маг",       
                             9=>"Чернок нижник ",       
                             11=>"Друид"       
                             );        
                    
        $race = array     (       
                             1=>"Человек",       
                             2=>"Орк",       
                             3=>"Д ворф",        
                             4=>"Ночной Эльф",       
                             5=>"Нежить",       
                             6=>"Таурен",       
                             7=>"Гном ",       
                             8 =>"Тролль",       
                             10=>"Эльф Крови",       
                             11=>"Дреней"       
                            );       
                    

          $sMySql = mysql_connect(DBHOST, DBUSER, DBPASS); // Соединяемся с базой        
            mysql_query("SET NAMES COLLATE"); // Устанавливаем кодировку соединения       
               
              mysql_select_db(CDB, $sMySql);        
                 
        $aSql = mysql_query("SELECT `name`, `race`, `class`, `totaltime` FROM `characters` ORDER BY `totaltime` DESC LIMIT 0 , 15", $sMySql);       
              
         $szContent .= "<br /><table width='98%' border='1' align='center'><tr>       
<td align='center' width='20%'><font color='green'>Персонаж</font></td>       
<td align='center' width='20%'><font color='green'>Сыгранное время</font></td>       
<td align='center' width='20%'><font color='green'>Класс</font></td>       
<td align='center' width='20%'><font color='green'>Раса</font></td>       
</tr></table>";          

                      while ($row = mysql_fetch_array($aSql))                       
                         {        
                           $name = $row['name'];       
                           $totaltime = conventNormTime($row['totaltime']);       
                           $show_race = $race[$row['race']];       
                           $show_class = $class[$row['class']];       
                        
         $szContent .= "<table width='98%' border='1' align='center'><tr>       
<td align='center' width='20%'>".$name."</td>       
<td align='center' width='20%'>".$totaltime."</td>       
<td align='center' width='20%'>".$show_class."</td>        
<td align='center' width='20%'>".$show_race."</td>       
</tr></table>";          
                         }        
                      
        mysql_close($sMySql);   // Закрываем соединение mysql       
              
        echo $szContent;        
?>

<?php    
       
// Configuration.    
// Realm database.    
$r_db = "Realmd";    
// IP (and port).    
$ip = "127.0.0.1:3306";    
// Username.    
$user = "trinity";    
// Password.    
$pass = "trinity";    
// Site title.    
$title = "Registration Form";    
$title2 = "Server name";    
// End config.    
       
$page = '<?xml version="1.0" encoding="utf-8" ?>    
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">    
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">    
<head>    
<title>' . $title . '</title>    
</head>    
<body style="background-color:black;color:yellow;font-family:verdana;">    
<form method="post" action="' . $_SERVER["SCRIPT_NAME"] . '">    
<p style="text-align:center;">    
<strong>' . $title2 . ' - ' . $title . '</strong>    
<br /><br /><br />    
Login:    
<br /><input name="username" type="text" maxlength="14" /><br />    
Password:    
<br /><input name="password" type="password" maxlength="12" /><br />    
Email:    
<br /><input name="email" type="text" maxlength="50" />    
<br /><input name="tbc" type="checkbox" checked="checked" /> WotLK<br /><br /><br />    
<button type="submit">Registration</button>    
</p>    
</form>    
</body>    
</html>';    
       
function error_s ($text) {    
       echo("<p style=\"background-color:black;color:yellow;font-family:verdana;\">" . $text);    
       echo("<br /><br /><a style=\"color:orange;\" href=\"" . $_SERVER["SCRIPT_NAME"] . "\">Go back...</a></p>");    
};    
       
$user_chars = "#[^a-zA-Z0-9_\-]#";&