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
  *