Changeset 15887

Timestamp:

10/21/2010 02:03:25 PM (14 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'] )