PureBasic

Code : Tout sélectionner

   $connexion = mysql_connect($host,$user,$password);
   mysql_select_db($base); 
   
    $option=array_key_exists("option",$_GET) ? $_GET["option"] : "";
    $user=array_key_exists("user",$_GET) ? $_GET["user"] : "";
	$score=array_key_exists("score",$_GET) ? $_GET["score"] : "0";
	$nbscore=array_key_exists("nbscore",$_GET) ? $_GET["nbscore"] : "";

	If($option=='addscore'){
		// Insert the new line
		mysql_query("INSERT INTO etna_hs (user,point) VALUES ('$user','$score')");
		echo ' ';
		exit();
	}
	elseif($option=='getscore'){
		$mysql_result = mysql_query("SELECT * FROM etna_hs ORDER BY `point` DESC LIMIT 0 , $nbscore");
   
		if ($ligne = mysql_fetch_array($mysql_result)) 
		{
			do
			{
				printf("%s\n",$ligne["user"]);
				printf("%s\n",$ligne["point"]);
			}
			while ($ligne = mysql_fetch_array($mysql_result));
		} 
		else  // No line in the chat
		{
			echo ' ';  
		}
		exit();
	}
?>