Changeset 32313 for branches/4.0/src/wp-admin/includes/upgrade.php

Timestamp:

04/27/2015 05:16:29 PM (11 years ago)

Author:

pento

Message:

4.0:

• 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/4.0/src/wp-admin/includes/upgrade.php (modified) (2 diffs)

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

@@ -440 +440 @@
     if ( $wp_current_db_version < 29630 )
         upgrade_400();
+
+    if ( $wp_current_db_version < 29631 )
+        upgrade_404();
 
     maybe_disable_link_manager();
@@ -1328 +1331 @@
 
 /**
+ * Execute changes made in WordPress 4.0.4.
+ *
+ * @since 4.0.4
+ */
+function upgrade_404() {
+    global $wp_current_db_version, $wpdb;
+
+    if ( $wp_current_db_version < 29631 ) {
+        $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 );
+        }
+    }
+}
+
+/**
  * Execute network level changes
  *