Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
Charsets	[ DIR ]	drwxrwxrwx
Config	[ DIR ]	drwxrwxrwx
Controllers	[ DIR ]	drwxrwxrwx
Database	[ DIR ]	drwxrwxrwx
Dbi	[ DIR ]	drwxrwxrwx
Di	[ DIR ]	drwxrwxrwx
Display	[ DIR ]	drwxrwxrwx
Engines	[ DIR ]	drwxrwxrwx
Gis	[ DIR ]	drwxrwxrwx
Navigation	[ DIR ]	drwxrwxrwx
Plugins	[ DIR ]	drwxrwxrwx
Properties	[ DIR ]	drwxrwxrwx
Rte	[ DIR ]	drwxrwxrwx
Server	[ DIR ]	drwxrwxrwx
Setup	[ DIR ]	drwxrwxrwx
Twig	[ DIR ]	drwxrwxrwx
Utils	[ DIR ]	drwxrwxrwx
Advisor.php	19.56 KB	-rw-rw-rw-
Bookmark.php	10.74 KB	-rw-rw-rw-
BrowseForeigners.php	11.15 KB	-rw-rw-rw-
CentralColumns.php	44.19 KB	-rw-rw-rw-
Charsets.php	6.14 KB	-rw-rw-rw-
CheckUserPrivileges.php	12.59 KB	-rw-rw-rw-
Config.php	57.38 KB	-rw-rw-rw-
Console.php	3.69 KB	-rw-rw-rw-
Core.php	38.31 KB	-rw-rw-rw-
CreateAddField.php	17.91 KB	-rw-rw-rw-
DatabaseInterface.php	104.47 KB	-rw-rw-rw-
Encoding.php	8.68 KB	-rw-rw-rw-
Error.php	13.34 KB	-rw-rw-rw-
ErrorHandler.php	17.17 KB	-rw-rw-rw-
ErrorReport.php	8.92 KB	-rw-rw-rw-
Export.php	42.76 KB	-rw-rw-rw-
File.php	21.29 KB	-rw-rw-rw-
FileListing.php	2.83 KB	-rw-rw-rw-
Font.php	5.54 KB	-rw-rw-rw-
Footer.php	10.6 KB	-rw-rw-rw-
Header.php	21.87 KB	-rw-rw-rw-
Import.php	56.56 KB	-rw-rw-rw-
Index.php	24.5 KB	-rw-rw-rw-
IndexColumn.php	4.44 KB	-rw-rw-rw-
InsertEdit.php	129.31 KB	-rw-rw-rw-
InternalRelations.php	17.42 KB	-rw-rw-rw-
IpAllowDeny.php	9.57 KB	-rw-rw-rw-
Language.php	4.31 KB	-rw-rw-rw-
LanguageManager.php	23.71 KB	-rw-rw-rw-
Linter.php	5.21 KB	-rw-rw-rw-
ListAbstract.php	2.51 KB	-rw-rw-rw-
ListDatabase.php	4.34 KB	-rw-rw-rw-
Logging.php	2.6 KB	-rw-rw-rw-
Menu.php	22.36 KB	-rw-rw-rw-
Message.php	19.32 KB	-rw-rw-rw-
Mime.php	916 B	-rw-rw-rw-
MultSubmits.php	23.64 KB	-rw-rw-rw-
Normalization.php	40.41 KB	-rw-rw-rw-
OpenDocument.php	8.52 KB	-rw-rw-rw-
Operations.php	81.25 KB	-rw-rw-rw-
OutputBuffering.php	3.71 KB	-rw-rw-rw-
ParseAnalyze.php	2.55 KB	-rw-rw-rw-
Partition.php	7.27 KB	-rw-rw-rw-
Pdf.php	4.37 KB	-rw-rw-rw-
Plugins.php	22.95 KB	-rw-rw-rw-
RecentFavoriteTable.php	12.04 KB	-rw-rw-rw-
Relation.php	79.64 KB	-rw-rw-rw-
RelationCleanup.php	15 KB	-rw-rw-rw-
Replication.php	5.75 KB	-rw-rw-rw-
ReplicationGui.php	21.23 KB	-rw-rw-rw-
Response.php	16.14 KB	-rw-rw-rw-
Sanitize.php	14.51 KB	-rw-rw-rw-
SavedSearches.php	11.94 KB	-rw-rw-rw-
Scripts.php	3.65 KB	-rw-rw-rw-
Session.php	7.62 KB	-rw-rw-rw-
Sql.php	82.09 KB	-rw-rw-rw-
SqlQueryForm.php	17.63 KB	-rw-rw-rw-
StorageEngine.php	13.75 KB	-rw-rw-rw-
SubPartition.php	3.55 KB	-rw-rw-rw-
SysInfo.php	1.61 KB	-rw-rw-rw-
SysInfoBase.php	822 B	-rw-rw-rw-
SysInfoLinux.php	2.16 KB	-rw-rw-rw-
SysInfoSunOS.php	1.89 KB	-rw-rw-rw-
SysInfoWINNT.php	3.27 KB	-rw-rw-rw-
SystemDatabase.php	3.97 KB	-rw-rw-rw-
Table.php	94.87 KB	-rw-rw-rw-
TablePartitionDefinition.php	6.64 KB	-rw-rw-rw-
Template.php	4.02 KB	-rw-rw-rw-
Theme.php	8.62 KB	-rw-rw-rw-
ThemeManager.php	10.42 KB	-rw-rw-rw-
Tracker.php	30.13 KB	-rw-rw-rw-
Tracking.php	40.26 KB	-rw-rw-rw-
Transformations.php	16.27 KB	-rw-rw-rw-
TwoFactor.php	7.14 KB	-rw-rw-rw-
Types.php	24.93 KB	-rw-rw-rw-
Url.php	8.32 KB	-rw-rw-rw-
UserPassword.php	9 KB	-rw-rw-rw-
UserPreferences.php	8.62 KB	-rw-rw-rw-
UserPreferencesHeader.php	4.13 KB	-rw-rw-rw-
Util.php	168.02 KB	-rw-rw-rw-
VersionInformation.php	6.92 KB	-rw-rw-rw-
ZipExtension.php	10.25 KB	-rw-rw-rw-

