<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/classes/Controllers/Sql/SqlController.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Sql;

use PhpMyAdmin\Bookmark;
use PhpMyAdmin\CheckUserPrivileges;
use PhpMyAdmin\Config\PageSettings;
use PhpMyAdmin\Controllers\AbstractController;
use PhpMyAdmin\Core;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Html\Generator;
use PhpMyAdmin\Message;
use PhpMyAdmin\ParseAnalyze;
use PhpMyAdmin\ResponseRenderer;
use PhpMyAdmin\Sql;
use PhpMyAdmin\Template;
use PhpMyAdmin\Url;
use PhpMyAdmin\Util;

use function __;
use function mb_strpos;
use function str_contains;
use function strlen;
use function urlencode;

class SqlController extends AbstractController
{
    /** @var Sql */
    private $sql;

    /** @var CheckUserPrivileges */
    private $checkUserPrivileges;

    /** @var DatabaseInterface */
    private $dbi;

    public function __construct(
        ResponseRenderer $response,
        Template $template,
        Sql $sql,
        CheckUserPrivileges $checkUserPrivileges,
        DatabaseInterface $dbi
    ) {
        parent::__construct($response, $template);
        $this-&gt;sql = $sql;
        $this-&gt;checkUserPrivileges = $checkUserPrivileges;
        $this-&gt;dbi = $dbi;
    }

