Статут сервера

<?php

////Статус сервера//////

error_reporting(0);
$IP = array(
"Login Server: " => "87.117.12.173:2106",
"Game Server: " => "87.117.12.173:7777",
); while(list($ServerName,$Host)=each($IP)) {
list($IPAddress,$Port)=explode(":",$Host);
echo($ServerName);
if($fp=fsockopen($IPAddress,$Port,$ERROR_NO,$ERROR_STR,(float)0.5)) {
echo("<font color='#00CC00'>Online </font><br>");
fclose($fp);
}
else {
echo ("<font color='red'>Offline </font><br>");
}
}

////Колличество он-лайн//////

$dbhost="87.117.12.173"; ////Адрес  MYSQL сервера
$dbname="l2jdb";  //// Имя базы
$dbuser="логин";   //// Логин для базы
$dbpass="пароль";       //// Пароль для базы


$msc=MYSQL_CONNECT($dbhost,$dbuser,$dbpass) or die ("Ошибка БД");
MYSQL_SELECT_DB($dbname) or die ("Ошибка БД");

$get_config_data="SELECT online FROM characters WHERE online>0";
$config_data=MYSQL_QUERY($get_config_data);
$config['num_online']=mysql_num_rows($config_data);
echo " Игроков: ";
echo ("<font color='#00CC00'>".$config['num_online']."</font>");
MYSQL_CLOSE($msc);
?>

<?php
$content .= "<p><table width=100% align=center>  
          <tr><td class=don2 bgcolor=linen><center><b>Название Сервера!</center></b>      
       </td></tr></table></p>";
$flogin = fsockopen ("l2imperia.com",2106, $errno, $errstr, 1);
       if ( $flogin )
               $content .= "<font><b>Логин сервер:</b> <font color=green><b>ON<BR></b></font>";
       else
               $content .= "<font><b>Логин сервер:</b> <font color=red><b>OFF<BR></b></font>";

$fgame = fsockopen ("l2imperia.com",7777, $errno, $errstr, 1);
       if ( $flogin )
               $content .= "<font><b>Игровой сервер:</b> <font color=green><b>ON<BR></b></font>";
       else
               $content .= "<font><b>Игровой сервер:</b> <font color=red><b>OFF</b></font>";
echo $content;
?>

<?php
error_reporting(1);

$CONFIG['dbaddress'] = "127.0.0.1";        // SQL IP Address                         [Default: 127.0.0.1]
$CONFIG['dbuser'] = "";                     // SQL Login Username                     [Default: alex]
$CONFIG['dbpass'] = "";             // SQL Login Password                     [Default: sas]
$CONFIG['dbdbname'] = "lin2db";                 // Lineage II Database Database Name      [Default: lin2db]
$CONFIG['worlddbname'] = "lin2world";           // Lineage II World Database Name         [Default: lin2world]
$mssql_addr="127.0.0.1";   // SQL IP Address                         [Default: 127.0.0.1]
$mssql_user="";     // SQL Login Username                     [Default: alex]
$mssql_pass="";    // SQL Login Password                     [Default: sas]
$mssql_db="lin2world";    // Lineage II World Database Name         [Default: lin2world]


?>

<?php

////Статус сервера//////

error_reporting(0);
$IP = array(
"Login Server: " => "127.0.0.1:2108",
"Game Server: " => "127.0.0.1:7777",
); while(list($ServerName,$Host)=each($IP)) {
list($IPAddress,$Port)=explode(":",$Host);
echo($ServerName);
if($fp=fsockopen($IPAddress,$Port,$ERROR_NO,$ERROR_STR,(float)0.5)) {
echo'<img src="/skins/noname/images/online.gif"><br>';
fclose($fp);
}
else {
echo'<img src="/skins/noname/images/offline.gif"><br>';
}
}
?>


<?php

require 'config.php';

mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($mssql_db);

