<?php
if (isset($_GET["accesskey"])){
if ($_GET["accesskey"]=="yhqlorp"){
$server="game.endless-edge.com";
$interval=15; //minutes
$host="127.0.0.1";
$user="root";
$pass="groudon";
$dbname="eoserv";
$port=8078;
$timeout=10;
$connection = fsockopen($server, $port, $errno, $errstr, $timeout);
$con=mysql_connect($host,$user,$pass);
if ($con){
$sql=mysql_query("CREATE TABLE IF NOT EXISTS `serverinfo`(
`serveradd` varchar(64),
`uptime` int(10),
PRIMARY KEY (uptime)
)");
if ($sql){
echo("eoserv database altered, `serverinfo` added!");
}else{
die(mysql_error());
}
}
if (!$connection){
if ($con){
mysql_select_db($dbname);
$sql=mysql_query("SELECT * FROM serverinfo WHERE serveradd='$server'");
if ($sql){
$sql=mysql_query("UPDATE serverinfo SET uptime=0 WHERE serveradd='$server'");
if ($sql){
echo("server is offline");
}else{
die(mysql_error());
}
}else{
$sql=mysql_query("INSERT INTO serverinfo VALUES ('".$server."',0)");
if ($sql){
echo("$server is unknown to the database but has been added, however it is offline at this time");
}else{
die(mysql_error());
}
}
}else{
die(mysql_error());
}
}else{
$con=mysql_connect($host,$user,$pass);
if ($con){
mysql_select_db($dbname);
$sql=mysql_query("SELECT * FROM serverinfo WHERE serveradd='$server'");
if ($sql){
$row=mysql_fetch_array($sql);
$newuptime=$row["uptime"]+$interval;
$sql=mysql_query("UPDATE serverinfo SET uptime=".$newuptime." WHERE serveradd='$server'");
echo("Server Uptime: ".$newuptime." minutes");
}else{
$sql=mysql_query("INSERT INTO serverinfo VALUES ('".$server."',0)");
if ($sql){
echo("$server is unknown to the database and but been added, server is online");
}else{
die(mysql_error());
}
}
}else{
die(mysql_error());
}
mysql_close($con);
}
}else{
echo("invalid security key");
}
}else{
echo("no security key identified");
}
?>