Changeset 5815 for trunk/wp-admin/includes/upgrade.php

Timestamp:

07/21/2007 09:52:35 PM (17 years ago)

Author:

ryan

Message:

Recalculate counts

File:

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

trunk/wp-admin/includes/upgrade.php

@@ -671 +671 @@
     }
 
-    //  TODO: Recalculate all counts
+    // Recalculate all counts
+    $terms = $wpdb->get_col("SELECT term_taxonomy_id FROM $wpdb->term_taxonomy");
+    foreach ( (array) $terms as $term ) {
+        $count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = '$term'");
+        $wpdb->query("UPDATE $wpdb->term_taxonomy SET count = '$count' WHERE term_taxonomy_id = '$term'");
+    }
 }