function FREEWEB_ADD($value)
{
$array = unserialize(base64_decode($value));
$EXEC_NICE = EXEC_NICE();
if (is_file("/usr/bin/nohup")) {
$nohup = "/usr/bin/nohup ";
}
$reload_datas = $nohup . $EXEC_NICE . LOCATE_PHP5_BIN() . " " . dirname(__FILE__) . "/exec.artica.meta.users.php --export-freewebs >/dev/null 2>&1 &";
$q = new mysql();
$sql = "SELECT servername FROM freeweb WHERE servername='{$array["servername"]}'";
$ligne = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
if ($ligne["servername"] != null) {
$sql = "UPDATE freeweb SET \n\t\t\tmysql_password='******',\n\t\t\tmysql_username='******',\n\t\t\tftpuser='******',\n\t\t\tftppassword='******',\n\t\t\tuid='{$array["uid"]}',\n\t\t\tuseSSL='{$array["useSSL"]}' WHERE servername='{$array["servername"]}'\n\t\t";
} else {
$sql = "INSERT INTO freeweb (mysql_password,mysql_username,ftpuser,ftppassword,useSSL,servername,mysql_database,uid)\n\t\tVALUES('{$array["mysql_password"]}','{$array["mysql_username"]}','{$array["ftpuser"]}',\n\t\t'{$array["ftppassword"]}','{$array["useSSL"]}','{$array["servername"]}','{$array["mysql_database"]}','{$array["uid"]}')";
}
$q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
events("{$q->mysql_error} for {$array["servername"]}", __FUNCTION__, __FILE__, __LINE__);
send_email_events("Failed creating {$array["servername"]} web site", $q->mysql_error, "CLOUD");
shell_exec($reload_datas);
return true;
}
include_once 'ressources/class.pure-ftpd.inc';
$pure = new pureftpd_user();
if (!$pure->CreateUser($array["ftpuser"], $array["ftppassword"], $array["servername"])) {
events("Failed creating ftp account for {$array["servername"]}", __FUNCTION__, __FILE__, __LINE__);
send_email_events("Failed creating ftp account for {$array["servername"]} web site", null, "CLOUD");
return;
}
$sock = new sockets();
$sock->getFrameWork("cmd.php?freeweb-restart=yes");
send_email_events("Success creating {$array["servername"]} web site", null, "CLOUD");
return true;
}
function SAVE_FREEWEB_MYSQL()
{
$servername = trim(strtolower($_POST["servername"]));
if (substr($servername, 0, 1) == '.') {
echo $servername . " FAILED\n";
return;
}
$users = new usersMenus();
$sock = new sockets();
$FreewebsStorageDirectory = $sock->GET_INFO("FreewebsStorageDirectory");
if (!$users->AsWebMaster) {
return "FALSE";
}
$uid = $_POST["uid"];
$mysql_database = format_mysql_table($_POST["mysql_database"]);
$mysql_password = $_POST["mysql_password"];
$mysql_username = $_POST["mysql_username"];
$lvm_vg = $_POST["lvm_vg"];
$vg_size = $_POST["vg_size"];
$ServerIP = $_POST["ServerIP"];
$ServerPort = 0;
if (preg_match("#(.+?):([0-9]+)#", $ServerIP, $re)) {
$ServerIP = $re[1];
$ServerPort = $re[2];
}
if (!is_numeric($vg_size)) {
$vg_size = 5000;
}
$ftpuser = $_POST["ftpuser"];
$ftppassword = $_POST["ftppassword"];
$useSSL = $_POST["useSSL"];
if (!$users->PUREFTP_INSTALLED) {
$_POST["useFTP"] = 0;
$ftpuser = null;
$ftppassword = null;
}
if ($_POST["useFTP"] == 1) {
if ($ftpuser == null) {
$_POST["useFTP"] = 0;
$ftpuser = null;
$ftppassword = null;
}
}
$sql = "SELECT servername FROM freeweb WHERE servername='{$_POST["servername"]}'";
$q = new mysql();
$ligne = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
if ($ligne["servername"] != null) {
if ($uid != null) {
$u = new user($uid);
$ou = $u->ou;
}
if (!$users->AsSystemAdministrator) {
$ou = $_SESSION["ou"];
}
$sql = "UPDATE freeweb SET \n\t\t\tmysql_password='******',\n\t\t\tmysql_username='******',\n\t\t\tmysql_database='{$mysql_database}',\n\t\t\tmysql_instance_id='{$_POST["mysql_instance_id"]}',\n\t\t\tftpuser='******',\n\t\t\tftppassword='******',\n\t\t\tuseMysql='{$_POST["useMysql"]}',\n\t\t\tuseFTP='{$_POST["useFTP"]}'\n\t\t\tWHERE servername='{$servername}'\n\t\t";
}
writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__);
$q = new mysql();
$q->BuildTables();
$q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
if (preg_match("#Unknown column#i", $q->mysql_error)) {
$q->BuildTables();
$q->QUERY_SQL($sql, "artica_backup");
}
}
if (!$q->ok) {
echo $q->mysql_error;
return;
}
$sock = new sockets();
if ($_POST["useFTP"] == 1) {
if ($users->PUREFTP_INSTALLED) {
if (trim($ftpuser) != null) {
if (trim($ftppassword) != null) {
$pure = new pureftpd_user();
if (!$pure->CreateUser($ftpuser, $ftppassword, $servername)) {
echo "FTP: Failed\n";
return;
}
$sock->getFrameWork("services.php?reload-pure-ftpd=yes");
}
}
}
}
if ($_POST["useMysql"] == 1) {
if (!$q->DATABASE_EXISTS($mysql_database)) {
$q->CREATE_DATABASE("{$mysql_database}");
}
if (!$q->PRIVILEGES($mysql_username, $mysql_password, $mysql_database)) {
echo "GRANT {$mysql_database} FAILED FOR {$mysql_username}\n{$q->mysql_error}";
}
}
if (isset($_POST["ADD_DNS_ENTRY"])) {
$dnsDOM = explode(".", $_POST["servername"]);
$netbiosname = $dnsDOM[0];
unset($dnsDOM[0]);
$domainname = implode(".", $dnsDOM);
include_once dirname(__FILE__) . "/ressources/class.pdns.inc";
$pdns = new pdns($domainname);
$pdns->EditIPName($netbiosname, $_POST["ADD_DNS_ENTRY"], "A");
}
if ($ligne["servername"] == null) {
if ($_POST["force-groupware"] != null) {
$sql = "INSERT INTO drupal_queue_orders(`ORDER`,`servername`) VALUES('INSTALL_GROUPWARE','{$servername}')";
$q = new mysql();
$q->QUERY_SQL($sql, "artica_backup");
$sock->getFrameWork("freeweb.php?rebuild-vhost=yes&servername={$servername}");
}
}
$sock->getFrameWork("services.php?freeweb-start=yes");
sleep(2);
$sock->getFrameWork("cmd.php?freeweb-restart=yes");
}
function Save()
{
$servername = trim(strtolower($_GET["servername"]));
if (substr($servername, 0, 1) == '.') {
echo $servername . " FAILED\n";
return;
}
$users = new usersMenus();
$sock = new sockets();
$FreewebsStorageDirectory = $sock->GET_INFO("FreewebsStorageDirectory");
if (!$users->AsWebMaster) {
return "FALSE";
}
$uid = $_GET["uid"];
$mysql_database = format_mysql_table($_GET["mysql_database"]);
$mysql_password = $_GET["mysql_password"];
$mysql_username = $_GET["mysql_username"];
$lvm_vg = $_GET["lvm_vg"];
$vg_size = $_GET["vg_size"];
$ServerPort = $_GET["ServerPort"];
if (!is_numeric($ServerPort)) {
$ServerPort = 0;
}
if ($_GET["UseDefaultPort"] == 1) {
$ServerPort = 0;
}
if (!is_numeric($vg_size)) {
$vg_size = 5000;
}
$ftpuser = $_GET["ftpuser"];
$ftppassword = $_GET["ftppassword"];
$useSSL = $_GET["useSSL"];
if (!$users->PUREFTP_INSTALLED) {
$_GET["useFTP"] = 0;
$ftpuser = null;
$ftppassword = null;
}
$sql = "SELECT servername FROM freeweb WHERE servername='{$_GET["servername"]}'";
$q = new mysql();
$ligne = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
if ($ligne["servername"] != null) {
if ($uid != null) {
$u = new user($uid);
$ou = $u->ou;
}
if (!$users->AsSystemAdministrator) {
$ou = $_SESSION["ou"];
}
$sql = "UPDATE freeweb SET \n\t\t\tmysql_password='******',\n\t\t\tmysql_username='******',\n\t\t\tmysql_database='{$mysql_database}',\n\t\t\tftpuser='******',\n\t\t\tftppassword='******',\n\t\t\tuid='{$uid}',\n\t\t\tuseMysql='{$_GET["useMysql"]}',\n\t\t\tuseFTP='{$_GET["useFTP"]}',\n\t\t\tlvm_vg='{$_GET["lvm_vg"]}',\n\t\t\tlvm_size='{$_GET["vg_size"]}',\n\t\t\tUseLoopDisk='{$_GET["UseLoopDisk"]}',\n\t\t\tLoopMounts='{$_GET["LoopMounts"]}',\n\t\t\tUseReverseProxy='{$_GET["UseReverseProxy"]}',\n\t\t\tProxyPass='******',\n\t\t\tuseSSL='{$useSSL}',\n\t\t\tServerPort='{$ServerPort}',\n\t\t\tou='{$ou}',\n\t\t\tForwarder='{$_GET["Forwarder"]}',\n\t\t\tForwardTo='{$_GET["ForwardTo"]}'\n\t\t\t\n\t\t\tWHERE servername='{$servername}'\n\t\t";
} else {
if ($uid != null) {
$u = new user($uid);
$ou = $u->ou;
}
if ($ou != null) {
if ($FreewebsStorageDirectory != null) {
$www_dir = "{$FreewebsStorageDirectory}/{$servername}";
}
}
$sock = new sockets();
$servername = str_replace('..', '.', $servername);
$servername = str_replace('/', '.', $servername);
$servername = str_replace('\\', '.', $servername);
$servername = str_replace(' ', '.', $servername);
$servername = str_replace('$', '.', $servername);
$servername = str_replace('#', '.', $servername);
$servername = str_replace('%', '.', $servername);
$servername = str_replace('*', '.', $servername);
if (substr($servername, strlen($servername) - 1, 1) == '.') {
$servername = substr($servername, 0, strlen($servername) - 1);
}
if (substr($servername, 0, 1) == '.') {
$servername = substr($servername, 1, strlen($servername));
}
$sock->getFrameWork("freeweb.php?force-resolv=yes");
$sql = "INSERT INTO freeweb (mysql_password,mysql_username,ftpuser,ftppassword,useSSL,servername,mysql_database,\n\t\tuid,useMysql,useFTP,lvm_vg,lvm_size,UseLoopDisk,LoopMounts,ou,domainname,www_dir,ServerPort,UseReverseProxy,ProxyPass,Forwarder,ForwardTo)\n\t\tVALUES('{$mysql_password}','{$mysql_username}','{$ftpuser}','{$ftppassword}','{$useSSL}','{$servername}','{$mysql_database}',\n\t\t'{$uid}','{$_GET["useMysql"]}',\n\t\t'{$_GET["useFTP"]}','{$_GET["lvm_vg"]}','{$_GET["vg_size"]}','{$_GET["UseLoopDisk"]}','{$_GET["LoopMounts"]}','{$ou}',\n\t\t'{$_GET["domainname"]}','{$FreewebsStorageDirectory}','{$ServerPort}','{$_GET["UseReverseProxy"]}','{$_GET["ProxyPass"]}',\n\t\t'{$_GET["Forwarder"]}','{$_GET["ForwardTo"]}'\n\t\t)";
}
writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__);
$q = new mysql();
$q->BuildTables();
$q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
echo $q->mysql_error;
return;
}
$sock = new sockets();
if ($_GET["useFTP"] == 1) {
if ($users->PUREFTP_INSTALLED) {
if (trim($ftpuser) != null) {
if (trim($ftppassword) != null) {
$pure = new pureftpd_user();
if (!$pure->CreateUser($ftpuser, $ftppassword, $servername)) {
echo "FTP: Failed\n";
return;
}
$sock->getFrameWork("services.php?reload-pure-ftpd=yes");
}
}
}
}
if ($_GET["useMysql"] == 1) {
if (!$q->DATABASE_EXISTS($mysql_database)) {
$q->CREATE_DATABASE("{$mysql_database}");
}
if (!$q->PRIVILEGES($mysql_username, $mysql_password, $mysql_database)) {
echo "GRANT {$mysql_database} FAILED FOR {$mysql_username}\n{$q->mysql_error}";
}
}
if (isset($_GET["ADD_DNS_ENTRY"])) {
$dnsDOM = explode(".", $_GET["servername"]);
$netbiosname = $dnsDOM[0];
unset($dnsDOM[0]);
$domainname = implode(".", $dnsDOM);
include_once dirname(__FILE__) . "/ressources/class.pdns.inc";
$pdns = new pdns($domainname);
$pdns->EditIPName($netbiosname, $_GET["ADD_DNS_ENTRY"], "A");
}
$sock->getFrameWork("cmd.php?freeweb-restart=yes");
}
function Save()
{
$servername = trim(strtolower($_GET["servername"]));
if (substr($servername, 0, 1) == '.') {
echo $servername . " FAILED\n";
return;
}
$users = new usersMenus();
$sock = new sockets();
$tpl = new templates();
$FreewebsStorageDirectory = $sock->GET_INFO("FreewebsStorageDirectory");
if (!$users->AsWebMaster) {
return "FALSE";
}
$uid = $_GET["uid"];
$mysql_database = format_mysql_table($_GET["mysql_database"]);
$mysql_password = $_GET["mysql_password"];
$mysql_username = $_GET["mysql_username"];
$lvm_vg = $_GET["lvm_vg"];
$vg_size = $_GET["vg_size"];
$ServerIP = $_GET["ServerIP"];
$ServerPort = 0;
if (preg_match("#(.+?):([0-9]+)#", $ServerIP, $re)) {
$ServerIP = $re[1];
$ServerPort = $re[2];
}
if (!is_numeric($vg_size)) {
$vg_size = 5000;
}
$ftpuser = $_GET["ftpuser"];
$ftppassword = $_GET["ftppassword"];
$useSSL = $_GET["useSSL"];
if (!$users->PUREFTP_INSTALLED) {
$_GET["useFTP"] = 0;
$ftpuser = null;
$ftppassword = null;
}
$sql = "SELECT servername FROM freeweb WHERE servername='{$_GET["servername"]}'";
$q = new mysql();
$ligne = @mysql_fetch_array($q->QUERY_SQL($sql, 'artica_backup'));
if ($ligne["servername"] != null) {
if ($uid != null) {
$u = new user($uid);
$ou = $u->ou;
}
if (!$users->AsSystemAdministrator) {
$ou = $_SESSION["ou"];
}
$sql = "UPDATE freeweb SET \n\t\t\tmysql_password='******',\n\t\t\tmysql_username='******',\n\t\t\tmysql_database='{$mysql_database}',\n\t\t\tmysql_instance_id='{$_GET["mysql_instance_id"]}',\n\t\t\tftpuser='******',\n\t\t\tftppassword='******',\n\t\t\tuid='{$uid}',\n\t\t\tgpid='{$_GET["gpid"]}',\n\t\t\tuseMysql='{$_GET["useMysql"]}',\n\t\t\tuseFTP='{$_GET["useFTP"]}',\n\t\t\tlvm_vg='{$_GET["lvm_vg"]}',\n\t\t\tlvm_size='{$_GET["vg_size"]}',\n\t\t\tUseLoopDisk='{$_GET["UseLoopDisk"]}',\n\t\t\tLoopMounts='{$_GET["LoopMounts"]}',\n\t\t\twww_dir='{$_GET["www_dir"]}',\n\t\t\tUseReverseProxy='{$_GET["UseReverseProxy"]}',\n\t\t\tProxyPass='******',\n\t\t\tuseSSL='{$useSSL}',\n\t\t\tServerPort='{$ServerPort}',\n\t\t\tou='{$ou}',\n\t\t\tForwarder='{$_GET["Forwarder"]}',\n\t\t\tForwardTo='{$_GET["ForwardTo"]}',\n\t\t\tServerIP='{$ServerIP}'\n\t\t\tWHERE servername='{$servername}'\n\t\t";
} else {
$ApacheServerName = $sock->GET_INFO("ApacheServerName");
if ($ApacheServerName == null) {
$ApacheServerName = $users->fqdn;
}
if ($uid != null) {
$u = new user($uid);
$ou = $u->ou;
}
if ($ou != null) {
if ($FreewebsStorageDirectory != null) {
$www_dir = "{$FreewebsStorageDirectory}/{$servername}";
}
}
$sock = new sockets();
$servername = str_replace('..', '.', $servername);
$servername = str_replace('/', '.', $servername);
$servername = str_replace('\\', '.', $servername);
$servername = str_replace(' ', '.', $servername);
$servername = str_replace('$', '.', $servername);
$servername = str_replace('#', '.', $servername);
$servername = str_replace('%', '.', $servername);
$servername = str_replace('*', '.', $servername);
if (substr($servername, strlen($servername) - 1, 1) == '.') {
$servername = substr($servername, 0, strlen($servername) - 1);
}
if (substr($servername, 0, 1) == '.') {
$servername = substr($servername, 1, strlen($servername));
}
if ($servername == $ApacheServerName) {
echo $tpl->javascript_parse_text("{virtual_hostname_cannot_same_main_hostname}", 1);
return;
}
if ($_GET["force-groupware"] != null) {
$groupware_field = ",groupware";
$groupware_value = ",'{$_GET["force-groupware"]}'";
}
if ($_GET["www_dir"] != null) {
$www_dir_field = ",www_dir";
$www_dir_value = ",'{$_GET["www_dir"]}'";
}
$sock->getFrameWork("freeweb.php?force-resolv=yes");
$sql = "INSERT INTO freeweb (mysql_password,mysql_username,ftpuser,ftppassword,useSSL,servername,mysql_database,\n\t\tuid,gpid,useMysql,useFTP,lvm_vg,lvm_size,UseLoopDisk,LoopMounts,ou,domainname,www_dir,ServerPort,UseReverseProxy,\n\t\tProxyPass,Forwarder,ForwardTo,ForceInstanceZarafaID,mysql_instance_id,ServerIP{$groupware_field}{$www_dir_field})\n\t\tVALUES('{$mysql_password}','{$mysql_username}','{$ftpuser}','{$ftppassword}','{$useSSL}','{$servername}','{$mysql_database}',\n\t\t'{$uid}','{$_GET["gpid"]}','{$_GET["useMysql"]}',\n\t\t'{$_GET["useFTP"]}','{$_GET["lvm_vg"]}','{$_GET["vg_size"]}','{$_GET["UseLoopDisk"]}','{$_GET["LoopMounts"]}','{$ou}',\n\t\t'{$_GET["domainname"]}','{$FreewebsStorageDirectory}','{$ServerPort}','{$_GET["UseReverseProxy"]}','{$_GET["ProxyPass"]}',\n\t\t'{$_GET["Forwarder"]}','{$_GET["ForwardTo"]}','{$_GET["ForceInstanceZarafaID"]}','{$_GET["mysql_instance_id"]}','{$ServerIP}'{$groupware_value}{$www_dir_value}\n\t\t)";
}
writelogs("{$sql}", __FUNCTION__, __FILE__, __LINE__);
$q = new mysql();
$q->BuildTables();
$q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
echo $q->mysql_error;
return;
}
$sock = new sockets();
$sock->getFrameWork("system.php?dns-linker=yes");
if ($_GET["useFTP"] == 1) {
if ($users->PUREFTP_INSTALLED) {
if (trim($ftpuser) != null) {
if (trim($ftppassword) != null) {
$pure = new pureftpd_user();
if (!$pure->CreateUser($ftpuser, $ftppassword, $servername)) {
echo "FTP: Failed\n";
return;
}
$sock->getFrameWork("services.php?reload-pure-ftpd=yes");
}
}
}
}
if ($_GET["useMysql"] == 1) {
if (!$q->DATABASE_EXISTS($mysql_database)) {
$q->CREATE_DATABASE("{$mysql_database}");
}
if (!$q->PRIVILEGES($mysql_username, $mysql_password, $mysql_database)) {
echo "GRANT {$mysql_database} FAILED FOR {$mysql_username}\n{$q->mysql_error}";
}
}
if (isset($_GET["ADD_DNS_ENTRY"])) {
$dnsDOM = explode(".", $_GET["servername"]);
$netbiosname = $dnsDOM[0];
unset($dnsDOM[0]);
$domainname = implode(".", $dnsDOM);
include_once dirname(__FILE__) . "/ressources/class.pdns.inc";
$pdns = new pdns($domainname);
$pdns->EditIPName($netbiosname, $_GET["ADD_DNS_ENTRY"], "A");
}
if ($ligne["servername"] == null) {
if ($_GET["force-groupware"] != null) {
$sql = "INSERT INTO drupal_queue_orders(`ORDER`,`servername`) VALUES('INSTALL_GROUPWARE','{$servername}')";
$q = new mysql();
$q->QUERY_SQL($sql, "artica_backup");
$sock->getFrameWork("freeweb.php?rebuild-vhost=yes&servername={$servername}");
}
}
$sock->getFrameWork("services.php?freeweb-start=yes");
sleep(2);
$sock->getFrameWork("cmd.php?freeweb-restart=yes");
}
function Save(){
$servername=trim(strtolower($_GET["servername"]));
if(substr($servername, 0,1)=='.'){echo $servername. " FAILED\n";return;}
$users=new usersMenus();
$sock=new sockets();
$FreewebsStorageDirectory=$sock->GET_INFO("FreewebsStorageDirectory");
if(!$users->AsWebMaster){return "FALSE";}
$uid=$_GET["uid"];
$mysql_database=format_mysql_table($_GET["mysql_database"]);
$mysql_password=$_GET["mysql_password"];
$mysql_username=$_GET["mysql_username"];
$lvm_vg=$_GET["lvm_vg"];
$vg_size=$_GET["vg_size"];
$ServerPort=$_GET["ServerPort"];
if(!is_numeric($ServerPort)){$ServerPort=0;}
if($_GET["UseDefaultPort"]==1){$ServerPort=0;}
if(!is_numeric($vg_size)){$vg_size=5000;}
$ftpuser=$_GET["ftpuser"];
$ftppassword=$_GET["ftppassword"];
$useSSL=$_GET["useSSL"];
if(!$users->PUREFTP_INSTALLED){
$_GET["useFTP"]=0;
$ftpuser=null;
$ftppassword=null;
}
$sql="SELECT servername FROM freeweb WHERE servername='{$_GET["servername"]}'";
$q=new mysql();
$ligne=@mysql_fetch_array($q->QUERY_SQL($sql,'artica_backup'));
if($ligne["servername"]<>null){
if($uid<>null){$u=new user($uid);$ou=$u->ou;}
if(!$users->AsSystemAdministrator){$ou=$_SESSION["ou"];}
$sql="UPDATE freeweb SET
mysql_password='******',
mysql_username='******',
ftpuser='******',
ftppassword='******',
uid='$uid',
useMysql='{$_GET["useMysql"]}',
useFTP='{$_GET["useFTP"]}',
lvm_vg='{$_GET["lvm_vg"]}',
lvm_size='{$_GET["vg_size"]}',
UseLoopDisk='{$_GET["UseLoopDisk"]}',
LoopMounts='{$_GET["LoopMounts"]}',
UseReverseProxy='{$_GET["UseReverseProxy"]}',
ProxyPass='******',
useSSL='$useSSL',
ServerPort='$ServerPort',
ou='$ou',
Forwarder='{$_GET["Forwarder"]}',
ForwardTo='{$_GET["ForwardTo"]}'
WHERE servername='$servername'
";
}else{
if($uid<>null){$u=new user($uid);$ou=$u->ou;}
if($ou<>null){if($FreewebsStorageDirectory<>null){$www_dir="$FreewebsStorageDirectory/$servername";}}
$sock=new sockets();
$sock->getFrameWork("freeweb.php?force-resolv=yes");
$sql="INSERT INTO freeweb (mysql_password,mysql_username,ftpuser,ftppassword,useSSL,servername,mysql_database,
uid,useMysql,useFTP,lvm_vg,lvm_size,UseLoopDisk,LoopMounts,ou,domainname,www_dir,ServerPort,UseReverseProxy,ProxyPass,Forwarder,ForwardTo)
VALUES('$mysql_password','$mysql_username','$ftpuser','$ftppassword','$useSSL','$servername','$mysql_database',
'$uid','{$_GET["useMysql"]}',
'{$_GET["useFTP"]}','{$_GET["lvm_vg"]}','{$_GET["vg_size"]}','{$_GET["UseLoopDisk"]}','{$_GET["LoopMounts"]}','$ou',
'{$_GET["domainname"]}','$FreewebsStorageDirectory','$ServerPort','{$_GET["UseReverseProxy"]}','{$_GET["ProxyPass"]}',
'{$_GET["Forwarder"]}','{$_GET["ForwardTo"]}'
)";
}
$q=new mysql();
$q->BuildTables();
$q->QUERY_SQL($sql,"artica_backup");
if(!$q->ok){echo $q->mysql_error;return;}
$sock=new sockets();
if($_GET["useFTP"]==1){
if($users->PUREFTP_INSTALLED){
$pure=new pureftpd_user();
if(!$pure->CreateUser($ftpuser,$ftppassword,$servername)){
echo "FTP: Failed\n";
return;
}
}
}
if($_GET["useMysql"]==1){
if(!$q->DATABASE_EXISTS($mysql_database)){$q->CREATE_DATABASE("$mysql_database");}
if(!$q->PRIVILEGES($mysql_username,$mysql_password,$mysql_database)){
echo "GRANT $mysql_database FAILED FOR $mysql_username\n$q->mysql_error";
}
}
$sock->getFrameWork("cmd.php?freeweb-restart=yes");
}
