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

Timestamp:

11/16/2005 06:29:36 AM (20 years ago)

Author:

ryan

Message:

Add comment_count to the posts table. Props donncha. fixes #1860

File:

• trunk/wp-admin/upgrade-functions.php (modified) (2 diffs)

trunk/wp-admin/upgrade-functions.php

@@ -31 +31 @@
     }
     
-    if ( $wp_current_db_version < 3092 )
+    if ( $wp_current_db_version < 3104 )
         upgrade_160();
 
@@ -301 +301 @@
         }
     }
-    
+
+    // 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" );
+    if( is_array( $comments ) ) {
+        foreach ($comments as $comment) {
+            $wpdb->query( "UPDATE $wpdb->posts SET comment_count = $comment->c WHERE ID = '$comment->comment_post_ID}'" );
+        }
+    }
+
     // Some alpha versions used a post status of object instead of attachment and put
     // the mime type in post_type instead of post_mime_type.