1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130
| <?php
session_start();
$msg = ' ' ;
$id = $_POST['Id'];
$verif_id = strtolower($id);
$mp = $_POST['mp'];
$verif_mp = strtolower($mp);
include 'fonctions.php';
// Si le site est fermé
if ($_SESSION['siteferme'] == "oui") {
if ($verif_id != "pandu" OR $mp !="papa"){
redirect('index.php?js=1');
exit ; }
}
var_dump($_SESSION) ;
$bdd = $_SESSION['BDD'];
$serveur = $_SESSION['serveur'];
$pass_bdd = $_SESSION['pass_bdd'];
$ut_bd = $_SESSION['ut_bd'];
$conn = mysqli_connect($serveur, $ut_bd, $pass_bdd, $bdd);
if (mysqli_connect_errno())
{
echo "La connexion au serveur MySQL n'a pas abouti : " . mysqli_connect_error();
}
$sql = "SELECT id_eleve,pass_eleve,Date_der_connect,id_prof,reg_inter,classe_eleve,directeur FROM eleves WHERE id_eleve ='$verif_id'" ;
$result = mysqli_query($conn,$sql)or die('Erreur SQL !<br>'.$sql.'<br>'.mysqli_error());
$data = mysqli_fetch_assoc($result); $n = mysqli_num_rows($result);
$_SESSION['id_prof']=$data['id_prof'];
$idprof = " ";
$idprof= $data['id_prof'];
$reg= $data['reg_inter'];
$_SESSION['directeur']=$data['directeur'];
$_SESSION['classe_eleve']=$data['classe_eleve'];
if(empty($n))
{$msg ='Identifiant inconnu';}
elseif ($verif_mp != $data['pass_eleve'])
{$msg ='Mot de passe incorrect';}
// Controles IP
if( $msg == ' ') {
$dotted = get_ip();
$ip = IPAddress2IPNumber($dotted); $_SESSION['ip']= $ip;
$sql = "SELECT * FROM connect_ip WHERE id_eleve ='$verif_id' AND adresse_ip=$ip" ;
$result = mysqli_query($conn,$sql)or die('Erreur SQL !<br>'.$sql.'<br>'.mysqli_error());
$data = mysqli_fetch_assoc($result); $n = mysqli_num_rows($result);
if($n==0){ // Nouvelle IP
$sql = "INSERT INTO connect_ip (id_eleve ,adresse_ip)
VALUES ( '$verif_id', $ip)" ;
$result = mysqli_query($conn,$sql)or die('Erreur SQL !<br>'.$sql.'<br>'.mysqli_error());
// Regarde s'il faut éjecter le profil à partir de la nouvelle ip
// A faire
} else { $fin=$data['Jours_exclusion'];
if (time()<$fin)$msg=htmlentities('Connexion non autorisée.');
}
}
// MAJ DER CONNECT
$date = date("ymd");
$sql = "SELECT * FROM eleves WHERE id_eleve ='$verif_id'" ;
$result = mysqli_query($conn,$sql)or die('Erreur SQL !<br>'.$sql.'<br>'.mysqli_error());
$dat = mysqli_fetch_assoc($result);
$sql="UPDATE eleves SET Date_der_connect = $date WHERE id_eleve ='$verif_id'";
$result = mysqli_query($conn,$sql)or die('Erreur SQL !<br>'.$sql.'<br>'.mysqli_error());
mysqli_close();
$_SESSION['message'] = ' ';
if( $msg != ' ') {
$_SESSION['message'] = $msg;
redirect('index.php?js=1');
}
else {
visites(1);
$_SESSION['id_eleve'] =$verif_id;
$_SESSION['id_prof']=$idprof;
$_SESSION['m_p']=$verif_mp;
if($idprof != '')
{
$s = $idprof ;
}
else
{
$s = $verif_id ;
}
$c = $s[0];
$c = strtoupper($c) ;
$s[0]=$c ;
$msg= 'Bonjour '.$s.' !' ;
// Message de bienvenue
$_SESSION['mesage'] = $msg;
// Ecriture dans le log général
include 'datetableau.php';
$repertoire = dirname(__FILE__)."/Devoirs/";
$s2 = "log.txt";
if(empty($idprof))
$s="Le ".$data." connexion de ".$verif_id."\n";
else
$s="Le ".$data." connexion de ".$verif_id." alias ".$idprof."\n";
$bavard = $repertoire.$s2 ;
$fp = fopen($bavard, "a+");
fwrite($fp,$s);
fclose($fp);
// Redirection
if($reg==0)
redirect('modregint.php');
else
redirect('devoirseleve.php');
exit;
}
?> |
Partager