Changeset 572 for trunk/wp-admin/wp-post.php

Timestamp:

12/05/2003 09:41:27 AM (21 years ago)

Author:

saxmatt

Message:

Beta multiple category support. Major style changes. You can now add, delete, edit categories through the admin interface.

File:

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

trunk/wp-admin/wp-post.php

@@ -49 +49 @@
             $excerpt = format_to_post($excerpt);
             $post_title = addslashes($HTTP_POST_VARS['post_title']);
-            $post_category = intval($HTTP_POST_VARS['post_category']);
+            $post_categories = $HTTP_POST_VARS['post_category'];
             if(get_settings('use_geo_positions')) {
                 $latstr = $HTTP_POST_VARS['post_latf'];
@@ -87 +87 @@
         if((get_settings('use_geo_positions')) && (strlen($latstr) > 2) && (strlen($lonstr) > 2) ) {
         $postquery ="INSERT INTO $tableposts
-                (ID, post_author, post_date, post_content, post_title, post_category, post_lat, post_lon, post_excerpt,  post_status, comment_status, ping_status, post_password, post_name)
+                (ID, post_author, post_date, post_content, post_title, post_lat, post_lon, post_excerpt,  post_status, comment_status, ping_status, post_password, post_name)
                 VALUES
-                ('0','$user_ID','$now','$content','$post_title','$post_category',$post_latf,$post_lonf,'$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password', '$post_name')
+                ('0', '$user_ID', '$now', '$content', '$post_title', $post_latf, $post_lonf,'$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password', '$post_name')
                 ";
         } else {
         $postquery ="INSERT INTO $tableposts
-                (ID, post_author, post_date, post_content, post_title, post_category,  post_excerpt,  post_status, comment_status, ping_status, post_password, post_name)
+                (ID, post_author, post_date, post_content, post_title, post_excerpt,  post_status, comment_status, ping_status, post_password, post_name)
                 VALUES
-                ('0','$user_ID','$now','$content','$post_title','$post_category','$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password', '$post_name')
+                ('0', '$user_ID', '$now', '$content', '$post_title', '$excerpt', '$post_status', '$comment_status', '$ping_status', '$post_password', '$post_name')
                 ";
         }
@@ -103 +103 @@
         $post_ID = $wpdb->get_var("SELECT ID FROM $tableposts ORDER BY ID DESC LIMIT 1");
 
+        // Insert categories
+        foreach ($post_categories as $post_category) {
+            // Double check it's not there already
+            $exists = $wpdb->get_row("SELECT * FROM $tablepost2cat WHERE post_id = $post_ID AND category_id = $post_category");
+
+             if (!$exists && $result) { 
+                $wpdb->query("
+                INSERT INTO $tablepost2cat
+                (post_id, category_id)
+                VALUES
+                ($post_ID, $post_category)
+                ");
+            }
+        }
+        
         if (isset($sleep_after_edit) && $sleep_after_edit > 0) {
                 sleep($sleep_after_edit);
@@ -204 +219 @@
         }
             $post_ID = $HTTP_POST_VARS['post_ID'];
-            $post_category = intval($HTTP_POST_VARS['post_category']);
+            $post_categories = $HTTP_POST_VARS['post_category'];
             $post_autobr = intval($HTTP_POST_VARS['post_autobr']);
             $content = balanceTags($HTTP_POST_VARS['content']);
@@ -249 +264 @@
                 post_content = '$content',
                 post_excerpt = '$excerpt',
-                post_title = '$post_title',
-                post_category = '$post_category'".$datemodif.",
-                ".$latlonaddition."
+                post_title = '$post_title'"
+                .$datemodif.","
+                .$latlonaddition."
                 post_status = '$post_status',
                 comment_status = '$comment_status',
@@ -259 +274 @@
             WHERE ID = $post_ID ");
 
+
+        // Now it's category time!
+        // First the old categories
+        $old_categories = $wpdb->get_col("SELECT category_id FROM $tablepost2cat WHERE post_id = $post_ID");
+        
+        // Delete any?
+        foreach ($old_categories as $old_cat) {
+            if (!in_array($old_cat, $post_categories)) // If a category was there before but isn't now
+                $wpdb->query("DELETE FROM $tablepost2cat WHERE category_id = $old_cat AND post_id = $post_ID LIMIT 1");
+        }
+        
+        // Add any?
+        foreach ($post_categories as $new_cat) {
+            if (!in_array($new_cat, $old_categories))
+                $wpdb->query("INSERT INTO $tablepost2cat (post_id, category_id) VALUES ($post_ID, $new_cat)");
+        }
+        
         if (isset($sleep_after_edit) && $sleep_after_edit > 0) {
             sleep($sleep_after_edit);
@@ -295 +327 @@
             die ('Cheatin’ uh?');
 
-        $post = $HTTP_GET_VARS['post'];
+        $post_id = $HTTP_GET_VARS['post'];
         $postdata = get_postdata($post) or die('Oops, no post with this ID. <a href="wp-post.php">Go back</a>!');
         $authordata = get_userdata($postdata['Author_ID']);
@@ -303 +335 @@
 
         // send geoURL ping to "erase" from their DB
-        $query = "SELECT post_lat from $tableposts WHERE ID=$post";
+        $query = "SELECT post_lat from $tableposts WHERE ID=$post_id";
         $rows = $wpdb->query($query); 
         $myrow = $rows[0];
@@ -311 +343 @@
         }
 
-        $result = $wpdb->query("DELETE FROM $tableposts WHERE ID=$post");
+        $result = $wpdb->query("DELETE FROM $tableposts WHERE ID=$post_id");
         if (!$result)
             die('Error in deleting... contact the <a href="mailto:$admin_email">webmaster</a>.');
 
-        $result = $wpdb->query("DELETE FROM $tablecomments WHERE comment_post_ID=$post");
+        $result = $wpdb->query("DELETE FROM $tablecomments WHERE comment_post_ID=$post_id");
+
+        $categories = $wpdb->query("DELETE FROM $tablepost2cat WHERE post_id = $post_id");
 
         if (isset($sleep_after_edit) && $sleep_after_edit > 0) {