/Graf/ graf.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
   </head>
  <body style="text-align:center;">

<div>


<?php

include 'config.php';

mysql_connect($db_server,$db_user,$db_pass) or die("Nelze se připojit k MySQL: " . mysql_error());
mysql_select_db($mangos_db);

$data = mysql_query("select `startstring` from `uptime` order by `startstring`");

$pocet = mysql_num_rows($data);
$start = $pocet-1;
$data = mysql_query("select `starttime`,`startstring` from `uptime` order by `startstring` limit $start,$pocet");

$start = mysql_fetch_array($data);

$date = Time();

$uptime = $date-$start['starttime'];

echo "<b>Posledni restart</b> : $start[startstring]&nbsp;";


if($uptime>60)
{

$minut = $uptime/60;

$minut = floor($minut);

if($minut>60)
{
$hodin = $minut/60;
$hodin = floor($hodin);

if($hodin>24)
{
$dnu=$hodin/24;
$dnu = floor($dnu);

echo "<b>Uptime</b> : ";
echo "$dnu dnu,";
echo ($hodin-($dnu*24));
echo "hodin,";
echo $minut-($hodin*60);
echo "minut,";
echo ($uptime-($minut*60));
echo "sec &nbsp;";


}
else

{
echo "<b>Uptime</b> : ";
echo "$hodin hodin,";
echo ($minut-($hodin*60));
echo "minut,";
echo ($uptime-($minut*60));
echo "sec &nbsp;";

}

}
else

{
echo "<b>Uptime </b>: ";
echo "$minut minut,";
echo ($uptime-($minut*60));
echo "sec &nbsp;";
}

}
else {
echo "<b>Uptime</b> : $uptime sec &nbsp;";
}


@$fp = fsockopen("127.0.0.1",8085,$errn,$errstr,5);

if($fp)

{

echo "<b>Realm status</b> : UP&nbsp;";

}
else {echo "<b>Realm Status</b> : DOWN&nbsp;";}


$ali_sql = mysql_query("select `race` from `characters`.`characters` where (`online`=1) AND (`race`=1 or `race`=3 or `race`=4 or `race`=7 or `race`=11)") or die("Nelze vykonat definiční dotaz: " . mysql_error());
$horda_sql = mysql_query("select `race` from `characters`.`characters` where (`online`=1) AND (`race`=2 or `race`=5 or `race`=6 or `race`=8 or `race`=10)") or die("Nelze vykonat definiční dotaz: " . mysql_error());

$horda=mysql_num_rows($horda_sql);

$ali=mysql_num_rows($ali_sql);


echo "<b>Online</b> : ";
echo $ali+$horda;
echo " ($ali aliance vs. $horda horda)";

$gm=mysql_query("select `name` from `characters`.`characters` where `account` in(select `id` from `auth`.`account_access` where `gmlevel`>1) and `online`=1");

echo "&nbsp;<b>GM InGame</b> : ";

$pocet_gm=mysql_num_rows($gm);

if($pocet_gm==0)
{
echo "Zadny GM ve hre &nbsp;";
}

while($gmm=mysql_fetch_array($gm))
{

echo "$gmm[name]";


$i=$i+1;

if($i<$pocet_gm)
{
echo ",";
}

}

echo "&nbsp;";


?>

</div>

<img src="./vykresli.php" style="margin-top:10px;">


<img src="vykresli2.php" style="margin-top:10px;">


<img src="vykresli3.php" style="margin-top:10px;">
  </body>
</html>