Changeset 7775 for trunk/wp-admin/includes/comment.php

Timestamp:

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

Author:

ryan

Message:

Consolidate get_pending_comments_num() queries. see #6770

File:

• trunk/wp-admin/includes/comment.php (modified) (1 diff)

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;
 }