Changeset 1204 for trunk/wp-admin/categories.php

Timestamp:

04/28/2004 08:57:11 AM (22 years ago)

Author:

saxmatt

Message:

Bug fixes and version bump.

File:

• trunk/wp-admin/categories.php (modified) (4 diffs)

trunk/wp-admin/categories.php

@@ -67 +67 @@
     $cat_name = get_catname($cat_ID);
     $cat_name = addslashes($cat_name);
-    $category = $wpdb->get_row("SELECT * FROM $tablecategories WHERE cat_ID = " . $cat_ID);
+    $category = $wpdb->get_row("SELECT * FROM $tablecategories WHERE cat_ID = '$cat_ID'");
     $cat_parent = $category->category_parent;
 
@@ -76 +76 @@
         die (__('Cheatin’ uh?'));
 
-    $wpdb->query("DELETE FROM $tablecategories WHERE cat_ID = $cat_ID");
-    $wpdb->query("UPDATE $tablecategories SET category_parent=$cat_parent WHERE category_parent=$cat_ID");
+    $wpdb->query("DELETE FROM $tablecategories WHERE cat_ID = '$cat_ID'");
+    $wpdb->query("UPDATE $tablecategories SET category_parent = '$cat_parent' WHERE category_parent = '$cat_ID'");
     $wpdb->query("UPDATE $tablepost2cat SET category_id='1' WHERE category_id='$cat_ID'");
 
@@ -87 +87 @@
 
     require_once ('admin-header.php');
-    $category = $wpdb->get_row("SELECT * FROM $tablecategories WHERE cat_ID = " . $_GET['cat_ID']);
+    $category = $wpdb->get_row("SELECT * FROM $tablecategories WHERE cat_ID = '{$_GET['cat_ID']}'");
     $cat_name = stripslashes($category->cat_name);
     ?>
@@ -128 +128 @@
     $category_description = $wpdb->escape(stripslashes($_POST['category_description']));
 
-    $wpdb->query("UPDATE $tablecategories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent = $cat WHERE cat_ID = $cat_ID");
+    $wpdb->query("UPDATE $tablecategories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent = '$cat' WHERE cat_ID = '$cat_ID'");
     
     header('Location: categories.php?message=3');