Gecko [ unitednationsplay.com ]

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

Rename

<?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 : '';
    }
}