Tiny File Manager

Back Back Up Advanced Editor

<?php
		session_start();
		include('correlation.php');
		include('chessmaster.php');
		include('generation_chessmaster.php');

//include('correlation.php');
		//include('echec_fonctions_communes.php');
		//include('chessmaster.php');

header( 'content-type: text/html; charset=utf-8' );
			
		$J1 = $_GET['J1'];
		$J2 = $_GET['J2'];
		$selection_score = $_GET['selection_score'];
		$id_partie = $_GET['id_partie'];
		$flag_validation = false;
			
		//	$J1 = "EmileM";
		//	$J2 = "PatrickA";
		//	$selection_score = "Blanc perd";
		//	$id_partie = 5;
		//	$flag_validation = false;
		
		echo "Modification de la partie ....";
		echo " ";
		
		switch($selection_score)
		{
			case "Blanc gagne":
					$score_blanc = "1";
					$score_noir = "0";
					$flag_validation = true;
			break;
				
			case "Blanc perd":
					$score_blanc = "0";
					$score_noir = "1";
					$flag_validation = true;
			break;

case "Match nul":
					$score_blanc = "0.5";
					$score_noir = "0.5";
					$flag_validation = true;
				break;
		}
			
		if($flag_validation == true)
		{
				$id_partie = $id_partie - 1;
				
				$tmp = transfert_DB();
				$nb_parties = $tmp[0];
				$table_parties = $tmp[1];

for ($i=0; $i < $nb_parties; $i++)
				{
					if($i == $id_partie )
					{
						$table_parties[$i][1] = $J1;
						$table_parties[$i][2] = $J2;
						$table_parties[$i][3] = $score_blanc;
						$table_parties[$i][4] = $score_noir;
					}
				}
				
				echo "<pre>";
				print_r($table_parties);
				
				$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";
				//$sql = "ALTER TABLE " .$_SESSION['chessmaster'] ." AUTO_INCREMENT = 1";
				$result = mysql_query($sql);
				
				//if($result == 0)
				//{
					//$nb_parties = count($liste_parties);
					echo "Nombre de parties dans la database : " .$nb_parties;
	
					for ($item=0; $item < $nb_parties ; $item++)
					{
						$donnees[0] = $table_parties[$item][0];
						$donnees[1] = $table_parties[$item][1];
						$donnees[2] = $table_parties[$item][2];
						$donnees[3] = $table_parties[$item][3];
						$donnees[4] = $table_parties[$item][4];
			
						echo " +++++ " .$item;
						echo " ";
						
			
						$indice = $item + 1;
						algo_elo($donnees, "statistique", "sql", $indice );
						//chess_master($donnees,$item);
					}
				
					echo " ";
					
					generer_chessmaster();

echo "Script executé avec succés";	
					echo " ";
					
					
					
				//}
				//else
				//{
				//	echo "Probléme lors de l'execution ....";
				//}
				
/*
			 // joueur
				$joueur = array();
				//$sql = "SELECT * FROM classement ORDER by joueur asc"; 
				$sql = "SELECT * FROM " .$_SESSION['classement'] ." ORDER by joueur asc"; 
				
				$results = mysql_query($sql);
								
				while($row = mysql_fetch_assoc($results))
				{
					$joueur[] = $row['joueur'];
				}
				
				// effacer les tables
				//$_SESSION['chessmaster'] = "chessmaster_new";	
				//$_SESSION['classement'] = "classement_new";
				//$_SESSION['parties'] = "parties_new";
				//$_SESSION['evolution'] = "evolution_new";
				
				//mysql_query('TRUNCATE TABLE classement;');
				//mysql_query('TRUNCATE TABLE evolution;');
				//mysql_query('TRUNCATE TABLE parties;');
				//mysql_query('TRUNCATE TABLE chessmaster;');
				
				$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);
	
				stockage_joueurs_DB($joueur);
	
				for ($item=0; $item < $nb_parties ; $item++)
				{
					$donnees[0] = $table_parties[$item][0];
					$donnees[1] = $table_parties[$item][1];
					$donnees[2] = $table_parties[$item][2];
					$donnees[3] = $table_parties[$item][3];
					$donnees[4] = $table_parties[$item][4];
			
					$indice = $item + 1;
					algo_elo($donnees, "nostatistique", "sql", $indice );
					chess_master($donnees,$indice);
				}
*/				
				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);
}
			
?>