X-Git-Url: http://git.euphorik.ch/?p=cl7.git;a=blobdiff_plain;f=php%2Fpages%2Fpizzas.php;fp=php%2Fpages%2Fpizzas.php;h=bb5de5e1deca1d4a3ae0402c9d1447787bd8ba68;hp=be856bd829795f57f7ec0bcc7fc6046f57028b28;hb=23bc2016d5fbd8f7daa9b7ba5c7fa862709ff7a7;hpb=75d6e5d29bfe332d68c617d26e3a8b1828a57893

diff --git a/php/pages/pizzas.php b/php/pages/pizzas.php
index be856bd..bb5de5e 100644
--- a/php/pages/pizzas.php
+++ b/php/pages/pizzas.php
@@ -6,7 +6,7 @@ function selection_pizzas()
 {
    global $config;
    global $participant;
-   $requ = mysql_query("select * from pizzas order by nom");
+   $requ = pg_query("select * from pizzas order by nom");
    echo '<h1>commande de pizza</h1>';
    
    if ($config->get('pizza_peut_commander'))
@@ -18,7 +18,7 @@ function selection_pizzas()
       echo '<table width ="100%" border="0" cellpadding="1" cellspacing="3">';
       echo '<tr><td class="pizzaHeader"></td><td class="pizzaHeader">Nom</td><td class="pizzaHeader">Composition</td><td class="pizzaHeader">Prix</td></tr>';
       echo '<tr><td><input type="radio" name="piz_choisie" value="-1" ', ($participant->info->pizza==null?'checked':''), '></td><td class="texte">', ($participant->info->pizza==null?'<b>':''), 'Aucune', ($participant->info->pizza==null?'</b>':''), '</td><td></td><td></td></tr>';
-      while($pizza = mysql_fetch_object($requ))
+      while($pizza = pg_fetch_object($requ))
          echo '<tr><td width="1" ',($participant->info->pizza==$pizza->id?'class="pizzaChoisie"':''),'><input type="radio" id="pizza_', $pizza->id ,'" name="piz_choisie" value="', $pizza->id, '"',($participant->info->pizza==$pizza->id?'checked':''), '></td><td class="',($participant->info->pizza==$pizza->id?'pizzaChoisie ':''),'texte"><label for="pizza_', $pizza->id ,'">', $pizza->nom, '</label></td><td class="',($participant->info->pizza==$pizza->id?'pizzaChoisie ':''),'texte"><label for="pizza_', $pizza->id ,'">', $pizza->composition, '</label></td><td class="',($participant->info->pizza==$pizza->id?'pizzaChoisie ':''),'texte"><label for="pizza_', $pizza->id ,'">', $pizza->prix, '.-</label></td></tr>';
       echo '</table><br><input type="submit" value="Commander"></form>';
    }
