Changeset 12333

Timestamp:

12/07/2009 06:09:11 PM (15 years ago)

Author:

markjaquith

Message:

Do not display comments on non-public posts in comments widget. props Denis-de-Bernardy. fixes #9211

File:

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

trunk/wp-includes/default-widgets.php

@@ -635 +635 @@
 
         if ( !$comments = wp_cache_get( 'recent_comments', 'widget' ) ) {
-            $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 15");
+            $comments = $wpdb->get_results("SELECT $wpdb->comments.* FROM $wpdb->comments JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID WHERE comment_approved = '1' AND post_status = 'publish' ORDER BY comment_date_gmt DESC LIMIT 15");
             wp_cache_add( 'recent_comments', $comments, 'widget' );
         }