<?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);
}
?>