Changeset 5229

Timestamp:

04/10/2007 04:57:21 PM (18 years ago)

Author:

rob1n

Message:

Use own category_exists() function, and only list categories to convert. fixes #4107

File:

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

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

@@ -15 +15 @@
     
     function populate_all_categories() {
-        $this->all_categories =& get_categories('hide_empty=0&hierarchal=0');
+        global $wpdb;
+        
+        $this->all_categories = $wpdb->get_results("SELECT * FROM $wpdb->categories WHERE (type & ~ " . TAXONOMY_TAG . ") != 0 ORDER BY cat_name ASC");
     }
     
@@ -71 +73 @@
     }
     
+    function _category_exists($cat_id) {
+        global $wpdb;
+        
+        $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) {
+            return true;
+        } else {
+            return false;
+        }
+    }
+    
     function convert_them() {
         global $wpdb;
@@ -90 +106 @@
             print '<li>' . __('Converting category') . ' #' . $cat_id . '... ';
             
-            if (!category_exists($cat_id)) {
+            if (!$this->_category_exists($cat_id)) {
                 _e('Category doesn\'t exist!');
             } else {
@@ -101 +117 @@
                 }
                 
+                // Set the category itself to $type from above
                 $wpdb->query("UPDATE $wpdb->categories SET type = '$type' WHERE cat_ID = '{$category->cat_ID}'");
                 
-                $wpdb->query("UPDATE $wpdb->post2cat SET rel_type = 'tag' 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}'");
+                
+                // 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}'");
+                
+                // Clean the cache
+                clean_category_cache($category->cat_ID);
                 
                 _e('Converted successfully.');
@@ -113 +137 @@
         
         print '</ul>';
-        
-        clean_category_cache();
     }