Changeset 130 for branches/2.0singleton/services

Timestamp:

May 30, 2006 9:30:35 PM (18 years ago)

Author:

scdev

Message:

finished updating DB:: to $db->

File:

• branches/2.0singleton/services/admins.php (modified) (15 diffs)

branches/2.0singleton/services/admins.php

@@ -154 +154 @@
         if (getFormdata('repeat', false)) {
             // Display edit function with next available ID.
-            $qid = DB::query("SELECT admin_id FROM admin_tbl WHERE admin_id > '" . DB::escapeString(getFormData('admin_id')) . "' ORDER BY admin_id ASC LIMIT 1");
+            $qid = $db->query("SELECT admin_id FROM admin_tbl WHERE admin_id > '" . $db->escapeString(getFormData('admin_id')) . "' ORDER BY admin_id ASC LIMIT 1");
             if (list($next_id) = mysql_fetch_row($qid)) {
                 $app->dieURL($_SERVER['PHP_SELF'] . '?op=edit&admin_id=' . $next_id);
@@ -259 +259 @@
     global $lock;
     $app =& App::getInstance();
-
+    $db =& DB::getInstance();
+    
     $lock->select('admin_tbl', 'admin_id', $id);
     if ($lock->isLocked() && !$lock->isMine()) {
@@ -266 +267 @@
 
     // Get the information for the form.
-    $qid = DB::query("
+    $qid = $db->query("
         SELECT *
         FROM admin_tbl
-        WHERE admin_id = '" . DB::escapeString($id) . "'
+        WHERE admin_id = '" . $db->escapeString($id) . "'
     ");
     if (!$frm = mysql_fetch_assoc($qid)) {
@@ -315 +316 @@
     global $auth, $lock;
     $app =& App::getInstance();
-
+    $db =& DB::getInstance();
+    
     $lock->select('admin_tbl', 'admin_id', $id);
     if ($lock->isLocked() && !$lock->isMine()) {
@@ -325 +327 @@
 
     // Get the information for this object.
-    $qid = DB::query("
+    $qid = $db->query("
         SELECT username, user_type from admin_tbl
-        WHERE admin_id = '" . DB::escapeString($id) . "'
+        WHERE admin_id = '" . $db->escapeString($id) . "'
     ");
     if (! list($name, $user_type) = mysql_fetch_row($qid)) {
@@ -336 +338 @@
 
     // Get the information for this object.
-    $qid = DB::query("SELECT COUNT(*) from admin_tbl");
+    $qid = $db->query("SELECT COUNT(*) from admin_tbl");
     list($num_admins) = mysql_fetch_row($qid);
     if ('root' == $user_type && 'root' != $auth->getVal('user_type')) {
@@ -349 +351 @@
     } else {
         // Delete the record.
-        DB::query("DELETE FROM admin_tbl WHERE admin_id = '" . DB::escapeString($id) . "'");
+        $db->query("DELETE FROM admin_tbl WHERE admin_id = '" . $db->escapeString($id) . "'");
         $app->raiseMsg(sprintf(_("The admin <strong>%s</strong> has been deleted."), $name), MSG_SUCCESS, __FILE__, __LINE__);
     }
@@ -361 +363 @@
     global $auth;
     $app =& App::getInstance();
-
+    $db =& DB::getInstance();
+    
     // Break the cache because we are changing the list data.
     SessionCache::breakCache($_SERVER['PHP_SELF']);
 
     // Insert record data.
-    DB::query("
+    $db->query("
         INSERT INTO admin_tbl (
             username,
@@ -376 +379 @@
             added_datetime
         ) VALUES (
-            '" . DB::escapeString($frm['username']) . "',
-            '" . DB::escapeString($frm['first_name']) . "',
-            '" . DB::escapeString($frm['last_name']) . "',
-            '" . DB::escapeString($frm['email']) . "',
-            '" . DB::escapeString($frm['user_type']) . "',
-            '" . DB::escapeString($auth->getVal('user_id')) . "',
+            '" . $db->escapeString($frm['username']) . "',
+            '" . $db->escapeString($frm['first_name']) . "',
+            '" . $db->escapeString($frm['last_name']) . "',
+            '" . $db->escapeString($frm['email']) . "',
+            '" . $db->escapeString($frm['user_type']) . "',
+            '" . $db->escapeString($auth->getVal('user_id')) . "',
             NOW()
         )
     ");
-    $last_insert_id = mysql_insert_id(DB::getDBH());
+    $last_insert_id = mysql_insert_id($db->getDBH());
 
     // Set admin password.
@@ -403 +406 @@
     global $auth, $lock;
     $app =& App::getInstance();
-
+    $db =& DB::getInstance();
+    
     $lock->select('admin_tbl', 'admin_id', $frm['admin_id']);
     if ($lock->isLocked() && !$lock->isMine()) {
@@ -419 +423 @@
 
     // Update record data.
-    DB::query("
+    $db->query("
         UPDATE admin_tbl SET
-            username = '" . DB::escapeString($frm['username']) . "',
-            first_name = '" . DB::escapeString($frm['first_name']) . "',
-            last_name = '" . DB::escapeString($frm['last_name']) . "',
-            email = '" . DB::escapeString($frm['email']) . "',
-            user_type = '" . DB::escapeString($frm['user_type']) . "',
-            modified_by_user_id = '" . DB::escapeString($auth->getVal('user_id')) . "',
+            username = '" . $db->escapeString($frm['username']) . "',
+            first_name = '" . $db->escapeString($frm['first_name']) . "',
+            last_name = '" . $db->escapeString($frm['last_name']) . "',
+            email = '" . $db->escapeString($frm['email']) . "',
+            user_type = '" . $db->escapeString($frm['user_type']) . "',
+            modified_by_user_id = '" . $db->escapeString($auth->getVal('user_id')) . "',
             modified_datetime = NOW()
-        WHERE admin_id = '" . DB::escapeString($frm['admin_id']) . "'
+        WHERE admin_id = '" . $db->escapeString($frm['admin_id']) . "'
     ");
 
@@ -445 +449 @@
     global $page;
     global $so;
+    $db =& DB::getInstance();
+    
 
     $where_clause = '';
@@ -454 +460 @@
             $where_clause .= (empty($where_clause) ? 'WHERE' : 'AND') . "
                 (
-                    admin_tbl.username LIKE '%" . DB::escapeString($qry_words[$i]) . "%'
-                    OR admin_tbl.first_name LIKE '%" . DB::escapeString($qry_words[$i]) . "%'
-                    OR admin_tbl.last_name LIKE '%" . DB::escapeString($qry_words[$i]) . "%'
-                    OR admin_tbl.email LIKE '%" . DB::escapeString($qry_words[$i]) . "%'
+                    admin_tbl.username LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
+                    OR admin_tbl.first_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
+                    OR admin_tbl.last_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
+                    OR admin_tbl.email LIKE '%" . $db->escapeString($qry_words[$i]) . "%'
                 )
             ";
@@ -464 +470 @@
 
     // Count the total number of records so we can do something about the page numbers.
-    $qid = DB::query("
+    $qid = $db->query("
         SELECT COUNT(*)
         FROM admin_tbl
@@ -505 +511 @@
     } else {
         // If the list is not already cached, query now.
-        $qid = DB::query($sql);
+        $qid = $db->query($sql);
         // Fill an array with the items for this page.
         while ($row = mysql_fetch_assoc($qid)) {