Changeset 36224

Timestamp:

01/08/2016 09:51:50 PM (9 years ago)

Author:

boonebgorges

Message:

Introduce 'author_url' param to WP_Comment_Query.

Props swissspidy.
Fixes #35377.

Location:

trunk

Files:

• src/wp-includes/class-wp-comment-query.php (modified) (4 diffs)
• tests/phpunit/tests/comment/query.php (modified) (1 diff)

trunk/src/wp-includes/class-wp-comment-query.php

@@ -140 +140 @@
      * @since 4.4.0 Order by `comment__in` was added. `$update_comment_meta_cache`, `$no_found_rows`,
      *              `$hierarchical`, and `$update_comment_post_cache` were added.
+     * @since 4.5.0 `$author_url` was added.
      * @access public
      *
@@ -146 +147 @@
      *
      *     @type string       $author_email              Comment author email address. Default empty.
+     *     @type string       $author_url                Comment author URL. Default empty.
      *     @type array        $author__in                Array of author IDs to include comments for. Default empty.
      *     @type array        $author__not_in            Array of author IDs to exclude comments for. Default empty.
@@ -246 +248 @@
         $this->query_var_defaults = array(
             'author_email' => '',
+            'author_url' => '',
             'author__in' => '',
             'author__not_in' => '',
@@ -671 +674 @@
         }
 
+        if ( '' !== $this->query_vars['author_url'] ) {
+            $this->sql_clauses['where']['author_url'] = $wpdb->prepare( 'comment_author_url = %s', $this->query_vars['author_url'] );
+        }
+
         if ( '' !== $this->query_vars['karma'] ) {
             $this->sql_clauses['where']['karma'] = $wpdb->prepare( 'comment_karma = %d', $this->query_vars['karma'] );

trunk/tests/phpunit/tests/comment/query.php

@@ -806 +806 @@
 
     /**
+     * @ticket 35377
+     */
+    public function test_get_comments_by_author_url() {
+        $c1 = self::factory()->comment->create( array( 'comment_post_ID' => $this->post_id, 'comment_author' => 'bar', 'comment_author_email' => 'bar@example.com', 'comment_author_url' => 'http://foo.bar' ) );
+        $c2 = self::factory()->comment->create( array( 'comment_post_ID' => $this->post_id, 'comment_author' => 'bar', 'comment_author_email' => 'bar@example.com', 'comment_author_url' => 'http://foo.bar' ) );
+        $c3 = self::factory()->comment->create( array( 'comment_post_ID' => $this->post_id, 'comment_author' => 'bar', 'comment_author_email' => 'bar@example.com', 'comment_author_url' => 'http://foo.bar/baz' ) );
+
+        $comments = get_comments( array(
+            'author_url' => 'http://foo.bar',
+        ) );
+
+        $this->assertCount( 2, $comments );
+        $this->assertSame( $c1, (int) $comments[0]->comment_ID );
+        $this->assertSame( $c2, (int) $comments[1]->comment_ID );
+    }
+
+    /**
      * @ticket 28434
      */