WordPress.org

Make WordPress Core

Changeset 12333


Ignore:
Timestamp:
12/07/09 18:09:11 (4 years ago)
Author:
markjaquith
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-includes/default-widgets.php

    r12209 r12333  
    635635 
    636636        if ( !$comments = wp_cache_get( 'recent_comments', 'widget' ) ) { 
    637             $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 15"); 
     637            $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"); 
    638638            wp_cache_add( 'recent_comments', $comments, 'widget' ); 
    639639        } 
Note: See TracChangeset for help on using the changeset viewer.