Tiny File Manager

Back Back Up Advanced Editor

<?php

session_start();
	include('database.php');
	DB_connexion(); 
		
	header( 'content-type: text/html; charset=utf-8' );
	
	$erreur1 = "";
	$erreur2 = "";
	
	//echo '<a href="admin.php">retour ...</a>  
	//<br>
	//<br>';

$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 "Les tables viennent d'être purgées.";
	//echo "<br><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, 'CedricV', 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, 'JulienBL', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(6, 'JulienV', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(7, 'HenriqueF', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(8, 'PhilippeA', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(9, 'RemyS', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(10, 'StephaneR', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(11, 'ValentiS', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1),	(12, 'VincentT', 1400, 1400, 0, 0, 0, 0, 0, 0, 0, 0, 1); ";	// AlvaroDM		// DamienB		// 			CedricV		// FranckV				//			JulienBL		//			JulienV		// HenriqueF		// PhilippeA		// RemyS 		//StephaneR 					// ValentiS					// VincentT	
	$result = mysql_query($sql);
	if (!$result) 
	{
		$erreur1 = "Requête invalide pour initialiser la table classement!.";
	}
	
	$sql = "ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1";
	$result = mysql_query($sql);
	if (!$result) 
	{
		$erreur2 = "Requête invalide auto increment chessmaster!.";
	}
	
	if( empty($erreur1) && empty($erreur2) )
	{
		//echo "InitialisationLes des tables réussie.";
		echo 1;
	}
	
	else
	{ 
		//echo "Erreur : Initialisation impossible !.";
		echo 2;
	}
	
	//header( "refresh:3;url=admin.php" );
	
?>