Tiny File Manager

Back Back Up Advanced Editor

<?php

session_start();
		include('correlation.php');
		include('chessmaster.php');
		include('generation_chessmaster.php');
			
		//include('database.php');
		DB_connexion(); 	
	
			
		header( 'content-type: text/html; charset=utf-8' );	
			
		
		echo '<a href="admin.php">Retour...</a>';
		echo ' ';
		
			
		$sql = "SELECT * from " .$_SESSION['parties']; 
						
		$resultat = mysql_query($sql);
		$n = mysql_num_rows($resultat);	
			
		echo "Nb parties dans la db : " .$n;	
		echo " ";
		
		echo "Effacer la partie portant l'indice " .$_GET['id_partie']; 
		echo " ";
		
		// en réalité on par de 0 pour l'indexation
		$id_partie = $_GET['id_partie'] - 1;
		
		$tmp = transfert_DB();
		$nb_parties = $tmp[0];
		$table_parties = $tmp[1];	
				
//		echo "<pre>";
//		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 "<pre>";
				print_r($table_parties[$i]);
				echo "</pre>";
			}				
		}
				
		//echo "<pre>";
		//print_r($new_table_parties);
		//echo "</pre>";
				
		// 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);
}
/****************************************************/