Changeset 32318 for branches/3.7/src/wp-admin/includes/upgrade.php

Timestamp:

04/27/2015 06:34:09 PM (11 years ago)

Author:

mdawaffe

Message:

3.7:

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

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

@@ -412 +412 @@
                 upgrade_373();
 
+        if ( $wp_current_db_version < 26150 )
+                upgrade_378();
+
         maybe_disable_link_manager();
 
@@ -1266 +1269 @@
                         $wpdb->update( $wpdb->posts, array( 'post_status' => 'draft' ), array( 'ID' => $post->ID ) );
                         clean_post_cache( $post->ID );
+                }
+        }
+}
+
+/**
+ * Execute changes made in WordPress 3.7.8.
+ *
+ * @since 3.7.8
+ */
+function upgrade_378() {
+        global $wp_current_db_version, $wpdb;
+
+        if ( $wp_current_db_version < 26150 ) {
+                $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 );
                 }
         }