Changeset 3091 for trunk/wp-includes/functions-post.php

Timestamp:

11/15/2005 04:31:24 PM (21 years ago)

Author:

ryan

Message:

Update category counts. Props donncha. fixes #1886

File:

• trunk/wp-includes/functions-post.php (modified) (2 diffs)

trunk/wp-includes/functions-post.php

@@ -168 +168 @@
         if ($post_status == 'publish') {
                 do_action('publish_post', $post_ID);
+
+                // Update category counts.
+                foreach ( $post_category 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'");
+                        wp_cache_delete($cat_id, 'category');           
+                }
+
                 if ($post_pingback && !defined('WP_IMPORTING'))
                         $result = $wpdb->query("
@@ -478 +486 @@
         do_action('delete_post', $postid);
 
+        if ( 'publish' == $post->post_status) {
+                $categories = wp_get_post_cats('', $post->ID);
+                if( is_array( $categories ) ) {
+                        foreach ( $categories as $cat_id ) {
+                                $wpdb->query("UPDATE $wpdb->categories SET category_count = category_count - 1 WHERE cat_ID = '$cat_id'");
+                                wp_cache_delete($cat_id, 'category');
+                        }
+                }
+        }
+
         if ( 'static' == $post->post_status )
                 $wpdb->query("UPDATE $wpdb->posts SET post_parent = $post->post_parent WHERE post_parent = $postid AND post_status = 'static'");