/** * Update Data for information: Deletes users * * @param array $queries queries array * * @return array */ function PMA_getDataForDeleteUsers($queries) { if (isset($_REQUEST['change_copy'])) { $selected_usr = array($_REQUEST['old_username'] . '' . $_REQUEST['old_hostname']); } else { $selected_usr = $_REQUEST['selected_usr']; $queries = array(); } foreach ($selected_usr as $each_user) { list($this_user, $this_host) = explode('', $each_user); $queries[] = '# ' . sprintf(__('Deleting %s'), '\'' . $this_user . '\'@\'' . $this_host . '\'') . ' ...'; $queries[] = 'DROP USER \'' . PMA_Util::sqlAddSlashes($this_user) . '\'@\'' . PMA_Util::sqlAddSlashes($this_host) . '\';'; PMA_relationsCleanupUser($this_user); if (isset($_REQUEST['drop_users_db'])) { $queries[] = 'DROP DATABASE IF EXISTS ' . PMA_Util::backquote($this_user) . ';'; $GLOBALS['reload'] = true; } } return $queries; }
/** * Update Data for information: Deletes users * * @param array $queries queries array * * @return array */ function PMA_getDataForDeleteUsers($queries) { if (isset($_REQUEST['change_copy'])) { $selected_usr = array($_REQUEST['old_username'] . '' . $_REQUEST['old_hostname']); } else { $selected_usr = $_REQUEST['selected_usr']; $queries = array(); } // this happens, was seen in https://reports.phpmyadmin.net/reports/view/17146 if (!is_array($selected_usr)) { return array(); } foreach ($selected_usr as $each_user) { list($this_user, $this_host) = explode('', $each_user); $queries[] = '# ' . sprintf(__('Deleting %s'), '\'' . $this_user . '\'@\'' . $this_host . '\'') . ' ...'; $queries[] = 'DROP USER \'' . $GLOBALS['dbi']->escapeString($this_user) . '\'@\'' . $GLOBALS['dbi']->escapeString($this_host) . '\';'; PMA_relationsCleanupUser($this_user); if (isset($_REQUEST['drop_users_db'])) { $queries[] = 'DROP DATABASE IF EXISTS ' . Util::backquote($this_user) . ';'; $GLOBALS['reload'] = true; } } return $queries; }