Changeset 7775

Timestamp:

04/22/2008 09:26:01 PM (18 years ago)

Author:

ryan

Message:

Consolidate get_pending_comments_num() queries. see #6770

Location:

trunk/wp-admin

Files:

• edit-post-rows.php (modified) (2 diffs)
• includes/comment.php (modified) (1 diff)

trunk/wp-admin/edit-post-rows.php

@@ -23 +23 @@
 $bgcolor = '';
 add_filter('the_title','wp_specialchars');
+
+// Create array of post IDs.
+$post_ids = array();
+foreach ( $wp_query->posts as $a_post )
+    $post_ids[] = $a_post->ID;
+
+$comment_pending_count = get_pending_comments_num($post_ids);
+
 while (have_posts()) : the_post();
 $class = 'alternate' == $class ? '' : 'alternate';
@@ -114 +122 @@
         <td class="num"><div class="post-com-count-wrapper">
         <?php
-        $left = get_pending_comments_num( $post->ID );
+        $left = isset($comment_pending_count) ? $comment_pending_count[$post->ID] : 0;
         $pending_phrase = sprintf( __('%s pending'), number_format( $left ) );
         if ( $left )

trunk/wp-admin/includes/comment.php

@@ -67 +67 @@
 function get_pending_comments_num( $post_id ) {
     global $wpdb;
-    $post_id = (int) $post_id;
-    $pending = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '0'", $post_id) );
-    return $pending;
+
+    $single = false;
+    if ( !is_array($post_id) ) {
+        $post_id = (array) $post_id;
+        $single = true;
+    }
+    $post_id = array_map('intval', $post_id);
+    $post_id = "'" . implode("', '", $post_id) . "'";
+
+    $pending = $wpdb->get_results( "SELECT comment_post_ID, COUNT(comment_ID) as num_comments FROM $wpdb->comments WHERE comment_post_ID IN ( $post_id ) AND comment_approved = '0' GROUP BY comment_post_ID", ARRAY_N );
+
+    if ( empty($pending) )
+        return 0;
+
+    if ( $single )
+        return $pending[0][1];
+
+    $pending_keyed = array();
+    foreach ( $pending as $pend )
+        $pending_keyed[$pend[0]] = $pend[1];
+
+    return $pending_keyed;
 }