Changeset 5539

Timestamp:

05/24/2007 10:40:24 PM (19 years ago)

Author:

ryan

Message:

Category/tag to taxonomy upgrade. First cut.

Location:

trunk

Files:

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

trunk/wp-admin/upgrade-functions.php

@@ -186 +186 @@
                 upgrade_old_slugs();
         
-        if ( $wp_current_db_version < 5200 ) {
+        if ( $wp_current_db_version < 5539 )
                 upgrade_230();
-        }
+
         
         maybe_disable_automattic_widgets();
@@ -573 +573 @@
 
 function upgrade_230() {
-        global $wp_current_db_version;
+        global $wp_current_db_version, $wpdb;
         
         if ( $wp_current_db_version < 5200 ) {
                 populate_roles_230();
+        }
+
+        // Convert categories to terms.
+        $tt_ids = array();
+        $categories = $wpdb->get_results("SELECT * FROM $wpdb->categories");
+        foreach ($categories as $category) {
+                $term_id = (int) $category->cat_ID;
+                $name = $wpdb->escape($category->cat_name);
+                $description = $wpdb->escape($category->category_description);
+                $slug = $wpdb->escape($category->category_nicename);
+                $parent = $wpdb->escape($category->category_parent);
+                $wpdb->query("INSERT INTO $wpdb->terms (term_id, name, slug, term_group) VALUES ('$term_id', '$name', '$slug', '$term_group')");
+
+                if ( !empty($category->category_count) ) {
+                        $count = (int) $category->category_count;
+                        $taxonomy = 'category';
+                        $wpdb->query("INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('$term_id', '$taxonomy', '$description', '$parent', '$count')");
+                        $tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;
+                } else if ( !empty($category->link_count) ) {
+                        $count = (int) $category->link_count;
+                        $taxonomy = 'link_category';
+                        $wpdb->query("INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('$term_id', '$taxonomy', '$description', '$parent', '$count')");
+                        $tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;
+                } else if ( !empty($category->tag_count) ) {
+                        $count = (int) $category->tag_count;
+                        $taxonomy = 'post_tag';
+                        $wpdb->query("INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('$term_id', '$taxonomy', '$description', '$parent', '$count')");
+                        $tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;
+                } else {
+                        $count = 0;
+                        $taxonomy = 'category';
+                        $wpdb->query("INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ('$term_id', '$taxonomy', '$description', '$parent', '$count')");
+                        $tt_ids[$term_id][$taxonomy] = (int) $wpdb->insert_id;
+                }
+        }
+
+        $posts = $wpdb->get_results("SELECT * FROM $wpdb->post2cat");
+        foreach ( $posts as $post ) {
+                $post_id = (int) $post->post_id;
+                $term_id = (int) $post->category_id;
+                $taxonomy = 'category';
+                if ( !empty($post->rel_type) && 'tag' == $post->rel_type)
+                        $taxonomy = 'tag';
+                $tt_id = $tt_ids[$term_id][$taxonomy];
+                if ( empty($tt_id) )
+                        continue;
+
+                $wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id) VALUES ('$post_id', '$tt_id')");
+        }
+
+        $links = $wpdb->get_results("SELECT * FROM $wpdb->link2cat");
+        foreach ( $links as $link ) {
+                $link_id = (int) $link->link_id;
+                $term_id = (int) $link->category_id;
+                $taxonomy = 'link_category';
+                $tt_id = $tt_ids[$term_id][$taxonomy];
+                if ( empty($tt_id) )
+                        continue;
+
+                $wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id) VALUES ('$link_id', '$tt_id')");
         }
 }

trunk/wp-admin/upgrade-schema.php

@@ -27 +27 @@
  count bigint(20) NOT NULL default 0,
  PRIMARY KEY (term_taxonomy_id),
- UNIQUE KEY (term_id, taxonomy)
+ UNIQUE KEY (term_id,taxonomy)
 ) $charset_collate;
 CREATE TABLE $wpdb->term_relationships (

trunk/wp-includes/version.php

@@ -4 +4 @@
 
 $wp_version = '2.3-alpha';
-$wp_db_version = 5495;
+$wp_db_version = 5539;
 
 ?>