|
- |
";
echo ""; echo ADMIN_TAPVERT_MSG2; echo ""; echo ""; $value=GENERAL; echo ""; $button=ENVOI; echo " "; } else { // MENU TYPES DE CLASSEMENT echo ""; echo ""; echo ""; $query="SELECT divisions.nom, saisons.annee, (saisons.annee)+1 FROM championnats, divisions, saisons WHERE championnats.id='$champ' AND divisions.id=championnats.id_division AND saisons.id=championnats.id_saison"; $result = mysql_query($query); while ($row=mysql_fetch_array($result)) { echo "".$row[0]." ".$row[1]."/".$row[2].""; } //SELECTION DES EQUIPES $query="SELECT clubs.nom from clubs, equipes, championnats WHERE equipes.id_champ=championnats.id AND championnats.id='$champ' AND equipes.id_club=clubs.id"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { $equipe[]=$row[0]; } } $class=0; $lien="oui"; switch($type) { case GENERAL; // CLASSEMENT GENERAL { // RAPPEL DES PARAMETRES du CHAMPIONNAT $result=mysql_query("select * from parametres where id_champ='$champ'"); while ($row=mysql_fetch_array($result)) { $accession = $row[accession]; $barrage = $row[barrage] + $accession; $relegation = nb_equipes($champ)- $row[relegation]; } $legende=CONSULT_CLMNT_MSG4.$debut.CONSULT_CLMNT_MSG5.$fin; $requete="SELECT * from clmnt ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM"; //db_clmnt($legende, GENERAL, $accession, $barrage, $relegation, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite); db_clmnt($legende, GENERAL, $accession, $barrage, $relegation, $champ, $debut, $fin); //clmnt($legende, $type, $accession, $barrage, $relegation, $equipe_fetiche, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite, $requete); clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete, $lien, $class, $chemin); $query="SELECT max(journees.numero) from journees, matchs where journees.id=matchs.id_journee and buts_dom is not NULL and journees.id_champ='$champ'"; $result=mysql_query($query); while ($row=mysql_fetch_row($result)) { $numero=$row[0]; } ?> =46) {echo " ".CONSULT_CLMNT_MSG7.""; aff_journee($champ, $numero, "".CONSULT_CLMNT_MSG8, 1, $fiches_clubs); } else { echo ""; aff_journee($champ, $numero, "".CONSULT_CLMNT_MSG9, 0, $fiches_clubs); } } } break; case DOMICILE; { $legende=CONSULT_CLMNT_MSG10.$debut.CONSULT_CLMNT_MSG5.$fin; $requete="SELECT NOM, DOMPOINTS, DOMJOUES, DOMG, DOMN, DOMP, DOMBUTSPOUR, DOMBUTSCONTRE, DOMDIFF from clmnt ORDER BY DOMPOINTS DESC, DOMDIFF DESC"; db_clmnt($legende, DOMICILE, $accession, $barrage, $relegation, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite); } clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete,$lien, $class, $chemin); break; case ATTAQUE; { $legende=CONSULT_CLMNT_MSG11.$debut.CONSULT_CLMNT_MSG5.$fin; $requete="SELECT * from clmnt ORDER BY BUTSPOUR DESC, DIFF DESC"; db_clmnt($legende, ATTAQUE, $accession, $barrage, $relegation, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite); clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete, $lien,$class, $chemin); } break; case DEFENSE; { $legende=CONSULT_CLMNT_MSG12.$debut.CONSULT_CLMNT_MSG5.$fin; $requete="SELECT * from clmnt ORDER BY BUTSCONTRE ASC, DIFF DESC"; db_clmnt($legende, DEFENSE, $accession, $barrage, $relegation, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite); clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete,$lien, $class, $chemin); } break; case GOALDIFF; { $legende=CONSULT_CLMNT_MSG13.$debut.CONSULT_CLMNT_MSG5.$fin; $requete="SELECT * from clmnt ORDER BY DIFF DESC, BUTSPOUR DESC, BUTSCONTRE ASC "; db_clmnt($legende, GOALDIFF, $accession, $barrage, $relegation, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite); clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete,$lien, $class, $chemin); } break; case EXTERIEUR; { $legende=CONSULT_CLMNT_MSG14.$debut.CONSULT_CLMNT_MSG5.$fin; $requete="SELECT NOM, EXTPOINTS, EXTJOUES, EXTG, EXTN, EXTP, EXTBUTSPOUR, EXTBUTSCONTRE, EXTDIFF from clmnt ORDER BY EXTPOINTS DESC, EXTDIFF DESC "; db_clmnt($legende, EXTERIEUR, $accession, $barrage, $relegation, $champ, $debut, $fin, $pts_victoire, $pts_nul, $pts_defaite); clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete, $lien, $class, $chemin); } break; @mysql_query("UNLOCK TABLE clmnt"); } include ("apres.php"); ?> |
|
