Changeset 12237

Timestamp:

11/20/2009 03:01:22 AM (15 years ago)

Author:

azaozz

Message:

Limit wp_get_recent_posts() to real/live posts, props josephscott, fixes #11123

File:

• trunk/wp-includes/post.php (modified) (1 diff)

trunk/wp-includes/post.php

@@ -1505 +1505 @@
     // Set the limit clause, if we got a limit
     $num = (int) $num;
-    if ($num) {
+    if ( $num ) {
         $limit = "LIMIT $num";
     }
 
-    $sql = "SELECT * FROM $wpdb->posts WHERE post_type = 'post' ORDER BY post_date DESC $limit";
-    $result = $wpdb->get_results($sql,ARRAY_A);
+    $sql = "SELECT * FROM $wpdb->posts WHERE post_type = 'post' AND post_status IN ( 'draft', 'publish', 'future', 'pending', 'private' ) ORDER BY post_date DESC $limit";
+    $result = $wpdb->get_results($sql, ARRAY_A);
 
     return $result ? $result : array();