    <div class="row">
        <div class="col-12">
            <pre class="with-hljs"><code class="lang-php">&lt;?php

define(&#039;WP_REPAIRING&#039;, true);
require_once dirname(dirname(__DIR__)) . &#039;/wp-load.php&#039;;
header(&#039;Content-Type: text/html; charset=utf-8&#039;);
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html &lt;?php 
language_attributes();
?&gt;&gt;
&lt;head&gt;
	&lt;meta name=&quot;viewport&quot; content=&quot;width=device-width&quot; /&gt;
	&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;
	&lt;meta name=&quot;robots&quot; content=&quot;noindex,nofollow&quot; /&gt;
	&lt;title&gt;&lt;?php 
_e(&#039;WordPress &amp;rsaquo; Database Repair&#039;);
?&gt;&lt;/title&gt;
	&lt;?php 
wp_admin_css(&#039;install&#039;, true);
?&gt;
&lt;/head&gt;
&lt;body class=&quot;wp-core-ui&quot;&gt;
&lt;p id=&quot;logo&quot;&gt;&lt;a href=&quot;&lt;?php 
echo esc_url(__(&#039;https://wordpress.org/&#039;));
?&gt;&quot;&gt;&lt;?php 
_e(&#039;WordPress&#039;);
?&gt;&lt;/a&gt;&lt;/p&gt;

&lt;?php 
if (!defined(&#039;WP_ALLOW_REPAIR&#039;) || !WP_ALLOW_REPAIR) {
    echo &#039;&lt;h1 class=&quot;screen-reader-text&quot;&gt;&#039; . __(&#039;Allow automatic database repair&#039;) . &#039;&lt;/h1&gt;&#039;;
    echo &#039;&lt;p&gt;&#039;;
    printf(__(&#039;To allow use of this page to automatically repair database problems, please add the following line to your %s file. Once this line is added to your config, reload this page.&#039;), &#039;&lt;code&gt;wp-config.php&lt;/code&gt;&#039;);
    echo &quot;&lt;/p&gt;&lt;p&gt;&lt;code&gt;define(&#039;WP_ALLOW_REPAIR&#039;, true);&lt;/code&gt;&lt;/p&gt;&quot;;
    $default_key = &#039;put your unique phrase here&#039;;
    $missing_key = false;
    $duplicated_keys = array();
    foreach (array(&#039;AUTH_KEY&#039;, &#039;SECURE_AUTH_KEY&#039;, &#039;LOGGED_IN_KEY&#039;, &#039;NONCE_KEY&#039;, &#039;AUTH_SALT&#039;, &#039;SECURE_AUTH_SALT&#039;, &#039;LOGGED_IN_SALT&#039;, &#039;NONCE_SALT&#039;) as $key) {
        if (defined($key)) {
            $duplicated_keys[constant($key)] = isset($duplicated_keys[constant($key)]);
        } else {
            $missing_key = true;
        }
    }
    if (isset($duplicated_keys[$default_key])) {
        $duplicated_keys[$default_key] = true;
    }
    $duplicated_keys = array_filter($duplicated_keys);
    if ($duplicated_keys || $missing_key) {
        echo &#039;&lt;h2 class=&quot;screen-reader-text&quot;&gt;&#039; . __(&#039;Check secret keys&#039;) . &#039;&lt;/h2&gt;&#039;;
        echo &#039;&lt;p&gt;&#039; . sprintf(__(&#039;While you are editing your %1$s file, take a moment to make sure you have all 8 keys and that they are unique. You can generate these using the &lt;a href=&quot;%2$s&quot;&gt;WordPress.org secret key service&lt;/a&gt;.&#039;), &#039;&lt;code&gt;wp-config.php&lt;/code&gt;&#039;, &#039;https://api.wordpress.org/secret-key/1.1/salt/&#039;) . &#039;&lt;/p&gt;&#039;;
    }
} elseif (isset($_GET[&#039;repair&#039;])) {
    echo &#039;&lt;h1 class=&quot;screen-reader-text&quot;&gt;&#039; . __(&#039;Database repair results&#039;) . &#039;&lt;/h1&gt;&#039;;
    $optimize = 2 == $_GET[&#039;repair&#039;];
    $okay = true;
    $problems = array();
    $tables = $wpdb-&gt;tables();
    $query = $wpdb-&gt;prepare(&#039;SHOW TABLES LIKE %s&#039;, $wpdb-&gt;esc_like($wpdb-&gt;sitecategories));
    if (is_multisite() &amp;&amp; !$wpdb-&gt;get_var($query)) {
        unset($tables[&#039;sitecategories&#039;]);
    }
    $tables = array_merge($tables, (array) apply_filters(&#039;tables_to_repair&#039;, array()));
    foreach ($tables as $table) {
        $check = $wpdb-&gt;get_row(&quot;CHECK TABLE {$table}&quot;);
        echo &#039;&lt;p&gt;&#039;;
        if (&#039;OK&#039; === $check-&gt;Msg_text) {
            printf(__(&#039;The %s table is okay.&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;);
        } else {
            printf(__(&#039;The %1$s table is not okay. It is reporting the following error: %2$s. WordPress will attempt to repair this table&amp;hellip;&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;, &quot;&lt;code&gt;{$check-&gt;Msg_text}&lt;/code&gt;&quot;);
            $repair = $wpdb-&gt;get_row(&quot;REPAIR TABLE {$table}&quot;);
            echo &#039;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&#039;;
            if (&#039;OK&#039; === $repair-&gt;Msg_text) {
                printf(__(&#039;Successfully repaired the %s table.&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;);
            } else {
                printf(__(&#039;Failed to repair the %1$s table. Error: %2$s&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;, &quot;&lt;code&gt;{$repair-&gt;Msg_text}&lt;/code&gt;&quot;) . &#039;&lt;br /&gt;&#039;;
                $problems[$table] = $repair-&gt;Msg_text;
                $okay = false;
            }
        }
        if ($okay &amp;&amp; $optimize) {
            $analyze = $wpdb-&gt;get_row(&quot;ANALYZE TABLE {$table}&quot;);
            echo &#039;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&#039;;
            if (&#039;Table is already up to date&#039; === $analyze-&gt;Msg_text) {
                printf(__(&#039;The %s table is already optimized.&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;);
            } else {
                $optimize = $wpdb-&gt;get_row(&quot;OPTIMIZE TABLE {$table}&quot;);
                echo &#039;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&#039;;
                if (&#039;OK&#039; === $optimize-&gt;Msg_text || &#039;Table is already up to date&#039; === $optimize-&gt;Msg_text) {
                    printf(__(&#039;Successfully optimized the %s table.&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;);
                } else {
                    printf(__(&#039;Failed to optimize the %1$s table. Error: %2$s&#039;), &quot;&lt;code&gt;{$table}&lt;/code&gt;&quot;, &quot;&lt;code&gt;{$optimize-&gt;Msg_text}&lt;/code&gt;&quot;);
                }
            }
        }
        echo &#039;&lt;/p&gt;&#039;;
    }
    if ($problems) {
        printf(&#039;&lt;p&gt;&#039; . __(&#039;Some database problems could not be repaired. Please copy-and-paste the following list of errors to the &lt;a href=&quot;%s&quot;&gt;WordPress support forums&lt;/a&gt; to get additional assistance.&#039;) . &#039;&lt;/p&gt;&#039;, __(&#039;https://wordpress.org/support/forum/how-to-and-troubleshooting&#039;));
        $problem_output = &#039;&#039;;
        foreach ($problems as $table =&gt; $problem) {
            $problem_output .= &quot;{$table}: {$problem}\n&quot;;
        }
        echo &#039;&lt;p&gt;&lt;textarea name=&quot;errors&quot; id=&quot;errors&quot; rows=&quot;20&quot; cols=&quot;60&quot;&gt;&#039; . esc_textarea($problem_output) . &#039;&lt;/textarea&gt;&lt;/p&gt;&#039;;
    } else {
        echo &#039;&lt;p&gt;&#039; . __(&#039;Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.&#039;) . &quot;&lt;/p&gt;&lt;p&gt;&lt;code&gt;define(&#039;WP_ALLOW_REPAIR&#039;, true);&lt;/code&gt;&lt;/p&gt;&quot;;
    }
} else {
    echo &#039;&lt;h1 class=&quot;screen-reader-text&quot;&gt;&#039; . __(&#039;WordPress database repair&#039;) . &#039;&lt;/h1&gt;&#039;;
    if (isset($_GET[&#039;referrer&#039;]) &amp;&amp; &#039;is_blog_installed&#039; === $_GET[&#039;referrer&#039;]) {
        echo &#039;&lt;p&gt;&#039; . __(&#039;One or more database tables are unavailable. To allow WordPress to attempt to repair these tables, press the &amp;#8220;Repair Database&amp;#8221; button. Repairing can take a while, so please be patient.&#039;) . &#039;&lt;/p&gt;&#039;;
    } else {
        echo &#039;&lt;p&gt;&#039; . __(&#039;WordPress can automatically look for some common database problems and repair them. Repairing can take a while, so please be patient.&#039;) . &#039;&lt;/p&gt;&#039;;
    }
    ?&gt;
	&lt;p class=&quot;step&quot;&gt;&lt;a class=&quot;button button-large&quot; href=&quot;repair.php?repair=1&quot;&gt;&lt;?php 
    _e(&#039;Repair Database&#039;);
    ?&gt;&lt;/a&gt;&lt;/p&gt;
	&lt;p&gt;&lt;?php 
    _e(&#039;WordPress can also attempt to optimize the database. This improves performance in some situations. Repairing and optimizing the database can take a long time and the database will be locked while optimizing.&#039;);
    ?&gt;&lt;/p&gt;
	&lt;p class=&quot;step&quot;&gt;&lt;a class=&quot;button button-large&quot; href=&quot;repair.php?repair=2&quot;&gt;&lt;?php 
    _e(&#039;Repair and Optimize Database&#039;);
    ?&gt;&lt;/a&gt;&lt;/p&gt;
	&lt;?php 
}
?&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>        </div>
    </div>