From e13f9e123b368575ff49b155d2f9802f30e2043f Mon Sep 17 00:00:00 2001
From: "Pierre Habouzit (MadCoder" <pierre.habouzit@m4x.org>
Date: Thu, 30 Dec 2004 09:12:06 +0000
Subject: [PATCH] no more mysql_query in the whole thing

git-archimport-id: opensource@polytechnique.org--2005/platal--mainline--0.9--patch-192
---
 htdocs/banana/include/profile.inc.php   | 28 +++++++++++++---------------
 htdocs/banana/include/session.inc.php   | 30 +++++++++++++++---------------
 htdocs/banana/include/subscribe.inc.php | 18 ++++++++++--------
 3 files changed, 38 insertions(+), 38 deletions(-)

diff --git a/htdocs/banana/include/profile.inc.php b/htdocs/banana/include/profile.inc.php
index 034d870..95212ff 100644
--- a/htdocs/banana/include/profile.inc.php
+++ b/htdocs/banana/include/profile.inc.php
@@ -27,11 +27,12 @@ function getprofile() {
         global $globals;
         
         $uid = Session::getInt('uid');
-	$req = mysql_query("SELECT  nom,mail,sig,if(FIND_IN_SET('threads',flags),'1','0'),
-				    IF(FIND_IN_SET('automaj',flags),'1','0') 
-			      FROM  {$globals->banana->table_prefix}profils
-			     WHERE  uid=$uid");
-	if (!(list($nom,$mail,$sig,$disp,$maj)=mysql_fetch_row($req))) {
+	$req = $globals->xdb->query(
+                "SELECT  nom,mail,sig,if(FIND_IN_SET('threads',flags),'1','0'),
+                         IF(FIND_IN_SET('automaj',flags),'1','0') 
+                   FROM  {$globals->banana->table_prefix}profils
+                  WHERE  uid={?}", $uid);
+	if (!(list($nom,$mail,$sig,$disp,$maj) = $req->fetchOneRow())) {
 	    $nom  = Session::get('prenom')." ".Session::get('nom');
 	    $mail = Session::get('forlife')."@polytechnique.org";
 	    $sig  = $nom." (".Session::getInt('promo').")";
@@ -47,17 +48,14 @@ function getprofile() {
 	$array['lastnews']  = Session::get('banana_last');
 	$array['dropsig']   = true;
 	if ($maj) {
-	    mysql_query("UPDATE auth_user_quick SET banana_last='"
-		.gmdate("YmdHis")."' WHERE user_id=$uid");
-	}
-	$req=mysql_query("SELECT  nom
-	                    FROM  {$globals->banana->table_prefix}abos
-		       LEFT JOIN  {$globals->banana->table_prefix}list ON list.fid=abos.fid
-		           WHERE  uid=$uid");
-	$array['subscribe']=array();
-	while (list($fnom)=mysql_fetch_array($req)) {
-	    array_push($array['subscribe'],$fnom);
+            $globals->xdb->execute("UPDATE auth_user_quick SET banana_last={?} WHERE user_id={?}", gmdate("YmdHis"), $uid);
 	}
+	$req = $globals->xdb->query(
+                "SELECT  nom
+                   FROM  {$globals->banana->table_prefix}abos
+              LEFT JOIN  {$globals->banana->table_prefix}list ON list.fid=abos.fid
+                  WHERE  uid={?}", $uid);
+	$array['subscribe'] = $req->fetchColumn();
     } else {
 	$array = array();
     }
diff --git a/htdocs/banana/include/session.inc.php b/htdocs/banana/include/session.inc.php
index 492d10e..f2148fe 100644
--- a/htdocs/banana/include/session.inc.php
+++ b/htdocs/banana/include/session.inc.php
@@ -1,31 +1,31 @@
 <?php
 /********************************************************************************
-* include/session.inc.php : sessions for profile
-* -------------------------
-*
-* This file is part of the banana distribution
-* Copyright: See COPYING files that comes with this distribution
-********************************************************************************/
+ * include/session.inc.php : sessions for profile
+ * -------------------------
+ *
+ * This file is part of the banana distribution
+ * Copyright: See COPYING files that comes with this distribution
+ ********************************************************************************/
 
 $sname = $_SERVER['SCRIPT_NAME'];
 $array = explode('/',$sname);
 $sname = array_pop($array);
 unset($array);
 switch ($sname) {
-    case "thread.php":
+    case 'thread.php':
         if (!Session::has('bananapostok')) {
-            $_SESSION['bananapostok']=true;
+            $_SESSION['bananapostok'] = true;
         }
-    break;
-    
-    case "index.php":
+        break;
+
+    case 'index.php':
         if (Get::get('banana') == 'updateall') {
-            mysql_query("UPDATE auth_user_quick SET banana_last='"
-                    .gmdate("YmdHis")."' WHERE user_id=".Session::getInt('uid'));
-            $_SESSION["banana_last"]=time();
+            $globals->xdb->execute('UPDATE auth_user_quick SET banana_last={?} WHERE user_id={?}', gmdate('YmdHis'), Session::getInt('uid'));
+            $_SESSION['banana_last'] = time();
         }
 
     default:
-    $_SESSION['bananapostok']=true;
+        $_SESSION['bananapostok'] = true;
 }
+
 ?>
diff --git a/htdocs/banana/include/subscribe.inc.php b/htdocs/banana/include/subscribe.inc.php
index 1a66fc9..6e86c65 100644
--- a/htdocs/banana/include/subscribe.inc.php
+++ b/htdocs/banana/include/subscribe.inc.php
@@ -8,16 +8,18 @@ function update_subscriptions($_subscriptions) {
     global $globals;
     $uid = Session::getInt('uid');
 
-    mysql_query("DELETE FROM {$globals->banana->table_prefix}abos WHERE uid='$uid'");
+    $globals->xdb->execute("DELETE FROM {$globals->banana->table_prefix}abos WHERE uid={?}", $uid);
     if (!count($_subscriptions)) {
         return true;
     }
+    
     // Récupération des fid
-    $req = mysql_query("SELECT fid,nom FROM {$globals->banana->table_prefix}list");
-    $fids=array();
-    while (list($fid,$fnom)=mysql_fetch_row($req)) {
-        $fids[$fnom]=$fid;
+    $req  = $globals->xdb->iterRow("SELECT fid,nom FROM {$globals->banana->table_prefix}list");
+    $fids =array();
+    while (list($fid,$fnom) = $req->next()) {
+        $fids[$fnom] = $fid;
     }
+
     // MAJ table de forums
     if (count(array_keys($fids))) {
         $diff = array_diff($_subscriptions,array_keys($fids));
@@ -26,13 +28,13 @@ function update_subscriptions($_subscriptions) {
     }
     if (count($diff)) {
         foreach ($diff as $g) {
-            mysql_query("INSERT INTO {$globals->banana->table_prefix}list (nom) VALUES ('$g')");
-            $fids[$g]=mysql_insert_id();
+            $globals->xdb->execute("INSERT INTO {$globals->banana->table_prefix}list (nom) VALUES ({?})", $g);
+            $fids[$g] = mysql_insert_id();
         }
     }
     // MAJ Abonnements
     foreach ($_subscriptions as $g) {
-        mysql_query("REPLACE INTO {$globals->banana->table_prefix}abos (fid,uid) VALUES ('{$fids[$g]}','$uid')");
+        $globals->xdb->execute("REPLACE INTO {$globals->banana->table_prefix}abos (fid,uid) VALUES ({?},{?})", $fids[$g], $uid);
     }
 }
 
-- 
2.1.4