Changeset 5090 for trunk/wp-admin/admin-db.php

Timestamp:

03/23/2007 02:16:16 AM (19 years ago)

Author:

ryan

Message:

Castaways on Gilligan's Isle

File:

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

trunk/wp-admin/admin-db.php

@@ -246 +246 @@
                 return 0;
 
-        return $wpdb->get_var("SELECT cat_ID FROM $wpdb->categories WHERE category_nicename = '$category_nicename'");
+        return (int) $wpdb->get_var("SELECT cat_ID FROM $wpdb->categories WHERE category_nicename = '$category_nicename'");
 }
 
@@ -299 +299 @@
         if ( !empty($link_id) )
                 $update = true;
+
+        $link_id = (int) $link_id;
 
         if( trim( $link_name ) == '' )
@@ -444 +446 @@
                 SELECT category_id
                 FROM $wpdb->link2cat
-                WHERE link_id = $link_ID");
+                WHERE link_id = '$link_ID'");
 
         if (!$old_categories) {
@@ -457 +459 @@
         if ($delete_cats) {
                 foreach ($delete_cats as $del) {
+                        $del = (int) $del;
                         $wpdb->query("
                                 DELETE FROM $wpdb->link2cat
-                                WHERE category_id = $del
-                                        AND link_id = $link_ID
+                                WHERE category_id = '$del'
+                                        AND link_id = '$link_ID'
                                 ");
                 }