Changeset 38497 for branches/4.6/src/wp-includes/class-wp-comment-query.php

Timestamp:

09/01/2016 03:14:16 PM (8 years ago)

Author:

jeremyfelt

Message:

Comments: Don't do direct SQL query when fetching decendants.

The SQL query was built using the clauses compiled when querying for
top-level comments. But in cases where the top-level comment query
results are already in the cache, the SQL clauses are not built, and
so are unavailable for fill_descendants(). Instead, we call
get_comments(), using modified versions of the parameters passed
to the main WP_Comment_Query class.

Merge of [38446] to the 4.6 branch.

Props boonebgorges, Akeif, Rarst for testing.
Fixes #37696.

Location:

branches/4.6

Files:

• . (modified) (1 prop)
• src/wp-includes/class-wp-comment-query.php (modified) (1 diff)

branches/4.6/src/wp-includes/class-wp-comment-query.php

@@ -996 +996 @@
 
             if ( $uncached_parent_ids ) {
-                $where = 'WHERE ' . $_where . ' AND comment_parent IN (' . implode( ',', array_map( 'intval', $uncached_parent_ids ) ) . ')';
-                $level_comments = $wpdb->get_results( "SELECT $wpdb->comments.comment_ID, $wpdb->comments.comment_parent {$this->sql_clauses['from']} {$where} {$this->sql_clauses['groupby']} ORDER BY comment_date_gmt ASC, comment_ID ASC" );
+                // Fetch this level of comments.
+                $parent_query_args = $this->query_vars;
+                foreach ( $exclude_keys as $exclude_key ) {
+                    $parent_query_args[ $exclude_key ] = '';
+                }
+                $parent_query_args['parent__in']    = $uncached_parent_ids;
+                $parent_query_args['no_found_rows'] = true;
+                $parent_query_args['hierarchical']  = false;
+
+                $level_comments = get_comments( $parent_query_args );
 
                 // Cache parent-child relationships.