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

Timestamp:

02/16/2013 02:08:46 AM (12 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