Changeset 60106

Timestamp:

03/29/2025 11:58:07 AM (17 months ago)

Author:

SergeyBiryukov

Message:

Coding Standards: Use $wpdb::prepare() in wp-admin/maint/repair.php.

Follow-up to [11902], [12092], [13224], [13229].

Props aristath, poena, afercia, SergeyBiryukov.
See #63168.

File:

• trunk/src/wp-admin/maint/repair.php (modified) (4 diffs)

trunk/src/wp-admin/maint/repair.php

@@ -109 +109 @@
         // Loop over the tables, checking and repairing as needed.
         foreach ( $tables as $table ) {
-                $check = $wpdb->get_row( "CHECK TABLE $table" );
+                $check = $wpdb->get_row( $wpdb->prepare( 'CHECK TABLE %i', $table ) );
 
                 echo '<p>';
@@ -119 +119 @@
                         printf( __( 'The %1$s table is not okay. It is reporting the following error: %2$s. WordPress will attempt to repair this table&hellip;' ), "<code>$table</code>", "<code>$check->Msg_text</code>" );
 
-                        $repair = $wpdb->get_row( "REPAIR TABLE $table" );
+                        $repair = $wpdb->get_row( $wpdb->prepare( 'REPAIR TABLE %i', $table ) );
 
                         echo '<br />&nbsp;&nbsp;&nbsp;&nbsp;';
@@ -134 +134 @@
 
                 if ( $okay && $optimize ) {
-                        $analyze = $wpdb->get_row( "ANALYZE TABLE $table" );
+                        $analyze = $wpdb->get_row( $wpdb->prepare( 'ANALYZE TABLE %i', $table ) );
 
                         echo '<br />&nbsp;&nbsp;&nbsp;&nbsp;';
@@ -141 +141 @@
                                 printf( __( 'The %s table is already optimized.' ), "<code>$table</code>" );
                         } else {
-                                $optimize = $wpdb->get_row( "OPTIMIZE TABLE $table" );
+                                $optimize = $wpdb->get_row( $wpdb->prepare( 'OPTIMIZE TABLE %i', $table ) );
 
                                 echo '<br />&nbsp;&nbsp;&nbsp;&nbsp;';