Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
doc	[ DIR ]	drwxrwxrwx
examples	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
libraries	[ DIR ]	drwxrwxrwx
locale	[ DIR ]	drwxrwxrwx
setup	[ DIR ]	drwxrwxrwx
sql	[ DIR ]	drwxrwxrwx
templates	[ DIR ]	drwxrwxrwx
themes	[ DIR ]	drwxrwxrwx
tmp	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
CONTRIBUTING.md	2.53 KB	-rw-rw-rw-
ChangeLog	32.24 KB	-rw-rw-rw-
LICENSE	17.67 KB	-rw-rw-rw-
README	1.48 KB	-rw-rw-rw-
RELEASE-DATE-5.0.4	29 B	-rw-rw-rw-
ajax.php	1.96 KB	-rw-rw-rw-
browse_foreigners.php	1.77 KB	-rw-rw-rw-
changelog.php	3.04 KB	-rw-rw-rw-
chk_rel.php	1.16 KB	-rw-rw-rw-
composer.json	3.47 KB	-rw-rw-rw-
composer.lock	170.01 KB	-rw-rw-rw-
config.inc.php	2 KB	-rw-rw-rw-
config.sample.inc.php	4.43 KB	-rw-rw-rw-
db_central_columns.php	4.5 KB	-rw-rw-rw-
db_datadict.php	730 B	-rw-rw-rw-
db_designer.php	7.6 KB	-rw-rw-rw-
db_events.php	1.96 KB	-rw-rw-rw-
db_export.php	5 KB	-rw-rw-rw-
db_import.php	1.08 KB	-rw-rw-rw-
db_multi_table_query.php	1.42 KB	-rw-rw-rw-
db_operations.php	9.64 KB	-rw-rw-rw-
db_qbe.php	5.19 KB	-rw-rw-rw-
db_routines.php	2.2 KB	-rw-rw-rw-
db_search.php	2.17 KB	-rw-rw-rw-
db_sql.php	1.18 KB	-rw-rw-rw-
db_sql_autocomplete.php	1.01 KB	-rw-rw-rw-
db_sql_format.php	613 B	-rw-rw-rw-
db_structure.php	2 KB	-rw-rw-rw-
db_tracking.php	3.58 KB	-rw-rw-rw-
db_triggers.php	1.96 KB	-rw-rw-rw-
error_report.php	4.64 KB	-rw-rw-rw-
export.php	16.93 KB	-rw-rw-rw-
favicon.ico	21.96 KB	-rw-rw-rw-
gis_data_editor.php	3.83 KB	-rw-rw-rw-
import.php	24.03 KB	-rw-rw-rw-
import_status.php	3.65 KB	-rw-rw-rw-
index.php	3.01 KB	-rw-rw-rw-
license.php	1021 B	-rw-rw-rw-
lint.php	1.52 KB	-rw-rw-rw-
logout.php	437 B	-rw-rw-rw-
navigation.php	2.58 KB	-rw-rw-rw-
normalization.php	4.48 KB	-rw-rw-rw-
package.json	1.42 KB	-rw-rw-rw-
phpinfo.php	633 B	-rw-rw-rw-
prefs_forms.php	3.02 KB	-rw-rw-rw-
prefs_manage.php	7.29 KB	-rw-rw-rw-
prefs_twofactor.php	1.93 KB	-rw-rw-rw-
print.css	1.18 KB	-rw-rw-rw-
robots.txt	26 B	-rw-rw-rw-
schema_export.php	861 B	-rw-rw-rw-
server_binlog.php	733 B	-rw-rw-rw-
server_collations.php	626 B	-rw-rw-rw-
server_databases.php	1.74 KB	-rw-rw-rw-
server_engines.php	797 B	-rw-rw-rw-
server_export.php	1.22 KB	-rw-rw-rw-
server_import.php	833 B	-rw-rw-rw-
server_plugins.php	595 B	-rw-rw-rw-
server_privileges.php	14.8 KB	-rw-rw-rw-
server_replication.php	1.57 KB	-rw-rw-rw-
server_sql.php	1.06 KB	-rw-rw-rw-
server_status.php	1.01 KB	-rw-rw-rw-
server_status_advisor.php	885 B	-rw-rw-rw-
server_status_monitor.php	3.22 KB	-rw-rw-rw-
server_status_processes.php	1.78 KB	-rw-rw-rw-
server_status_queries.php	1.34 KB	-rw-rw-rw-
server_status_variables.php	1.31 KB	-rw-rw-rw-
server_user_groups.php	2.16 KB	-rw-rw-rw-
server_variables.php	1.08 KB	-rw-rw-rw-
services.yml	3.09 KB	-rw-rw-rw-
services_controllers.yml	8.4 KB	-rw-rw-rw-
show_config_errors.php	1.23 KB	-rw-rw-rw-
sql.php	6.73 KB	-rw-rw-rw-
tbl_addfield.php	4.33 KB	-rw-rw-rw-
tbl_change.php	6.86 KB	-rw-rw-rw-
tbl_chart.php	1.13 KB	-rw-rw-rw-
tbl_create.php	3.92 KB	-rw-rw-rw-
tbl_export.php	2.9 KB	-rw-rw-rw-
tbl_find_replace.php	1.29 KB	-rw-rw-rw-
tbl_get_field.php	2.05 KB	-rw-rw-rw-
tbl_gis_visualization.php	1.64 KB	-rw-rw-rw-
tbl_import.php	895 B	-rw-rw-rw-
tbl_indexes.php	1.23 KB	-rw-rw-rw-
tbl_operations.php	15.43 KB	-rw-rw-rw-
tbl_recent_favorite.php	590 B	-rw-rw-rw-
tbl_relation.php	2.81 KB	-rw-rw-rw-
tbl_replace.php	17.51 KB	-rw-rw-rw-
tbl_row_action.php	5.48 KB	-rw-rw-rw-
tbl_select.php	1.29 KB	-rw-rw-rw-
tbl_sql.php	1.23 KB	-rw-rw-rw-
tbl_structure.php	2.31 KB	-rw-rw-rw-
tbl_tracking.php	5.33 KB	-rw-rw-rw-
tbl_triggers.php	265 B	-rw-rw-rw-
tbl_zoom_select.php	1.22 KB	-rw-rw-rw-
themes.php	894 B	-rw-rw-rw-
transformation_overview.php	846 B	-rw-rw-rw-
transformation_wrapper.php	5.26 KB	-rw-rw-rw-
url.php	1.56 KB	-rw-rw-rw-
user_password.php	2.18 KB	-rw-rw-rw-
version_check.php	1.17 KB	-rw-rw-rw-
view_create.php	7.02 KB	-rw-rw-rw-
view_operations.php	3.45 KB	-rw-rw-rw-
yarn.lock	109.31 KB	-rw-rw-rw-

