Pastebin

<?php
date_default_timezone_set("Europe/Dublin");
$host="127.0.0.1";
$user="eoserv";
$pass="eoserv";
$dbname="eoserv";
$accesskey="abcdefg";
$servername="game.endless-online.com";
$port=8078;
$timeout=10;
$con=mysql_connect($host,$user,$pass);
	if ($con){
		if (isset($_GET["accesskey"])){
			if ($_GET["accesskey"]==$accesskey){
				$servercon = fsockopen($servername, $port, $errno, $errstr, $timeout);
				if ($servercon){
					mysql_select_db($dbname);
					$sql=mysql_query("SELECT * FROM `servinfo` WHERE servname='$servername' ");
					if (!$row=mysql_fetch_array($sql)){
						$sql=mysql_query("
						CREATE TABLE IF NOT EXISTS `servinfo` (
							servname varchar(64),
							started timestamp,
							stopped timestamp,
							PRIMARY KEY (servname)
						)");
						$sql=mysql_query("INSERT INTO servinfo(`servname`) VALUES('$servername')");
						if (!$sql) die (mysql_error());
					}
					//format of the string reading from the database
					$sql=mysql_query("SELECT * FROM `servinfo` WHERE servname='$servername' ");
					$row=mysql_fetch_array($sql);
					if ($row["stopped"]!="0000-00-00 00:00:00"){
						$now=date('Y-m-d H:i:s');
						$sql=mysql_query("UPDATE `servinfo` SET started='$now' WHERE servname='$servername'");
						if (!$sql) die(mysql_error());
						$sql=mysql_query("UPDATE `servinfo` SET stopped='0000-00-00 00:00:00' WHERE servname='$servname'");
					}
					$format = 'Y-m-d H:i:s';
					$servertime = DateTime::createFromFormat($format, $row["started"]);
					$now = new DateTime();
					$interval = $now->diff($servertime);
					echo ("$servername has been up for: ");
					
					if ($interval->format('%i')=="1") echo('1 minute'); 
					else echo $interval->format('%i minutes');
					echo(' ');
					if ($interval->format('%s')=="1") echo ('1 second');
					else echo($interval->format('%s seconds'));
				}else{
					$sql=mysql_query("SELECT * FROM `servinfo` WHERE servname='$servname'");
					if ($row=mysql_fetch_array($sql)){
						if($row["stopped"]=="0000-00-00 00:00:00"){
							$now = date('Y-m-d H:i:s');
							$sql=mysql_query("UPDATE `servinfo` UPDATE `stopped`='$now' WHERE servname='$servername'");
							if (!$sql) die (mysql_error());
						}
						echo("$servername is offline");
					}
				}
			}else{
				echo("security key incorrect!");
			}
		}else{
			echo("no security key present");
		}
}else{
	die(mysql_error());
}

mysql_close($con);
?>