Name

Size

Permission

Action

Charsets

[ DIR ]

drwxrwxrwx

Config

[ DIR ]

drwxrwxrwx

Controllers

[ DIR ]

drwxrwxrwx

Database

[ DIR ]

drwxrwxrwx

Dbi

[ DIR ]

drwxrwxrwx

[ DIR ]

drwxrwxrwx

Display

[ DIR ]

drwxrwxrwx

Engines

[ DIR ]

drwxrwxrwx

Gis

[ DIR ]

drwxrwxrwx

Navigation

[ DIR ]

drwxrwxrwx

Plugins

[ DIR ]

drwxrwxrwx

Properties

[ DIR ]

drwxrwxrwx

Rte

[ DIR ]

drwxrwxrwx

Server

[ DIR ]

drwxrwxrwx

Setup

[ DIR ]

drwxrwxrwx

Twig

[ DIR ]

drwxrwxrwx

Utils

[ DIR ]

drwxrwxrwx

Advisor.php

19.56 KB

-rw-rw-rw-

Bookmark.php

10.74 KB

-rw-rw-rw-

BrowseForeigners.php

11.15 KB

-rw-rw-rw-

CentralColumns.php

44.19 KB

-rw-rw-rw-

Charsets.php

6.14 KB

-rw-rw-rw-

CheckUserPrivileges.php

12.59 KB

-rw-rw-rw-

Config.php

57.38 KB

-rw-rw-rw-

Console.php

3.69 KB

-rw-rw-rw-

Core.php

38.31 KB

-rw-rw-rw-

CreateAddField.php

17.91 KB

-rw-rw-rw-

DatabaseInterface.php

104.47 KB

-rw-rw-rw-

Encoding.php

8.68 KB

-rw-rw-rw-

Error.php