Code Editor : sql.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * SQL executor
 *
 * @todo    we must handle the case if sql.php is called directly with a query
 *          that returns 0 rows - to prevent cyclic redirects or includes
 * @package PhpMyAdmin
 */
declare(strict_types=1);

use PhpMyAdmin\CheckUserPrivileges;
use PhpMyAdmin\Config\PageSettings;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\ParseAnalyze;
use PhpMyAdmin\Response;
use PhpMyAdmin\Sql;
use PhpMyAdmin\Url;
use PhpMyAdmin\Util;
use PhpMyAdmin\Core;

if (! defined('ROOT_PATH')) {
    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
}

global $cfg, $containerBuilder, $pmaThemeImage;

require_once ROOT_PATH . 'libraries/common.inc.php';

/** @var Response $response */
$response = $containerBuilder->get(Response::class);

/** @var DatabaseInterface $dbi */
$dbi = $containerBuilder->get(DatabaseInterface::class);

/** @var CheckUserPrivileges $checkUserPrivileges */
$checkUserPrivileges = $containerBuilder->get('check_user_privileges');
$checkUserPrivileges->getPrivileges();

PageSettings::showGroup('Browse');

$header = $response->getHeader();
$scripts = $header->getScripts();
$scripts->addFile('vendor/jquery/jquery.uitablefilter.js');
$scripts->addFile('table/change.js');
$scripts->addFile('indexes.js');
$scripts->addFile('vendor/stickyfill.min.js');
$scripts->addFile('gis_data_editor.js');
$scripts->addFile('multi_column_sort.js');

