Date non valide.';
}
else
{
$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
echo $_POST['date_reference'];
echo $_POST['option_date'];
if($_POST['option_date'] == "avant")
{
echo $timestamp ." **** " .$_POST['date_reference'];
if($timestamp <= $_POST['date_reference'])
{
$plage_date = "Ok";
}
else
{
$plage_date = "Erreur_avant";
}
}
if($_POST['option_date'] == "apres")
{
echo $timestamp ." **** " .$_POST['date_reference'];
if($timestamp >= $_POST['date_reference'])
{
$plage_date = "Ok";
}
else
{
$plage_date = "Erreur_apres";
}
}
echo "Plage Date " .$plage_date;
if($plage_date == "Ok")
{
$donnees = array();
$donnees[0] = $jour ."/" .$mois ."/" .$annee;
$donnees[1] = $_POST['J1'];
$donnees[2] = $_POST['J2'];
$donnees[3] = $score_blanc;
$donnees[4] = $score_noir;
// print_r($donnees);
//$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'];
$date = $row['date'];
$resultat = $row['result'];
$date_partie = date('d/m/Y', $date);
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] = $date_partie;
$table_csv[1] = $blanc;
$table_csv[2] = $noir;
$table_csv[3] = $_score_blanc;
$table_csv[4] = $_score_noir;
$table_fichier[] = $table_csv;
}
$nom_fichier = "sauvegarde_insertion.txt";
$fp = fopen($nom_fichier, 'w');
for ($i=0; $i < $nb_parties; $i++)
{
$str_comma_separated = implode(";", $table_fichier[$i]);
fputs ($fp, $str_comma_separated);
if($i != $nb_parties - 1)
fputs($fp, "\n");
}
fclose($fp);
// creation du fichier modifie
$nom_fichier = "new_insertion.txt";
if($_POST['option_date'] == "avant")
{
$id_position = $_POST['id_partie'] -1;
}
if($_POST['option_date'] == "apres")
{
$id_position = $_POST['id_partie'] ;
}
$tab1 = array();
$tab2 = array();
$fp = fopen($nom_fichier, 'w');
for ($i=0; $i <= $id_position - 1; $i++)
{
$tab1[] = $table_fichier[$i];
}
$table[] = $donnees;
for ($i=$id_position ; $i < $nb_parties; $i++)
{
$tab2[] = $table_fichier[$i];
}
$tab_global = array_merge($tab1,$table,$tab2);
$fp = fopen($nom_fichier, 'w');
for ($i=0; $i < count($tab_global); $i++)
{
$str_comma_separated = implode(";", $tab_global[$i]);
fputs ($fp, $str_comma_separated);
if($i != count($tab_global) - 1)
{
fputs($fp, "\n");
}
}
fclose($fp);
// 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'];
}
// regenerer le classement
//mysql_query('TRUNCATE TABLE classement;');
//mysql_query('TRUNCATE TABLE evolution;');
//mysql_query('TRUNCATE TABLE parties;');
$str1 = "TRUNCATE TABLE " .$_SESSION['classement'];
$str2 = "TRUNCATE TABLE " .$_SESSION['evolution'];
$str3 = "TRUNCATE TABLE " .$_SESSION['parties'];
$str4 = "TRUNCATE TABLE " .$_SESSION['chessmaster']; // nouveau
// pourquoi la table chessmaster n'est pas mise à jour ??????
mysql_query($str1);
mysql_query($str2);
mysql_query($str3);
mysql_query($str4);
stockage_joueurs_DB($joueur);
$file = fopen ("new_insertion.txt","r");
$indice = 1;
while(! feof($file))
{
$tmp = fgets($file);
$tmp = strtolower($tmp);
//echo $tmp ."
";
//$tmp = str_to_noaccent($tmp);
$pieces = explode(";", $tmp);
$donnees[0] = $pieces[0];
list($jour, $mois, $annee) = explode('/', $donnees[0]);
$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
$donnees[0] = $timestamp;
$donnees[1] = $pieces[1];
$donnees[2] = $pieces[2];
$donnees[3] = $pieces[3];
$donnees[4] = $pieces[4];
algo_elo($donnees, "nostatistique", "sql", $indice );
$indice = $indice + 1;
// nouveau
chess_master($donnees,$indice);
}
echo "
";
echo "Base modifiée: " .$_POST['J1'] ." ".$_POST['J2'] ." " .$score_blanc ." - " .$score_noir;
$message = '