}
if (isset($_REQUEST['adduser'])) {
// Add user
$response->addHTML(PMA_getHtmlForAddUser(isset($dbname) ? $dbname : ''));
} elseif (isset($_REQUEST['checkprivsdb'])) {
if (isset($_REQUEST['checkprivstable'])) {
// check the privileges for a particular table.
$response->addHTML(PMA_getHtmlForSpecificTablePrivileges($_REQUEST['checkprivsdb'], $_REQUEST['checkprivstable']));
} else {
// check the privileges for a particular database.
$response->addHTML(PMA_getHtmlForSpecificDbPrivileges($_REQUEST['checkprivsdb']));
}
} else {
if (!isset($username)) {
// No username is given --> display the overview
$response->addHTML(PMA_getHtmlForUserOverview($pmaThemeImage, $text_dir));
} else {
// A user was selected -> display the user's properties
// In an Ajax request, prevent cached values from showing
if ($GLOBALS['is_ajax_request'] == true) {
header('Cache-Control: no-cache');
}
if (isset($dbname) && !is_array($dbname)) {
$url_dbname = urlencode(str_replace(array('\\_', '\\%'), array('_', '%'), $_REQUEST['dbname']));
}
$response->addHTML(PMA_getHtmlForUserProperties(isset($dbname_is_wildcard) ? $dbname_is_wildcard : '', isset($url_dbname) ? $url_dbname : '', $username, $hostname, isset($dbname) ? $dbname : '', isset($tablename) ? $tablename : ''));
}
}
if (isset($_REQUEST['viewing_mode']) && $_REQUEST['viewing_mode'] == 'server' && $GLOBALS['cfgRelation']['menuswork']) {
$response->addHTML('</div>');
}
/**
* Tests for PMA_getHtmlForUserProperties
*
* @return void
*/
function testPMAGetHtmlForUserProperties()
{
$actual = PMA_getHtmlForUserProperties(false, 'db', 'user', 'host', 'db', 'table');
$this->assertContains('addUsersForm', $actual);
$this->assertContains('SELECT', $actual);
$this->assertContains('Allows reading data.', $actual);
$this->assertContains('INSERT', $actual);
$this->assertContains('Allows inserting and replacing data.', $actual);
$this->assertContains('UPDATE', $actual);
$this->assertContains('Allows changing data.', $actual);
$this->assertContains('DELETE', $actual);
$this->assertContains('Allows deleting data.', $actual);
$this->assertContains('CREATE', $actual);
$this->assertContains('Allows creating new tables.', $actual);
}
$response->addHTML(
PMA_getHtmlForRoutineSpecificPrivilges(
$username, $hostname, $dbname, $routinename,
(isset($url_dbname) ? $url_dbname : '')
)
);
} else {
// A user was selected -> display the user's properties
// In an Ajax request, prevent cached values from showing
if ($response->isAjax()) {
header('Cache-Control: no-cache');
}
$response->addHTML(
PMA_getHtmlForUserProperties(
(isset($dbname_is_wildcard) ? $dbname_is_wildcard : ''),
(isset($url_dbname) ? $url_dbname : ''),
$username, $hostname,
(isset($dbname) ? $dbname : ''),
(isset($tablename) ? $tablename : '')
)
);
}
}
if ((isset($_REQUEST['viewing_mode']) && $_REQUEST['viewing_mode'] == 'server')
&& $GLOBALS['cfgRelation']['menuswork']
) {
$response->addHTML('</div>');
}