/** @var Sql $sql */
$sql = $containerBuilder->get('sql');

/**
 * Set ajax_reload in the response if it was already set
 */
if (isset($ajax_reload) && $ajax_reload['reload'] === true) {
    $response->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'
        );
    }
} // end if

if (! isset($err_url)) {
    $err_url = (! empty($back) ? $back : $goto)
        . '?' . Url::getCommon(['db' => $GLOBALS['db']])
        . ((mb_strpos(' ' . $goto, 'db_') != 1
            && strlen($table) > 0)
            ? '&amp;table=' . urlencode($table)
            : ''
        );
} // end if

// 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']) && isset($_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'];
}

// During grid edit, if we have a relational field, show the dropdown for it.
if (isset($_POST['get_relational_values'])
    && $_POST['get_relational_values'] == true
) {
    $sql->getRelationalValues($db, $table);
    // script has exited at this point
}

// Just like above, find possible values for enum fields during grid edit.
if (isset($_POST['get_enum_values']) && $_POST['get_enum_values'] == true) {
    $sql->getEnumOrSetValues($db, $table, "enum");
    // script has exited at this point
}

// Find possible values for set fields during grid edit.
if (isset($_POST['get_set_values']) && $_POST['get_set_values'] == true) {
    $sql->getEnumOrSetValues($db, $table, "set");
    // script has exited at this point
}

if (isset($_GET['get_default_fk_check_value'])
    && $_GET['get_default_fk_check_value'] == true
) {
    $response = Response::getInstance();
    $response->addJSON(
        'default_fk_check_value',
        Util::isForeignKeyCheck()
    );
    exit;
}

/**
 * Check ajax request to set the column order and visibility
 */
if (isset($_POST['set_col_prefs']) && $_POST['set_col_prefs'] == true) {
    $sql->setColumnOrderOrVisibility($table, $db);
    // script has exited at this point
}

// Default to browse if no query set and we have table
// (needed for browsing from DefaultTabTable)
if (empty($sql_query) && strlen($table) > 0 && strlen($db) > 0) {
    $sql_query = $sql->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
 */
list(
    $analyzed_sql_results,
    $db,
    $table_from_sql
) = ParseAnalyze::sqlQuery($sql_query, $db);
// @todo: possibly refactor
extract($analyzed_sql_results);

if ($table != $table_from_sql && ! 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 ($sql->hasNoRightsToDropDatabase(
    $analyzed_sql_results,
    $cfg['AllowUserDropDatabase'],
    $dbi->isSuperuser()
)) {
    Util::mysqlDie(
        __('"DROP DATABASE" statements are disabled.'),
        '',
        false,
        $err_url
    );
} // end if

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

/**
 * Bookmark add
 */
if (isset($_POST['store_bkm'])) {
    $sql->addBookmark($goto);
    // script has exited at this point
} // end if

/**
 * Sets or modifies the $goto variable if required
 */
if ($goto == 'sql.php') {
    $is_gotofile = false;
    $goto = 'sql.php' . Url::getCommon(
        [
            'db' => $db,
            'table' => $table,
            'sql_query' => $sql_query,
        ]
    );
} // end if

$sql->executeQueryAndSendQueryResponse(
    $analyzed_sql_results, // analyzed_sql_results
    $is_gotofile, // is_gotofile
    $db, // db
    $table, // table
    isset($find_real_end) ? $find_real_end : null, // find_real_end
    isset($import_text) ? $import_text : null, // sql_query_for_bookmark
    isset($extra_data) ? $extra_data : null, // extra_data
    isset($message_to_show) ? $message_to_show : null, // message_to_show
    isset($message) ? $message : null, // message
    isset($sql_data) ? $sql_data : null, // sql_data
    $goto, // goto
    $pmaThemeImage, // pmaThemeImage
    isset($disp_query) ? $display_query : null, // disp_query
    isset($disp_message) ? $disp_message : null, // disp_message
    isset($query_type) ? $query_type : null, // query_type
    $sql_query, // sql_query
    isset($selected) ? $selected : null, // selectedTables
    isset($complete_query) ? $complete_query : null // complete_query
);

${this.title}

Code Editor : sql.php