13.34 KB

-rw-rw-rw-

ErrorHandler.php

17.17 KB

-rw-rw-rw-

ErrorReport.php

8.92 KB

-rw-rw-rw-

Export.php

42.76 KB

-rw-rw-rw-

File.php

21.29 KB

-rw-rw-rw-

FileListing.php

2.83 KB

-rw-rw-rw-

Font.php

5.54 KB

-rw-rw-rw-

Footer.php

10.6 KB

-rw-rw-rw-

Header.php

21.87 KB

-rw-rw-rw-

Import.php

56.56 KB

-rw-rw-rw-

Index.php

24.5 KB

-rw-rw-rw-

IndexColumn.php

4.44 KB

-rw-rw-rw-

InsertEdit.php

129.31 KB

-rw-rw-rw-

InternalRelations.php

17.42 KB

-rw-rw-rw-

IpAllowDeny.php

9.57 KB

-rw-rw-rw-

Language.php

4.31 KB

-rw-rw-rw-

LanguageManager.php

23.71 KB

-rw-rw-rw-

Linter.php

5.21 KB

-rw-rw-rw-

ListAbstract.php

2.51 KB

-rw-rw-rw-

ListDatabase.php

4.34 KB

-rw-rw-rw-

Logging.php

2.6 KB

-rw-rw-rw-

Menu.php

22.36 KB

-rw-rw-rw-

Message.php

19.32 KB

-rw-rw-rw-

Mime.php

916 B

-rw-rw-rw-

MultSubmits.php

23.64 KB

-rw-rw-rw-

Normalization.php

40.41 KB

-rw-rw-rw-

OpenDocument.php

8.52 KB

-rw-rw-rw-

Operations.php

81.25 KB

-rw-rw-rw-

OutputBuffering.php

3.71 KB

-rw-rw-rw-

ParseAnalyze.php

2.55 KB

-rw-rw-rw-

Partition.php

7.27 KB

-rw-rw-rw-

Pdf.php

4.37 KB

-rw-rw-rw-

Plugins.php

22.95 KB

-rw-rw-rw-

RecentFavoriteTable.php

12.04 KB

-rw-rw-rw-

Relation.php

79.64 KB

-rw-rw-rw-

RelationCleanup.php

15 KB

-rw-rw-rw-

Replication.php

5.75 KB

-rw-rw-rw-

ReplicationGui.php

21.23 KB

-rw-rw-rw-

Response.php

16.14 KB

-rw-rw-rw-

Sanitize.php

14.51 KB

-rw-rw-rw-

SavedSearches.php

11.94 KB

-rw-rw-rw-

Scripts.php

3.65 KB

-rw-rw-rw-

Session.php

7.62 KB

-rw-rw-rw-

Sql.php

82.09 KB

-rw-rw-rw-

SqlQueryForm.php

17.63 KB

-rw-rw-rw-

StorageEngine.php

13.75 KB

-rw-rw-rw-

SubPartition.php

3.55 KB

-rw-rw-rw-

SysInfo.php

1.61 KB

-rw-rw-rw-

SysInfoBase.php

822 B

-rw-rw-rw-

SysInfoLinux.php

2.16 KB

-rw-rw-rw-

SysInfoSunOS.php

1.89 KB

-rw-rw-rw-

SysInfoWINNT.php

3.27 KB

-rw-rw-rw-

SystemDatabase.php

3.97 KB

-rw-rw-rw-

Table.php

94.87 KB

-rw-rw-rw-

TablePartitionDefinition.php

6.64 KB

-rw-rw-rw-

Template.php

4.02 KB

-rw-rw-rw-

Theme.php

8.62 KB

-rw-rw-rw-

ThemeManager.php

10.42 KB

-rw-rw-rw-

Tracker.php

30.13 KB

-rw-rw-rw-

Tracking.php

40.26 KB

-rw-rw-rw-

Transformations.php

16.27 KB

-rw-rw-rw-

TwoFactor.php

7.14 KB

-rw-rw-rw-

Types.php

