PHP:
<?
include "config.php";
$conn = @mysql_connect($MySQL_HOST, $MySQL_USER, $MySQL_USER_PASS) or die ("Ошибка соединения с сервером, попробуйте позже.");
$xadb = @mysql_select_db($MySQL_DB,$conn) or die ("Ошибка соединения с базой, попробуйте позже.");
//---------------------------------------------------- SERV STATUS
$sock = socket_create(AF_INET, SOCK_STREAM, SOL_TCP);
if(!$sock)
$servstatus = '<font color="red">Offline.</font>';
else
{
if(socket_connect($sock, $GameServer, $GdeliverydPort))
$servstatus = '<font color="green">Online.</font>';
else
$servstatus = '<font color="red">Offline.</font>';
}
//---------------------------------------------------- ONLINE
$query = mysql_query("select count(uid) as `cnt` from point where zoneid=1", $conn);
if (MySQL_Num_Rows($query) > 0)
$online = MySQL_result($query,0,"cnt");
else
$online = 0;
//---------------------------------------------------- GM ONLINE
$query = mysql_query("SELECT count(p.uid) as `cnt` FROM point p WHERE p.`uid` in (SELECT userid FROM auth WHERE rid=0) AND p.zoneid=1 ",$conn);
if (MySQL_Num_Rows($query) > 0)
$gmonline = MySQL_result($query,0,"cnt");
else
$gmonline = 0;
//---------------------------------------------------- TOTAL AKK
$query = mysql_query("SELECT count(`id`) as `cnt` FROM users",$conn);
if (MySQL_Num_Rows($query) > 0)
$total = MySQL_result($query,0,"cnt");
else
$total = 0;
//---------------------------------------------------- RESULT as html
echo <<<HTML
Статус сервера: {$servstatus}<br/>
В сети: {$online}<br/>
GM в сети: {$gmonline}<br/>
Аккаунтов на сервере: {$total}
HTML;
mysql_close($conn);
?>