Changeset 6079 for trunk/wp-admin/import/wp-cat2tag.php

Timestamp:

09/11/2007 07:33:35 PM (17 years ago)

Author:

ryan

Message:

Retain default category when converting categories to tags. fixes #4845

File:

• trunk/wp-admin/import/wp-cat2tag.php (modified) (1 diff)

trunk/wp-admin/import/wp-cat2tag.php

@@ -127 +127 @@
                 }
 
-                // Set the category itself to $type from above
-                $wpdb->query("UPDATE $wpdb->term_taxonomy SET taxonomy = 'post_tag' WHERE term_id = '{$category->term_id}' AND taxonomy = 'category'");
-
-                // Set all parents to 0 (root-level) if their parent was the converted tag
-                $wpdb->query("UPDATE $wpdb->term_taxonomy SET parent = 0 WHERE parent = '{$category->term_id}' AND taxonomy = 'category'");
-
+                // If the category is the default, leave category in place and create tag.
+                if ( get_option('default_category') == $category->term_id ) {
+                    $id = wp_insert_term($category->name, 'post_tag', array('slug' => $category->slug));
+                    $id = $id['term_taxonomy_id'];
+                    $posts = get_objects_in_term($category->term_id, 'category');
+                    foreach ( $posts as $post ) {
+                        if ( !$wpdb->get_var("SELECT object_id FROM $wpdb->term_relationships WHERE object_id = '$post' AND term_taxonomy_id = '$id'") )                        
+                            $wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id) VALUES ('$post', '$id')");
+                    }
+                } else {
+                    // Change the category to a tag.
+                    $wpdb->query("UPDATE $wpdb->term_taxonomy SET taxonomy = 'post_tag' WHERE term_id = '{$category->term_id}' AND taxonomy = 'category'");
+
+                    // Set all parents to 0 (root-level) if their parent was the converted tag
+                    $wpdb->query("UPDATE $wpdb->term_taxonomy SET parent = 0 WHERE parent = '{$category->term_id}' AND taxonomy = 'category'");
+                }
                 // Clean the cache
                 clean_category_cache($category->term_id);