Changeset 7897

Timestamp:

05/05/08 17:15:35 (7 months ago)

Author:

ryan

Message:

Show when a term is both a category and a tag, also when a child category is converted to a tag and then converted back, restore the child status, if the parent still exists. Props azaozz. fixes #6909

Files:

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

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

@@ -4 +4 @@
-    var $categories_to_convert = array();
-    var $all_categories = array();
+    var $tags_to_convert = array();
+    var $all_tags = array();
+    var $hybrids_ids = array();
-
-    function header() {
-        echo '<div class="wrap">';
-
+
+
+
+
+
+
+
+
-    }
-
@@ -14 +24 @@
-    }
-
-all_categorie
+cat
-        global $wpdb;
-
-        $categories = get_categories('get=all');
-        foreach ( $categories as $category ) {
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-            echo '<p>' . __('Hey there. Here you can selectively converts existing categories to tags. To get started, check the categories you wish to be converted, then click the Convert button.') . '</p>';
-
+</div>
-
-            $this->categories_form();
+        } elseif ( $hyb_num > 0 ) {
+             echo '<p>' . __('You have no categories that can be converted. However some of your categories are both a tag and a category.') . '</p>';
-        } else {
-            echo '<p>'.__('You have no categories to convert!').'</p>';
-        }
-
-
-
-
-
-
+
+
+
+
-<script type="text/javascript">
-
+
-var checkflag = "false";
-function check_all_rows() {
-form
+cat
-    if ( 'false' == checkflag ) {
-        for ( i = 0; i < field.length; i++ ) {
@@ -64 +89 @@
-    }
-}
-
-
+
-</script>
-
-       echo '<form name="formlist" id="form
-
-
-
-
+
+<form name="catlist" id="cat
+
+
+
+
-        $hier = _get_term_hierarchy('category');
-
@@ -78 +102 @@
-            $category = sanitize_term( $category, 'category', 'display' );
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
-                }
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-    }
-
-    function _category_children($parent, $hier) {
-
-
+
+
+
+
-        foreach ($hier[$parent->term_id] as $child_id) {
-            $child =& get_category($child_id);
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
-                $this->_category_children($child, $hier);
-
-
-
-
-
-
+
+
+
+
+
+
+
-    }
-
@@ -126 +250 @@
-    }
-
-them
+categories
-        global $wpdb;
-
@@ -135 +259 @@
-            return;
-        }
-
-
-        if ( empty($this->categories_to_convert) )
@@ -200 +323 @@
-    }
-
+    function convert_tags() {
+        global $wpdb;
+
+        if ( (!isset($_POST['tags_to_convert']) || !is_array($_POST['tags_to_convert'])) && empty($this->tags_to_convert)) {
+            echo '<div class="narrow">';
+            echo '<p>' . sprintf(__('Uh, oh. Something didn&#8217;t work. Please <a href="%s">try again</a>.'), 'admin.php?import=wp-cat2tag&amp;step=3') . '</p>';
+            echo '</div>';
+            return;
+        }
+
+        if ( empty($this->categories_to_convert) )
+            $this->tags_to_convert = $_POST['tags_to_convert'];
+
+        $clean_cache = array();
+        echo '<ul>';
+
+        foreach ( (array) $this->tags_to_convert as $tag_id) {
+            $tag_id = (int) $tag_id;
+
+            echo '<li>' . sprintf(__('Converting tag #%s ... '),  $tag_id);
+
+            if ( ! is_term($tag_id, 'post_tag') ) {
+                _e('Tag doesn\'t exist!');
+            } else {
+
+                if ( is_term($tag_id, 'category') ) {
+                    _e('This Tag is already a Category.');
+                    echo '</li>';
+                    continue;
+                }
+
+                $tt_ids = $wpdb->get_col( $wpdb->prepare("SELECT term_taxonomy_id FROM $wpdb->term_taxonomy WHERE term_id = %d AND taxonomy = 'post_tag'", $tag_id) );
+                if ( $tt_ids ) {
+                        $posts = $wpdb->get_col("SELECT object_id FROM $wpdb->term_relationships WHERE term_taxonomy_id IN (" . join(',', $tt_ids) . ") GROUP BY object_id");
+                    foreach ( (array) $posts as $post )
+                        clean_post_cache($post);
+                }
+
+                // Change the tag to a category.
+                $parent = $wpdb->get_var( $wpdb->prepare("SELECT parent FROM $wpdb->term_taxonomy WHERE term_id = %d AND taxonomy = 'post_tag'", $tag_id) );
+                if ( 0 == $parent || (0 < (int) $parent && $this->_category_exists($parent)) )
+                    $reset_parent = '';
+                else $reset_parent = ", parent = '0'";
+
+                $wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET taxonomy = 'category' $reset_parent WHERE term_id = %d AND taxonomy = 'post_tag'", $tag_id) );
+
+                // Clean the cache
+                $clean_cache[] = $tag_id;
+
+                _e('Converted successfully.');
+            }
+
+            echo '</li>';
+        }
+
+        clean_term_cache( $clean_cache, 'post_tag' );
+        delete_option('category_children');
+        
+        echo '</ul>';
+        echo '<p>' . sprintf( __('We&#8217;re all done here, but you can always <a href="%s">convert more</a>.'), 'admin.php?import=wp-cat2tag&amp;step=3' ) . '</p>';
+    }
+
-    function init() {
-
@@ -206 +391 @@
-        $this->header();
-
-
-
-
-
-
-
-
+
-
-            switch ($step) {
-                case 1 :
-welcome
+categories_tab
-                break;
-
-                case 2 :
-
+
+
+
+
+
+
+
+
+
+
+
-                break;
-            }
@@ -235 +424 @@
-$wp_cat2tag_importer = new WP_Categories_to_Tags();
-
-to Tags Converter'), __('Convert existing categories to tag
-
-
+and Tags Converter'), __('Convert existing categories to tags or tags to categorie
+
+