Changeset 3091

Timestamp:

11/15/05 16:31:24 (3 years ago)

Author:

ryan

Message:

Update category counts. Props donncha. fixes #1886

Files:

• trunk/wp-admin/upgrade-functions.php (modified) (2 diffs)
• trunk/wp-includes/functions-post.php (modified) (2 diffs)
• trunk/wp-includes/version.php (modified) (1 diff)

trunk/wp-admin/upgrade-functions.php

@@ -31 +31 @@
-    }
-    
-2966
+3091
-        upgrade_160();
-
@@ -297 +297 @@
-        $categories = $wpdb->get_col("SELECT cat_ID FROM $wpdb->categories");
-        foreach ( $categories as $cat_id ) {
- WHERE
+, $wpdb->posts WHERE $wpdb->posts.ID=$wpdb->post2cat.post_id AND post_status='publish' AND
-            $wpdb->query("UPDATE $wpdb->categories SET category_count = '$count' WHERE cat_ID = '$cat_id'");
-        }

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'");

trunk/wp-includes/version.php

@@ -4 +4 @@
-
-$wp_version = '1.6-ALPHA-2-still-dont-use';
-2966
+3091
-
-?>