File "traitement_initialisation.php"

Full Path: /home/analogde/www/Freebox/CHESS_ON/traitement_initialisation.php
File size: 4.23 KB
MIME-type: text/x-php
Charset: utf-8

<?php

	include('database.php');
	DB_connexion(); 
	
	$erreur1 = "";
	$erreur2 = "";
	$erreur3 = "";
	$erreur4 = "";
	$erreur5 = "";
	$erreur6 = "";
	$erreur7 = "";

	
	//$jour = date('d-m-Y');
	//$heure = date("H_i_s");
	//$infos = $jour.'-'.$heure;
	
	//$fichier = '/homez.65/analogde/www/CHESS_2022/dump/db-backup-'.$infos.'.sql';
	//system("mysqldump --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 --default-character-set=utf8 analogdepat clone_chessmaster_new clone_classement_new clone_evolution_new clone_parties_new clone_elo_affectation > $fichier");

	
/*	$result = mysql_query('TRUNCATE clone_chessmaster_new;');
	if (!$result) 
	{
		//die('Requête invalide  - table chessmaster: ' . mysql_error());
		$erreur1 = "Requête invalide purge table chessmaster";
	}

	$result = mysql_query('TRUNCATE clone_classement_new;');
	if (!$result) 
	{
		//die('Requête invalide  - table classement: ' . mysql_error());
		$erreur2 = "Requête invalide purge table classement";
	}

	$result = mysql_query('TRUNCATE clone_evolution_new;');
	if (!$result) 
	{
		//die('Requête invalide  - table evolution: ' . mysql_error());
		$erreur3 = "Requête invalide purge table evolution";
	}
	
	$result = mysql_query('TRUNCATE clone_parties_new;');
	if (!$result) 
	{
		//die('Requête invalide  - table parties: ' . mysql_error());
		$erreur4 = "Requête invalide purge table parties";
	}
	
	$sql = "	INSERT INTO `clone_elo_affectation` (`joueur`, `elo`) VALUES
	('AlvaroM', 1400),
	('DamienB', 1400),
	('EmileM', 1400),
	('FranckV', 1400),
	('HenriqueF', 1400),
	('PatrickA', 1400),
	('PhilippeA', 1400),
	('RemyS', 1400),
	('StephaneR', 1400); ";
	$result = mysql_query($sql);
	if (!$result) 
	{
		//die('Requête invalide  - insertion affectation: ' . mysql_error());
		$erreur5 = "Requête invalide insertion affectation";
	}
	
	$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);
	if (!$result) 
	{
		//die('Requête invalide  - insertion classement : ' . mysql_error());
		$erreur6 = "Requête invalide purge table parties";
	}
	
	$sql = "ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1";
	$result = mysql_query($sql);
	if (!$result) 
	{
		//die('Requête invalide : auto increment chessmaster : ' . mysql_error());
		$erreur7 = "Requête invalide auto increment chessmaster";
	}
	*/
	
	
	/*******************************************************************/
	
	$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);
	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 1;
	}
	
	else
	{ 
		echo 2;
	}
?>