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 : db_designer.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpMyAdmin designer general code
 *
 * @package PhpMyAdmin-Designer
 */
declare(strict_types=1);

use PhpMyAdmin\Database\Designer;
use PhpMyAdmin\Database\Designer\Common;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Response;

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

global $db;

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 Designer $databaseDesigner */
$databaseDesigner = $containerBuilder->get('designer');

/** @var Common $designerCommon */
$designerCommon = $containerBuilder->get('designer_common');

if (isset($_POST['dialog'])) {
    if ($_POST['dialog'] == 'edit') {
        $html = $databaseDesigner->getHtmlForEditOrDeletePages($_POST['db'], 'editPage');
    } elseif ($_POST['dialog'] == 'delete') {
        $html = $databaseDesigner->getHtmlForEditOrDeletePages($_POST['db'], 'deletePage');
    } elseif ($_POST['dialog'] == 'save_as') {
        $html = $databaseDesigner->getHtmlForPageSaveAs($_POST['db']);
    } elseif ($_POST['dialog'] == 'export') {
        $html = $databaseDesigner->getHtmlForSchemaExport(
            $_POST['db'],
            $_POST['selected_page']
        );
    } elseif ($_POST['dialog'] == 'add_table') {
        // Pass the db and table to the getTablesInfo so we only have the table we asked for
        $script_display_field = $designerCommon->getTablesInfo($_POST['db'], $_POST['table']);
        $tab_column = $designerCommon->getColumnsInfo($script_display_field);
        $tables_all_keys = $designerCommon->getAllKeys($script_display_field);
        $tables_pk_or_unique_keys = $designerCommon->getPkOrUniqueKeys($script_display_field);

$html = $databaseDesigner->getDatabaseTables(
            $_POST['db'],
            $script_display_field,
            [],
            -1,
            $tab_column,
            $tables_all_keys,
            $tables_pk_or_unique_keys
        );
    }

if (! empty($html)) {
        $response->addHTML($html);
    }
    return;
}

if (isset($_POST['operation'])) {
    if ($_POST['operation'] == 'deletePage') {
        $success = $designerCommon->deletePage($_POST['selected_page']);
        $response->setRequestStatus($success);
    } elseif ($_POST['operation'] == 'savePage') {
        if ($_POST['save_page'] == 'same') {
            $page = $_POST['selected_page'];
        } else { // new
            if ($designerCommon->getPageExists($_POST['selected_value'])) {
                $response->addJSON(
                    'message',
                    /* l10n: The user tries to save a page with an existing name in Designer */
                    __(
                        sprintf(
                            "There already exists a page named \"%s\" please rename it to something else.",
                            htmlspecialchars($_POST['selected_value'])
                        )
                    )
                );
                $response->setRequestStatus(false);
                return;
            } else {
                $page = $designerCommon->createNewPage($_POST['selected_value'], $_POST['db']);
                $response->addJSON('id', $page);
            }
        }
        $success = $designerCommon->saveTablePositions($page);
        $response->setRequestStatus($success);
    } elseif ($_POST['operation'] == 'setDisplayField') {
        [
            $success,
            $message,
        ] = $designerCommon->saveDisplayField(
            $_POST['db'],
            $_POST['table'],
            $_POST['field']
        );
        $response->setRequestStatus($success);
        $response->addJSON('message', $message);
    } elseif ($_POST['operation'] == 'addNewRelation') {
        list($success, $message) = $designerCommon->addNewRelation(
            $_POST['db'],
            $_POST['T1'],
            $_POST['F1'],
            $_POST['T2'],
            $_POST['F2'],
            $_POST['on_delete'],
            $_POST['on_update'],
            $_POST['DB1'],
            $_POST['DB2']
        );
        $response->setRequestStatus($success);
        $response->addJSON('message', $message);
    } elseif ($_POST['operation'] == 'removeRelation') {
        list($success, $message) = $designerCommon->removeRelation(
            $_POST['T1'],
            $_POST['F1'],
            $_POST['T2'],
            $_POST['F2']
        );
        $response->setRequestStatus($success);
        $response->addJSON('message', $message);
    } elseif ($_POST['operation'] == 'save_setting_value') {
        $success = $designerCommon->saveSetting($_POST['index'], $_POST['value']);
        $response->setRequestStatus($success);
    }

return;
}

require ROOT_PATH . 'libraries/db_common.inc.php';

$script_display_field = $designerCommon->getTablesInfo();

$display_page = -1;
$selected_page = null;

if (isset($_GET['query'])) {
    $display_page = $designerCommon->getDefaultPage($_GET['db']);
} elseif (! empty($_GET['page'])) {
    $display_page = $_GET['page'];
} else {
    $display_page = $designerCommon->getLoadingPage($_GET['db']);
}
if ($display_page != -1) {
    $selected_page = $designerCommon->getPageName($display_page);
}
$tab_pos = $designerCommon->getTablePositions($display_page);

$fullTableNames = [];

foreach ($script_display_field as $designerTable) {
    $fullTableNames[] = $designerTable->getDbTableString();
}

foreach ($tab_pos as $position) {
    if (! in_array($position['dbName'] . '.' . $position['tableName'], $fullTableNames)) {
        foreach ($designerCommon->getTablesInfo($position['dbName'], $position['tableName']) as $designerTable) {
            $script_display_field[] = $designerTable;
        }
    }
}

$tab_column = $designerCommon->getColumnsInfo($script_display_field);
$script_tables = $designerCommon->getScriptTabs($script_display_field);
$tables_pk_or_unique_keys = $designerCommon->getPkOrUniqueKeys($script_display_field);
$tables_all_keys = $designerCommon->getAllKeys($script_display_field);
$classes_side_menu = $databaseDesigner->returnClassNamesFromMenuButtons();

$script_contr = $designerCommon->getScriptContr($script_display_field);

$params = ['lang' => $GLOBALS['lang']];
if (isset($_GET['db'])) {
    $params['db'] = $_GET['db'];
}

$response = Response::getInstance();
$response->getFooter()->setMinimal();
$header   = $response->getHeader();
$header->setBodyId('designer_body');

$scripts  = $header->getScripts();
$scripts->addFile('vendor/jquery/jquery.fullscreen.js');
$scripts->addFile('designer/database.js');
$scripts->addFile('designer/objects.js');
$scripts->addFile('designer/page.js');
$scripts->addFile('designer/history.js');
$scripts->addFile('designer/move.js');
$scripts->addFile('designer/init.js');

list(
    $tables,
    $num_tables,
    $total_num_tables,
    $sub_part,
    $is_show_stats,
    $db_is_system_schema,
    $tooltip_truename,
    $tooltip_aliasname,
    $pos
) = PhpMyAdmin\Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');

// Embed some data into HTML, later it will be read
// by designer/init.js and converted to JS variables.
$response->addHTML(
    $databaseDesigner->getHtmlForMain(
        $db,
        $_GET['db'],
        $script_display_field,
        $script_tables,
        $script_contr,
        $script_display_field,
        $display_page,
        isset($_GET['query']),
        $selected_page,
        $classes_side_menu,
        $tab_pos,
        $tab_column,
        $tables_all_keys,
        $tables_pk_or_unique_keys
    )
);

$response->addHTML('<div id="PMA_disable_floating_menubar"></div>');

${this.title}

Code Editor : db_designer.php