$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); }