Changeset 15887

Timestamp:

10/21/2010 02:03:25 PM (16 years ago)

Author:

scribu

Message:

Allow filtering comments by user_id via URL. Props neoxx. Fixes #14163

Location:

trunk

Files:

• wp-admin/includes/default-list-tables.php (modified) (2 diffs)
• wp-includes/query.php (modified) (6 diffs)

trunk/wp-admin/includes/default-list-tables.php

@@ -2094 +2094 @@
                 $search = ( isset( $_REQUEST['s'] ) ) ? $_REQUEST['s'] : '';
 
+                $user_id = ( isset( $_REQUEST['user_id'] ) ) ? $_REQUEST['user_id'] : '';
+
                 $comments_per_page = $this->get_items_per_page( 'edit_comments_per_page' );
                 $comments_per_page = apply_filters( 'comments_per_page', $comments_per_page, $comment_status );
@@ -2114 +2116 @@
                         'status' => isset( $status_map[$comment_status] ) ? $status_map[$comment_status] : $comment_status,
                         'search' => $search,
+                        'user_id' => $user_id,
                         'offset' => $start,
                         'number' => $number,

trunk/wp-includes/query.php

@@ -1186 +1186 @@
                         , 's'
                         , 'sentence'
+                        , 'fields'
                 );
 
                 foreach ( $keys as $key ) {
-                        if ( !isset($array[$key]))
+                        if ( !isset($array[$key]) )
                                 $array[$key] = '';
                 }
@@ -1197 +1198 @@
 
                 foreach ( $array_keys as $key ) {
-                        if ( !isset($array[$key]))
+                        if ( !isset($array[$key]) )
                                 $array[$key] = array();
                 }
@@ -1649 +1650 @@
                 $search = '';
                 $groupby = '';
-                $fields = "$wpdb->posts.*";
+                $fields = '';
                 $post_status_join = false;
                 $page = 1;
@@ -1729 +1730 @@
                 else
                         $q['no_found_rows'] = false;
+
+                switch ( $q['fields'] ) {
+                        case 'ids':
+                                $fields = "$wpdb->posts.ID";
+                                break;
+                        case 'id=>parent':
+                                $fields = "$wpdb->posts.ID, $wpdb->posts.post_parent";
+                                break;
+                        default:
+                                $fields = "$wpdb->posts.*";
+                }
 
                 // If a month is specified in the querystring, load that month
@@ -2273 +2285 @@
                 if ( !empty( $orderby ) )
                         $orderby = 'ORDER BY ' . $orderby;
+
                 $found_rows = '';
                 if ( !$q['no_found_rows'] && !empty($limits) )
@@ -2281 +2294 @@
                         $this->request = apply_filters_ref_array('posts_request', array( $this->request, &$this ) );
 
+                if ( 'ids' == $q['fields'] ) {
+                        $this->posts = $wpdb->get_col($this->request);
+
+                        return $this->posts;
+                }
+
+                if ( 'id=>parent' == $q['fields'] ) {
+                        $this->posts = $wpdb->get_results($this->request);
+
+                        $r = array();
+                        foreach ( $this->posts as $post )
+                                $r[ $post->ID ] = $post->post_parent;
+
+                        return $r;
+                }
+
                 $this->posts = $wpdb->get_results($this->request);
+
                 // Raw results filter.  Prior to status checks.
                 if ( !$q['suppress_filters'] )