$result=mssql_query("
        select a.char_name, a.Lev, a.builder, a.class, a.use_time,
               a.PK, a.Duel, a.gender, b.name, a.Exp, b.pledge_id
        from user_data as a
        left join pledge as b on a.Pledge_id=b.pledge_id
        where char_name not in (".("'".join("','",$exclude_from_top)."'").") and (login>logout) and (builder>=0)");
$online_count=mssql_num_rows($result);

$result=mssql_query("
        select a.char_name, a.Lev, a.builder, a.class, a.use_time,
               a.PK, a.Duel, a.gender, b.name, a.Exp, b.pledge_id
        from user_data as a
        left join pledge as b on a.Pledge_id=b.pledge_id
        where char_name not in (".("'".join("','",$exclude_from_top)."'").") and (login>logout) and (builder>=0)");


$d_count = 0;
$de_count = 0;
$e_count = 0;
$h_count = 0;
$o_count = 0;
$online_users=array();
for ($x=0;$online_users[$x]=mssql_fetch_assoc($result);$x++)
{
  $hours=round($online_users[$x]['use_time']/3600,1);
  $online_users[$x]['use_time_d']=floor($hours/24)." дн. ".($hours % 24)." ч.";
  if ($online_users[$x]['class'] >= 0 && $online_users[$x]['class'] <= 17) $h_count++;
  if ($online_users[$x]['class'] >= 18 && $online_users[$x]['class'] <= 30) $e_count++;
  if ($online_users[$x]['class'] >= 31 && $online_users[$x]['class'] <= 43) $de_count++;
  if ($online_users[$x]['class'] >= 44 && $online_users[$x]['class'] <= 52) $o_count++;
  if ($online_users[$x]['class'] >= 53 && $online_users[$x]['class'] <= 57) $d_count++;
}
unset($online_users[count($online_users)-1]);

mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($CONFIG['dbdbname']) or DIE("Table unavailable");

$result=mssql_query("
        select record_time, world_user
        from user_count
        where auth_user<>0
        order by world_user desc");
$max_user=mssql_fetch_assoc($result);

$result=mssql_query("
        SELECT AVG(world_user) AS avg_user
        FROM user_count
        WHERE (server_id = '1') AND (DATEPART(yy, record_time) = '".date("Y")."') AND (DATEPART(mm, record_time) = '".date("m")."') AND (DATEPART(dd, record_time) = '".date("d")."')");
$avg_today=mssql_fetch_assoc($result);
?>




    
   <table border="0"  cellpadding="1" cellspacing="1">
<tr>
     <td class="al">Oнлайн: </td>
     <td class="t-bold al info ar"><?php echo "$online_count" ?></td>
    </tr>
    
<tr>
     <td class="al">Мах было :</td>
     <td class="t-bold al info ar"><?=$max_user["world_user"]?></td>
    </tr>
<tr>
     <tr>
     <td class="al"><?=$max_user["record_time"]?></td>
     <td></td>
    </tr>
<tr>
    </tr>
   </table>
  </td>
</tr>
<?=$sep?>
</table>

<a href="java script:void(0)" title="Май сервер" onClick="java script:window.open('http://mysite.ru/statistika.php','width=400,height=480,status=no,toolbar=no, menubar=no,scrollbars=yes,resizable=yes');">
Нажми и посмотри</a>

<html>
<head>
<title>СПИСОК злых ПКшников :)</title>
<style type="text/css">

.tabela {
    background: #000000;
    background-color: #000000;
    font-size: 12px;
    
}

.tabelatitle {
    background-color: #000000;
    font-size: 14px;
    font-weight: bold;

}

body {
    background-color: #000000;
    color: #FFFFFF;
    font-family: tahoma;
    font-size: 19px;
}

</style>
<font color="#FF0000">

<body>

<p>TOP 50 PK</p>
<table border="0" width="300" class="tabela">
<tr class="tabelatitle"><td>Игрок</td><td> Кол-во ПК</td><tr>
<tr class="tabela">
<?php


mssql_select_db("lin2world");

//print "Conexгo OK<br><br><br>";

$query = mssql_query("SELECT char_name, PK FROM dbo.user_data WHERE PK > 0 ORDER BY PK DESC");

$maxr = 0;



while ($consulta = mssql_fetch_array($query) AND $maxr < 50)
{
$maxr = $maxr + 1;
print "<td>$consulta[char_name] </td><td> $consulta[PK]</td></tr>";
}

mssql_close();
?>
</table>
<br />
</body>
</html>