    public function __invoke(): void
    {
        global $cfg, $db, $display_query, $sql_query, $table;
        global $ajax_reload, $goto, $errorUrl, $find_real_end, $unlim_num_rows, $import_text, $disp_query;
        global $extra_data, $message_to_show, $sql_data, $disp_message, $complete_query;
        global $is_gotofile, $back, $table_from_sql;

        $this-&gt;checkUserPrivileges-&gt;getPrivileges();

        $pageSettings = new PageSettings('Browse');
        $this-&gt;response-&gt;addHTML($pageSettings-&gt;getErrorHTML());
        $this-&gt;response-&gt;addHTML($pageSettings-&gt;getHTML());

        $this-&gt;addScriptFiles([
            'vendor/jquery/jquery.uitablefilter.js',
            'table/change.js',
            'indexes.js',
            'gis_data_editor.js',
            'multi_column_sort.js',
        ]);

        /**
         * Set ajax_reload in the response if it was already set
         */
        if (isset($ajax_reload) &amp;&amp; $ajax_reload['reload'] === true) {
            $this-&gt;response-&gt;addJSON('ajax_reload', $ajax_reload);
        }

        /**
         * Defines the url to return to in case of error in a sql statement
         */
        $is_gotofile = true;
        if (empty($goto)) {
            if (empty($table)) {
                $goto = Util::getScriptNameForOption($cfg['DefaultTabDatabase'], 'database');
            } else {
                $goto = Util::getScriptNameForOption($cfg['DefaultTabTable'], 'table');
            }
        }

        if (! isset($errorUrl)) {
            $errorUrl = ! empty($back) ? $back : $goto;
            $errorUrl .= Url::getCommon(
                ['db' =&gt; $GLOBALS['db']],
                ! str_contains($errorUrl, '?') ? '?' : '&amp;'
            );
            if (
                (mb_strpos(' ' . $errorUrl, 'db_') !== 1 || ! str_contains($errorUrl, '?route=/database/'))
                &amp;&amp; strlen($table) &gt; 0
            ) {
                $errorUrl .= '&amp;amp;table=' . urlencode($table);
            }
        }

        // Coming from a bookmark dialog
        if (isset($_POST['bkm_fields']['bkm_sql_query'])) {
            $sql_query = $_POST['bkm_fields']['bkm_sql_query'];
        } elseif (isset($_POST['sql_query'])) {
            $sql_query = $_POST['sql_query'];
        } elseif (isset($_GET['sql_query'], $_GET['sql_signature'])) {
            if (Core::checkSqlQuerySignature($_GET['sql_query'], $_GET['sql_signature'])) {
                $sql_query = $_GET['sql_query'];
            }
        }

        // This one is just to fill $db
        if (isset($_POST['bkm_fields']['bkm_database'])) {
            $db = $_POST['bkm_fields']['bkm_database'];
        }

        // Default to browse if no query set and we have table
        // (needed for browsing from DefaultTabTable)
        if (empty($sql_query) &amp;&amp; strlen($table) &gt; 0 &amp;&amp; strlen($db) &gt; 0) {
            $sql_query = $this-&gt;sql-&gt;getDefaultSqlQueryForBrowse($db, $table);

            // set $goto to what will be displayed if query returns 0 rows
            $goto = '';
        } else {
            // Now we can check the parameters
            Util::checkParameters(['sql_query']);
        }

        /**
         * Parse and analyze the query
         */
        [
            $analyzed_sql_results,
            $db,
            $table_from_sql,
        ] = ParseAnalyze::sqlQuery($sql_query, $db);

        if ($table != $table_from_sql &amp;&amp; ! empty($table_from_sql)) {
            $table = $table_from_sql;
        }

        /**
         * Check rights in case of DROP DATABASE
         *
         * This test may be bypassed if $is_js_confirmed = 1 (already checked with js)
         * but since a malicious user may pass this variable by url/form, we don't take
         * into account this case.
         */
        if (
            $this-&gt;sql-&gt;hasNoRightsToDropDatabase(
                $analyzed_sql_results,
                $cfg['AllowUserDropDatabase'],
                $this-&gt;dbi-&gt;isSuperUser()
            )
        ) {
            Generator::mysqlDie(
                __('&quot;DROP DATABASE&quot; statements are disabled.'),
                '',
                false,
                $errorUrl
            );
        }

        /**
         * Need to find the real end of rows?
         */
        if (isset($find_real_end) &amp;&amp; $find_real_end) {
            $unlim_num_rows = $this-&gt;sql-&gt;findRealEndOfRows($db, $table);
        }

        /**
         * Bookmark add
         */
        if (isset($_POST['store_bkm'])) {
            $this-&gt;addBookmark($goto);

            return;
        }

        /**
         * Sets or modifies the $goto variable if required
         */
        if ($goto === Url::getFromRoute('/sql')) {
            $is_gotofile = false;
            $goto = Url::getFromRoute('/sql', [
                'db' =&gt; $db,
                'table' =&gt; $table,
                'sql_query' =&gt; $sql_query,
            ]);
        }

        $this-&gt;response-&gt;addHTML($this-&gt;sql-&gt;executeQueryAndSendQueryResponse(
            $analyzed_sql_results,
            $is_gotofile,
            $db,
            $table,
            $find_real_end ?? null,
            $import_text ?? null,
            $extra_data ?? null,
            $message_to_show ?? null,
            $sql_data ?? null,
            $goto,
            isset($disp_query) ? $display_query : null,
            $disp_message ?? null,
            $sql_query,
            $complete_query ?? null
        ));
    }

    private function addBookmark(string $goto): void
    {
        $bookmark = Bookmark::createBookmark(
            $this-&gt;dbi,
            $_POST['bkm_fields'],
            isset($_POST['bkm_all_users']) &amp;&amp; $_POST['bkm_all_users'] === 'true'
        );

        $result = null;
        if ($bookmark instanceof Bookmark) {
            $result = $bookmark-&gt;save();
        }

        if (! $this-&gt;response-&gt;isAjax()) {
            Core::sendHeaderLocation('./' . $goto . '&amp;label=' . $_POST['bkm_fields']['bkm_label']);

            return;
        }

        if ($result) {
            $msg = Message::success(__('Bookmark %s has been created.'));
            $msg-&gt;addParam($_POST['bkm_fields']['bkm_label']);
            $this-&gt;response-&gt;addJSON('message', $msg);

            return;
        }

        $msg = Message::error(__('Bookmark not created!'));
        $this-&gt;response-&gt;setRequestStatus(false);
        $this-&gt;response-&gt;addJSON('message', $msg);
    }
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2FphpMyAdmin%2Flibraries%2Fclasses%2FControllers%2FSql'>Back to Directory</a>