2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * displays and handles the form where the user can change his password
5 * linked from index.php
11 * Gets some core libraries
13 require_once './libraries/common.inc.php';
15 $response = PMA_Response
::getInstance();
16 $header = $response->getHeader();
17 $scripts = $header->getScripts();
18 $scripts->addFile('server_privileges.js');
21 * Displays an error message and exits if the user isn't allowed to use this
24 if (! $GLOBALS['cfg']['ShowChgPassword']) {
25 $GLOBALS['cfg']['ShowChgPassword'] = $GLOBALS['dbi']->selectDb('mysql');
27 if ($cfg['Server']['auth_type'] == 'config' ||
! $cfg['ShowChgPassword']) {
29 __('You don\'t have sufficient privileges to be here right now!')
35 * If the "change password" form has been submitted, checks for valid values
36 * and submit the query or logout
38 if (isset($_REQUEST['nopass'])) {
39 if ($_REQUEST['nopass'] == '1') {
42 $password = $_REQUEST['pma_pw'];
44 $change_password_message = PMA_setChangePasswordMsg();
45 $msg = $change_password_message['msg'];
46 if (! $change_password_message['error']) {
47 PMA_changePassword($password, $msg, $change_password_message);
49 PMA_getChangePassMessage($change_password_message);
54 * If the "change password" form hasn't been submitted or the values submitted
55 * aren't valid -> displays the form
58 // Displays an error message if required
64 require_once './libraries/display_change_password.lib.php';
65 echo PMA_getHtmlForChangePassword($username, $hostname);
69 * Send the message as an ajax request
71 * @param array $change_password_message Message to display
72 * @param string $sql_query SQL query executed
76 function PMA_getChangePassMessage($change_password_message, $sql_query = '')
78 if ($GLOBALS['is_ajax_request'] == true) {
80 * If in an Ajax request, we don't need to show the rest of the page
82 $response = PMA_Response
::getInstance();
83 if ($change_password_message['error']) {
84 $response->addJSON('message', $change_password_message['msg']);
85 $response->isSuccess(false);
87 $sql_query = PMA_Util
::getMessage(
88 $change_password_message['msg'],
92 $response->addJSON('message', $sql_query);
99 * Generate the message
101 * @return array error value and message
103 function PMA_setChangePasswordMsg()
106 $message = PMA_Message
::success(__('The profile has been updated.'));
108 if (($_REQUEST['nopass'] != '1')) {
109 if (empty($_REQUEST['pma_pw']) ||
empty($_REQUEST['pma_pw2'])) {
110 $message = PMA_Message
::error(__('The password is empty!'));
112 } elseif ($_REQUEST['pma_pw'] != $_REQUEST['pma_pw2']) {
113 $message = PMA_Message
::error(__('The passwords aren\'t the same!'));
117 return array('error' => $error, 'msg' => $message);
121 * Change the password
123 * @param string $password New password
124 * @param string $message Message
125 * @param array $change_password_message Message to show
129 function PMA_changePassword($password, $message, $change_password_message)
133 $hashing_function = PMA_changePassHashingFunction();
134 if (PMA_Util
::getServerType() === 'MySQL' && PMA_MYSQL_INT_VERSION
>= 50706) {
135 $sql_query = 'ALTER USER USER() IDENTIFIED BY '
136 . (($password == '') ?
'\'\'' : '\'***\'');
138 $sql_query = 'SET password = '
139 . (($password == '') ?
'\'\'' : $hashing_function . '(\'***\')');
141 PMA_changePassUrlParamsAndSubmitQuery(
142 $password, $sql_query, $hashing_function
145 $auth_plugin->handlePasswordChange($password);
146 PMA_getChangePassMessage($change_password_message, $sql_query);
147 PMA_changePassDisplayPage($message, $sql_query);
151 * Generate the hashing function
153 * @return string $hashing_function
155 function PMA_changePassHashingFunction()
157 if (PMA_isValid($_REQUEST['pw_hash'], 'identical', 'old')) {
158 $hashing_function = 'OLD_PASSWORD';
160 $hashing_function = 'PASSWORD';
162 return $hashing_function;
166 * Generate the error url and submit the query
168 * @param string $password Password
169 * @param string $sql_query SQL query
170 * @param string $hashing_function Hashing function
174 function PMA_changePassUrlParamsAndSubmitQuery(
175 $password, $sql_query, $hashing_function
177 $err_url = 'user_password.php' . PMA_URL_getCommon();
178 if (PMA_Util
::getServerType() === 'MySQL' && PMA_MYSQL_INT_VERSION
>= 50706) {
179 $local_query = 'ALTER USER USER() IDENTIFIED BY ' . (($password == '')
181 : '\'' . PMA_Util
::sqlAddSlashes($password) . '\'');
183 $local_query = 'SET password = ' . (($password == '')
185 : $hashing_function . '(\'' . PMA_Util
::sqlAddSlashes($password)
188 if (! @$GLOBALS['dbi']->tryQuery($local_query)) {
189 PMA_Util
::mysqlDie($GLOBALS['dbi']->getError(), $sql_query, false, $err_url);
196 * @param string $message Message
197 * @param string $sql_query SQL query
201 function PMA_changePassDisplayPage($message, $sql_query)
203 echo '<h1>' . __('Change password') . '</h1>' . "\n\n";
204 echo PMA_Util
::getMessage(
205 $message, $sql_query, 'success'
207 echo '<a href="index.php' . PMA_URL_getCommon()
208 . ' target="_parent">' . "\n"
209 . '<strong>' . __('Back') . '</strong></a>';