<?php

$r_db = "realmd"; // Realm adatb�zis
$c_db = "characters"; // Characters adatb�zis
$w_db = "world"; // World/Mangos adatb�zis

$host = "127.0.0.1:3306";  // szerver ip:port
$user = "user"; // MYSQL felhaszn�l�
$pass = "pass"; // MYSQL jelsz�

$realmip = 'jankec.myip.hu';
$realmport  = '8085';


    function date_now() {
    $DateNow=date('Y')."-".date('m')."-".date('d')." ".date('H').":".date('i').":".date('s');
    return $DateNow;
    }


$fs='1000';

$fs = @fsockopen ($realmip,$realmport,$errno,$errstr, 0.5);
if ($fs) {
    $conn = mysql_connect($host,$user,$pass) or die(mysql_error());
    mysql_select_db($c_db) or die(mysql_error());
    $numonline=@mysql_num_rows(mysql_query("SELECT NULL FROM `characters` WHERE `online`='1';"));
    $status1="OnLine (".$numonline." j&aacute;t&eacute;kos) &nbsp;&nbsp; Uptime: ";

mysql_connect($host,$user,$pass);
mysql_select_db($r_db);
$result=mysql_query("select startstring from uptime ORDER BY startstring DESC limit 1;");
while ($row=mysql_fetch_array($result)) {
    $timestart=$row['startstring'];
};
       $timestart = (int)strtotime($timestart);
    $uptime = (int)strtotime(date_now()) - $timestart - (60*60*1);
        $status1.= (int)date('z', $uptime)."day ";
    $status1.= (int)date('H', $uptime)."h ";
        $status1.= (int)date('i', $uptime)."m ";
    $status1.= (int)date('s', $uptime)."s";
    fclose($fs);
    }
else {
$status1="<font color=\"#FF0000\">OffLine</font>";
}

        echo($status1);

?>