$res = mysql_query($sql);
if ($res) {
setmsg(t("Password updated"), 'notice', 'self');
} else {
setmsg(mysql_error());
}
}
if (checktoken() && 'host' == $op) {
$host = $_REQUEST['host'];
$old_host = $_REQUEST['old_host'];
$host || ($host = 'localhost');
$user = $name;
$dbhost = $host;
// overwrites the global $dbhost
// create user
if (ZDatabase::addmysqluser($user)) {
$sql = "DROP USER '{$user}'@'{$old_host}'";
$res = mysql_query($sql);
if (!$res) {
setmsg(mysql_error());
break;
}
setmsg(t('Updated.'), 'notice');
} else {
setmsg(t('Database Error. ') . mysql_error(), 'error');
}
}
if (checktoken() && ('deluser' == $op || 'remove' == $op)) {
$deldb = isset($_REQUEST['deldb']);
$host = $_REQUEST['host'];
$host || ($host = 'localhost');
}
// check domain
if (true !== ($res = ZVhosts::chkDomain($domain))) {
$err['domain'] = t('Domain Invalid.');
if ($res == 'occupied') {
$err['domain'] = t('Domain Occupied.');
}
$break = true;
}
if ($break) {
break;
}
// execute!
$r1 = ZUser::adduser_request($username, $password, $package);
$r2 = ZVhosts::addvhost($username, $domain);
$r3 = ZDatabase::addmysqluser($username, $password);
setmsg(t('Adduser request pending. It will take a few minutes to take into effect.'), 'notice');
}
break;
case 'edit':
$token = token();
$name = isset($_REQUEST['name']) ? $_REQUEST['name'] : '';
if (!isadmin() && $me != $name) {
setmsg(t('Permission Denied.'));
//break;
}
$name = preg_replace("/[^a-z0-9]+/i", "", $name);
if (!$name) {
redirect('user.php');
}
$package = ZPackage::getUserPackage($name);
function addmysqluser($user, $pass)
{
return ZDatabase::addmysqluser($user, $pass);
}
