| Club | Debut du tournoi | Fin du tournoi | Type | Interne au club | Contact | e mail | ";
for ($i=0;$i".$[''][$i]." | | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." |
";
}
echo "
";
}
function afficher_tableau_tournoi_admin($id_ja){
include("conf.php");
include("mysql_compat.php");
include("conf.php");
$saison = date("Y") ;
if(date("m") >= 10 and date("m") <=12) {
$saison+=1;
}
$db_connection=mysql_connect($db_host,$db_user,$password);
mysql_select_db($db_name,$db_connection);
if($id_ja>-1)
$requete="SELECT c.nom as nom_club,c.e_mail, c.id_club, c.telephone ,t.debut,t.fin,t.date_cloture,t.id_tournoi,t.saison,t.nom, t.interne FROM club c,tournoi t, juge_arbitre ja WHERE t.id_jugearbitre='$id_ja' AND t.id_club=c.id_club AND t.saison='$saison' GROUP BY t.debut , c.nom;";
else
$requete="SELECT c.nom as nom_club,c.e_mail, c.id_club, c.telephone ,t.debut,t.fin,t.id_tournoi,t.saison,t.nom FROM club c,tournoi t, juge_arbitre ja WHERE t.id_club=club.id_club AND t.saison='$saison' GROUP BY t.debut , club.nom;";
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
while($reptab=mysql_fetch_array($reponse)){
$debut=explode("-",$['']);
$fin=explode("-",$['']);
$cloture=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()."
");
while($reptab2=mysql_fetch_object($reponse2)){
if($reptab2->type=="double")
$type_double=$type_double+1;
else if($reptab2->type!="double" and $reptab2->age_min<18 and $reptab2->age_max!=0)
$type_enfant=$type_enfant+1;
else if($reptab2->type!="double" and $reptab2->age_max==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 "
| Club | Debut du tournoi | Fin du tournoi | Type | Interne au club | Contact | e mail | ";
for ($i=0;$i".$[''][$i]." | | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." |
";
}
echo "
";
}
function afficher_tableau_tournoi(){
$id_joueur=$_GET['id_joueur'];
$saison = date("Y") ;
if(date("m") >= 10 and date("m") <=12) {
$saison+=1;
}
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 id_tournoi FROM tournoi WHERE fin > CURDATE()";
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
$nb=mysql_num_rows($reponse);
if($nb>0) {
$requete="SELECT club.nom as nom_club,club.e_mail, club.id_club, club.telephone ,tournoi.debut,tournoi.fin,tournoi.date_cloture,tournoi.id_tournoi,tournoi.saison,tournoi.nom, tournoi.interne FROM club,tournoi WHERE tournoi.id_club=club.id_club AND tournoi.saison=$saison GROUP BY tournoi.debut , club.nom;";
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
while($reptab=mysql_fetch_array($reponse)){
$debut=explode("-",$['']);
$fin=explode("-",$['']);
$cloture=explode("-",$['']);
$contact=$[''];
$intitule=$[''];
$type="";
$type_adulte=0;
$type_enfant=0;
$type_double=0;
if (mktime(20,0,0,$fin[1],$fin[2],$fin[0])-time()>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()."
");
while($reptab2=mysql_fetch_object($reponse2)){
if($reptab2->type=="double")
$type_double=$type_double+1;
else if($reptab2->type=="simple" and $reptab2->age_min<18 and $reptab2->age_max!=0)
$type_enfant=$type_enfant+1;
else if($reptab2->type=="simple" and $reptab2->age_max==0)
$type_adulte=$type_adulte+1;
}
/* affectation des categories */
if($type_adulte>0)
$type.="adulte ";
if($type_enfant>0)
$type.="jeune ";
if($type_double>0)
$type.="double";
/* remplissage des champs */
$debut=explode("-",$['']);
$fin=explode("-",$['']);
$[''][]=$[''];
$[''][]=$[''];
$[''][]=$debut[2]."/".$debut[1]."/".$debut[0];
$[''][]=$fin[2]."/".$fin[1]."/".$fin[0];
$[''][]=$type;
$[''][]=$contact;
$[''][]=$intitule;
$[''][]=$[''];
$[''][]=$[''];
}
}
mysql_close($db_connection);
echo "
| Club | Debut du tournoi | Fin du tournoi | Type | Interne au club | Contact | e mail | ";
for ($i=0;$i".$[''][$i]." | | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." |
";
}
echo "
";
}
else {
echo "
Il n'y a pas de tournois disponibles à l'inscription ou tous les tournois de l'année sont terminés.";
}
}
?>