getHeader(); $scripts = $header->getScripts(); $scripts->addFile('server_privileges.js'); /** * Displays an error message and exits if the user isn't allowed to use this * script */ if (! $GLOBALS['cfg']['ShowChgPassword']) { $GLOBALS['cfg']['ShowChgPassword'] = $GLOBALS['dbi']->selectDb('mysql'); } if ($cfg['Server']['auth_type'] == 'config' || ! $cfg['ShowChgPassword']) { PMA_Message::error( __('You don\'t have sufficient privileges to be here right now!') )->display(); exit; } // end if /** * If the "change password" form has been submitted, checks for valid values * and submit the query or logout */ if (isset($_REQUEST['nopass'])) { if ($_REQUEST['nopass'] == '1') { $password = ''; } else { $password = $_REQUEST['pma_pw']; } $change_password_message = PMA_setChangePasswordMsg(); $msg = $change_password_message['msg']; if (! $change_password_message['error']) { PMA_changePassword($password, $msg, $change_password_message); } else { PMA_getChangePassMessage($change_password_message); } } /** * If the "change password" form hasn't been submitted or the values submitted * aren't valid -> displays the form */ // Displays an error message if required if (isset($msg)) { $msg->display(); unset($msg); } require_once './libraries/display_change_password.lib.php'; echo PMA_getHtmlForChangePassword($username, $hostname); exit; /** * Send the message as an ajax request * * @param array $change_password_message Message to display * @param string $sql_query SQL query executed * * @return void */ function PMA_getChangePassMessage($change_password_message, $sql_query = '') { if ($GLOBALS['is_ajax_request'] == true) { /** * If in an Ajax request, we don't need to show the rest of the page */ $response = PMA_Response::getInstance(); if ($change_password_message['error']) { $response->addJSON('message', $change_password_message['msg']); $response->isSuccess(false); } else { $sql_query = PMA_Util::getMessage( $change_password_message['msg'], $sql_query, 'success' ); $response->addJSON('message', $sql_query); } exit; } } /** * Generate the message * * @return array error value and message */ function PMA_setChangePasswordMsg() { $error = false; $message = PMA_Message::success(__('The profile has been updated.')); if (($_REQUEST['nopass'] != '1')) { if (empty($_REQUEST['pma_pw']) || empty($_REQUEST['pma_pw2'])) { $message = PMA_Message::error(__('The password is empty!')); $error = true; } elseif ($_REQUEST['pma_pw'] != $_REQUEST['pma_pw2']) { $message = PMA_Message::error(__('The passwords aren\'t the same!')); $error = true; } } return array('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 */ function PMA_changePassword($password, $message, $change_password_message) { global $auth_plugin; $hashing_function = PMA_changePassHashingFunction(); if (PMA_Util::getServerType() === 'MySQL' && PMA_MYSQL_INT_VERSION >= 50706) { $sql_query = 'ALTER USER USER() IDENTIFIED BY ' . (($password == '') ? '\'\'' : '\'***\''); } else { $sql_query = 'SET password = ' . (($password == '') ? '\'\'' : $hashing_function . '(\'***\')'); } PMA_changePassUrlParamsAndSubmitQuery( $password, $sql_query, $hashing_function ); $auth_plugin->handlePasswordChange($password); PMA_getChangePassMessage($change_password_message, $sql_query); PMA_changePassDisplayPage($message, $sql_query); } /** * Generate the hashing function * * @return string $hashing_function */ function PMA_changePassHashingFunction() { if (PMA_isValid($_REQUEST['pw_hash'], 'identical', 'old')) { $hashing_function = 'OLD_PASSWORD'; } else { $hashing_function = 'PASSWORD'; } return $hashing_function; } /** * Generate the error url and submit the query * * @param string $password Password * @param string $sql_query SQL query * @param string $hashing_function Hashing function * * @return void */ function PMA_changePassUrlParamsAndSubmitQuery( $password, $sql_query, $hashing_function ) { $err_url = 'user_password.php' . PMA_URL_getCommon(); if (PMA_Util::getServerType() === 'MySQL' && PMA_MYSQL_INT_VERSION >= 50706) { $local_query = 'ALTER USER USER() IDENTIFIED BY ' . (($password == '') ? '\'\'' : '\'' . PMA_Util::sqlAddSlashes($password) . '\''); } else { $local_query = 'SET password = ' . (($password == '') ? '\'\'' : $hashing_function . '(\'' . PMA_Util::sqlAddSlashes($password) . '\')'); } if (! @$GLOBALS['dbi']->tryQuery($local_query)) { PMA_Util::mysqlDie($GLOBALS['dbi']->getError(), $sql_query, false, $err_url); } } /** * Display the page * * @param string $message Message * @param string $sql_query SQL query * * @return void */ function PMA_changePassDisplayPage($message, $sql_query) { echo '

' . __('Change password') . '

' . "\n\n"; echo PMA_Util::getMessage( $message, $sql_query, 'success' ); echo '' . "\n" . '' . __('Back') . ''; exit; }