Changeset 3012 for trunk/wp-includes/functions.php

Timestamp:

11/07/2005 11:09:09 PM (19 years ago)

Author:

ryan

Message:

Add LIMIT 1 to some of our gets.

File:

• trunk/wp-includes/functions.php (modified) (4 diffs)

trunk/wp-includes/functions.php

@@ -558 +558 @@
             $_post = & $post_cache[$post];
         else {
-            $query = "SELECT * FROM $wpdb->posts WHERE ID = '$post'";
+            $query = "SELECT * FROM $wpdb->posts WHERE ID = '$post' LIMIT 1";
             $post_cache[$post] = & $wpdb->get_row($query);
             $_post = & $post_cache[$post];
@@ -597 +597 @@
             // Got it.
         } else {
-            $query = "SELECT * FROM $wpdb->posts WHERE ID= '$page'";
+            $query = "SELECT * FROM $wpdb->posts WHERE ID= '$page' LIMIT 1";
             $_page = & $wpdb->get_row($query);
             wp_cache_add($_page->ID, $_page, 'pages');
@@ -641 +641 @@
     } else {
         if ( ! $_category = wp_cache_get($category, 'category') ) {
-            $_category = $wpdb->get_row("SELECT * FROM $wpdb->categories WHERE cat_ID = '$category'");
+            $_category = $wpdb->get_row("SELECT * FROM $wpdb->categories WHERE cat_ID = '$category' LIMIT 1");
             wp_cache_add($category, $_category, 'category');
         }
@@ -676 +676 @@
     } else {
         if ( !isset($comment_cache[$comment]) ) {
-            $_comment = $wpdb->get_row("SELECT * FROM $wpdb->comments WHERE comment_ID = '$comment'");
+            $_comment = $wpdb->get_row("SELECT * FROM $wpdb->comments WHERE comment_ID = '$comment' LIMIT 1");
             $comment_cache[$comment->comment_ID] = & $_comment;
         } else {