File "effacer.php"

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

<?php
	session_start();
	include('database.php');
	DB_connexion(); 
	
	ini_set( 'display_errors', '0');
	error_reporting( 0 );
	
	if(!isset($_SESSION['logged']) )
	{		header ('Location: interdiction.php');
	}
	
	if($_SESSION['logged']== "no")
	{
		header ('Location: interdiction.php');
	}
	
/***********************************************************/	
	if(!empty($_POST) )
	{
		$_SESSION['sauvegarde_formulaire'] = $_POST ;
     
		$page_actuelle = $_SERVER['PHP_SELF'] ;
		if(!empty($_SERVER['QUERY_STRING']))
		{
			$page_actuelle .= '?' . $_SERVER['QUERY_STRING'] ;
		}
     
		header('Location: ' . $page_actuelle);
		exit;
	}
	
	if(isset($_SESSION['sauvegarde_formulaire']))
	{
		$_POST = $_SESSION['sauvegarde_formulaire'] ;
		unset($_SESSION['sauvegarde_formulaire']);		
	}	
/***********************************************************/	
	
	if( isset($_GET['yes']) && $_GET['yes'] == 1  )
	{
		// supprime l'entrée de la table
		//$id = $_GET['id'];	
		
		//$sql = "DELETE FROM joueurs where id = '".$id."' ";
		$sql = "DELETE FROM " .$_SESSION['classement'] ." where joueur = '".$_GET['joueur']."' ";
		//echo $sql;
		//echo "<br>";
		$requete = mysql_query($sql);
		
		$sql = "DELETE * FROM " .$_SESSION['elo_affectation'] ." WHERE joueur = '".$_GET['joueur']."' ";
		//echo $sql;
		//echo "<br>";
		$requete = mysql_query($sql);
			
		//$results = mysql_query($sql);
		//$val = mysql_fetch_array($results);
		//echo $val['nom'] ."   " .$val['prenom'];
		//echo $val['joueur'];
		
		//$requete = mysql_query($sql);
		//header ('Location: liste_joueurs.php');
		$_SESSION['message'] = "ok";
		
		// AlvaroDM
		// DamienB
		// CedricV
		// FranckV
		
		//JulienBL
		//JulienV
		// HenriqueF

		// PhilippeA
		// RemyS 
		//StephaneR 
		// ValentiS
		// VincentT
		
		//RemyS
		//DamienB
		//FranckV
		//StephaneR
		//JulienV
		//ValentiS
		//PhilippeA
		//HenriqueF
		//VincentT
		//JulienBL
		//AlvaroDM
		//CedricV
		
	}
	
?>
  
<!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" />
<meta name="Description" content="Site perso,cours,ouvrages" />
<meta name="Keywords" content="WEBSITE perso " />
<meta name="Distribution" content="Global" />
<meta name="Robots" content="" />
<meta http-equiv="Content-Language" content="fr" />
<meta name="rating" content="general" />
<meta name="author" content="Patrice DELPY" />
<meta name="copyright" content="Copyright 2013" />
<meta name="generator" content="Patoche" />
<title>Patoche WEBSITE - 2013 - Template du site - en cours de développemment ...</title>

<!---------------------------------------------------------->	
<?php
		include('include_css_template_commun.php');
		include('include_css.php');
		include('css_tools_skill.php');
		include('include_javascript.php');

?> 

<link href="http://code.jquery.com/ui/1.10.4/themes/ui-lightness/jquery-ui.css" rel="stylesheet">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="http://code.jquery.com/ui/1.10.4/jquery-ui.js"></script>


<style type="text/css">
#bloc_gestion { float: left;
					width: 831px; 
					padding: 50px 50px 25px 50px;
					}	
					
#navigation_tournoi{
					float: left;
					width: 885px;
					padding: 10px 0px 0px 10px;
		}

label
{   
	display: block;
	width: 150px;
	float: left;
	//padding: 28px;
}

select
{
width: 100px;
display: inline-block;
}

input {
 display: inline-block;
		}
		
</style>

<script type="text/javascript">
function call_update()
{
	 //ajax_routine(); 
	 scruter();
	 setTimeout("call_update()", 1000); //appelle la fonction 1 fois par  seconde
}

