/**
 * 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;
}
Esempio n. 2
0
/**
 * 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;
}