89 lines
3.3 KiB
PHP
Executable File
89 lines
3.3 KiB
PHP
Executable File
<?php
|
|
/* include("admin_connecte.php"); */
|
|
session_start();
|
|
/* test si la session est lancée */
|
|
if((isset($_SESSION['Admin'])==true) && ($_SESSION['Admin']==1))
|
|
{
|
|
$titre="Administration des tournois";
|
|
include("enTete.php");
|
|
echo"<center><B>$info</B></center>";
|
|
?>
|
|
<body background="images/balle_raquette3.jpg">
|
|
<br>
|
|
<br>
|
|
<br>
|
|
<center><B>Veuillez choisir le tournoi à administrer</B></center>
|
|
<CENTER>
|
|
<?php
|
|
afficher_tableau_tournoi_admin();
|
|
echo "<br /><br />";
|
|
include("deco_admin.php");
|
|
include("piedDePage.php");
|
|
/* sinon si la personne n'est pas autorisé la renvoyer àla page de login */
|
|
}
|
|
else
|
|
{
|
|
echo("Non autorisé - Redirection vers la page d'identification dans 2 secondes");
|
|
sleep(2);
|
|
include("identification_admin.php");
|
|
}
|
|
|
|
function afficher_tableau_tournoi_admin(){
|
|
$id_joueur=$_GET['id_joueur'];
|
|
$annee_en_cours = date("Y") ;
|
|
include("conf.php");
|
|
include("mysql_compat.php");
|
|
include("conf.php");
|
|
|
|
$db_connection=mysql_connect($db_host,$db_user,$password);
|
|
mysql_select_db($db_name,$db_connection);
|
|
$requete="SELECT club.nom as nom_club,club.e_mail, club.id_club, club.telephone ,tournoi.debut,tournoi.fin,tournoi.id_tournoi,tournoi.saison,tournoi.nom FROM club,tournoi, juge_arbitre WHERE tournoi.id_club=club.id_club AND tournoi.saison=$annee_en_cours GROUP BY tournoi.debut , club.nom;";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br />");
|
|
while($reptab=mysql_fetch_array($reponse)){
|
|
$debut=explode("-",$['']);
|
|
$fin=explode("-",$['']);
|
|
$contact=$[''];
|
|
$intitule=$[''];
|
|
$type="";
|
|
$type_adulte=0;
|
|
$type_enfant=0;
|
|
$type_double=0;
|
|
$requete2="SELECT categorie.type, categorie.age_min, categorie.age_max FROM categorie, categories_par_tournoi WHERE categories_par_tournoi.id_tournoi=$[''] AND categories_par_tournoi.id_categorie=categorie.id_categorie";
|
|
$reponse2=mysql_query($requete2,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br />");
|
|
while($reptab2=mysql_fetch_array($reponse2)){
|
|
if($['']=="double")
|
|
$type_double=$type_double+1;
|
|
else if($['']!="double" && $['']==0)
|
|
$type_enfant=$type_enfant+1;
|
|
else if($['']!="double" && $['']==0)
|
|
$type_adulte=$type_adulte+1;
|
|
}
|
|
/* affectation des categories */
|
|
if($type_adulte>0)
|
|
$type=$type."adulte ";
|
|
if($type_enfant>0)
|
|
$type=$type."jeune ";
|
|
if($type_double>0)
|
|
$type=$type."double";
|
|
$debut=explode("-",$['']);
|
|
$fin=explode("-",$['']);
|
|
$[''][]=$[''];
|
|
$[''][]=$[''];
|
|
$[''][]=$debut[2]."/".$debut[1]."/".$debut[0];
|
|
$[''][]=$fin[2]."/".$fin[1]."/".$fin[0];
|
|
$[''][]=$type;
|
|
$[''][]=$contact;
|
|
$[''][]=$intitule;
|
|
$[''][]=$[''];
|
|
}
|
|
mysql_close($db_connection);
|
|
echo "<div id=\"tableauTournoi\"><center><table><th>Club</th><th>Debut du tournoi</th><th>Fin du tournoi</th><th>Type</th><th>Contact</th><th>e mail</th>";
|
|
for ($i=0;$i<count($['']);$i++)
|
|
{
|
|
$mail=$[''][$i];
|
|
echo "<tr bgcolor='#FFDEAD'><td colspan='6'>".$[''][$i]."</td></tr><tr bgcolor='#FFF5EE'><td><a href='menu_choix_administration_tournoi.php?id_joueur=$id_joueur&id_tournoi=".$[''][$i]."'>".$[''][$i]."</td><td ><font size=1 >".$[''][$i]."</td><td align=center><font size=1 >".$[''][$i]."</td><td align=center><font size=1 >".$[''][$i]."</td><td align=center><font size=1 >".$[''][$i]."</td><td><a href='mailto:$mail'><font size=1 >".$[''][$i]."</a></td></tr><tr>";
|
|
}
|
|
echo "</table></center></div>";
|
|
}
|
|
?>
|