Changeset 60106

Timestamp:

03/29/2025 11:58:07 AM (3 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;';