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

Timestamp:

05/26/2007 06:54:16 PM (19 years ago)

Author:

ryan

Message:

Update cat2tag converter. Some term API tweaks. see #4189

File:

• trunk/wp-admin/import/wp-cat2tag.php (modified) (7 diffs)

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

@@ -17 +17 @@
         global $wpdb;
         
-        $this->all_categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE (type & ~ " . TAXONOMY_TAG . ") != 0 AND category_count > 0 ORDER BY cat_name ASC");
+        $this->all_categories = get_categories('get=all');
     }
     
@@ -41 +41 @@
         print '<ul style="list-style:none">';
         
-        $hier = _get_category_hierarchy();
+        $hier = _get_term_hierarchy('category');
         
         foreach ($this->all_categories as $category) {
-            if ((int) $category->category_parent == 0) {
-                print '<li><label><input type="checkbox" name="cats_to_convert[]" value="' . intval($category->cat_ID) . '" /> ' . $category->cat_name . ' (' . $category->category_count . ')</label>';
-                
-                if (isset($hier[$category->cat_ID])) {
+            if ((int) $category->parent == 0) {
+                print '<li><label><input type="checkbox" name="cats_to_convert[]" value="' . intval($category->term_id) . '" /> ' . $category->name . ' (' . $category->count . ')</label>';
+                
+                if (isset($hier[$category->term_id])) {
                     $this->_category_children($category, $hier);
                 }
@@ -64 +64 @@
         print '<ul style="list-style:none">';
         
-        foreach ($hier[$parent->cat_ID] as $child_id) {
+        foreach ($hier[$parent->term_id] as $child_id) {
             $child =& get_category($child_id);
             
-            print '<li><label><input type="checkbox" name="cats_to_convert[]" value="' . intval($child->cat_ID) . '" /> ' . $child->cat_name . ' (' . $child->category_count . ')</label>';
-            
-            if (isset($hier[$child->cat_ID])) {
+            print '<li><label><input type="checkbox" name="cats_to_convert[]" value="' . intval($child->term_id) . '" /> ' . $child->name . ' (' . $child->count . ')</label>';
+            
+            if (isset($hier[$child->term_id])) {
                 $this->_category_children($child, $hier);
             }
@@ -84 +84 @@
         $cat_id = (int) $cat_id;
         
-        $maybe_exists = $wpdb->get_results("SELECT cat_ID from $wpdb->categories WHERE cat_ID = '$cat_id'");
-        
-        if (count($maybe_exists) > 0) {
+        $maybe_exists = category_exists($cat_id);
+        
+        if ( $maybe_exists ) {
             return true;
         } else {
@@ -102 +102 @@
         }
         
-        $this->categories_to_convert = $_POST['cats_to_convert'];
-        $hier = _get_category_hierarchy();
+        
+        if ( empty($this->categories_to_convert) )
+            $this->categories_to_convert = $_POST['cats_to_convert'];
+        $hier = _get_term_hierarchy('category');
         
         print '<ul>';
@@ -117 +119 @@
                 $category =& get_category($cat_id);
                 
-                if ($category->link_count > 0) {
-                    $type = $category->type | TAXONOMY_TAG;
-                } else {
-                    $type = TAXONOMY_TAG;
-                }
-                
                 // Set the category itself to $type from above
-                $wpdb->query("UPDATE $wpdb->categories SET type = '$type' WHERE cat_ID = '{$category->cat_ID}'");
-                
-                // Set relationships in post2cat to 'tag', category_count becomes tag_count
-                $wpdb->query("UPDATE $wpdb->post2cat SET rel_type = 'tag' WHERE category_ID = '{$category->cat_ID}'");
-                $wpdb->query("UPDATE $wpdb->categories SET tag_count = '{$category->category_count}', category_count = '0' WHERE cat_ID = '{$category->cat_ID}'");
+                $wpdb->query("UPDATE $wpdb->term_taxonomy SET taxonomy = '$type' 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->categories SET category_parent = 0 WHERE category_parent = '{$category->cat_ID}'");
+                $wpdb->query("UPDATE $wpdb->term_taxonomy SET parent = 0 WHERE parent = '{$category->term_id}' AND taxonomy = 'category'");
                 
                 // Clean the cache
-                clean_category_cache($category->cat_ID);
+                clean_category_cache($category->term_id);
                 
                 _e('Converted successfully.');
@@ -161 +153 @@
     function convert_all() {
         global $wpdb;
-        
-        $cats = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE (type & ~ " . TAXONOMY_TAG . ") != 0 AND category_count > 0");
-        
-        $_POST['cats_to_convert'] = array();
-        
-        foreach ($cats as $cat) {
-            $_POST['cats_to_convert'][] = $cat->cat_ID;
-        }
-        
-        $this->convert_them();
+
+        $wpdb->query("UPDATE $wpdb->term_taxonomy SET taxonomy = '$type', parent = 0 WHERE taxonomy = 'category'");
+        clean_category_cache($category->term_id);
     }