File "purge_init_tables.php"

Full Path: /home/analogde/www/Bookmarks/CHESS_ON/purge_init_tables.php
File size: 2.1 KB
MIME-type: text/x-php
Charset: utf-8

<?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" );
	
?>