Changeset 3192 for trunk/wp-admin/upgrade-functions.php

Timestamp:

11/22/2005 03:40:32 AM (19 years ago)

Author:

ryan

Message:

Count only approved comments. Props Mark JAquith. fixes #1930

File:

• trunk/wp-admin/upgrade-functions.php (modified) (1 diff)

trunk/wp-admin/upgrade-functions.php

@@ -303 +303 @@
 
     // populate comment_count field of posts table
-    $comments = $wpdb->get_results( "SELECT comment_post_ID, COUNT(*) as c FROM $wpdb->comments GROUP BY comment_post_ID" );
+    $comments = $wpdb->get_results( "SELECT comment_post_ID, COUNT(*) as c FROM $wpdb->comments WHERE comment_approved = '1' GROUP BY comment_post_ID" );
     if( is_array( $comments ) ) {
         foreach ($comments as $comment) {