
<?

include "include/opendb.inc";

session_start();

$valid=false;


if (!isset($_POST["Auto"])) $_POST["Auto"]="0";


if (($_POST["NomU"] <> "") && ($_POST["Password"] <> "")) {
	$strSql = "Select * from admin where 
	NomU = '".stripslashes($_POST["NomU"])."' and Password = '".$_POST["Password"]."' and Statut = 1 ";
	$rsQuery = mysql_query($strSql);		

if (!$rsQuery) {
   echo "Impossible d'exécuter la requête  dans la base : merci" . mysql_error();
   exit;
}

if (mysql_num_rows($rsQuery) == 0) {
    Header("Location: login.php");
   exit;
}

if ($row = mysql_fetch_assoc($rsQuery)){
			$valid = true;
			//************
			$_SESSION["CodeAdmin"]= $row["CodeAdmin"]; 
			//************
			$_SESSION["accesslevel"]= $row["accesslevel"];
			$_SESSION["SuperAdmin"]= $row["SuperAdmin"];
			//************
			$_SESSION["PersonneA"]= $row["PersonneA"];
			$_SESSION["PersonneM"]= $row["PersonneM"];
			$_SESSION["PersonneS"]= $row["PersonneS"];
			$_SESSION["PersonneL"]= $row["PersonneL"];
			//************
			$_SESSION["ActiviteA"]= $row["ActiviteA"];
			$_SESSION["ActiviteM"]= $row["ActiviteM"];
			$_SESSION["ActiviteS"]= $row["ActiviteS"];
			$_SESSION["ActiviteL"]= $row["ActiviteL"];
			//************
			$_SESSION["InscriptionA"]= $row["InscriptionA"];
			$_SESSION["InscriptionM"]= $row["InscriptionM"];
			$_SESSION["InscriptionS"]= $row["InscriptionS"];
			$_SESSION["InscriptionL"]= $row["InscriptionL"];
			//************
			$_SESSION["SalleA"]= $row["SalleA"]; 
			$_SESSION["SalleM"]= $row["SalleM"];
			$_SESSION["SalleS"]= $row["SalleS"];
			$_SESSION["SalleL"]= $row["SalleL"];
			//************
			$_SESSION["EquipementA"]= $row["EquipementA"];
			$_SESSION["EquipementM"]= $row["EquipementM"];
			$_SESSION["EquipementS"]= $row["EquipementS"];
			$_SESSION["EquipementL"]= $row["EquipementL"];
			//************
			$_SESSION["OrganisationA"]= $row["OrganisationA"];
			$_SESSION["OrganisationM"]= $row["OrganisationM"];
			$_SESSION["OrganisationS"]= $row["OrganisationS"];
			$_SESSION["OrganisationL"]= $row["OrganisationL"];
			//************
			$_SESSION["RapportA"]= $row["RapportA"];
			$_SESSION["RapportM"]= $row["RapportM"];
			$_SESSION["RapportS"]= $row["RapportS"];
			$_SESSION["RapportLL"]= $row["RapportL"];
			
			$_SESSION["NomAdmin"]= $row["Nom"];
			$_SESSION["PrenomAdmin"]= $row["Prenom"];
			//mysql_free_result($row);
		}	
}

if ($valid == true) {

            $_SESSION["NomUss"]= $_POST["NomU"];
			$_SESSION["Password"]= $_POST["Password"];
            $_SESSION['last_access']=time();
            $_SESSION['ipaddr']= $_SERVER['REMOTE_ADDR'];
            $_SESSION['statut']="administrateur";
            $_SESSION["validVS"]= true;
			
			      if ($_POST["Auto"]== "Auto") {
			      setcookie("NomU1",$_POST["NomU"],time()+31536000);
			      setcookie("RememberMe","1",time()+31536000);
			      setcookie("Password1",$_POST["Password"],time()+31536000);

            	  } else {
			      	setcookie("RememberMe","0",time()+31536000);
			      	setcookie("Password1","",time()-1);
            		setcookie("NomU1","",time()+31536000);
				 }
           Header("Location: index.php");
		   
		   
}else {
    $_SESSION["validVS"]= false;
   Header("Location: login.php");
   
   echo $valid;

}

?>