Changeset 29808 for trunk/src/wp-includes/comment.php

Timestamp:

10/02/2014 01:40:56 AM (6 years ago)

Author:

boonebgorges

Message:

WP_Comment_Query: commentin, commentnot_in, postin, postnot_in.

Props nofearinc, mordauk, boonebgorges

Fixes #25386

File:

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

trunk/src/wp-includes/comment.php

@@ -258 +258 @@
      *
      * @since 3.1.0
+     * @since 4.1.0 Introduced 'comment__in', 'comment__not_in',
+     *              'post__in', and 'post__not_in' to $query_vars.
      *
      * @param string|array $query_vars
@@ -269 +271 @@
             'fields' => '',
             'ID' => '',
+            'comment__in' => '',
+            'comment__not_in' => '',
             'karma' => '',
             'number' => '',
@@ -277 +281 @@
             'post_ID' => '',
             'post_id' => 0,
+            'post__in' => '',
+            'post__not_in' => '',
             'post_author' => '',
             'post_name' => '',
@@ -409 +415 @@
         }
 
+        // Parse comment IDs for an IN clause.
+        if ( ! empty( $this->query_vars['comment__in'] ) ) {
+            $where .= ' AND comment_ID IN ( ' . implode( ',', wp_parse_id_list( $this->query_vars['comment__in'] ) ) . ' )';
+        }
+
+        // Parse comment IDs for a NOT IN clause.
+        if ( ! empty( $this->query_vars['comment__not_in'] ) ) {
+            $where .= ' AND comment_ID NOT IN ( ' . implode( ',', wp_parse_id_list( $this->query_vars['comment__not_in'] ) ) . ' )';
+        }
+
+        // Parse comment post IDs for an IN clause.
+        if ( ! empty( $this->query_vars['post__in'] ) ) {
+            $where .= ' AND comment_post_ID IN ( ' . implode( ',', wp_parse_id_list( $this->query_vars['post__in'] ) ) . ' )';
+        }
+
+        // Parse comment post IDs for a NOT IN clause.
+        if ( ! empty( $this->query_vars['post__not_in'] ) ) {
+            $where .= ' AND comment_post_ID NOT IN ( ' . implode( ',', wp_parse_id_list( $this->query_vars['post__not_in'] ) ) . ' )';
+        }
+
         if ( '' !== $this->query_vars['author_email'] ) {
             $where .= $wpdb->prepare( ' AND comment_author_email = %s', $this->query_vars['author_email'] );