= "'.(date("U")-7200).'" AND visible = 1 ORDER BY datedebut ASC';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
$p=0;
while ($data = mysql_fetch_array($req)) // DŽbut de la boucle pour chaque event <---- elle est fermŽe ou cette loop?
{
$joueurs='';
$sql2 = 'select * from event_jeux where id='.$data['test_id_jeux'].'';
$req2 = mysql_query($sql2) or die('Erreur SQL2 !
'.$sql2.'
'.mysql_error());
$data2 = mysql_fetch_array($req2);
$nom_partie[$p] = htmlentities($data2['jeux']);
$date_partie[$p] = date("d/m/Y",$data['datedebut']);
$heure_partie[$p] = date("H:i",$data['datedebut']);
$image_partie[$p] = $data2['icone'];
$id_partie[$p] = $data2['id'];
$lvl_partie[$p] = $data2['acces_lvl'];
$sql2 = 'select * from ibf_members where id='.$data['ibf_id_createur'].'';
$req2 = mysql_query($sql2) or die('Erreur SQL2 !
'.$sql2.'
'.mysql_error());
$data2 = mysql_fetch_array($req2);
$author = $data2['name'];
//$joueurs = 'Présents :
';
$i=0;
$j=0;
$sql2 = 'select * from event_place where test_id_event='.$data['id'].' AND accepted = 1';
$req2 = mysql_query($sql2) or die('Erreur SQL2 !
'.$sql2.'
'.mysql_error());
while ($data2 = mysql_fetch_array($req2))
{
$sql3 = 'select * from ibf_members where id='.$data2['ibf_id_member_name'].'';
$req3 = mysql_query($sql3) or die('Erreur SQL3 !
'.$sql3.'
'.mysql_error());
$data3 = mysql_fetch_array($req3);
{
$nom_joueur[$i][$p] .= htmlentities($data3['name']);
$i++;
}
}
while ($i < $data['nbplace'])
{
$i++;
$j++;
}
$places_parties[$p] = $j;
$p++;
}
$loop_parties = array('nom_partie' => $nom_partie, 'date_partie' => $date_partie, 'heure_partie' => $heure_partie, 'places_parties' =>$places_parties, 'image_partie' => $image_partie);
$loop_joueurs = array('nom_joueur' => $nom_joueur);
$parties_tpl = new tpl('../../xml/parties_tpl.xml');
$parties_tpl -> set_vars(array('parties' => $loop_parties));
$parties_tpl -> set_vars(array('joueurs' => $loop_joueurs));
$parties_tpl->get_html();
//$parties_tpl = str_replace('','',$parties_tpl);
echo $parties_tpl;
?>