Changeset 3311

Timestamp:

12/15/2005 08:31:29 PM (20 years ago)

Author:

ryan

Message:

When changing a post's categories, redo category counts for both old and new cats. Props ringmaster. fixes #2085

File:

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

trunk/wp-includes/functions-post.php

@@ -505 +505 @@
     
     // Update category counts.
-    foreach ( $post_categories as $cat_id ) {
+    $all_affected_cats = array_unique(array_merge($post_categories, $old_categories));
+    foreach ( $all_affected_cats as $cat_id ) {
         $count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->post2cat, $wpdb->posts WHERE $wpdb->posts.ID=$wpdb->post2cat.post_id AND post_status='publish' AND category_id = '$cat_id'");
         $wpdb->query("UPDATE $wpdb->categories SET category_count = '$count' WHERE cat_ID = '$cat_id'");