'' ";
$mysql_result2 = mysql_query($req,$connexion) ;
if ($ligne2 = mysql_fetch_array($mysql_result2))
{
header("Location: ".$ligne2['url']);
die();
}
$req="select * from epreuves where id=".secure($_GET['epreuve'])." ";
$mysql_result2 = mysql_query($req,$connexion) ;
$ligne2 = mysql_fetch_array($mysql_result2);
$idc=0;
if (isset($_GET['idc']))
$idc=$_GET['idc'];
$ids=0;
if (isset($_GET['ids']))
{
$ids=$_GET['ids'];
$_SESSION['ids']=$ids;
}
else
if (isset($_SESSION['ids']))
{
$ids=$_SESSION['ids'];
}
$txt1="Résultats - ";
if ($ligne2['sans_classement']==1) $txt1="";
$txt2="Cliquez sur une ligne pour voir le résultat en détail";
$txt3="Classement";
$txt4="Temps";
$txt5="Nom Prénom";
$txt6="Club";
$txt7="Cat./Clt cat.";
$txt70="Clt cat.";
if ($_GET['cat']<0) $txt70="Clt. sexe";
$txt77="Clt gén.";
$txt8="Retour au formulaire de recherche";
$txt9="DIPLOME";
$txtS="Sexe";
$txtC="Classement par catégories";
if ($_SESSION['langue']=="E")
{
$txt1="Results - ";
if ($ligne2['sans_classement']==1) $txt1="";
$txt2="Click on a line to see result details";
$txt3="Position";
$txt4="Finish time";
$txt5="Name";
$txt6="Club";
$txt7="Cat./Cat. pos.";
$txt70="Cat. pos.";
if ($_GET['cat']<0) $txt70="Sexe pos.";
$txt77="Gen. pos.";
$txt8="Back to search form";
$txt9="DIPLOMA";
$txtS="Sex";
$txtC="Position by category";
}
if ($_POST['quoi']=="suite_result")
{
$ajax=1;
$req="select * from epreuves where id=".secure($_POST['ide'])." ";
$mysql_result2 = mysql_query($req,$connexion) ;
$ep = mysql_fetch_array($mysql_result2);
$req="select * from courses where etat<9 and publi>=0 and id=".secure($ep['id_course']);
$mysql_result = mysql_query($req,$connexion) ;
$course = mysql_fetch_array($mysql_result);
$req="select * from epreuves_resultats where id_epreuve=".secure($_POST['ide']);
$mysql_result = mysql_query($req,$connexion) ;
if ($ligne = mysql_fetch_array($mysql_result))
$idc=$ligne['id_course'];
$i=0;
$req="select * from colonnes where id_course= '".secure($idc)."' and id_epreuve=".secure($ep['id']);
$req.=" and actif=1 and sur_liste>0 order by sur_liste ";
$mysql_result = mysql_query($req,$connexion) ;
while ($ligne = mysql_fetch_array($mysql_result))
{
$col[$i]=$ligne['indice']; $i++;
$nbcol=$i;
}
require 'inc_pages/iframe_head.php';
$dip=$course['diplome'];
$maxi=$_POST['maxi'];
$d=($_POST['page']-1)*40;
$cpt=0;
$req="select * from epreuves_resultats where id_epreuve=".secure($_POST['ide'])." and classement>0 ";
if (trim($_POST['nom'])!="") $req.=" and nom like '".secure($_POST['nom'])."%' ";
if (trim($_POST['dossard'])!="") $req.=" and dossard like '".secure($_POST['dossard'])."' ";
if (trim($_POST['groupe'])!="") $req.=" and groupe like '".secure($_POST['groupe'])."%' ";
if (trim($_POST['groupe2'])!="") $req.=" and libre6 like '".secure($_POST['groupe2'])."' ";
if (trim($_POST['cat'])!="")
{
if ($_POST['cat']==-1)
$req.=" and sexe like 'F' ";
else
if ($_POST['cat']==-2)
$req.=" and (sexe like 'H' or sexe like 'M') ";
else
$req.=" and categorie like '".secure($_POST['cat'])."' ";
}
if ($ep['sans_classement']==0)
$req.=" order by classement LIMIT ".$d.",40 ";
else
$req.=" order by nom,prenom LIMIT ".$d.",40 ";
$mysql_result = mysql_query($req,$connexion) ;
while ($ligne = mysql_fetch_array($mysql_result))
{
$cpt++;
$bg=$table_texte_bg1;
if ($cpt%2==0) $bg=$table_texte_bg2;
$pictos="";
if ($dip==1)
if ($ligne['diplome']!="")
$pictos='';
$req="select * from epreuves_videos where id_epreuve=".secure($_POST['ide'])." and dossard like '".secure($ligne['dossard'])."' ";
$mysql_resultD = mysql_query($req,$connexion) ;
if ($ligneD = mysql_fetch_array($mysql_resultD))
{
$pictos.='
';
}
$req="select * from epreuves_photos where id_epreuve=".secure($_POST['ide'])." and dossard like '".secure($ligne['dossard'])."' ";
$mysql_resultD = mysql_query($req,$connexion) ;
if ($ligneD = mysql_fetch_array($mysql_resultD))
{
$pictos.=' 
';
}
$req="select * from epreuves_direct where id_epreuve=".secure($_POST['ide'])." and dossard like '".secure($ligne['dossard'])."' ";
$mysql_resultD = mysql_query($req,$connexion) ;
if ($ligneD = mysql_fetch_array($mysql_resultD))
{
$pictos.=' 
';
}
$req="select * from epreuves_resultats_brut where id_course=".secure($ep['id_course'])." and id_epreuve=".secure($ep['id'])." and id_resultat=".secure($ligne['id'])." ";
$mysql_resultD = mysql_query($req,$connexion) ;
$brut = mysql_fetch_array($mysql_resultD);
$clF="";
if ($ligne['sexe']=="F") $clF=' class="Femme" ';
$clFP=' class="picto" ';
if ($ligne['sexe']=="F") $clFP=' class="Femme picto" ';
$c7=$ligne['classement'];
$c77=$ligne['categorie']." / ".$ligne['classement_categ'];
?>
|
|