@@ -32,19 +32,19 @@ function selection_pizzas()
 // Affiche les statistique sur les pizza
 function stats()
 {
-   $requ_pizza = mysql_query("select * from pizzas order by nom");
-   $requ_participant = mysql_query("select * from participants");
+   $requ_pizza = pg_query("select * from pizzas order by nom");
+   $requ_participant = pg_query("select * from participants");
    $nb = array();
    $nb_tot = 0;
    $total = 0;
-   $nb_pizza = mysql_fetch_row(mysql_query("select count(*) from pizzas"));
+   $nb_pizza = pg_fetch_row(pg_query("select count(*) from pizzas"));
    
    // Initialise le tableau de comptage
    for ($i=0; $i < ($nb_pizza[0] + 3); $i++)  // on fait un '+3' parce que on ne sais jamais trop ce qui pourrait se passer ;-))
       $nb[$i] = 0;
      
    // Rempli le tableau de nombre de pizzas
-   while ($participant = mysql_fetch_object($requ_participant))
+   while ($participant = pg_fetch_object($requ_participant))
       if ($participant->pizza != null)
           $nb[$participant->pizza]++;
       
@@ -52,7 +52,7 @@ function stats()
    echo '<table width="100%" border="0" cellpadding="1" cellspacing="3">';
    echo '<tr><td class="pizzaHeader">Nom</td><td class="pizzaHeader">Nombre</td><td class="pizzaHeader">Prix unitaire</td><td class="pizzaHeader">Prix total</td></tr>';   
       
-   while($pizza = mysql_fetch_object($requ_pizza))
+   while($pizza = pg_fetch_object($requ_pizza))
    {
       if ($nb[$pizza->id] == 0)
          continue;      
@@ -67,8 +67,8 @@ function stats()
 // Retourne le nom de la pizza en fonction de son ID
 function pizza ($id)
 {
-   $requ = mysql_query("select * from pizzas where id = " . $id);
-   if ($pizza = mysql_fetch_object($requ))
+   $requ = pg_query_params("select * from pizzas where id = $1", array($id));
+   if ($pizza = pg_fetch_object($requ))
       return $pizza->nom;
    else
       return 'Pizza inexistante !';
@@ -79,18 +79,18 @@ function pizza ($id)
 function kiakoi()
 {
    global $participant;
-   $requ = mysql_query("select * from participants order by nom");
+   $requ = pg_query("select * from participants order by nom");
    
    
    echo '<h1>qui prend quoi</h1>';
    echo '<table width="100%" border="0" cellpadding="1" cellspacing="3">';
    echo '<tr><td class="pizzaHeader">Pseudo</td><td class="pizzaHeader">Nom</td><td class="pizzaHeader">Prix</td><td class="pizzaHeader">Paiement</td></tr>';
    
-   while ($participant = mysql_fetch_object($requ))
+   while ($participant = pg_fetch_object($requ))
    {
       if ($participant->pizza != null)
       {
-         $pizza = mysql_fetch_object(mysql_query("select * from pizzas where id = " . $participant->pizza));
+         $pizza = pg_fetch_object(pg_query_params("select * from pizzas where id = $1", array($participant->pizza));
          echo '<tr><td class="texte">', $participant->pseudo ,'</td><td class="texte">', $pizza->nom, '</td><td class="texte">', $pizza->prix, '.-</td><td class="texte">', ($participant->info->admin?'<a href="?page=pizzas&stats=1&paye=' . $participant->id . '">':''), ($participant->pizza_paye?'payé':'non payé !'), ($participant->info->admin?'</a>':'') ,'</td></tr>';
       }
       else
@@ -122,24 +122,24 @@ function liens()
 
 
 echo '<div id="pizzas">';
-if ($participant->valide) // le participant est loggé
+if ($participant->existe()) // le participant est loggé
 {
    // Si demande d'effacer les commande et que le gars est admin, le fait
    if(isset($_GET['reset']) && $participant->info->admin)
    {
-      mysql_query("update participants set pizza = null, pizza_paye = 0");
+      pg_query("update participants set pizza = null, pizza_paye = 0");
       $participant->info->pizza = -1; //mettre a jour le participants courant pour la beaute de l'affichage
    }
       
    if(isset($_GET['paye']) && $participant->info->admin)
    {  
       /////// methode d'inversion
-      // $gars = mysql_fetch_object(mysql_query("select * from participants where id = " . $paye));
-      // mysql_query("update participants set pizza_paye = " . (1 - $gars->pizza_paye) . " where id = " . $paye);
+      // $gars = pg_fetch_object(pg_query_params("select * from participants where id = $1", array($paye)));
+      // pg_query_object("update participants set pizza_paye = $1 where id = $2", array(1 - $gars->pizza_paye, $paye));
       ///////
       
       /////// methode d'un unique changement : non-paye -> paye
-      mysql_query("update participants set pizza_paye = 1 where id = " . $_GET['paye']);
+      pg_query_params("update participants set pizza_paye = 1 where id = $1", array($_GET['paye']));
       ///////
    }
       
@@ -158,7 +158,7 @@ if ($participant->valide) // le participant est loggé
             echo 'Aucune pizza commandée !'; // la pizza est '-1' donc pas de pizza commandée         
             $pizza_id = "NULL";
          }
-         mysql_query("update participants set pizza = " . $pizza_id . " where id = " . $participant->info->id);
+         pg_query_params("update participants set pizza = $1 where id = $2", array($pizza_id, $participant->info->id));
       }
       else
          selection_pizzas();