Changeset 17667 for trunk/wp-includes/comment.php

Timestamp:

04/20/2011 06:02:41 PM (14 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

File:

• trunk/wp-includes/comment.php (modified) (2 diffs)

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 ) );