Changeset 17667

Timestamp:

04/20/2011 06:02:41 PM (13 years ago)

Author:

ryan

Message:

Allow retrieving comments by post type, status, author, author, name, or parent. Fetch only published posts for recent comments widget. Props filosofo. fixes #16506 #12904

Location:

trunk/wp-includes

Files:

• comment.php (modified) (2 diffs)
• default-widgets.php (modified) (1 diff)

trunk/wp-includes/comment.php

@@ -214 +214 @@
             'post_ID' => '',
             'post_id' => 0,
+            'post_author' => '',
+            'post_name' => '',
+            'post_parent' => '',
+            'post_status' => '',
+            'post_type' => '',
             'status' => '',
             'type' => '',
@@ -320 +325 @@
             $where .= $this->get_search_sql( $search, array( 'comment_author', 'comment_author_email', 'comment_author_url', 'comment_author_IP', 'comment_content' ) );
 
+        $post_fields = array_filter( compact( array( 'post_author', 'post_name', 'post_parent', 'post_status', 'post_type', ) ) );
+        if ( ! empty( $post_fields ) ) {
+            $join = "JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID";
+            foreach( $post_fields as $field_name => $field_value )
+                $where .= $wpdb->prepare( " AND {$wpdb->posts}.{$field_name} = %s", $field_value );
+        }
+
         $pieces = array( 'fields', 'join', 'where', 'orderby', 'order', 'limits' );
         $clauses = apply_filters_ref_array( 'comments_clauses', array( compact( $pieces ), &$this ) );

trunk/wp-includes/default-widgets.php

@@ -641 +641 @@
             $number = 5;
 
-        $comments = get_comments( array( 'number' => $number, 'status' => 'approve' ) );
+        $comments = get_comments( array( 'number' => $number, 'status' => 'approve', 'post_status' => 'publish' ) );
         $output .= $before_widget;
         if ( $title )