File "debug_efface_partie.php"

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

<?php

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

		//include('correlation.php');
		//include('echec_fonctions_communes.php');
		//include('chessmaster.php');
			
		//$id_partie =  $_POST['id_partie'] - 1;
		$id_partie = 5 - 1;
		
		$tmp = transfert_DB();
		$nb_parties = $tmp[0];
		$table_parties = $tmp[1];	

		echo "N parties : " .$nb_parties ."<br>"; 		
				
		echo "<pre>";
		print_r($tmp[1]);
		echo "<br>";
				
		for ($i=0; $i < $nb_parties; $i++)
		{
			if($i != $id_partie )
			{
				$new_table_parties[] = $table_parties[$i];
			}
		}
				
		echo "<pre>";
		print_r($new_table_parties);
		echo "<br>";
				
		// 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 );
			//chess_master($donnees,$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);
}
				
?>