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: */
/**
 * Holds the PhpMyAdmin\UserPassword class
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

namespace PhpMyAdmin;

use PhpMyAdmin\Core;
use PhpMyAdmin\Message;
use PhpMyAdmin\Response;
use PhpMyAdmin\Server\Privileges;
use PhpMyAdmin\Url;
use PhpMyAdmin\Util;

/**
 * Functions for user_password.php
 *
 * @package PhpMyAdmin
 */
class UserPassword
{
    /**
     * @var Privileges
     */
    private $serverPrivileges;

/**
     * UserPassword constructor.
     *
     * @param Privileges $serverPrivileges Privileges object
     */
    public function __construct(Privileges $serverPrivileges)
    {
        $this->serverPrivileges = $serverPrivileges;
    }

/**
     * Send the message as an ajax request
     *
     * @param array  $change_password_message Message to display
     * @param string $sql_query               SQL query executed
     *
     * @return void
     */
    public function getChangePassMessage(array $change_password_message, $sql_query = '')
    {
        $response = Response::getInstance();
        if ($response->isAjax()) {
            /**
             * If in an Ajax request, we don't need to show the rest of the page
             */
            if ($change_password_message['error']) {
                $response->addJSON('message', $change_password_message['msg']);
                $response->setRequestStatus(false);
            } else {
                $sql_query = Util::getMessage(
                    $change_password_message['msg'],
                    $sql_query,
                    'success'
                );
                $response->addJSON('message', $sql_query);
            }
            exit;
        }
    }

/**
     * Generate the message
     *
     * @return array   error value and message
     */
    public function setChangePasswordMsg()
    {
        $error = false;
        $message = Message::success(__('The profile has been updated.'));

if ($_POST['nopass'] != '1') {
            if (strlen($_POST['pma_pw']) === 0 || strlen($_POST['pma_pw2']) === 0) {
                $message = Message::error(__('The password is empty!'));
                $error = true;
            } elseif ($_POST['pma_pw'] !== $_POST['pma_pw2']) {
                $message = Message::error(
                    __('The passwords aren\'t the same!')
                );
                $error = true;
            } elseif (strlen($_POST['pma_pw']) > 256) {
                $message = Message::error(__('Password is too long!'));
                $error = true;
            }
        }
        return [
            'error' => $error,
            'msg' => $message,
        ];
    }

/**
     * Change the password
     *
     * @param string $password                New password
     * @param string $message                 Message
     * @param array  $change_password_message Message to show
     *
     * @return void
     */
    public function changePassword($password, $message, array $change_password_message)
    {
        global $auth_plugin;

$hashing_function = $this->changePassHashingFunction();

list($username, $hostname) = $GLOBALS['dbi']->getCurrentUserAndHost();

$serverType = Util::getServerType();
        $serverVersion = $GLOBALS['dbi']->getVersion();

if (isset($_POST['authentication_plugin'])
            && ! empty($_POST['authentication_plugin'])
        ) {
            $orig_auth_plugin = $_POST['authentication_plugin'];
        } else {
            $orig_auth_plugin = $this->serverPrivileges->getCurrentAuthenticationPlugin(
                'change',
                $username,
                $hostname
            );
        }

$sql_query = 'SET password = '
            . (($password == '') ? '\'\'' : $hashing_function . '(\'***\')');

if ($serverType == 'MySQL'
            && $serverVersion >= 50706
        ) {
            $sql_query = 'ALTER USER \'' . $GLOBALS['dbi']->escapeString($username)
                . '\'@\'' . $GLOBALS['dbi']->escapeString($hostname)
                . '\' IDENTIFIED WITH ' . $orig_auth_plugin . ' BY '
                . (($password == '') ? '\'\'' : '\'***\'');
        } elseif (($serverType == 'MySQL'
            && $serverVersion >= 50507)
            || ($serverType == 'MariaDB'
            && $serverVersion >= 50200)
        ) {
            // For MySQL versions 5.5.7+ and MariaDB versions 5.2+,
            // explicitly set value of `old_passwords` so that
            // it does not give an error while using
            // the PASSWORD() function
            if ($orig_auth_plugin == 'sha256_password') {
                $value = 2;
            } else {
                $value = 0;
            }
            $GLOBALS['dbi']->tryQuery('SET `old_passwords` = ' . $value . ';');
        }

$this->changePassUrlParamsAndSubmitQuery(
            $username,
            $hostname,
            $password,
            $sql_query,
            $hashing_function,
            $orig_auth_plugin
        );

$auth_plugin->handlePasswordChange($password);
        $this->getChangePassMessage($change_password_message, $sql_query);
        $this->changePassDisplayPage($message, $sql_query);
    }

/**
     * Generate the hashing function
     *
     * @return string
     */
    private function changePassHashingFunction()
    {
        if (Core::isValid(
            $_POST['authentication_plugin'],
            'identical',
            'mysql_old_password'
        )) {
            $hashing_function = 'OLD_PASSWORD';
        } else {
            $hashing_function = 'PASSWORD';
        }
        return $hashing_function;
    }

/**
     * Changes password for a user
     *
     * @param string $username         Username
     * @param string $hostname         Hostname
     * @param string $password         Password
     * @param string $sql_query        SQL query
     * @param string $hashing_function Hashing function
     * @param string $orig_auth_plugin Original Authentication Plugin
     *
     * @return void
     */
    private function changePassUrlParamsAndSubmitQuery(
        $username,
        $hostname,
        $password,
        $sql_query,
        $hashing_function,
        $orig_auth_plugin
    ) {
        $err_url = 'user_password.php' . Url::getCommon();

$serverType = Util::getServerType();
        $serverVersion = $GLOBALS['dbi']->getVersion();

if ($serverType == 'MySQL' && $serverVersion >= 50706) {
            $local_query = 'ALTER USER \'' . $GLOBALS['dbi']->escapeString($username)
                . '\'@\'' . $GLOBALS['dbi']->escapeString($hostname) . '\''
                . ' IDENTIFIED with ' . $orig_auth_plugin . ' BY '
                . (($password == '')
                ? '\'\''
                : '\'' . $GLOBALS['dbi']->escapeString($password) . '\'');
        } elseif ($serverType == 'MariaDB'
            && $serverVersion >= 50200
            && $serverVersion < 100100
            && $orig_auth_plugin !== ''
        ) {
            if ($orig_auth_plugin == 'mysql_native_password') {
                // Set the hashing method used by PASSWORD()
                // to be 'mysql_native_password' type
                $GLOBALS['dbi']->tryQuery('SET old_passwords = 0;');
            } elseif ($orig_auth_plugin == 'sha256_password') {
                // Set the hashing method used by PASSWORD()
                // to be 'sha256_password' type
                $GLOBALS['dbi']->tryQuery('SET `old_passwords` = 2;');
            }

$hashedPassword = $this->serverPrivileges->getHashedPassword($_POST['pma_pw']);

$local_query = "UPDATE `mysql`.`user` SET"
                . " `authentication_string` = '" . $hashedPassword
                . "', `Password` = '', "
                . " `plugin` = '" . $orig_auth_plugin . "'"
                . " WHERE `User` = '" . $GLOBALS['dbi']->escapeString($username)
                . "' AND Host = '" . $GLOBALS['dbi']->escapeString($hostname) . "';";
        } else {
            $local_query = 'SET password = ' . (($password == '')
                ? '\'\''
                : $hashing_function . '(\''
                    . $GLOBALS['dbi']->escapeString($password) . '\')');
        }
        if (! @$GLOBALS['dbi']->tryQuery($local_query)) {
            Util::mysqlDie(
                $GLOBALS['dbi']->getError(),
                $sql_query,
                false,
                $err_url
            );
        }

// Flush privileges after successful password change
        $GLOBALS['dbi']->tryQuery("FLUSH PRIVILEGES;");
    }

/**
     * Display the page
     *
     * @param string $message   Message
     * @param string $sql_query SQL query
     *
     * @return void
     */
    private function changePassDisplayPage($message, $sql_query)
    {
        echo '<h1>' , __('Change password') , '</h1>' , "\n\n";
        echo Util::getMessage(
            $message,
            $sql_query,
            'success'
        );
        echo '<a href="index.php' , Url::getCommon()
            , ' target="_parent">' , "\n"
            , '<strong>' , __('Back') , '</strong></a>';
        exit;
    }
}