33 lines
1.3 KiB
PHP
Executable File
33 lines
1.3 KiB
PHP
Executable File
<?php
|
|
header('Content-Type: text/html; charset=ISO-8859-1');
|
|
$id_club=$_POST['club'];
|
|
$num_fft=$_POST['num_fft'];
|
|
|
|
include("conf.php");
|
|
|
|
$requete="SELECT id_joueur FROM joueur WHERE numero_fft='$num_fft'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
$existe=mysqli_num_rows($reponse);
|
|
if($existe>0) {
|
|
$joueur=mysqli_fetch_object($reponse);
|
|
/* Controle si le joueur est bien licencié dans le club */
|
|
$requete="SELECT statut FROM compte WHERE id_joueur='$joueur->id_joueur' AND id_club='$id_club'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
$compte=mysqli_fetch_object($reponse);
|
|
if(strcmp(utf8_encode($compte->statut),"MembreLicencié")==0) {
|
|
/* on change les privilieges de l'administrateur */
|
|
$requete="UPDATE compte SET droit='Administrateur' WHERE id_joueur='$joueur->id_joueur' AND id_club='$id_club'";
|
|
$reponse=mysqli_query($db_connection, $requete) or die ("Erreur no".mysqli_errno($db_connection)()." : ".mysqli_error($db_connection)()."<br>");
|
|
if($reponse!=FALSE) {
|
|
include("menu_admin.php");
|
|
}
|
|
}
|
|
else {
|
|
include("AjoutTyrol.php");
|
|
}
|
|
}
|
|
else {
|
|
include("AjoutTyrol.php");
|
|
}
|
|
?>
|