File "debug_efface_partie.php"

Full Path: /home/analogde/www/download/CHESS_2022/debug_efface_partie.php
File size: 4.09 KB
MIME-type: text/x-php
Charset: utf-8

<?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 '<br><br>';
		
			
		$sql = "SELECT * from " .$_SESSION['parties']; 
						
		$resultat = mysql_query($sql);
		$n = mysql_num_rows($resultat);	
			
		echo "Nb parties dans la db : " .$n;	
		echo "<br><br>";
		
		echo "Effacer la partie portant l'indice " .$_GET['id_partie']; 
		echo "<br><br>";
		
		// 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 "<br>";
				
		// 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 "<br>";
	
		$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);
}
/****************************************************/				

?>