return;
}
-if ($participant->valide)
+if ($participant->existe())
echo '<p>Modification de mes infos</p>';
else
echo'<p><em>Les personnes inscrites s\'engagent à être présentes à la LAN et à payer la somme convenue.</em></p><p>Elles peuvent se désinscrirent en cas d\'empèchements majeurs.</p>';
<form id="formulaireInscription" method="post" action="inscription.html">
<?php
- if($participant->valide)
+ if($participant->existe())
echo '<p><input type="hidden" name="modification_participant" value="1" /></p>';
else
echo '<p><input type="hidden" name="inscription" value="1" /></p>';
pseudo <span class="miniInfo">(login)</span>
</td>
<td>
- <input type="text" maxlength="50" name="pseudo" value="<?=$participant->valide ? $participant->info->pseudo : $_POST["pseudo"]?>" />
+ <input type="text" maxlength="50" name="pseudo" value="<?=$participant->existe() ? $participant->info->pseudo : $_POST["pseudo"]?>" />
</td>
</tr>
<tr>
password <span class="miniInfo">(pour pouvoir par la suite modifier mes infos)</span>
</td>
<td>
- <input type="password" size="10" maxlength="10" name="pass1" value="<?=$participant->valide ? $participant->info->password : $_POST["pass1"]?>" />
- re: <input type="password" maxlength="10" size="10" name="pass2" value="<?=$participant->valide ? $participant->info->password : $_POST["pass2"]?>" />
+ <input type="password" size="10" maxlength="10" name="pass1" value="<?=$participant->existe() ? '': $_POST["pass1"]?>" />
+ re: <input type="password" maxlength="10" size="10" name="pass2" value="<?=$participant->existe() ? '' : $_POST["pass2"]?>" />
</td>
</tr>
<tr>
clan name
</td>
<td>
- <input type="text" maxlength="30" size="15" name="clan_nom" value="<?=$participant->valide ? $participant->info->clan_nom : $_POST["clan_nom"]?>" />
+ <input type="text" maxlength="30" size="15" name="clan_nom" value="<?=$participant->existe() ? $participant->info->clan_nom : $_POST["clan_nom"]?>" />
<select id="clanChoix" name="clanChoix" size="1">
<option value ="0" selected="selected">clans existants</option>
<?php
- $res = mysql_query("SELECT DISTINCT clan_nom, clan_tag FROM participants WHERE clan_nom != '' OR clan_tag != ''");
- while($info_clan = mysql_fetch_object($res))
- {
- echo '<option value = "', $info_clan->clan_nom, ';', $info_clan->clan_tag, '">', $info_clan->clan_nom != '' ? $info_clan->clan_nom : $info_clan->clan_tag, '</option>';
- }
- ?>
+ $res = pg_query("SELECT DISTINCT clan_nom, clan_tag FROM participants WHERE clan_nom != '' OR clan_tag != ''");
+ while($info_clan = pg_fetch_object($res))
+ echo '<option value = "', $info_clan->clan_nom, ';', $info_clan->clan_tag, '">', $info_clan->clan_nom != '' ? $info_clan->clan_nom : $info_clan->clan_tag, '</option>';
+ ?>
</select>
</td>
</tr>
clan tag
</td>
<td>
- <input type="text" maxlength="10" name="clan_tag" value="<?=$participant->valide ? $participant->info->clan_tag : $_POST['clan_tag']?>" />
+ <input type="text" maxlength="10" name="clan_tag" value="<?=$participant->existe() ? $participant->info->clan_tag : $_POST['clan_tag']?>" />
</td>
</tr>
<tr>
nom
</td>
<td>
- <input type="text" maxlength="30" name="nom" value="<?=$participant->valide ? $participant->info->nom : $_POST['nom']?>" />
+ <input type="text" maxlength="30" name="nom" value="<?=$participant->existe() ? $participant->info->nom : $_POST['nom']?>" />
</td>
</tr>
<tr>
prénom
</td>
<td>
- <input type="text" maxlength="30" name="prenom" value="<?=$participant->valide ? $participant->info->prenom : $_POST['prenom']?>" />
+ <input type="text" maxlength="30" name="prenom" value="<?=$participant->existe() ? $participant->info->prenom : $_POST['prenom']?>" />
</td>
</tr>
<tr>
age
</td>
<td>
- <input type="text" maxlength="30" name="age" value="<?=$participant->valide ? $participant->info->age : $_POST['age']?>" />
+ <input type="text" maxlength="30" name="age" value="<?=$participant->existe() ? $participant->info->age : $_POST['age']?>" />
</td>
</tr>
<tr>
<td>
- email <span class="miniInfo">(non-public, sauf si piratage de la base ^-^´)</span>
+ email <span class="miniInfo">(non-public)</span>
</td>
<td>
- <input type="text" maxlength="30" name="e_mail" value="<?=$participant->valide ? $participant->info->e_mail : $_POST['e_mail']?>" />
+ <input type="text" maxlength="30" name="e_mail" value="<?=$participant->existe() ? $participant->info->e_mail : $_POST['e_mail']?>" />
</td>
</tr>
<tr>
</td>
<td>
<?php
- $res = mysql_query("
+ $res = pg_query_params("
SELECT periodes.id, periodes.nom, participations.participant_id
FROM periodes
LEFT JOIN participations ON periodes.id = participations.periode_id
- AND participations.participant_id = ".($participant->valide ? $participant->info->id : "0")."
+ AND participations.participant_id = $1
ORDER BY periodes.id
- ");
- while($periode = mysql_fetch_object($res))
- {
- echo '<p><input name="periodes[]" value="'.$periode->id.'" '.((!$participant->valide && (!$_POST['periodes'] || in_array($periode->id, $_POST['periodes']))) || $periode->participant_id ? 'checked="checked"' : '').' id="periode'.$periode->id.'" type="checkbox" /><label for="periode'.$periode->id.'" />'.$periode->nom.'</label></p>';
- }
+ ", array(($participant->existe() ? $participant->info->id : "0")));
+ while($periode = pg_fetch_object($res))
+ echo '<p><input name="periodes[]" value="'.$periode->id.'" '.((!$participant->existe() && (!$_POST['periodes'] || in_array($periode->id, $_POST['periodes']))) || $periode->participant_id ? 'checked="checked"' : '').' id="periode'.$periode->id.'" type="checkbox" /><label for="periode'.$periode->id.'" />'.$periode->nom.'</label></p>';
?>
</td>
</tr>
remarques
</td>
<td>
- <textarea cols="30" rows="5" name="remarques"><?=$participant->valide ? $participant->info->remarques : $_POST['remarques']?></textarea>
+ <textarea cols="30" rows="5" name="remarques"><?=$participant->existe() ? $participant->info->remarques : $_POST['remarques']?></textarea>
</td>
</tr>
<?php
- if (!$participant->valide)
+ if (!$participant->existe())
echo'
<tr>
<td>