|
- |
";
require ("../league.css"); ?>
JURA SUD FOOT
";
}
// nombres de journees d un championnat
function nb_journees($id_champ)
{
$query="SELECT id FROM equipes WHERE id_champ='$id_champ'";
$result=mysql_query($query);
$nb_equipes=mysql_num_rows( $result );
$nb_journees=((($nb_equipes)*2)-2) ;
return("$nb_journees");
}
// Nombres d equipes dans un championnat
function nb_equipes($id_champ)
{
$query="SELECT id FROM equipes WHERE id_champ='$id_champ'";
$result=mysql_query($query);
$nb_equipes=mysql_num_rows( $result );
return("$nb_equipes");
}
function aff_journee($champ, $numero, $legende, $proba, $fiches_clubs)
{
// SELECTION DES PARAMETRES
$result=(mysql_query("select * from parametres where id_champ='$champ' "));
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
//@mysql_free_result($result);
// NOM de EQUIPE FAVORITE a partir de son id
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
//@mysql_free_result($result);
// cellule d'affichage des derniers résultats
$color=0;
$query1="SELECT cldom.nom as cldom, clext.nom as clext, matchs.buts_dom, matchs.buts_ext , journees.date_prevue, cldom.id as cliddom, clext.id as clidext
FROM equipes as dom, equipes as ext, matchs, journees, clubs as cldom, clubs as clext
WHERE matchs.id_equipe_dom=dom.id
AND matchs.id_equipe_ext=ext.id
AND journees.id_champ='$champ'
AND journees.numero='$numero'
AND dom.id_club=cldom.id
AND ext.id_club=clext.id
AND matchs.id_journee=journees.id ";
$result=mysql_query($query1);
echo "";
$x=1;
while ($row=mysql_fetch_array($result))
{
$domproba= $row[2];
$extproba= $row[3];
if ($row[buts_dom]=='' and $row[buts_ext]=='' and $proba==1 and $numero>=4)
{
$query2="SELECT * from clmnt WHERE NOM='$row[cldom]'";
$result2=mysql_query($query2);
while ($row2=mysql_fetch_array($result2))
{
$dom_buts=($row2[DOMBUTSPOUR]);
$dom_joues=($row2[DOMG]+$row2[DOMN]+$row2[DOMP]);
$ext_buts=($row2[DOMBUTSCONTRE]);
$ext_joues=($row2[DOMG]+$row2[DOMN]+$row2[DOMP]);
}
$query2="SELECT * from clmnt WHERE NOM='$row[clext]'";
$result2=mysql_query($query2);
while ($row2=mysql_fetch_array($result2))
{
$dom_joues+=($row2[EXTG]+$row2[EXTN]+$row2[EXTP]);
$ext_joues+=$row2[EXTG]+$row2[EXTN]+$row2[EXTP];
$dom_buts+=($row2[EXTBUTSCONTRE]);
$ext_buts+=($row2[EXTBUTSPOUR]);
$dom_buts=intval((($dom_buts)/$dom_joues));
$ext_buts=intval((($ext_buts)/$ext_joues));
}
$domproba="".$dom_buts."";
$extproba="".$ext_buts."";
}
if ($x==1)
{
$date = ereg_replace('^([0-9]{2,4})-([0-9]{1,2})-([0-9]{1,2})$','\\3/\\2/\\1', $row[4]);
echo "".$legende." ". $numero."
".CONSULT_MATCHS_MSG2."".$date." |
|---|
";
}
if ($row[0]==$equipe_fetiche )
{
$DebMarqueur1 = "";
$FinMarqueur1 = "";
}
else
{
$DebMarqueur1 = "";
$FinMarqueur1 = "";
}
if ($row[1]==$equipe_fetiche )
{
$DebMarqueur2 = "";
$FinMarqueur2 = "";
}
else
{
$DebMarqueur2 = "";
$FinMarqueur2 = "";
}
$bgcolor="#FFFFFF";
if (($color%2)==0) $bgcolor="#E5E5E5";
if ($fiches_clubs=="1")
{
echo "| ".$DebMarqueur1.$row[0].$FinMarqueur1." | ".$domproba." | - | ".$extproba." | ".$DebMarqueur2.$row[1].$FinMarqueur2."";
}
elseif (!$fiches_clubs=="1")
{
echo " | | ".$DebMarqueur1.$row[0].$FinMarqueur1." | ".$domproba." | - | ".$extproba." | ".$DebMarqueur2.$row[1].$FinMarqueur2."";
}
$x++;
$color+=1;
}
//@mysql_free_result($result);
echo " | ";
}
// *** REMPLI LA TABLE CLMNT
function db_clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $debut, $fin)
{
@mysql_query("DELETE FROM clmnt");
if (!$fin){$fin=(nb_equipes($champ)*2)-2;}
if (!$debut){$debut=1;}
// SELECTION DES PARAMETRES
$query="select * from parametres where id_champ='$champ'";
$result=(mysql_query($query) ) ;
while ($row=mysql_fetch_array($result) )
{
$pts_victoire=$row[pts_victoire];
$pts_nul=$row[pts_nul];
$pts_defaite=$row[pts_defaite];
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
// NOM de EQUIPE FAVORITE a partir de son id
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
@mysql_free_result($result);
// victoires domicile
$query="SELECT dom.id, count(dom.id), clubs.nom, sum(buts_dom), sum(buts_ext) FROM equipes as dom, clubs, matchs, journees, championnats
WHERE dom.id_champ='$champ'
AND dom.id_club=clubs.id
AND dom.id=matchs.id_equipe_dom
AND buts_dom > buts_ext
AND championnats.id=journees.id_champ
AND journees.id=matchs.id_journee
AND journees.numero>='$debut'
AND journees.numero<='$fin'
GROUP by clubs.nom ";
$dom = mysql_query($query);
while($row= mysql_fetch_array($dom))
{
$clmnt[$row[2]][GDOM]=$row[1];
$clmnt[$row[2]][BUTSDOMPOUR]=$row[3];
$clmnt[$row[2]][BUTSDOMCONTRE]=$row[4];
}
@mysql_free_result($dom);
// Defaites domicile
$query="SELECT dom.id, count(dom.id), clubs.nom, sum(buts_dom), sum(buts_ext) FROM equipes as dom, clubs, matchs, journees, championnats
WHERE dom.id_champ='$champ'
AND dom.id_club=clubs.id
AND dom.id=matchs.id_equipe_dom
AND buts_dom < buts_ext
AND championnats.id=journees.id_champ
AND journees.id=matchs.id_journee
AND journees.numero>='$debut'
AND journees.numero<='$fin'
GROUP by clubs.nom ";
$dom = mysql_query($query);
while($row= mysql_fetch_array($dom))
{
$clmnt[$row[2]][PDOM]=$row[1];
$clmnt[$row[2]][BUTSDOMPOUR]+=$row[3];
$clmnt[$row[2]][BUTSDOMCONTRE]+=$row[4];
}
@mysql_free_result($dom);
// Nuls domicile
$query="SELECT dom.id, count(dom.id), clubs.nom, sum(buts_dom), sum(buts_ext) FROM equipes as dom, clubs, matchs, journees, championnats
WHERE dom.id_champ='$champ'
AND dom.id_club=clubs.id
AND dom.id=matchs.id_equipe_dom
AND buts_dom = buts_ext
AND buts_dom is not null
AND buts_ext is not null
AND championnats.id=journees.id_champ
AND journees.id=matchs.id_journee
AND journees.numero>='$debut'
AND journees.numero<='$fin'
GROUP by clubs.nom ";
$dom = mysql_query($query);
while($row= mysql_fetch_array($dom))
{
$clmnt[$row[2]][NDOM]=$row[1];
$clmnt[$row[2]][BUTSDOMPOUR]+=$row[3];
$clmnt[$row[2]][BUTSDOMCONTRE]+=$row[4];
}
@mysql_free_result($dom);
// Resultats à domicile
$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);
// RESULTATS EXTERIEURS :
// victoires exterieur
$query="SELECT ext.id, count(ext.id), clubs.nom, sum(buts_ext), sum(buts_dom) FROM equipes as ext, clubs, matchs, journees, championnats
WHERE ext.id_champ='$champ'
AND ext.id_club=clubs.id
AND ext.id=matchs.id_equipe_ext
AND buts_ext > buts_dom
AND championnats.id=journees.id_champ
AND journees.id=matchs.id_journee
AND journees.numero>='$debut'
AND journees.numero<='$fin'
GROUP by clubs.nom ";
$dom = mysql_query($query);
while($row= mysql_fetch_array($dom))
{
$clmnt[$row[2]][GEXT]=$row[1];
$clmnt[$row[2]][BUTSEXTPOUR]=$row[3];
$clmnt[$row[2]][BUTSEXTCONTRE]=$row[4];
}
@mysql_free_result($dom);
// Defaites exterieur
$query="SELECT ext.id, count(ext.id), clubs.nom, sum(buts_ext), sum(buts_dom) FROM equipes as ext, clubs, matchs, journees, championnats
WHERE ext.id_champ='$champ'
AND ext.id_club=clubs.id
AND ext.id=matchs.id_equipe_ext
AND buts_ext < buts_dom
AND championnats.id=journees.id_champ
AND journees.id=matchs.id_journee
AND journees.numero>='$debut'
AND journees.numero<='$fin'
GROUP by clubs.nom ";
$dom=mysql_query($query);
While($row= mysql_fetch_array($dom))
{
$clmnt[$row[2]][PEXT]=$row[1];
$clmnt[$row[2]][BUTSEXTPOUR]+=$row[3];
$clmnt[$row[2]][BUTSEXTCONTRE]+=$row[4];
}
@mysql_free_result($dom);
// Nuls exterieur
$query="SELECT ext.id, count(ext.id), clubs.nom, sum(buts_ext), sum(buts_dom) FROM equipes as ext, clubs, matchs, journees, championnats
WHERE ext.id_champ='$champ'
AND ext.id_club=clubs.id
AND ext.id=matchs.id_equipe_ext
AND buts_ext = buts_dom
AND buts_dom is not null
AND buts_ext is not null
AND championnats.id=journees.id_champ
AND journees.id=matchs.id_journee
AND journees.numero>='$debut'
AND journees.numero<='$fin'
GROUP by clubs.nom ";
$dom=mysql_query($query);
while($row= mysql_fetch_array($dom))
{
$clmnt[$row[2]][NEXT]=$row[1];
$clmnt[$row[2]][BUTSEXTPOUR]+=$row[3];
$clmnt[$row[2]][BUTSEXTCONTRE]+=$row[4];
}
@mysql_free_result($dom);
// TABLEAU DE CLASSEMENT
$query="SELECT clubs.nom, tapis_vert.pts from clubs, equipes, championnats, tapis_vert
WHERE equipes.id_champ=championnats.id
AND championnats.id='$champ'
AND equipes.id_club=clubs.id
AND equipes.id=tapis_vert.id_equipe";
$result=mysql_query($query);
if (mysql_num_rows($result)==0)
{
@mysql_free_result($result);
$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);
}
mysql_query("LOCK TABLE clmnt");
while($row=mysql_fetch_array($result))
{
$x=$row[0];
$NOM=$row[0];
$DOMJOUES=$clmnt[$x][GDOM]+$clmnt[$x][NDOM] + $clmnt[$x][PDOM];
$EXTJOUES=$clmnt[$x][GEXT]+$clmnt[$x][NEXT] + $clmnt[$x][PEXT];
$JOUES=$EXTJOUES + $DOMJOUES;
$DOMPOINTS=(($clmnt[$x][GDOM])*$pts_victoire) + (($clmnt[$x][NDOM])*$pts_nul) + (($clmnt[$x][PDOM])*$pts_defaite);
$EXTPOINTS=(($clmnt[$x][GEXT])*$pts_victoire) + (($clmnt[$x][NEXT])*$pts_nul) + (($clmnt[$x][PEXT])*$pts_defaite);
$POINTS= $DOMPOINTS+ $EXTPOINTS + $row[1];
$G=($clmnt[$x][GEXT])+($clmnt[$x][GDOM]);
$N=($clmnt[$x][NEXT])+($clmnt[$x][NDOM]);
$P=$clmnt[$x][PEXT] + $clmnt[$x][PDOM];
$DOMG=($clmnt[$x][GDOM]);
$DOMN=($clmnt[$x][NDOM]);
$DOMP=$clmnt[$x][PDOM];
$EXTG=($clmnt[$x][GEXT]);
$EXTN=($clmnt[$x][NEXT]);
$EXTP=$clmnt[$x][PEXT];
$BUTSPOUR=$clmnt[$x][BUTSEXTPOUR] + $clmnt[$x][BUTSDOMPOUR];
$DOMBUTSPOUR=$clmnt[$x][BUTSDOMPOUR];
$EXTBUTSPOUR=$clmnt[$x][BUTSEXTPOUR];
$BUTSCONTRE=$clmnt[$x][BUTSEXTCONTRE] + $clmnt[$x][BUTSDOMCONTRE];
$DOMBUTSCONTRE= $clmnt[$x][BUTSDOMCONTRE];
$EXTBUTSCONTRE=$clmnt[$x][BUTSEXTCONTRE] ;
$DIFF=$BUTSPOUR - $BUTSCONTRE;
$DOMDIFF=$DOMBUTSPOUR-$DOMBUTSCONTRE;
$EXTDIFF=$EXTBUTSPOUR - $EXTBUTSCONTRE;
$PEN= $row[1];
$query1="SELECT equipes.id FROM equipes, clubs WHERE clubs.id=equipes.id_club
and clubs.nom='$NOM'
and equipes.id_champ='$champ'";
$result1=mysql_query($query1) or die (mysql_error());
while($row1=mysql_fetch_array($result1)){$id_equipe=$row1[0];}
$question="INSERT INTO clmnt
SET NOM='$NOM',
ID_EQUIPE='$id_equipe',
POINTS='$POINTS',
DOMPOINTS='$DOMPOINTS',
EXTPOINTS='$EXTPOINTS',
JOUES= '$JOUES',
DOMJOUES= '$DOMJOUES',
EXTJOUES= '$EXTJOUES',
G='$G',
DOMG='$DOMG',
EXTG='$EXTG',
N='$N',
DOMN='$DOMN',
EXTN='$EXTN',
P='$P',
DOMP='$DOMP',
EXTP='$EXTP',
BUTSPOUR='$BUTSPOUR',
DOMBUTSPOUR='$DOMBUTSPOUR',
EXTBUTSPOUR='$EXTBUTSPOUR',
BUTSCONTRE='$BUTSCONTRE',
DOMBUTSCONTRE='$DOMBUTSCONTRE',
EXTBUTSCONTRE='$EXTBUTSCONTRE',
DIFF='$DIFF',
DOMDIFF='$DOMDIFF',
EXTDIFF='$EXTDIFF',
PEN='$PEN'";
$result2=mysql_query($question) or die(mysql_error());
}
@mysql_free_result($result);
}
function clmnt($legende, $type, $accession, $barrage, $relegation, $champ, $requete, $lien)
{
// NOM de EQUIPE FAVORITE a partir de son id
$query="select * from parametres where id_champ='$champ'";
$result=mysql_query($query);
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
@mysql_free_result($result);
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
@mysql_free_result($result);
echo "| ".$legende;
echo " |
|---|
| ".CLMNT_POSITION."
| ".CLMNT_EQUIPE."
| ".CLMNT_POINTS."";
echo "".CLMNT_JOUES."
".CLMNT_VICTOIRES."
".CLMNT_NULS."
".CLMNT_DEFAITES."
".CLMNT_BUTSPOUR."
".CLMNT_BUTSCONTRE."
".CLMNT_DIFF."
";
$result=mysql_query($requete) or die (mysql_error());
$pl=1;
while ($row=mysql_fetch_array($result))
{
if ($row[NOM]==EXEMPT){continue;}
if ($pl<=$accession and $type==GENERAL){echo "";}
elseif ($pl<=$barrage and $type==GENERAL){echo " ";}
elseif ($pl>$relegation and $type==GENERAL){echo " ";}
elseif (($pl%2)==0){echo " ";}
else{echo " ";}
echo "| ";
print $pl;
$pl++;
$x=0;
while($x<9)
{
echo " | ";
if ($x==0){echo " ";}
if ($row[$x]==$equipe_fetiche){echo "";}
if ($x==0)
{
$query2="SELECT equipes.id, clubs.nom FROM equipes, clubs
WHERE clubs.nom='$row[0]'
AND equipes.id_champ='$champ'
AND clubs.id=equipes.id_club";
$result2=mysql_query($query2);
while($id_equipe=mysql_fetch_array($result2))
{
$id=$id_equipe[id];
}
@mysql_free_result($result2);
if ($lien=='non'){echo "$row[$x]";}
else {echo "$row[$x]";}
}
else print $row[$x];
$x++;
echo "";
}
echo " | ";
if ($type==GENERAL){echo "![](\"graph.gif\") ";}
echo " | ";
}
@mysql_free_result($result);
echo " | | | | | | | | |
";
}
function Buteur($legende, $requete, $type, $EquipeFetiche )
{
echo "".$legende."
";
echo " |
|---|
| ".CLMNT_POSITION." | ".JOUEUR." | ".TEAM." | ".ADMIN_JOUEURS_2;
$query=$requete;
$result=mysql_query($query) or die (mysql_error());
$pl=1;
while ($row=mysql_fetch_array($result))
{
echo " |
|---|
";
echo "| " . $pl;
$pl++;
$Test="NON";
$array = explode(",",$EquipeFetiche);
if (sizeof($array)==1)
{
if ($row[idClub]==$array[0]){$Test="OUI";}
}
else
{
for ($i="0"; $i < sizeof($array); $i++)
{
if ("'$row[idClub]'"==$array[$i]){$Test="OUI";}
}
}
if ($Test=="OUI")
{
echo " | ".$row[3]." ".$row[2]."" ;
echo " | ".$row[7]."" ;
echo " | ".$row[1]."" ;
}
else
{
echo " | " . $row[3] . " " . $row[2];
echo " | " . $row[7];
echo " | " . $row[1];
}
}
echo " |
";
}
/////////////////////////////////////////////////////////////////////////////////////////////////
// Titre : Add-on Gestion des clubs (fiches clubs), mini-classement, //
// statistiques, amélioration de la gestion des buteurs pour PhpLeague. //
// Auteur : Alexis MANGIN //
// Email : Alexis@univert.org //
// Url : http://www.univert.org //
// Démo : http://univert42.free.fr/adversaire/classement/consult/classement.php?champ=2 //
// Description : Edition, gestion, fiches clubs, statistiques, mini-classement... //
// Version : 0.71 (29/03/2003) //
// //
// //
// L'Univert : Retrouvez quotidiennement l'actualité des Verts ainsi que de //
// nombreuses autres rubriques consacrées à l'AS Saint-Etienne. Mais //
// L'Univert c'est avant tout la présentation d'un club devenu légende. //
// //
/////////////////////////////////////////////////////////////////////////////////////////////////
// Affichage renseignements utilisée dans consult/club.php
function aff_rens ($id_classe, $id_clubs)
{
$query="select donnee.id, donnee.nom, id_rens, id_clubs, rens.id, rens.nom, rens.id_classe, clubs.id, etat, donnee.url, rens.url
FROM donnee, rens, clubs
WHERE id_clubs='$id_clubs'
AND id_clubs=clubs.id
AND id_rens=rens.id
AND id_classe='$id_classe'
AND etat='1' order by rang";
$result = mysql_query ($query);
$nb_rens=mysql_num_rows($result);
if ($nb_rens=="0"){echo "".ADMIN_EQUIPE_8."";}
while($row = mysql_fetch_array($result))
{
if (empty ($row[9]) and empty ($row[10])){echo "$row[5] : $row[1]
";}
elseif (empty ($row[9])){echo "$row[5] : $row[1]
";}
elseif (empty ($row[10])){echo "$row[5] : $row[1]
";}
else {echo "$row[5] : $row[1]
";}
}
}
function clmntmini($legendemini, $typemini, $accessionmini, $barragemini, $relegationmini, $champmini, $requetemini, $nb_dessusmini, $nb_dessousmini, $lienmini, $cheminmini)
{
// NOM de EQUIPE FAVORITE a partir de son id
$query="select * from parametres where id_champ='$champmini'";
$result=(mysql_query($query));
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
echo "| ".$legendemini;
echo " |
|---|
| ".CLMNT_POSITION."";
echo " | ".CLMNT_EQUIPE."";
echo " | ".CLMNT_POINTS."";
//echo " | ".CLMNT_JOUES."";
//echo " | ".CLMNT_VICTOIRES."";
//echo " | ".CLMNT_NULS."";
//echo " | ".CLMNT_DEFAITES."";
//echo " | ".CLMNT_BUTSPOUR."";
//echo " | ".CLMNT_BUTSCONTRE."";
//echo " | ".CLMNT_DIFF;
$result=mysql_query($requetemini) or die (mysql_error());
$pl=0;
$pl2=1;
while ($row=mysql_fetch_array($result))
{
if ($row[NOM]==$equipe_fetiche)
{
$av=$pl2-$nb_dessusmini;
$ap=$pl2+$nb_dessousmini;
}
$pl2++;
}
$result=mysql_query($requetemini) or die (mysql_error());
while ($row=mysql_fetch_array($result))
{
if ($pl>$ap){$pl++;}
if ($pl<$av){$pl++;}
if ($pl<=$ap and $pl>=$av)
{
if ($row[NOM]==EXEMPT){continue;}
elseif ($pl<=$accessionmini and $typemini==GENERAL){echo " |
|---|
";} //accession
elseif ($pl<=$barragemini and $typemini==GENERAL){echo " ";} //barrage
elseif ($pl>$relegationmini and $typemini==GENERAL){echo " ";} //relegation
elseif (($pl%2)==0){echo " ";}
else {echo " ";}
echo "| ";
print $pl;
$pl++;
$x=0;
while($x<2) // nb de colones
{
echo " | ";
if ($x==0){echo " ";}
if ($row[$x]==$equipe_fetiche){echo "";}
if ($x==0)
{
$query2="SELECT equipes.id, clubs.nom FROM equipes, clubs
WHERE clubs.nom='$row[0]'
AND equipes.id_champ='$champ'
AND clubs.id=equipes.id_club";
$result2=mysql_query($query2);
while($id_equipe=mysql_fetch_array($result2))
{
$id=$id_equipe[id];
}
if ($lien=='non'){echo "$row[$x]";}
else {echo "$row[$x]";}
}
else print $row[$x];
$x++;
echo "";
}
}
}
echo " |
";
}
function clmnt_barre($legende, $type, $accession, $barrage, $relegation, $champ, $requete, $lien)
{
// NOM de EQUIPE FAVORITE a partir de son id
$query="select * from parametres where id_champ='$champ'";
$result=(mysql_query($query));
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
echo "| ".$legende;
echo " |
|---|
| ".CLMNT_POSITION."
| ".CLMNT_EQUIPE."
| ".CLMNT_POINTS."";
echo "".CLMNT_JOUES."
".CLMNT_VICTOIRES."
".CLMNT_NULS."
".CLMNT_DEFAITES."
".CLMNT_BUTSPOUR."
".CLMNT_BUTSCONTRE."
".CLMNT_DIFF."
";
$result=mysql_query($requete) or die (mysql_error());
$pl=1;
$action=0;
while ($row=mysql_fetch_array($result))
{
if ($row[NOM]==EXEMPT){continue;}
if ($pl==$accession and $type==GENERAL){$action=1;}
if (($pl%2)==0)
{
echo "";
}
else
{
echo " ";
}
//if ($pl==($accession+1) and $type==GENERAL){$action=1;} // Si vous souhaitez encadrer le premier non promu
if ($pl==$relegation and $type==GENERAL){$action=1;}
echo "| ";
print $pl;
$pl++;
$x=0;
while($x<9)
{
echo " | ";
if ($x==0){echo " ";}
if ($row[$x]==$equipe_fetiche){echo "";}
if ($x==0)
{
$query2="SELECT equipes.id, clubs.nom FROM equipes, clubs
WHERE clubs.nom='$row[0]'
AND equipes.id_champ='$champ'
AND clubs.id=equipes.id_club";
$result2=mysql_query($query2);
while($id_equipe=mysql_fetch_array($result2))
{
$id=$id_equipe[id];
}
if ($lien=='non'){echo "$row[$x]";}
else {echo "$row[$x]";}
}
else print $row[$x];
$x++;
echo "";
}
echo " | ";
if ($type==GENERAL){echo " ";}
echo " | ";
if ($action==0){echo" | ";$action=0;}
if ($action==1){echo"![](\"pix.gif\") | ";$action=0;}
}
echo " | | | | | | | | |
";
}
function clmntmini_barre($legendemini, $typemini, $accessionmini, $barragemini, $relegationmini, $champmini, $requetemini, $nb_dessusmini, $nb_dessousmini, $lienmini, $cheminmini)
{
// NOM de EQUIPE FAVORITE a partir de son id
$query="select * from parametres where id_champ='$champmini'";
$result=(mysql_query($query));
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
echo "| ".$legendemini;
echo " |
|---|
| ".CLMNT_POSITION."";
echo " | ".CLMNT_EQUIPE."";
echo " | ".CLMNT_POINTS."";
//echo " | ".CLMNT_JOUES."";
//echo " | ".CLMNT_VICTOIRES."";
//echo " | ".CLMNT_NULS."";
//echo " | ".CLMNT_DEFAITES."";
//echo " | ".CLMNT_BUTSPOUR."";
//echo " | ".CLMNT_BUTSCONTRE."";
//echo " | ".CLMNT_DIFF;
$result=mysql_query($requetemini) or die (mysql_error());
$pl=0;
$pl2=1;
while ($row=mysql_fetch_array($result))
{
if ($row[NOM]==$equipe_fetiche)
{
$av=$pl2-$nb_dessusmini;
$ap=$pl2+$nb_dessousmini;
}
$pl2++;
}
$result=mysql_query($requetemini) or die (mysql_error());
while ($row=mysql_fetch_array($result))
{
if ($pl>$ap){$pl++;}
if ($pl<$av){$pl++;}
if ($pl<=$ap and $pl>=$av)
{
if ($row[NOM]==EXEMPT){continue;}
if ($pl==$accessionmini){$action=1;}
if (($pl%2)==0)
{
echo " |
|---|
";
}
else
{
echo " ";
}
//if ($pl==($accession+1)){$action=1;} // Si vous souhaitez encadrer le premier non promu
if ($pl==$relegationmini){$action=1;}
echo "| ";
print $pl;
$pl++;
$x=0;
while($x<2) // nb de colone
{
echo " | ";
if ($x==0)
{
echo " ";
}
if ($row[$x]==$equipe_fetiche )
{
echo "";
}
if ($x==0)
{
$query2="SELECT equipes.id, clubs.nom FROM equipes, clubs
WHERE clubs.nom='$row[0]'
AND equipes.id_champ='$champ'
AND clubs.id=equipes.id_club";
$result2=mysql_query($query2);
while($id_equipe=mysql_fetch_array($result2))
{
$id=$id_equipe[id];
}
if ($lienmini=='non'){echo "$row[$x]";}
else {echo "$row[$x]";}
}
else print $row[$x];
$x++;
echo "";
}
if ($action==0 and $typemini==GENERAL){echo" | | ";$action=0;}
if ($action==1 and $typemini==GENERAL){echo" | ";$action=0;}
}
}
echo "
";
}
function clmntred($legendemini, $typemini, $accessionmini, $barragemini, $relegationmini, $champmini, $requetemini, $lienmini, $cheminmini)
{
// NOM de EQUIPE FAVORITE a partir de son id
$query="select * from parametres where id_champ='$champmini'";
$result=(mysql_query($query));
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
echo "| ".$legendemini;
echo " |
|---|
| ".CLMNT_POSITION."
| ".CLMNT_EQUIPE."
| ".CLMNT_POINTS."";
$result=mysql_query($requetemini) or die (mysql_error());
$pl=1;
while ($row=mysql_fetch_array($result))
{
if ($row[NOM]==EXEMPT){continue;}
if ($pl<=$accessionmini and $typemini==GENERAL){echo "";}
elseif ($pl<=$barragminie and $typemini==GENERAL){echo " ";}
elseif ($pl>$relegationmini and $typemini==GENERAL){echo " ";}
elseif (($pl%2)==0){echo " ";}
else{echo " ";}
echo "| ";
print $pl;
$pl++;
$x=0;
while($x<2)
{
echo " | ";
if ($x==0){echo " ";}
if ($row[$x]==$equipe_fetiche){echo "";}
if ($x==0)
{
$query2="SELECT equipes.id, clubs.nom FROM equipes, clubs
WHERE clubs.nom='$row[0]'
AND equipes.id_champ='$champ'
AND clubs.id=equipes.id_club";
$result2=mysql_query($query2);
while($id_equipe=mysql_fetch_array($result2))
{
$id=$id_equipe[id];
}
if ($lienmini=='non'){echo "$row[$x]";}
else {echo "$row[$x]";}
}
else print $row[$x];
$x++;
echo "";
}
}
echo " | |
";
}
function clmnt_barrered($legendemini, $typemini, $accessionmini, $barragemini, $relegationmini, $champmini, $requetemini, $lienmini, $cheminmini)
{
// NOM de EQUIPE FAVORITE a partir de son id
$query="select * from parametres where id_champ='$champmini'";
$result=(mysql_query($query));
while ($row=mysql_fetch_array($result))
{
$id_equipe_fetiche=$row[id_equipe_fetiche];
}
$result=(mysql_query("select nom from clubs, equipes where equipes.id='$id_equipe_fetiche' and clubs.id=equipes.id_club"));
while ($row=mysql_fetch_array($result))
{
$equipe_fetiche=$row[0];
}
echo "| ".$legendemini;
echo " |
|---|
| ".CLMNT_POSITION."
| ".CLMNT_EQUIPE."
| ".CLMNT_POINTS."";
$result=mysql_query($requetemini) or die (mysql_error());
$pl=1;
$action=0;
while ($row=mysql_fetch_array($result))
{
if ($row[NOM]==EXEMPT){continue;}
if ($pl==$accessionmini and $typemini==GENERAL){$action=1;}
if (($pl%2)==0)
{
echo "";
}
else
{
echo " ";
}
//if ($pl==($accession+1) and $type==GENERAL){$action=1;} // Si vous souhaitez encadrer le premier non promu
if ($pl==$relegationmini and $typemini==GENERAL){$action=1;}
echo "| ";
print $pl;
$pl++;
$x=0;
while($x<2)
{
echo " | ";
if ($x==0){echo " ";}
if ($row[$x]==$equipe_fetiche){echo "";}
if ($x==0)
{
$query2="SELECT equipes.id, clubs.nom FROM equipes, clubs
WHERE clubs.nom='$row[0]'
AND equipes.id_champ='$champ'
AND clubs.id=equipes.id_club";
$result2=mysql_query($query2);
while($id_equipe=mysql_fetch_array($result2))
{
$id=$id_equipe[id];
}
if ($lienmini=='non'){echo "$row[$x]";}
else {echo "$row[$x]";}
}
else print $row[$x];
$x++;
echo "";
}
if ($action==0){echo" | | ";$action=0;}
if ($action==1){echo" | ";$action=0;}
}
echo " |
";
}
function time1 ()
{ //calcul du temps de debut de recherche
$time_deb = microtime();
$time_deb = explode(" ",$time_deb);
$time_deb = $time_deb[0] + $time_deb[1];
}
function time2 ($page, $nom)
{$time_fin = microtime();
$time_fin = explode(" ",$time_fin);
$time_fin = $time_fin[0] + $time_fin[1];
$time_search = $time_fin - $time_deb;
print $time_search;
$query="INSERT into chargement (id_page, temps) VALUES ($page, $time_search) " ;
mysql_query($query) or die(mysql_error());
}
?>
| |