MOD MySQL est remplacé par PostgreSQL (fini)

[cl7.git] / php / pages / inscription.php

diff --git a/php/pages/inscription.php b/php/pages/inscription.php
index cfdd1e7..dd603ac 100644 (file)
--- a/php/pages/inscription.php
+++ b/php/pages/inscription.php
@@ -6,7 +6,7 @@ if ($config->get("inscription_terminees"))
    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>';
@@ -14,7 +14,7 @@ else
 
 <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>';
@@ -29,7 +29,7 @@ else
          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>
@@ -37,8 +37,8 @@ else
          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() ? $participant->info->password : $_POST["pass1"]?>" />
+         re: <input type="password" maxlength="10" size="10" name="pass2" value="<?=$participant->existe() ? $participant->info->password : $_POST["pass2"]?>" /> 
       </td>
    </tr>
    <tr>
@@ -46,16 +46,14 @@ else
          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> 
@@ -64,7 +62,7 @@ else
          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>
@@ -72,7 +70,7 @@ else
          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>
@@ -80,7 +78,7 @@ else
          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>
@@ -88,7 +86,7 @@ else
          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>
@@ -96,7 +94,7 @@ else
          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>
@@ -105,17 +103,15 @@ else
       </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>
@@ -132,11 +128,11 @@ else
          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>