<?php	ob_start();

	function removeOldServersFromServerList()
	{
		$time = explode(' ',microtime());
		$timetoremove = ($time[1] - 60*4);
		$query = "DELETE FROM `serverlist` WHERE time<='$timetoremove'";
		mysql_query($query) or
			die ("error: deleting servers: ".mysql_error());
	}

	function getServerlistForEM($gameidlogin)
	{

		$query = "SELECT * FROM serverlist WHERE game='$gameidlogin'";
		$result = mysql_query($query) or
				die ("error: getting serverlist for EM: ".mysql_error());

		$data = array();

		while($tuple = mysql_fetch_assoc($result))
		{
			foreach($tuple as $column => $value)
			{
				$data[$column] .= '|' . $tuple[$column];
			}
		}
		$r="";
		foreach($data as $key => $data_string)
		{
			$r.='&'.$key.'='.substr($data_string,1);
		}
		return substr($r,1);
	}

	include "connect.php";

	if(isset($_REQUEST["gameidlogin"])) $gameidlogin = $_REQUEST["gameidlogin"]; else die("erro: gameidlogin requiered");
	
	removeOldServersFromServerList();	

	$data = getServerlistForEM($gameidlogin);

	$other_output = ob_get_contents();
	ob_end_clean();

	echo $data;
	include "disconnect.php";
?>