Changeset 32317 for branches/3.8/src/wp-admin/includes/upgrade.php

Timestamp:

04/27/2015 06:33:43 PM (11 years ago)

Author:

mdawaffe

Message:

3.8:

• WPDB: Sanity check that any strings being stored in the DB are not too long to store correctly.
• When upgrading, remove any suspicious comments.

File:

• branches/3.8/src/wp-admin/includes/upgrade.php (modified) (2 diffs)

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

@@ -415 +415 @@
         upgrade_383();
 
+    if ( $wp_current_db_version < 26693 )
+        upgrade_388();
+
     maybe_disable_link_manager();
 
@@ -1281 +1284 @@
             $wpdb->update( $wpdb->posts, array( 'post_status' => 'draft' ), array( 'ID' => $post->ID ) );
             clean_post_cache( $post->ID );
+        }
+    }
+}
+
+/**
+ * Execute changes made in WordPress 3.8.8.
+ *
+ * @since 3.8.8
+ */
+function upgrade_388() {
+    global $wp_current_db_version, $wpdb;
+
+    if ( $wp_current_db_version < 26693 ) {
+        $content_length = $wpdb->get_col_length( $wpdb->comments, 'comment_content' );
+        if ( ! $content_length ) {
+            $content_length = 65535;
+        }
+
+        $comments = $wpdb->get_results(
+            "SELECT comment_ID FROM $wpdb->comments
+            WHERE comment_date_gmt > '2015-04-26'
+            AND CHAR_LENGTH( comment_content ) >= $content_length
+            AND ( comment_content LIKE '%<%' OR comment_content LIKE '%>%' )"
+        );
+
+        foreach ( $comments as $comment ) {
+            wp_delete_comment( $comment->comment_ID, true );
         }
     }