";
//		print_r($tmp[1]);
//		echo "
";
				
		// on bypass la partie qui doit être ignorée			
		for ($i=0; $i < $nb_parties; $i++)
		{
			if($i != $id_partie )
			{
				$new_table_parties[] = $table_parties[$i];
			}
			else
			{
				echo "Partie  effacée : " .$removed_game; 
				echo "
";
				print_r($table_parties[$i]);
				echo "
";
			}				
		}
				
		//echo "
";
		//print_r($new_table_parties);
		//echo "
";
				
		// purger les tables
		$str1 = "TRUNCATE TABLE " .$_SESSION['classement'];
		$str2 = "TRUNCATE TABLE " .$_SESSION['evolution'];
		$str3 = "TRUNCATE TABLE " .$_SESSION['parties'];
		$str4 = "TRUNCATE TABLE " .$_SESSION['chessmaster'];
				
		mysql_query($str1);
		mysql_query($str2);
		mysql_query($str3);
		mysql_query($str4);

		echo "Initialisation de la table classement ....";
		echo "
";
	
		$sql = "INSERT INTO `clone_classement_new` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
		(1, 'AlvaroM', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(2, 'DamienB', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(3, 'EmileM', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(4, 'FranckV', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(5, 'HenriqueF', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(6, 'PatrickA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(7, 'PhilippeA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(8, 'RemyS', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),
		(9, 'StephaneR', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1); ";
		$result = mysql_query($sql);
	
		$sql = "ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1";
		$result = mysql_query($sql);
				
		for ($item=0; $item < count($new_table_parties) ; $item++)
		{
			$donnees[0] = $new_table_parties[$item][0];
			$donnees[1] = $new_table_parties[$item][1];
			$donnees[2] = $new_table_parties[$item][2];
			$donnees[3] = $new_table_parties[$item][3];
			$donnees[4] = $new_table_parties[$item][4];
			
			$indice = $item + 1;
					
			//algo_elo($donnees, "nostatistique", "sql", $indice );
			
			algo_elo($donnees, "statistique", "sql", $indice );
			
		}

		//generer_chessmaster();
		
		echo 1;
				
/****************************************************/				
function transfert_DB()
{	
			//$sql = "SELECT * FROM parties ORDER by date asc"; 
			$sql = "SELECT * FROM " .$_SESSION['parties'] ." ORDER by date asc"; 
						
			$results = mysql_query($sql);
			$nb_parties = mysql_num_rows($results);

			while($row = mysql_fetch_assoc($results))
			{
				$blanc = $row['w_name'];
				$noir = $row['b_name'];
				$timestamp = $row['date'];
				$resultat = $row['result'];
				
				if($resultat == 1)
				{
					$_score_blanc = 1;
					$_score_noir = 0;
				}
				if($resultat == 2)
				{
					$_score_blanc = 0;
					$_score_noir = 1;
				}
				if($resultat == 3)
				{
					$_score_blanc = 0.5;
					$_score_noir = 0.5;
				}

				$table_csv[0] = $timestamp;
				$table_csv[1] = $blanc;
				$table_csv[2] = $noir;
				$table_csv[3] = $_score_blanc;
				$table_csv[4] = $_score_noir;
				$table_fichier[] = $table_csv;
			}
			
			$retour[] = $nb_parties;
			$retour[] = $table_fichier;
			return($retour);
}
/****************************************************/				

?>