get_results("SELECT * FROM listes WHERE visible=1 ORDER BY `defaut` DESC"); function prologue($liste) { global $wpdb; $night=$liste->prefixe . '_prologue'; $person=$liste->prefixe . '_person'; $participant=$liste->prefixe . '_participant'; $participants=$wpdb->get_results("SELECT N.ID,per.last_name,per.first_name FROM $night AS N INNER JOIN $participant AS par INNER JOIN $person AS per WHERE N.person_id = per.id AND N.participant_id = par.id ORDER BY N.ID"); echo "

$liste->name

"; echo ""; echo ""; foreach ($participants as $people) { echo ""; } echo "
N° DossardNomPrénom
$people->ID$people->last_name$people->first_name
"; } function raid($liste) { global $wpdb; $equipe=$liste->prefixe . '_equipe'; $person=$liste->prefixe . '_person'; $participant=$liste->prefixe . '_participant'; $raid_id=$wpdb->get_var('SELECT id FROM raid WHERE value="'.$liste->prefixe.'"'); $valid_team=$wpdb->get_results("SELECT * FROM $equipe WHERE state='accepte' OR state='valide'"); $requete=$wpdb->get_results("SELECT meta FROM raidmeta WHERE value='category' AND raid_ID='$raid_id'"); parse_str($requete); echo "

$liste->name

"; /* foreach($cat as $category) { $requeteCat = $wpdb->get_results("SELECT * FROM category WHERE nb_people = '$category'"); }*/ for ($i=1;$i<=6;$i++) { if ($i==1) { echo "
Catégorie : 2 Hommes"; } elseif ($i==2) { echo "
Catégorie : 2 Femmes"; } elseif ($i==3) { echo "
Catégorie : 2 Mixtes"; } elseif ($i==4) { echo "
Catégorie : 4 Hommes"; } elseif ($i==5) { echo "
Catégorie : 4 Femmes"; } elseif ($i==6) { echo "
Catégorie : 4 Mixtes"; } foreach ($valid_team as $team) { if ($team->category_id==$i) { $team_id=$team->id; echo "
"; } else { echo " unvalide'>"; } echo '

'.stripslashes($team->name).'

'; // Get id membres echo "
"; $mems=$wpdb->get_results("SELECT * FROM $participant WHERE team_id='$team_id'"); foreach ($mems as $mem) { $person_id=$mem->person_id; $part=$wpdb->get_row("SELECT * FROM $person WHERE id='$person_id'",ARRAY_A); echo '' . $part["last_name"] . " " . $part["first_name"] . ''; } echo "
"; echo "
"; } } echo "
"; } } function attente($liste) { global $wpdb; $equipe=$liste->prefixe . '_equipe'; $person=$liste->prefixe . '_person'; $participant=$liste->prefixe . '_participant'; $equipes=$wpdb->get_results("SELECT * FROM $equipe WHERE state='attente' ORDER BY id"); echo "

$liste->name

"; echo ""; echo ""; if ($wpdb->num_rows != 0) { foreach ($equipes as $equipe) { $participants=$wpdb->get_results("SELECT per.* FROM $person AS per INNER JOIN $participant AS par WHERE $equipe->id=par.team_id AND par.person_id=per.id"); echo ''; foreach ($participants as $part) { echo ''; } echo ''; } } echo "
Nom de l'équipeNomsPrénoms
' . stripslashes($equipe->name) . '' . stripslashes($part->last_name) . '' . stripslashes($part->first_name) . '
"; } ?>