Date non valide.'; header ('Location: interdiction.php'); } else { $timestamp = mktime (0, 0, 0, $mois, $jour, $annee); //echo $_POST['date_reference']; //echo $_POST['option_date']; if($option_date == "avant") { //echo $timestamp ." **** " .$_POST['date_reference']; if($timestamp <= $date_reference) { $plage_date = "Ok"; } else { $plage_date = "Erreur_avant"; } } if($option_date == "apres") { //echo $timestamp ." **** " .$_POST['date_reference']; if($timestamp >= $date_reference) { $plage_date = "Ok"; } else { $plage_date = "Erreur_apres"; } } if($plage_date == "Ok") { $donnees = array(); $donnees[0] = $jour ."/" .$mois ."/" .$annee; $donnees[1] = $J1; $donnees[2] = $J2; $donnees[3] = $score_blanc; $donnees[4] = $score_noir; $sql = "SELECT * FROM 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($option_date == "avant") { $id_position = $id_partie -1; } if($option_date == "apres") { $id_position = $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"; $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;'); 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; chess_master($donnees,$indice); } //partie insérée dans la database echo 1; } else { //Date non valide dans la plage définie echo 2 ." " .$timestamp ." " .$date_reference ." " .$option_date; //25 juillet 1437775200 //27 juillet 1437948000 } } } else { //Erreur dans le traitement echo 3; } //$str = $jour ." " .$mois ." " .$annee ." " .$J1 ." " .$J2 ." " .$selection_score ." " .$date_reference ." " .$option_date ." " .$id_partie; //echo $str; ?>