File Manager

003 File Manager

Current Path: /usr/local/www/sites/shared/phpmyadmin/libraries/classes

usr / local / www / sites / shared / phpmyadmin / libraries / classes /

📁 ..
📄 Advisor.php(17.87 KB)
📄 Bookmark.php(9.85 KB)
📄 BrowseForeigners.php(10.7 KB)
📄 CentralColumns.php(53.12 KB)
📄 Charsets.php(24.07 KB)
📄 CheckUserPrivileges.php(11.58 KB)
📁 Config
📄 Config.php(58.1 KB)
📄 Console.php(3.58 KB)
📁 Controllers
📄 Core.php(38.15 KB)
📄 CreateAddField.php(17.95 KB)
📁 Database
📄 DatabaseInterface.php(103.63 KB)
📁 Dbi
📁 Di
📁 Display
📄 Encoding.php(8.25 KB)
📁 Engines
📄 Error.php(12.93 KB)
📄 ErrorHandler.php(16.32 KB)
📄 ErrorReport.php(8.28 KB)
📄 Export.php(40.32 KB)
📄 File.php(20.43 KB)
📄 FileListing.php(2.83 KB)
📄 Font.php(4.25 KB)
📄 Footer.php(10.47 KB)
📁 Gis
📄 Header.php(25.81 KB)
📄 Import.php(55.59 KB)
📄 Index.php(24.63 KB)
📄 IndexColumn.php(4.43 KB)
📄 InsertEdit.php(129.1 KB)
📄 IpAllowDeny.php(9.21 KB)
📄 Language.php(4.3 KB)
📄 LanguageManager.php(23.17 KB)
📄 Linter.php(5.1 KB)
📄 ListAbstract.php(3.15 KB)
📄 ListDatabase.php(4.22 KB)
📄 Logging.php(2.56 KB)
📄 Menu.php(22.34 KB)
📄 Message.php(19.19 KB)
📄 Mime.php(891 B)
📄 MultSubmits.php(23.19 KB)
📁 Navigation
📄 Normalization.php(38.99 KB)
📄 OpenDocument.php(8.5 KB)
📄 Operations.php(79.4 KB)
📄 OutputBuffering.php(3.63 KB)
📄 ParseAnalyze.php(2.46 KB)
📄 Partition.php(7.26 KB)
📄 Pdf.php(4.07 KB)
📁 Plugins
📄 Plugins.php(21.42 KB)
📁 Properties
📄 RecentFavoriteTable.php(12.05 KB)
📄 Relation.php(75.97 KB)
📄 RelationCleanup.php(14.7 KB)
📄 Replication.php(5.37 KB)
📄 ReplicationGui.php(41.46 KB)
📄 Response.php(16.31 KB)
📁 Rte
📄 Sanitize.php(14.15 KB)
📄 SavedSearches.php(11.95 KB)
📄 Scripts.php(5.33 KB)
📁 Server
📄 Session.php(7.68 KB)
📄 Sql.php(87.62 KB)
📄 SqlQueryForm.php(17.19 KB)
📄 StorageEngine.php(13.47 KB)
📄 SubPartition.php(3.53 KB)
📄 SysInfo.php(1.54 KB)
📄 SysInfoBase.php(801 B)
📄 SysInfoLinux.php(1.96 KB)
📄 SysInfoSunOS.php(1.87 KB)
📄 SysInfoWINNT.php(3.1 KB)
📄 SystemDatabase.php(3.84 KB)
📄 Table.php(92.48 KB)
📄 Template.php(3.91 KB)
📄 Theme.php(10.53 KB)
📄 ThemeManager.php(10.64 KB)
📄 Tracker.php(29.43 KB)
📄 Tracking.php(41.96 KB)
📄 Transformations.php(16.12 KB)
📁 Twig
📄 TwoFactor.php(7 KB)
📄 Types.php(22.75 KB)
📄 Url.php(8.02 KB)
📄 UserPassword.php(8.26 KB)
📄 UserPreferences.php(8.52 KB)
📄 Util.php(162.41 KB)
📁 Utils
📄 VersionInformation.php(6.34 KB)
📄 ZipExtension.php(9.98 KB)

Editing: SystemDatabase.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * hold PhpMyAdmin\SystemDatabase class
 *
 * @package PhpMyAdmin
 */
namespace PhpMyAdmin;

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

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

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

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

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

// 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 $new_transformations_sql SQL query for new transformations
     */
    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 : '';
    }
}

003 File Manager

Editing: SystemDatabase.php

Upload File

Create Folder