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'
                 ");
         }