Changeset 28077

Timestamp:

04/11/2014 05:28:30 PM (12 years ago)

Author:

nacin

Message:

Recover auto-drafts lost via Quick Draft.

Merges [28075] from the 3.8 to the 3.7 branch. See [28074].

fixes #27734.

Location:

branches/3.7

Files:

• . (modified) (1 prop)
• src/wp-admin/includes/upgrade.php (modified) (2 diffs)
• src/wp-includes/version.php (modified) (1 diff)

branches/3.7/src/wp-admin/includes/upgrade.php

@@ -409 +409 @@
         upgrade_372();
 
+    if ( $wp_current_db_version < 26149 )
+        upgrade_373();
+
     maybe_disable_link_manager();
 
@@ -1236 +1239 @@
     if ( $wp_current_db_version < 26148 )
         wp_clear_scheduled_hook( 'wp_maybe_auto_update' );
+}
+
+/**
+ * Execute changes made in WordPress 3.7.3.
+ *
+ * @since 3.7.3
+ */
+function upgrade_373() {
+    global $wp_current_db_version, $wpdb;
+    if ( $wp_current_db_version < 26149 ) {
+        // Find all lost Quick Draft auto-drafts and promote them to proper drafts.
+        $posts = $wpdb->get_results( "SELECT ID, post_title, post_content FROM $wpdb->posts WHERE post_type = 'post'
+            AND post_status = 'auto-draft' AND post_date >= '2014-04-08 00:00:00'" );
+
+        foreach ( $posts as $post ) {
+            // A regular auto-draft should never have content as that would mean it should have been promoted.
+            // If an auto-draft has content, it's from Quick Draft and it should be recovered.
+            if ( '' === $post->post_content ) {
+                // If it does not have content, we must evaluate whether the title should be recovered.
+                if ( 'Auto Draft' === $post->post_title || __( 'Auto Draft' ) === $post->post_title ) {
+                    // This a plain old auto draft. Ignore it.
+                    continue;
+                }
+            }
+
+            $wpdb->update( $wpdb->posts, array( 'post_status' => 'draft' ), array( 'ID' => $post->ID ) );
+            clean_post_cache( $post->ID );
+        }
+    }
 }
 

branches/3.7/src/wp-includes/version.php

@@ -12 +12 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 26148;
+$wp_db_version = 26149;
 
 /**