86 lines
2.7 KiB
PHP
Executable File
86 lines
2.7 KiB
PHP
Executable File
<?php
|
|
$type=$_POST['type'];
|
|
$email_tel=$_POST['email_tel'];
|
|
$num_fft=$_POST['licence_fft'];
|
|
include("conf.php");
|
|
$db_connection=mysql_connect($db_host,$db_user,$password);
|
|
mysql_select_db($db_name,$db_connection);
|
|
/* controle du numero de licence */
|
|
$num_fft_ok=verifierLicence($num_fft);
|
|
$requete="SELECT id_joueur, nom, prenom, e_mail FROM joueur WHERE numero_fft LIKE '$num_fft'";
|
|
$result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
$IdUser=mysql_fetch_object($result);
|
|
$exist = mysql_numrows($result);
|
|
if($num_fft_ok==0)
|
|
{
|
|
echo"<center><B>Le numé de licence n'est pas valide.</b></center>";
|
|
include("connexion.php");
|
|
}
|
|
else if($exist==0) {
|
|
echo"<center><B>Mauvaise identification</b></center>";
|
|
include("connexion.php");
|
|
}
|
|
else
|
|
{
|
|
/* Si la personne a saisi son email */
|
|
if($type=="email") {
|
|
if($email_tel==$IdUser->e_mail) {
|
|
session_start();
|
|
$_SESSION['Id_joueur']=$IdUser->id_joueur;
|
|
$_SESSION['nom_joueur']=$IdUser->nom;
|
|
$_SESSION['prenom_joueur']=$IdUser->prenom;
|
|
include("accueil_joueur.php");
|
|
}
|
|
else {
|
|
echo"<center><B>Mauvaise identification</b></center>";
|
|
include("connexion.php");
|
|
}
|
|
}
|
|
/* si elle a saisi son numero de telephone */
|
|
else {
|
|
$requete="SELECT numero FROM telephone WHERE id_joueur='$IdUser->id_joueur'";
|
|
$result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
$tel=mysql_fetch_object($result);
|
|
/* si la chaine recue de la BDD content des espaces */
|
|
if(strlen($tel->numero)>10) {
|
|
list($un,$deux,$trois, $quatre, $cinq)=explode(" ",$tel->numero);
|
|
$telephone=$un.$deux.$trois.$quatre.$cinq;
|
|
}
|
|
else {
|
|
$telephone=$tel->numero;
|
|
}
|
|
if($email_tel==$telephone) {
|
|
session_start();
|
|
$_SESSION['Id_joueur']=$IdUser->id_joueur;
|
|
$_SESSION['nom_joueur']=$IdUser->nom;
|
|
$_SESSION['prenom_joueur']=$IdUser->prenom;
|
|
include("accueil_joueur.php");
|
|
}
|
|
else {
|
|
echo"<center><B>Mauvaise identification</b></center>";
|
|
include("connexion.php");
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
/* fonction de controle de format de la licence FFT */
|
|
function verifierLicence($numero_fft){
|
|
$numero=0;
|
|
$res=1;
|
|
// controle de la licence si le numero de licence est valide (1234567K par ex,)
|
|
if(is_numeric($numero_fft[0])) {
|
|
for($i=0;$i<7;$i++){$numero=$numero+($numero_fft[$i]* pow (10,(6-$i)));}
|
|
$cle=$numero_fft[7];
|
|
$tab_lettres=array("A","B","C","D","E","F","G","H","J","K","L","M","N","P","R","S","T","U","V","W","X","Y","Z");
|
|
$mod=($numero % 23);
|
|
if ($mod==0){$mod=23;}
|
|
if(strtoupper($cle)!=$tab_lettres[$mod-1]){
|
|
$res=0;
|
|
}
|
|
}
|
|
return $res;
|
|
}
|
|
|
|
?>
|