File "traitement_dump.php"

Full Path: /home/analogde/www/download/CHESS_2022/traitement_dump.php
File size: 4.97 KB
MIME-type: text/x-php
Charset: utf-8

<?php
	session_start();
	include('database.php');
	DB_connexion(); 

/*
	if(!empty($_POST) )
	{
		$filename = $_POST["filename"];
		//chdir("dump");
		
		
		$cmd = "mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 analogdepat <" .$filename;
		
		system($cmd, $ret);
		
		
		echo 1;
	}		
	else
	{
		echo 5;
	}
*/


	$req1 = "DROP TABLE " .$_SESSION['chessmaster'];
	$req2 = "DROP TABLE " .$_SESSION['classement'];
	$req3 = "DROP TABLE " .$_SESSION['parties'];
	$req4 = "DROP TABLE " .$_SESSION['evolution'];
	$req5 = "DROP TABLE " .$_SESSION['elo_affectation'];
	
	//mysql_query($req1);
	//mysql_query($req2);
	//mysql_query($req3);
	//mysql_query($req4);
	//mysql_query($req5);

	$filename = $_POST["filename"];
	
	$cmd = "mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 analogdepat <" .$filename;
		
	//system($cmd, $ret);
	
	/*if($ret == 0)
	{
		echo 1;
	}
	else
	{
		echo 5;
	}*/
	
	
	
	
//	system("mysqldump --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 --default-character-set=utf8 analogdepat configuration client gestion reservation2015 > $fichier");

//	$fichier = "Student.sql";

//	$cmd = "mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 < $fichier";

//	echo $cmd;
//	echo "<br><br>";
	
//	$cmd = "mysql -u analogdepat -pUn92pac007 analogdepat.mysql.db < Student.sql";

//system("cat nom_fichier_sauvegarde.sql | mysql --host=adresse_du_serveur --user=nom_utilisateur 
//		--password=mot_de_passe_utilisateur nom_base_de_données");

  //$db_host    = "analogdepat.mysql.db";
  // 	       $db_user   = "analogdepat";
  //	       $db_pass   = "Un92pac007";
//	       $db_name   = "analogdepat";

	//system(" mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 analogdepat <Student.sql";

	$cmd = "mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 analogdepat <Student.sql";



	//echo $cmd;
	//echo "<br><br>";
	
	//system($cmd, $ret);
	
	
	
	

//system("mysqldump --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 --default-character-set=utf8 analogdepat configuration client gestion reservation2015 > $fichier");
/*
		$sql = "CREATE TABLE abcd(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nom VARCHAR(30) NOT NULL,
    prenom VARCHAR(30) NOT NULL,
    ville VARCHAR(30) NOT NULL 
)";
		*/
/*		
		$sql = " INSERT INTO abcd";
		$sql = $sql . " (joueur, elo, parties, prior, initial) VALUES ";
		$sql = $sql . " ('lui', 'gfg','toulouse') ";
		$result = mysql_query($sql);
		
		
		$sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com')";

$sql = "CREATE TABLE Student
(
ID int NOT NULL AUTO_INCREMENT,
nom varchar(50),
prenom varchar(50),
ville varchar(50),
PRIMARY KEY (ID)
)"; 


INSERT INTO Student (nom, prenom, ville) VALUES ('delpy', 'vincent', 'toulouse')
INSERT INTO Student (nom, prenom, ville) VALUES ('blase', 'bob', 'albi')
INSERT INTO Student (nom, prenom, ville) VALUES ('toto', 'lulu', 'paris')
*/

	

	if(!empty($_POST) )
	{
	
		$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);	
	
		$filename = $_POST["filename"];
		//$filename = "dump_db_auto-07-07-2022-17_55_02.sql";
		
		chdir("dump");
		$cmd = "mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 analogdepat <" .$filename;
		system($cmd, $return_var);
		chdir("..");
		
		
		//chdir("dump");
		//$cmd = "mysql --host=analogdepat.mysql.db --user=analogdepat --password=Un92pac007 analogdepat <" .$filename;
		//exec($cmd, $output, $return_var);
		//chdir("..");
		
		//echo "+++++ " .$return_var;
		//echo "<br><br>";
		
		$retour_dump = "";
		
		switch($return_var)
		{
			case 0:
					$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";
					$retour_dump = 1;
			break;
			case 1:
					$retour_dump = 2;
			break;
		}
		
		echo $retour_dump;

	}		

?>