Tiny File Manager

Back Back Up Advanced Editor

<?php

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

header( 'content-type: text/html; charset=utf-8' );

}

/******************************************/
function import_donnees($folder, $fichier)
{
	$donnees = lire_csv($folder, $fichier);
	
	// fragmentation
	$liste_parties = array();
	$liste_joueurs = array();
	$liste_parties = $donnees[0];
	$liste_joueurs = $donnees[1]; 
	// affichage
	echo " ------------------------------" ." ";
	echo "<pre>";
	print_r($liste_parties);
	echo " ";
	echo " ------------------------------" ." ";
	echo "<pre>";
	print_r($liste_joueurs);
	
	
	$_SESSION['chessmaster'] = "clone_chessmaster_new";	
	$_SESSION['classement'] = "clone_classement_new";
	$_SESSION['parties'] = "clone_parties_new";
	$_SESSION['evolution'] = "clone_evolution_new";
	$_SESSION['elo_affectation'] = "clone_elo_affectation";
	
	
	$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);
	
	$sql = "ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1";
	$result = mysql_query($sql);
	
	$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);

echo " ";
	echo " ------------------------------" ." ";
	// enregistrer 
	// stockage_joueurs_DB($liste_joueurs);
	echo " ";
	echo " ------------------------------" ." ";
	// calculer du classement
	
//	04 Novembre 2017 test
	$nb_parties = count($liste_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 );
			chess_master($donnees,$item);
			
	}
	
	echo " ";
	echo " ------------------------------" ." ";

echo "Script executé avec succés";	
	echo " ";
	
}
/******************************************/
function mise_en_forme_date($date)
{
		list($jour, $mois, $annee) = explode('/', $date);
		$timestamp = mktime (0, 0, 0, $mois, $jour, $annee);
		return($timestamp);
}
/******************************************/
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);
}
/******************************************/

$folder = "insertion";
	$fichier = "aze.txt";

//lire_csv($folder, $fichier);
	import_donnees($folder, $fichier)