Retour...';
echo '
';
/***********************************************************************/
function check_date($data)
{
if (date('d-m-Y', strtotime($data)) == $data)
{
return "OK";
}
else
{
return "Erreur";
}
}
/***********************************************************************/
function DB_to_file($filename)
{
chdir("insertion");
$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 = $filename;
//chdir("backup");
echo "Sauvegarde de la db dans un fichier provisoire " .$filename;
echo "
";
$fp = fopen($filename, '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);
chdir("..");
}
/***********************************************************************/
function lire_csv($nom_fichier )
{
$donnee = array();
$joueur = array();
$table_csv = array();
$file = fopen ($nom_fichier,"r");
while(! feof($file))
{
$tmp = fgets($file);
// on désactive le mode minuscule
//$tmp = strtolower($tmp);
//echo $tmp ."
";
$tmp = str_to_noaccent($tmp);
$pieces = explode(";", $tmp);
if($pieces[1] != "")
{
$table_csv[] = $pieces;
$joueur[] = $pieces[1];
$joueur[] = $pieces[2];
}
}
fclose($file);
$nb_ligne = count($table_csv);
for ($i=0; $i < $nb_ligne; $i++)
{
$val = $table_csv[$i][4];
$position = strpos($val, "5");
if($position !== false)
{
//echo " Match nul";
//echo "
";
$table_csv[$i][3] = "0.5";
$table_csv[$i][4] = "0.5";
}
$date_partie = $table_csv[$i][0];
if($date_partie != "")
{ $date = mise_en_forme_date($date_partie);
$sauve = $date;
$table_csv[$i][0] = $date;
}
else
{ $table_csv[$i][0] = $sauve;
}
}
$sans_doublon = array_unique($joueur);
$sans_doublon = array_values($sans_doublon);
// ordonner par ordre alphabetique
usort($sans_doublon, "strcasecmp");
$merge = array($table_csv, $sans_doublon );
//echo "";
//print_r($merge);
return $merge;
}
/***********************************************************************/
function str_to_noaccent($str)
{
$tmp = $str;
$tmp = preg_replace('#Ç#', 'C', $tmp);
$tmp = preg_replace('#ç#', 'c', $tmp);
$tmp = preg_replace('#è|é|ê|ë#', 'e', $tmp);
$tmp = preg_replace('#È|É|Ê|Ë#', 'E', $tmp);
$tmp = preg_replace('#à|á|â|ã|ä|å#', 'a', $tmp);
$tmp = preg_replace('#@|À|Á|Â|Ã|Ä|Å#', 'A', $tmp);
$tmp = preg_replace('#ì|í|î|ï#', 'i', $tmp);
$tmp = preg_replace('#Ì|Í|Î|Ï#', 'I', $tmp);
$tmp = preg_replace('#ð|ò|ó|ô|õ|ö#', 'o', $tmp);
$tmp = preg_replace('#Ò|Ó|Ô|Õ|Ö#', 'O', $tmp);
$tmp = preg_replace('#ù|ú|û|ü#', 'u', $tmp);
$tmp = preg_replace('#Ù|Ú|Û|Ü#', 'U', $tmp);
$tmp = preg_replace('#ý|ÿ#', 'y', $tmp);
$tmp = preg_replace('#Ý#', 'Y', $tmp);
return ($tmp);
}
/***********************************************************************/
function mise_en_forme_date($date)
{
list($jour, $mois, $annee) = explode('/', $date);
$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
return($timestamp);
}
/***********************************************************************/
function clean_folder()
{
$folder_path = "insertion";
// list name of files inside specified folder
$files = glob($folder_path.'/*');
// deleting all the files in the list
foreach($files as $file)
{
if(is_file($file))
{
// Delete the given file
unlink($file);
}
}
}
/***********************************************************************/
/* $id_partie = $_GET['id_partie'];
$jour = $_GET['jour'];
$mois = $_GET['mois'];
$annee = $_GET['annee'];
$J1 = $_GET['J1'];
$J2 = $_GET['J2'];
$selection_score = $_GET['selection_score'];
$date_reference = $_GET['date_reference'];
$option_date = $_GET['option_date'];
$id_partie = $id_partie - 1;
*/
/* $id_partie = 2;
$jour = 15;
$mois = "Juin";
$annee = 2022;
$J1_insert = "RemyS";
$J2_insert = "StephaneR";
$selection_score = "Blanc gagne";
$date_reference = 1655244000;
$option_date = "avant";
*/
$J1 = $_GET['J1'];
$J2 = $_GET['J2'];
$jour = $_GET['jour'];
$mois = $_GET['mois'];
$annee = $_GET['annee'];
$selection_score = $_GET['selection_score'];
$option_date = $_GET['option_date'];
$id_partie = $_GET['id_partie'];
$date_reference = $_GET['date_reference'];
$concate = $J1 ." " .$J2 ." " .$jour ." " .$mois ." " .$annee ." " .$selection_score ." " .$date_reference ." " .$option_date ." " .$id_partie;
//10 Avril 2023 RemyS StephaneR Match nul 1655244000 apres 5
$id_partie = $id_partie - 1;
echo "Infos sur la partie qui va être insérée : " .$concate;
echo "
";
/********/
$day = date('d-m-Y');
$heure = date("H_i_s");
$infos = $day.'-'.$heure;
$fichier_current_DB = "current_db-" .$infos .".txt";
DB_to_file($fichier_current_DB);
$tab_associatif = array();
$tab_associatif ['Janvier']='1';
$tab_associatif ['Février']='2';
$tab_associatif ['Mars']='3';
$tab_associatif ['Avril']='4';
$tab_associatif ['Mai']='5';
$tab_associatif ['Juin']='6';
$tab_associatif ['Juillet']='7';
$tab_associatif ['Aôut']='8';
$tab_associatif ['Septembre']='9';
$tab_associatif ['Octobre']='10';
$tab_associatif ['Novembre']='11';
$tab_associatif ['Décembre']='12';
$mois = $tab_associatif[$mois];
$num_jour = intval($jour);
$num_mois = intval($mois);
if($num_jour < 10)
{
$jour = '0' .$jour;
}
if($num_mois < 10)
{
$mois = '0' .$mois;
}
$date_format = $jour ."-" .$mois ."-" .$annee;
//echo "Format " .$date_format;
//echo "
";
//echo "
";
switch($selection_score)
{
case "Blanc gagne":
$score_blanc = "1";
$score_noir = "0";
break;
case "Blanc perd":
$score_blanc = "0";
$score_noir = "1";
break;
case "Noir gagne":
$score_blanc = "0";
$score_noir = "1";
break;
case "Noir perd":
$score_blanc = "1";
$score_noir = "0";
break;
case "Match nul":
$score_blanc = "0.5";
$score_noir = "0.5";
break;
}
/********/
$new_partie = $jour ."/" .$mois ."/" .$annee .";" .$J1 .";" .$J2 .";" .$score_blanc .";" .$score_noir;
//echo " >>>>>> " .$new_partie ;
//echo "
";
chdir("insertion");
//echo "Chemin :" .getcwd();
//echo "
";
$parties_data = array();
$nblines = count(file($fichier_current_DB));
echo " Nb de parties avant l'insertion " .$nblines;
echo "
";
if ($file = fopen($fichier_current_DB, "r"))
{
$indice = 0;
while(!feof($file))
{
$line = fgets($file);
$line = str_replace(array("\n", "\r"), '', $line);
if( $indice == $id_partie)
{
if($option_date == "avant")
{
$date_partie[] = $new_partie;
$date_partie[] = $line;
}
if($option_date == "apres")
{
$date_partie[] = $line;
$date_partie[] = $new_partie;
}
}
else
{
$date_partie[] = $line;
}
$indice++;
}
fclose($file);
}
$nblines = count($date_partie);
echo " Nb de parties aprés l'insertion " .$nblines;
// on inverse le tableau pour une lecture du type : plus ancien au plus récent
echo "";
$reversed = array_reverse($date_partie);
print_r($reversed);
echo "
";
/****/
$fichier_insertion = "sauvegarde_insertion.txt";
$fp = fopen($fichier_insertion, 'w');
for ($i=0; $i < count($date_partie); $i++)
{
fputs ($fp, $date_partie[$i]);
fputs($fp, "\n");
}
fclose($fp);
/***/
$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 "
";
$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);
echo "+++++ " .getcwd();
if (file_exists($fichier_insertion))
{
echo "Le fichier " .$fichier_insertion ." existe.";
}
else
{
echo "Le fichier n'existe pas.";
}
$donnees = lire_csv($fichier_insertion);
$liste_parties = array();
$liste_joueurs = array();
$liste_parties = $donnees[0];
$liste_joueurs = $donnees[1];
echo " ------------------------------" ."
";
echo "";
print_r($liste_parties);
echo "
";
echo " ------------------------------" ."
";
echo "";
print_r($liste_joueurs);
$nb_parties = count($liste_parties);
echo "Nombre de parties extraites: " .$nb_parties;
for ($item=0; $item < $nb_parties ; $item++)
{
$donnees[0] = $liste_parties[$item][0];
$donnees[1] = $liste_parties[$item][1];
$donnees[2] = $liste_parties[$item][2];
$donnees[3] = $liste_parties[$item][3];
$donnees[4] = $liste_parties[$item][4];
$indice = $item + 1;
algo_elo($donnees, "statistique", "sql", $indice );
}
echo "
";
echo " Chessmaster extraction ....";
echo "
";
generer_chessmaster();
unlink($fichier_current_DB);
unlink($fichier_insertion);
echo "
";
echo "
";
echo "Script executé avec succés";
echo "
";
echo 1;
/*$file = fopen($fichier_insertion,"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];
//echo "";
//print_r($donnees);
//echo "
";
algo_elo($donnees, "nostatistique", "sql", $indice );
$indice = $indice + 1;
}*/
?>