Changeset 23436 for trunk/wp-includes/query.php

Timestamp:

02/16/2013 02:08:46 AM (14 years ago)

Author:

nacin

Message:

WP_Query: post_parent__in and post_parent__not_in. props wonderboymusic. fixes #11056.

File:

• trunk/wp-includes/query.php (modified) (3 diffs)

trunk/wp-includes/query.php

@@ -1407 +1407 @@
                 }
 
-                $array_keys = array('category__in', 'category__not_in', 'category__and', 'post__in', 'post__not_in',
-                        'tag__in', 'tag__not_in', 'tag__and', 'tag_slug__in', 'tag_slug__and');
+                $array_keys = array( 'category__in', 'category__not_in', 'category__and', 'post__in', 'post__not_in',
+                        'tag__in', 'tag__not_in', 'tag__and', 'tag_slug__in', 'tag_slug__and', 'post_parent__in', 'post_parent__not_in' );
 
                 foreach ( $array_keys as $key ) {
@@ -2168 +2168 @@
                 }
 
-                if ( is_numeric($q['post_parent']) )
+                if ( is_numeric( $q['post_parent'] ) ) {
                         $where .= $wpdb->prepare( " AND $wpdb->posts.post_parent = %d ", $q['post_parent'] );
+                } elseif ( $q['post_parent__in'] ) {
+                        $post_parent__in = implode( ',', array_map( 'absint', $q['post_parent__in'] ) );
+                        $where .= " AND {$wpdb->posts}.post_parent IN ($post_parent__in)";
+                } elseif ( $q['post_parent__not_in'] ) {
+                        $post_parent__not_in = implode( ',',  array_map( 'absint', $q['post_parent__not_in'] ) );
+                        $where .= " AND {$wpdb->posts}.post_parent NOT IN ($post_parent__not_in)";
+                }
 
                 if ( $q['page_id'] ) {
@@ -2340 +2347 @@
                 } elseif ( $q['orderby'] == 'post__in' && ! empty( $post__in ) ) {
                         $orderby = "FIELD( {$wpdb->posts}.ID, $post__in )";
+                } elseif ( $q['orderby'] == 'post_parent__in' && ! empty( $post_parent__in ) ) {
+                        $orderby = "FIELD( {$wpdb->posts}.post_parent, $post_parent__in )";
                 } else {
                         // Used to filter values