Changeset 5539

Timestamp:

05/24/07 22:40:24 (1 year ago)

Author:

ryan

Message:

Category/tag to taxonomy upgrade. First cut.

Files:

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

trunk/wp-admin/upgrade-functions.php

@@ -186 +186 @@
-        upgrade_old_slugs();
-    
-200 ) {
+539 )
-        upgrade_230();
-
+
-    
-    maybe_disable_automattic_widgets();
@@ -573 +573 @@
-
-function upgrade_230() {
-
+, $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),
- 
+
-) $charset_collate;
-CREATE TABLE $wpdb->term_relationships (

trunk/wp-includes/version.php

@@ -4 +4 @@
-
-$wp_version = '2.3-alpha';
-495
+539
-
-?>