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: */
/**
 * Set of functions used for cleaning up phpMyAdmin tables
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

namespace PhpMyAdmin;

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

/**
 * PhpMyAdmin\RelationCleanup class
 *
 * @package PhpMyAdmin
 */
class RelationCleanup
{
    /**
     * @var Relation
     */
    public $relation;

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

/**
     * RelationCleanup constructor.
     *
     * @param DatabaseInterface $dbi      DatabaseInterface object
     * @param Relation          $relation Relation object
     */
    public function __construct($dbi, Relation $relation)
    {
        $this->dbi = $dbi;
        $this->relation = $relation;
    }

/**
     * Cleanup column related relation stuff
     *
     * @param string $db     database name
     * @param string $table  table name
     * @param string $column column name
     *
     * @return void
     */
    public function column($db, $table, $column)
    {
        $cfgRelation = $this->relation->getRelationsParam();

if ($cfgRelation['commwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['column_info'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND table_name = \'' . $this->dbi->escapeString($table)
                . '\''
                . ' AND column_name = \'' . $this->dbi->escapeString($column)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['displaywork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['table_info'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND table_name = \'' . $this->dbi->escapeString($table)
                . '\''
                . ' AND display_field = \'' . $this->dbi->escapeString($column)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['relwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['relation'])
                . ' WHERE master_db  = \'' . $this->dbi->escapeString($db)
                . '\''
                . ' AND master_table = \'' . $this->dbi->escapeString($table)
                . '\''
                . ' AND master_field = \'' . $this->dbi->escapeString($column)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);

$remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['relation'])
                . ' WHERE foreign_db  = \'' . $this->dbi->escapeString($db)
                . '\''
                . ' AND foreign_table = \'' . $this->dbi->escapeString($table)
                . '\''
                . ' AND foreign_field = \'' . $this->dbi->escapeString($column)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }
    }

/**
     * Cleanup table related relation stuff
     *
     * @param string $db    database name
     * @param string $table table name
     *
     * @return void
     */
    public function table($db, $table)
    {
        $cfgRelation = $this->relation->getRelationsParam();

if ($cfgRelation['commwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['column_info'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND table_name = \'' . $this->dbi->escapeString($table)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['displaywork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['table_info'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND table_name = \'' . $this->dbi->escapeString($table)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['pdfwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['table_coords'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND table_name = \'' . $this->dbi->escapeString($table)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['relwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['relation'])
                . ' WHERE master_db  = \'' . $this->dbi->escapeString($db)
                . '\''
                . ' AND master_table = \'' . $this->dbi->escapeString($table)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);

$remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['relation'])
                . ' WHERE foreign_db  = \'' . $this->dbi->escapeString($db)
                . '\''
                . ' AND foreign_table = \'' . $this->dbi->escapeString($table)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['uiprefswork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['table_uiprefs'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND table_name = \'' . $this->dbi->escapeString($table)
                . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['navwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['navigationhiding'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\''
                . ' AND (table_name = \'' . $this->dbi->escapeString($table)
                . '\''
                . ' OR (item_name = \'' . $this->dbi->escapeString($table)
                . '\''
                . ' AND item_type = \'table\'))';
            $this->relation->queryAsControlUser($remove_query);
        }
    }

/**
     * Cleanup database related relation stuff
     *
     * @param string $db database name
     *
     * @return void
     */
    public function database($db)
    {
        $cfgRelation = $this->relation->getRelationsParam();

if ($cfgRelation['bookmarkwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['bookmark'])
                . ' WHERE dbase  = \'' . $this->dbi->escapeString($db) . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['pdfwork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['pdf_pages'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
            $this->relation->queryAsControlUser($remove_query);

$remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['table_coords'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['uiprefswork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['table_uiprefs'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['savedsearcheswork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['savedsearches'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['centralcolumnswork']) {
            $remove_query = 'DELETE FROM '
                . Util::backquote($cfgRelation['db'])
                . '.' . Util::backquote($cfgRelation['central_columns'])
                . ' WHERE db_name  = \'' . $this->dbi->escapeString($db) . '\'';
            $this->relation->queryAsControlUser($remove_query);
        }
    }

/**
     * Cleanup user related relation stuff
     *
     * @param string $username username
     *
     * @return void
     */
    public function user($username)
    {
        $cfgRelation = $this->relation->getRelationsParam();

if ($cfgRelation['bookmarkwork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['bookmark'])
                . " WHERE `user`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['historywork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['history'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['recentwork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['recent'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['favoritework']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['favorite'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['uiprefswork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['table_uiprefs'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['userconfigwork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['userconfig'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['menuswork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['users'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['navwork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['navigationhiding'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['savedsearcheswork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['savedsearches'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }

if ($cfgRelation['designersettingswork']) {
            $remove_query = "DELETE FROM "
                . Util::backquote($cfgRelation['db'])
                . "." . Util::backquote($cfgRelation['designer_settings'])
                . " WHERE `username`  = '" . $this->dbi->escapeString($username)
                . "'";
            $this->relation->queryAsControlUser($remove_query);
        }
    }
}