24.93 KB

-rw-rw-rw-

Url.php

8.32 KB

-rw-rw-rw-

UserPassword.php

9 KB

-rw-rw-rw-

UserPreferences.php

8.62 KB

-rw-rw-rw-

UserPreferencesHeader.php

4.13 KB

-rw-rw-rw-

Util.php

168.02 KB

-rw-rw-rw-

VersionInformation.php

6.92 KB

-rw-rw-rw-

ZipExtension.php

10.25 KB

-rw-rw-rw-

Code Editor : SystemDatabase.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * hold PhpMyAdmin\SystemDatabase class
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

namespace PhpMyAdmin;

use mysqli_result;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Relation;
use PhpMyAdmin\Util;

/**
 * Class SystemDatabase
 *
 * @package PhpMyAdmin
 */
class SystemDatabase
{
    /**
     * @var DatabaseInterface
     */
    protected $dbi;

/**
     * @var Relation
     */
    private $relation;

/**
     * Get instance of SystemDatabase
     *
     * @param DatabaseInterface $dbi Database interface for the system database
     *
     */
    public function __construct(DatabaseInterface $dbi)
    {
        $this->dbi = $dbi;
        $this->relation = new Relation($this->dbi);
    }

/**
     * Get existing data on transformations applied for
     * columns in a particular table
     *
     * @param string $db Database name looking for
     *
     * @return mysqli_result|false Result of executed SQL query
     */
    public function getExistingTransformationData($db)
    {
        $cfgRelation = $this->relation->getRelationsParam();

if (! $cfgRelation['mimework']) {
            return false;
        }

// Get the existing transformation details of the same database
        // from pma__column_info table
        $pma_transformation_sql = sprintf(
            "SELECT * FROM %s.%s WHERE `db_name` = '%s'",
            Util::backquote($cfgRelation['db']),
            Util::backquote($cfgRelation['column_info']),
            $GLOBALS['dbi']->escapeString($db)
        );

return $this->dbi->tryQuery($pma_transformation_sql);
    }

/**
     * Get SQL query for store new transformation details of a VIEW
     *
     * @param object $pma_transformation_data Result set of SQL execution
     * @param array  $column_map              Details of VIEW columns
     * @param string $view_name               Name of the VIEW
     * @param string $db                      Database name of the VIEW
     *
     * @return string SQL query for new transformations
     */
    public function getNewTransformationDataSql(
        $pma_transformation_data,
        array $column_map,
        $view_name,
        $db
    ) {
        $cfgRelation = $this->relation->getRelationsParam();

// Need to store new transformation details for VIEW
        $new_transformations_sql = sprintf(
            "INSERT INTO %s.%s ("
            . "`db_name`, `table_name`, `column_name`, "
            . "`comment`, `mimetype`, `transformation`, "
            . "`transformation_options`) VALUES",
            Util::backquote($cfgRelation['db']),
            Util::backquote($cfgRelation['column_info'])
        );

$column_count = 0;
        $add_comma = false;

while ($data_row = $this->dbi->fetchAssoc($pma_transformation_data)) {
            foreach ($column_map as $column) {
                if ($data_row['table_name'] != $column['table_name']
                    || $data_row['column_name'] != $column['refering_column']
                ) {
                    continue;
                }

$new_transformations_sql .= sprintf(
                    "%s ('%s', '%s', '%s', '%s', '%s', '%s', '%s')",
                    $add_comma ? ', ' : '',
                    $db,
                    $view_name,
                    isset($column['real_column'])
                    ? $column['real_column']
                    : $column['refering_column'],
                    $data_row['comment'],
                    $data_row['mimetype'],
                    $data_row['transformation'],
                    $GLOBALS['dbi']->escapeString(
                        $data_row['transformation_options']
                    )
                );

$add_comma = true;
                $column_count++;
                break;
            }

if ($column_count == count($column_map)) {
                break;
            }
        }

return ($column_count > 0) ? $new_transformations_sql : '';
    }
}

${this.title}

Code Editor : SystemDatabase.php