<?
$server = mysql_connect("localhost",  "USER", "PASS"); 
mysql_select_db("DB", $server);  
  
//  session_start(); 
//define('nextGenGaming', true ); 
$time=$timee=time();
$datum = date("d-m-Y H:i");

	$game=addslashes($_REQUEST['game']);
	$level=addslashes($_REQUEST['level']);
 
 	if($what=='top5'){
 	 	echo "Top 10 ever:\n";
	    $query = "SELECT name, score FROM highscores WHERE game='$game' && level='$level' ORDER by score ASC LIMIT 10";
	    $result = mysql_query($query) or die('Query failed: ' . mysql_error());	 
	    $num_results = mysql_num_rows($result);  	 
	    for($i = 0; $i < $num_results; $i++)
	    {
	         $row = mysql_fetch_array($result);
	         echo "\t". $row['score'] . " seconds". " \t\t\t " .$row['name']."\n";
	    }
	    
	    echo"\n";
	    
		$timeout=time()-3600*24;
     	echo "Top 10 today:\n";
	    $query = "SELECT name, score FROM highscores WHERE game='$game' && level='$level' && time>'$timeout' ORDER by score ASC LIMIT 10";
	    $result = mysql_query($query) or die('Query failed: ' . mysql_error());	 
	    $num_results = mysql_num_rows($result);  	 
	    for($i = 0; $i < $num_results; $i++)
	    {
	         $row = mysql_fetch_array($result);
	         echo "\t". $row['score'] . " seconds". " \t\t\t " .$row['name']."\n";
	    }		
		
	}
?>