Changeset 2695 for trunk/wp-admin/admin-functions.php

Timestamp:

07/03/2005 07:26:51 PM (21 years ago)

Author:

ryan

Message:

wp_insert_category(), wp_update_category(), wp_delete_category().

File:

• trunk/wp-admin/admin-functions.php (modified) (1 diff)

trunk/wp-admin/admin-functions.php

@@ -203 +203 @@
 
         return $comment;
+}
+
+function get_category_to_edit($id) {
+        $category = get_category($id);
+
+        return $category;
+}
+
+function wp_insert_category($catarr) {
+        global $wpdb;
+
+        extract($catarr);
+
+        $cat_ID = (int) $cat_ID;
+
+        // Are we updating or creating?
+        if ( !empty($cat_ID) ) {
+                $update = true;
+        } else {
+                $update = false;
+                $id_result = $wpdb->get_row("SHOW TABLE STATUS LIKE '$wpdb->categories'");
+                $cat_ID = $id_result->Auto_increment;
+        }
+
+        $cat_name = wp_specialchars($cat_name);
+
+        if ( empty($category_nicename) )
+                $category_nicename = sanitize_title($cat_name, $cat_ID);
+        else
+                $category_nicename = sanitize_title($category_nicename, $cat_ID);
+
+        if ( empty($category_description) )
+                $category_description = '';
+
+        if ( empty($category_parent) )
+                $category_parent = 0;
+
+        if ( !$update)
+                $query = "INSERT INTO $wpdb->categories (cat_ID, cat_name, category_nicename, category_description, category_parent) VALUES ('0', '$cat_name', '$category_nicename', '$category_description', '$cat')";
+        else
+                $query = "UPDATE $wpdb->categories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent = '$category_parent' WHERE cat_ID = '$cat_ID'";
+
+        $result = $wpdb->query($query);
+
+        if ( $update ) {
+                $rval = $wpdb->rows_affected;
+                do_action('edit_category', $cat_ID);
+        } else {
+                $rval = $wpdb->insert_id;
+                do_action('create_category', $cat_ID);
+        }
+
+        return $rval;
+}
+
+function wp_update_category($catarr) {
+        global $wpdb;
+
+        $cat_ID = (int) $catarr['cat_ID'];
+        
+        // First, get all of the original fields
+        $category = get_category($cat_ID, ARRAY_A);     
+
+        // Escape data pulled from DB.
+        $category = add_magic_quotes($category);
+
+        // Merge old and new fields with new fields overwriting old ones.
+        $catarr = array_merge($category, $catarr);
+
+        return wp_insert_category($catarr);
+}
+
+function wp_delete_category($cat_ID) {
+        global $wpdb;
+
+        $cat_ID = (int) $cat_ID;
+
+        // Don't delete the default cat.
+        if ( 1 == $cat_ID )
+                return 0;
+
+        $category = get_category($cat_ID);
+
+        $parent = $category->category_parent;
+
+        // Delete the category.
+        $wpdb->query("DELETE FROM $wpdb->categories WHERE cat_ID = '$cat_ID'");
+
+        // Update children to point to new parent.
+        $wpdb->query("UPDATE $wpdb->categories SET category_parent = '$parent' WHERE category_parent = '$cat_ID'");
+
+        // TODO: Only set categories to general if they're not in another category already
+        $wpdb->query("UPDATE $wpdb->post2cat SET category_id='1' WHERE category_id='$cat_ID'");
+
+        do_action('delete_category', $cat_ID);
+
+        return 1;
 }