Changeset 3510 for trunk/wp-admin/upgrade-functions.php

Timestamp:

02/09/2006 10:03:48 AM (20 years ago)

Author:

ryan

Message:

Allow draft pages. Use post_type for object types. Reserve post_status strictly for status. fixes #1820

File:

• trunk/wp-admin/upgrade-functions.php (modified) (2 diffs)

trunk/wp-admin/upgrade-functions.php

@@ -33 +33 @@
     if ( $wp_current_db_version < 3308 )
         upgrade_160();
+
+    if ( $wp_current_db_version < 3506 )
+        upgrade_210();
 
     $wp_rewrite->flush_rules();
@@ -324 +327 @@
                 add_post_meta($object->ID, '_wp_attached_file', $meta['file']);
         }
+    }
+}
+
+function upgrade_210() {
+    global $wpdb, $table_prefix, $wp_current_db_version;
+
+    // Update status and type.
+    $posts = $wpdb->get_results("SELECT ID, post_status FROM $wpdb->posts");
+    
+    if ( ! empty($posts) ) foreach ($posts as $post) {
+        $status = $post->post_status;
+        $type = 'post';
+
+        if ( 'static' == $status ) {
+            $status = 'publish';
+            $type = 'page';
+        } else if ( 'attachment' == $status ) {
+            $status = 'inherit';
+            $type = 'attachment';   
+        }
+        
+        $wpdb->query("UPDATE $wpdb->posts SET post_status = '$status', post_type = '$type' WHERE ID = '$post->ID'");
     }
 }