function scruter()
{
				var xhr = getXhr()
				// On défini ce qu'on va faire quand on aura la réponse
				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)
					{
						//alert(xhr.responseText);
						retour = xhr.responseText
						
						if(retour == 0)
						{  	
		
							$(function()
							{
									$( "#message_expiration" ).dialog({
									modal: true,
									title: "Infos",
									buttons: {
												Ok: function()
												{
													$( this ).dialog( "close" );
													 document.location.href = "logout_expire.php";
												}
											 }
										});
							});
							
							
						}
	
						
						
					}
				}
					
				xhr.open("GET","session_timeout.php",true);
				xhr.send(null);
}

function redirect() 
{  
        window.location="https://analog-design.net/CHESS_ON/admin.php"; 
}  
 
function redirection()
{
	setTimeout('redirect()', 5000);   
}	

   
</script>

<!---------------------------------------------------------->	
</head>

<body>
<!---------------------------------------------------------->	
	<div class="main"> <!-- main -->
<!---------------------------------------------------------->	

          <div class="header">
                <div class="balise_titre">Patoche</div>
                <div class="balise_citation">
                &quot;Etre conscient que l'on est ignorant est un grand pas vers le savoir&quot;
                </div>
          </div> 
 
          <div class="banniere"></div>  

<!---------------------------------------------------------->
<?php
/*	include("include_barre_login.php");
	echo '<div id="box_icon">';
	include("debug_connexion_membre.php");
	echo '</div>';
	include("include_menu.php");*/
	
	echo '<div id="box_infos">';
			include("include_menu.php");
			
			echo '<div id="box_icon2">';
			include("connexion_membre.php");
			echo	'</div>';
			
			echo '<div id="box_icon3">';
			include("include_barre_login.php");
			echo	'</div>';

	echo	'</div>';
	$_SESSION['page_active'] = basename (__FILE__ );
?>
		

<!---------------------------------------------------------->	
            <div class="contenu"> <!-- contenu -->
<!---------------------------------------------------------->	
	
			<div class="barre_vide"></div>
			
			<div id="navigation_tournoi">
				<ul id="menu_horiz">
				<li class="tournoi_back_tag_selected"><a href="admin.php" title="Retour au menu admin">Retour</a></li>
				</ul>
			</div>
			
			<div id="bloc_gestion"> 
<?php			

			echo "Effacer le joueur : " .$_GET["joueur"];   
	

			//$id = $_GET["eff"];
			//$sql = "SELECT * FROM " .$_SESSION['classement'] ." WHERE id = '".$id."' ";
			//echo $sql;
			//echo "<br>";
			
			//$results = mysql_query($sql);
			//$val = mysql_fetch_array($results);
			//echo $val['nom'] ."   " .$val['prenom'];
			//echo "----> " .$val['joueur'];
			//echo '<br/>
			//	  <br/>
			//	  <br/>'; 		

			echo '<br><br><br><p align=center><a href="effacer.php?joueur='.$_GET["joueur"].'&yes=1">OUI</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="liste_joueurs.php">NON</a></p>';

			if($_SESSION['message'] == "ok")
			{	
				echo '<div id="message_traitement" style="display:block">Joueur supprimer de la base de donnée, redirection dans 5s.</div>';
				$_SESSION['message'] = "none";
				
				echo '<script type="text/javascript">redirection();</script>';
			}
?>		
 
			</div>	
			
<!--		// affiche le message de confirmation + le lien de retour
			echo "<h1 align=center>Enregistrement effacé<br><br><a href='powerball.php'>Retour</a>"; -->

			<div id="message_expiration" style="display: none">
			<p>
			<span class="ui-icon ui-icon-circle-check" style="float:left; margin:0 7px 50px 0;"></span>
			La session a expiré. veuillez vous reconnecter.
			</p>
			</div>
			
			
			<br/>
			<br/>
			<br/>
			<br/>
			<br/>

<!---------------------------------------------------------->	
<?php			
    include('include_pied_page.php');
	include('include_publicite.php');
?>
<!---------------------------------------------------------->	
			</div>  <!-- contenu -->
<!---------------------------------------------------------->	
	</div>   <!-- main -->
<!---------------------------------------------------------->	

	<div id="myDiv"></div>

	<script type="text/javascript">
		call_update();
	</script>

</body>
</html>