File "initialisation.php"
Full Path: /home/analogde/www/WORDPRESS/HDL/CHESS_2022/initialisation.php
File size: 6.98 KB
MIME-type: text/x-php
Charset: utf-8
<?php
include('database.php');
DB_connexion();
echo '<a href="admin.php">Retour...</a>';
echo '<br><br>';
if( isset($_POST['var']) )
{
echo $_POST['var'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<link rel="stylesheet" href="//code.jquery.com/ui/1.13.1/themes/base/jquery-ui.css">
<link rel="stylesheet" href="/resources/demos/style.css">
<script src="https://code.jquery.com/jquery-3.6.0.js"></script>
<script src="https://code.jquery.com/ui/1.13.1/jquery-ui.js"></script>
<script type="text/javascript">
function getXhr()
{
var xhr = null;
if(window.XMLHttpRequest) // Firefox et autres
xhr = new XMLHttpRequest();
else if(window.ActiveXObject)
{ // Internet Explorer
try
{
xhr = new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xhr = new ActiveXObject("Microsoft.XMLHTTP");
}
}
else
{
// XMLHttpRequest non supporté par le navigateur
alert("Votre navigateur ne supporte pas les objets XMLHTTPRequest...");
xhr = false;
}
return xhr;
}
function fct_confirmation()
{
$(function ()
{
$( "#dialog" ).dialog({
modal: true,
title: "Info",
closeOnEscape: false,
buttons: {
Oui: function()
{
$( this ).dialog( "close" );
fct_initialiser();
},
Non: function()
{
$( this ).dialog( "close" );
}
}
});
//$("#btnShow").click(function ()
$("#action").click(function ()
{
$('#dialog').dialog('open');
});
});
}
function fct_initialiser()
{
var xhr = getXhr();
xhr.onreadystatechange = function()
{
// On ne fait quelque chose que si on a tout reçu et que le serveur est ok
if(xhr.readyState == 4 && xhr.status == 200)
{
retour = xhr.responseText;
if(retour == 1)
{
document.getElementById("pour_le_message").innerHTML = "Initialisation réussie, vous allez être redirigé dans qq secondes";
setTimeout(function(){ window.location="admin.php"; },2500);
/*$(function()
{
$( "#message_import" ).dialog({
modal: true,
title: "Infos",
buttons: {
Ok: function()
{
$( this ).dialog( "close" );
//window.location.reload();
bye();
//setTimeout(function(){ window.location="read02.php"; },5000);
}
}
});
});*/
}
if(retour == 2)
{
document.getElementById("pour_le_message").innerHTML = "Pas bon";
/*$(function()
{
$( "#message_erreur" ).dialog({
modal: true,
title: "Infos",
buttons: {
Ok: function()
{
$( this ).dialog( "close" );
//window.location.reload();
}
}
});
});*/
}
}
}
xhr.open("POST","traitement_initialisation.php",true);
xhr.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
xhr.send();
}
// https://makitweb.com/how-to-handle-ajax-request-on-the-same-page-php/
</script>
<?php
echo '<button id="action" onclick="fct_confirmation()">Initialiser DB</button>';
echo '<div id="dialog" style="display: none" align = "center">Confirmation de l\'initialisation ?.</div>';
echo '<p id="pour_le_message"></p>';
?>
<div id="message_import" style="display: none">
<p><span class="ui-icon ui-icon-circle-check" style="float:left; margin:0 7px 50px 0;"></span>Initialisation faite</p></div>
<div id="message_erreur" style="display: none">
<p><span class="ui-icon ui-icon-circle-check" style="float:left; margin:0 7px 50px 0;"></span>Pb lors de la génération</p></div>
<?php
/*
$result = mysql_query('TRUNCATE clone_chessmaster_new;');
if (!$result)
{
die('Requête invalide - table chessmaster: ' . mysql_error());
}
$result = mysql_query('TRUNCATE clone_classement_new;');
if (!$result)
{
die('Requête invalide - table classement: ' . mysql_error());
}
$result = mysql_query('TRUNCATE clone_evolution_new;');
if (!$result)
{
die('Requête invalide - table evolution: ' . mysql_error());
}
$result = mysql_query('TRUNCATE clone_parties_new;');
if (!$result)
{
die('Requête invalide - table parties: ' . mysql_error());
}
$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 elo_affectation: ' . mysql_error());
}
$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());
}
$sql = "ALTER TABLE clone_chessmaster_new AUTO_INCREMENT = 1";
$result = mysql_query($sql);
if (!$result)
{
die('Requête invalide - chessmaster auto increment : ' . mysql_error());
}
*/
/*
CREATE TABLE clone_chessmaster_new LIKE chessmaster_new ;
INSERT INTO clone_chessmaster_new SELECT * FROM chessmaster_new ;
CREATE TABLE clone_classement_new LIKE classement_new ;
INSERT INTO clone_classement_new SELECT * FROM classement_new ;
CREATE TABLE clone_parties_new LIKE parties_new ;
INSERT INTO clone_parties_new SELECT * FROM parties_new ;
CREATE TABLE clone_evolution_new LIKE evolution_new ;
INSERT INTO clone_evolution_new SELECT * FROM evolution_new ;
CREATE TABLE clone_elo_affectation LIKE elo_affectation ;
INSERT INTO clone_elo_affectation SELECT * FROM elo_affectation ;
*/
?>