Changeset 3012

Timestamp:

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

Author:

ryan

Message:

Add LIMIT 1 to some of our gets.

Location:

trunk/wp-includes

Files:

• functions.php (modified) (4 diffs)
• pluggable-functions.php (modified) (1 diff)

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 {

trunk/wp-includes/pluggable-functions.php

@@ -38 +38 @@
                 return $user;
 
-        if ( !$user = $wpdb->get_row("SELECT * FROM $wpdb->users WHERE ID = '$user_id'") )
+        if ( !$user = $wpdb->get_row("SELECT * FROM $wpdb->users WHERE ID = '$user_id' LIMIT 1") )
                 return false;