Changeset 6994 for trunk/wp-includes/comment.php

Timestamp:

02/23/2008 08:33:44 AM (18 years ago)

Author:

ryan

Message:

Manage comments rework. WIP

File:

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

trunk/wp-includes/comment.php

@@ -445 +445 @@
         }
         return false;
+}
+
+function wp_count_comments() {
+        global $wpdb;
+
+        $count = $wpdb->get_results( "SELECT comment_approved, COUNT( * ) AS num_comments FROM {$wpdb->comments} GROUP BY comment_approved", ARRAY_A );
+
+        $stats = array( );
+        $approved = array('0' => 'moderated', '1' => 'approved', 'spam' => 'spam');
+        foreach( (array) $count as $row_num => $row ) {
+                $stats[$approved[$row['comment_approved']]] = $row['num_comments'];
+        }
+
+        foreach ( $approved as $key ) {
+                if ( empty($stats[$key]) )
+                        $stats[$key] = 0;
+        }
+
+        return (object) $stats;
 }