Changeset 587 for trunk/admin/picture_modify.php

Timestamp:

Oct 30, 2004, 5:42:29 PM (20 years ago)

Author:

z0rglub

Message:

• function mysql_query replaced by pwg_query : the same with debugging features

• by default, DEBUG is set to 0 (off)

File:

• trunk/admin/picture_modify.php (modified) (11 diffs)

trunk/admin/picture_modify.php

@@ -83 +83 @@
   $query.= ' WHERE id = '.$_GET['image_id'];
   $query.= ';';
-  mysql_query($query);
+  pwg_query($query);
   // make the picture representative of a category ?
   $query = '
@@ -91 +91 @@
     AND image_id = '.$_GET['image_id'].'
 ;';
-  $result = mysql_query($query);
+  $result = pwg_query($query);
   while ($row = mysql_fetch_array($result))
   {
@@ -103 +103 @@
       $query.= ' WHERE id = '.$row['category_id'];
       $query.= ';';
-      mysql_query($query);
+      pwg_query($query);
     }
     // if the user ask this picture to be not any more the representative,
@@ -115 +115 @@
   WHERE id = '.$row['category_id'].'
 ;';
-      mysql_query($query);
+      pwg_query($query);
     }
   }
@@ -134 +134 @@
   WHERE id = '.$_POST['associate'].'
 ;';
-      if (mysql_num_rows(mysql_query($query)) == 0)
+      if (mysql_num_rows(pwg_query($query)) == 0)
         array_push($errors, $lang['cat_unknown_id']);
     }
@@ -148 +148 @@
   ('.$_POST['associate'].','.$_GET['image_id'].')
 ;';
-    mysql_query($query);
+    pwg_query($query);
     $associate_or_dissociate = true;
     update_category($_POST['associate']);
@@ -159 +159 @@
   WHERE image_id = '.$_GET['image_id'].'
 ;';
-  $result = mysql_query($query);
+  $result = pwg_query($query);
   while ($row = mysql_fetch_array($result))
   {
@@ -169 +169 @@
   AND category_id = '.$row['category_id'].'
 ;';
-      mysql_query($query);
+      pwg_query($query);
       $associate_or_dissociate = true;
       update_category($row['category_id']);
@@ -186 +186 @@
   WHERE id = '.$_GET['image_id'].'
 ;';
-$row = mysql_fetch_array(mysql_query($query));
+$row = mysql_fetch_array(pwg_query($query));
 
 if (empty($row['name']))
@@ -217 +217 @@
     AND category_id = id
 ;';
-$result = mysql_query($query);
+$result = pwg_query($query);
 $categories = '';
 while ($cat_row = mysql_fetch_array($result))
@@ -287 +287 @@
 $query = 'SELECT COUNT(id) AS nb_total_categories';
 $query.= ' FROM '.CATEGORIES_TABLE.';';
-$row = mysql_fetch_array(mysql_query($query));
+$row = mysql_fetch_array(pwg_query($query));
 if ($row['nb_total_categories'] < $conf['max_LOV_categories'])
 {