<?
session_start();
// Authetification
$db_hostname = "localhost";
$db_name="ecoleprogress1415";
$db_user = "eprog1415";
$db_pass = "E^g6m87i";


if (isset($_POST['test']))
{
	
  $conn = mysql_connect($db_hostname, $db_user, $db_pass);
  if (!$conn) {
	echo 'Pb de connexion a la base';
  }
  
  if (!mysql_select_db($db_name, $conn)) {
	echo 'Pb de selection de la base';
  }
  
  //filtrage par section pour le simulateur
	$esse=array(21,20,18);
	$eu_esse=array(19,22,23);
  $strSQL = "SELECT etat.cle, etat.nom, etat.prenom,etat.email_el,etat.email_me,etat.email_pe, classe.nom AS classe,etat.section,classe.cle AS cle_classe FROM (etat INNER JOIN classe ON etat.classe = classe.cle) WHERE etat.id_pass = '".$_POST['id_eleve']."' AND etat.el_pass = '".$_POST['pwd_eleve']."'";
  $req_verif_select = mysql_query($strSQL, $conn);
  $data = mysql_fetch_array($req_verif_select);
  if ($data[0]) // Compte valide. 
    {
	$_SESSION['UserCle'] = $data['cle'];
	$_SESSION['UserType'] = 'eleve';
	$_SESSION['UserPrenom'] = $data['prenom'];
	$_SESSION['UserNom'] = $data['nom'];
    $_SESSION['UserMail'] = $data['email_el'];
    $_SESSION['UserMail_me'] = $data['email_me'];
    $_SESSION['UserMail_pe'] = $data['email_pe'];
	$_SESSION['UserClasse'] = $data['classe'];
	$_SESSION['UserClasseCle'] = $data['cle_classe'];
	$_SESSION['UserMainMenu'] = 'eleve_menu.php';
    $_SESSION['UserEtablissement'] = 'ecole progress';
    $_SESSION['ident_sess_exoo']=md5(uniqid(rand()));
	
	if(array_search($data['section'],$esse)){
		$_SESSION["niveau"]="S";
	}else if(array_search($data['section'],$eu_esse)){
		$_SESSION["niveau"]="ES";
	}else{
		$_SESSION["niveau"]=-1;
	}
    require 'add_visiteur.php';
	session_write_close();
      header('Location: classe.php');
    }
    else
    {
        $db_hostname='localhost';
        $db_name="progressante1314";
        $db_user = "psante1314";
        $db_pass = "mZrWnSQsUAGDeDhhtYrEszqhUUy";


        $conn = mysql_connect($db_hostname, $db_user, $db_pass);
        if (!$conn) {
            echo 'Pb de connexion a la base';
        }

        if (!mysql_select_db($db_name, $conn)) {
            echo 'Pb de selection de la base';
        }

        //filtrage par section pour le simulateur
        $esse=array(21,20,18);
        $eu_esse=array(19,22,23);
        $strSQL = "SELECT etat.cle, etat.nom, etat.prenom,etat.email_el,etat.email_me,etat.email_pe, classe.nom AS classe,etat.section,classe.cle AS cle_classe FROM (etat INNER JOIN classe ON etat.classe = classe.cle) WHERE etat.id_pass = '".$_POST['id_eleve']."' AND etat.el_pass = '".$_POST['pwd_eleve']."'";
        $req_verif_select = mysql_query($strSQL, $conn);
        $data = mysql_fetch_array($req_verif_select);
        if ($data[0]) // Compte valide.
        {
            $_SESSION['UserCle'] = $data['cle'];
            $_SESSION['UserType'] = 'eleve';
            $_SESSION['UserPrenom'] = $data['prenom'];
            $_SESSION['UserNom'] = $data['nom'];
            $_SESSION['UserMail'] = $data['email_el'];
            $_SESSION['UserMail_me'] = $data['email_me'];
            $_SESSION['UserMail_pe'] = $data['email_pe'];
            $_SESSION['UserClasse'] = $data['classe'];
            $_SESSION['UserClasseCle'] = $data['cle_classe'];
            $_SESSION['UserMainMenu'] = 'eleve_menu.php';
            $_SESSION['UserEtablissement'] = 'progress sante';
            $_SESSION['ident_sess_exoo']=md5(uniqid(rand()));

            if(array_search($data['section'],$esse)){
                $_SESSION["niveau"]="S";
            }else if(array_search($data['section'],$eu_esse)){
                $_SESSION["niveau"]="ES";
            }else{
                $_SESSION["niveau"]=-1;
            }
            require 'add_visiteur.php';
            session_write_close();
            header('Location: classe.php');
        }
        else
        {
            $db_hostname="localhost";
            $db_name="prepa-progress1314";
            $db_user = "prepa1314";
            $db_pass = "u1141!Hk7aDosJt";

            $conn = mysql_connect($db_hostname, $db_user, $db_pass);
            if (!$conn) {
                echo 'Pb de connexion a la base';
            }

            if (!mysql_select_db($db_name, $conn)) {
                echo 'Pb de selection de la base';
            }

            //filtrage par section pour le simulateur
            $esse=array(21,20,18);
            $eu_esse=array(19,22,23);
            $strSQL = "SELECT etat.cle, etat.nom, etat.prenom,etat.email_el,etat.email_me,etat.email_pe, classe.nom AS classe,etat.section,classe.cle AS cle_classe FROM (etat INNER JOIN classe ON etat.classe = classe.cle) WHERE etat.id_pass = '".$_POST['id_eleve']."' AND etat.el_pass = '".$_POST['pwd_eleve']."'";
            $req_verif_select = mysql_query($strSQL, $conn);
            $data = mysql_fetch_array($req_verif_select);
            if ($data[0]) // Compte valide.
            {
                $_SESSION['UserCle'] = $data['cle'];
                $_SESSION['UserType'] = 'eleve';
                $_SESSION['UserPrenom'] = $data['prenom'];
                $_SESSION['UserNom'] = $data['nom'];
                $_SESSION['UserClasse'] = $data['classe'];
                $_SESSION['UserClasseCle'] = $data['cle_classe'];
                $_SESSION['UserMail'] = $data['email_el'];
                $_SESSION['UserMail_me'] = $data['email_me'];
                $_SESSION['UserMail_pe'] = $data['email_pe'];
                $_SESSION['UserMainMenu'] = 'eleve_menu.php';
                $_SESSION['UserEtablissement'] = 'prepa progress';
                $_SESSION['ident_sess_exoo']=md5(uniqid(rand()));

                if(array_search($data['section'],$esse)){
                    $_SESSION["niveau"]="S";
                }else if(array_search($data['section'],$eu_esse)){
                    $_SESSION["niveau"]="ES";
                }else{
                    $_SESSION["niveau"]=-1;
                }
                require 'add_visiteur.php';
                session_write_close();
                header('Location: classe.php');
            }

        }
    }
} 
//else {
?>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ecole progress - Loggin élève</title>
<meta name="description" content="" />
<meta name="keywords" content="" />
  <!--[if IE]>
