<?  
$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><br />  
<?echo " $onoff200"; ?><br /></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";          

$host = "localhost";         
$user = "mangos";                 
$pass = "mangos";                    
$port = "3306";                  

$tbc = 2;                      
$database_encoding = 'CP1251';        

$realmd = mysql_connect("$host:$port", "$user", "$pass", True);      
mysql_selectdb("$db1", $realmd);      

$world = mysql_connect("$host:$port", "$user", "$pass", True);      
mysql_selectdb("$db2", $world);      

$characters = mysql_connect("$host:$port", "$user", "$pass", True);      
mysql_selectdb("$db3", $characters);      

echo "      
<script type=\"text/javascript\">      
function isAlphaNumeric(value)      
{      
       if (value.match(/^[a-zA-Z0-9_]+$/))      
         return true;      
       return false;      
}      
function checkform(f)      
{      
       if (f.account.value == \"\")      
       {      
         alert(\"Введите логин\");      
         return false;      
       }      
       if (!isAlphaNumeric(f.account.value))      
       {      
         alert(\"Запрещенные символы в логине\");      
         return false;      
       }      
       if (f.password.value==\"\")      
       {      
         alert(\"Введите пароль\");      
         return false;      
       }      
       if (!isAlphaNumeric(f.password.value))      
       {      
         alert(\"Запрещенные символы в пароле\");      
         return false;      
       }      
       if (f.password2.value==\"\")      
       {      
         alert(\"Вы не ввели повтор пароля\");      
         return false;      
       }      
       if (f.password.value != f.password2.value)      
       {      
         alert(\"Пароли не совпадают\");      
         return false;      
       }      
       if (f.email.value==\"\")      
       {      
         alert(\"Вы не ввели e-mail\");      
         return false;      

       }      
}      
</script>";      

echo "      

<font color=#00CC00>      
</font><br><br>      
<center>      
<form method=post action=register.php onsubmit=\"return checkform(this)\">       
<table>      

<tr>      
       <td>Login: <Br>      
       <input type=text name=account maxlength=20></td>      
</tr>      

<tr>      
       <td> Password:<Br>      
       <input type=password name=password maxlength=20></td>      
</tr>      
<tr>      
       <td> Confirm Password: <Br>      
       <input type=password name=password2 maxlength=20></td>      
</tr>      
<tr>      
       <td> e-mail:<Br>       
       <input type=text name=email maxlength=32></td>      
</tr>      
      <tr>      
       <td colspan=2 style=\"text-align: center;\"><br><input type=submit value=Зарегистрироваться></td>      
      </tr>      
</table>      
</form></center>";      

if (isset($_POST['account'])) {      
if ($_POST['account'] && strlen($_POST['account'])<=20 && strlen($_POST['account'])>=3 && strlen($_POST['password'])>=3 && $_POST['password'] && $_POST['password2'] && $_POST['password']==$_POST['password2']) {      
       if (!eregi("^[a-zA-Z0-9_]+$", $_POST['account']))      
         die ("<p>Error: SQL-Injection</p>");      
       if (!eregi("^[a-zA-Z0-9_]+$", $_POST['password']))      
         die ("<p>Error: SQL-Injection</p>");      
         $pass = ($_POST['password']);      
         $username = ($_POST['account']);      
         $result = mysql_query("SELECT * FROM account WHERE username='".$_POST['account']."' AND sha_pass_hash='$pass'", $realmd);      
         if (mysql_num_rows($result) != 0) {      
             echo "<center><p><font color=#CC0000><b>Такой аккаунт уже есть!</b></font></p></center>";      
         } else {      
             if (!mysql_query("INSERT INTO account (username, sha_pass_hash, gmlevel, email, expansion) VALUES ('$username', SHA1(CONCAT(UPPER('$username'),':',UPPER('$pass'))), 0, '".$_POST['email']."', $tbc)", $realmd)) {echo "<center><p><font color=#CC0000><b>Ошибка</b></font></p></center>";} else {echo "<center><p><font color=#00CC00><b>Аккаунт успешно зарегестрирован! </b></font></p></center>";}      
         }      
} else {      
         echo "<center><p><font color=#CC0000><b>Проверьте правильность ввода!</b></font></p></center>";      
}      
}      

?>

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