<style type="text/css" medcia="all">.borderitem {border-style:solid;}</style>
<![endif]-->
<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<link rel="stylesheet" type="text/css" href="neo/css/styles.css" />
<style>
    .boutonbleu {
         background-color: #09f;
        display: block;
      text-align:center;
        height: 34px;
        margin-right: 0px;
        padding:0px 15px 0px 15px;
        text-decoration: none;
        font-family:Tahoma, Geneva, sans-serif;
        font-size:14px;
        font-weight:bold;
        color:#fff;
		border-radius: 9px; 
-moz-border-radius: 9px; 
-webkit-border-radius: 9px; 
border:0px;
cursor:pointer;
    }
	.boutonbleu:hover {
         background-color: #9c0;
    }
</style>
</head>
<body>
<!-- Begin Wrapper -->
<div id="wrapper">
  <!-- Begin Faux Columns -->
  <div id="main">
     <!-- Begin Left Column -->
     
    <div id="leftcolumn"><div id="header"><a href="index.php"><div id="logo"></div></a><div id="headertxt" style="text-align:center;">Bienvenue sur le site de Jean-Marc Fitoussi<br>
Entra&icirc;nement en math&eacute;matiques - Terminale S, ES et concours<br>
<span style="font-size:12px;">exoo.fr est un site de l'<a href="http://www.ecoleprogress.com" target="_blank">&eacute;cole Progress</a></span></div></div> 
   <form name="identif" action="./eleve.php" method="post">
<input type="hidden" name="GoVal" value="1">
<h1>Espace &Eacute;l&egrave;ve</h1>
<div id="inlay" style="display:table; margin:0 auto;">
<table width="287" border="0" align="center" cellpadding="0" cellspacing="2">
          <tr align="left" valign="top">
            <td colspan="2"><span class="titgras">Saisie de l&#39;identifiant et du mot de passe</span></td>
          </tr>
          <tr align="left" valign="top">
            <td class="txt">&nbsp;</td>
            <td align="right">&nbsp;</td>
          </tr>
          <tr align="left" valign="top"> 
            <td width="151" class="txt">Identifiant :</td>
            <td width="130" align="right"> <INPUT name="id_eleve" class="inputtrack" size=10></td>
          </tr>
          <tr align="left" valign="top"> 
            <td class="txt">Mot de passe :</td>
            <td align="right"> <input name="pwd_eleve" type=password class="inputtrack" size=10></td>
          </tr>
          <tr> 
            <td colspan="2"><img src="images/spacer.gif" width="10" height="6"></td>
          </tr>
          <tr> 
            <td colspan="2" align="right">
               <input name=test class="boutonbleu" type=submit class="butt" value=Soumettre> 
<!-- L&#39;espace est en cours de maintenance.<br>R&eacute;ouverture pr&eacute;vue vers 19h.
-->
</td> 
          </tr>
        </table>
    <input type=hidden value=eleve name=pers>

</form>
</div></div>
</div>
    <!-- End Left Column -->
    <!-- Begin Right Column -->
<div id="rightcolumn">

<div id="gruppo2"></div><br><br>

<div style="text-align:center; margin: 10px 0px 0px 13px;"><a title="&Eacute;valuez votre moyenne au Bac" href="http://www.ecoleprogress.com/espaces/simu_bac_open.php"
 class="iframe2 simul_bout"></a></div>
      <div class="clear"> </div>
    </div>
    <!-- End Right Column -->  <!-- End Faux Columns -->
<!-- End Wrapper -->
      <script type='text/javascript' src="simple/js/jquery.rs.slideshow.js"></script>
		<script type='text/javascript' src="simple/js/html-captions-bootstrap.js"></script>
</body>
</html>