$new_mx_2 .= "|" . $new_mx_3;
}
if (isset($new_mx_4) && $new_mx_4 != "") {
$new_mx_2 .= "|" . $new_mx_4;
}
if (isset($new_mx_5) && $new_mx_5 != "") {
$new_mx_2 .= "|" . $new_mx_5;
}
if (isset($new_mx_6) && $new_mx_6 != "") {
$new_mx_2 .= "|" . $new_mx_6;
}
}
// If domain whois is hosted here, change the whois value using a registry call.
if (file_exists($dtcshared_path . "/dtcrm")) {
$query = "SELECT * FROM {$pro_mysql_domain_table} WHERE name='{$edit_domain}';";
$result = mysql_query($query) or die("Cannot execute query \"{$query}\" !!!" . mysql_error());
$row = mysql_fetch_array($result);
if ($row["whois"] == "here") {
$regz = registry_update_whois_dns($adm_login, $adm_pass, $edit_domain, "{$new_dns_1}|{$new_dns_2}");
if ($regz["is_success"] != 1) {
die("<font color=\"red\"><b>Whois update failed</b></font><br>\nServer said: <i>" . $regz["response_text"] . "</i>");
}
}
}
$query = "UPDATE {$pro_mysql_domain_table} SET primary_dns='{$new_dns_1}',other_dns='{$new_dns_2}',primary_mx='{$new_mx_1}',other_mx='{$new_mx_2}',txt_root_entry='" . addslashes($_REQUEST["txt_root_entry"]) . "',txt_root_entry2='" . addslashes($_REQUEST["txt_root_entry2"]) . "' WHERE owner='{$adm_login}' AND name='{$edit_domain}';";
mysql_query($query) or die("Cannot execute query \"{$query}\" !!!" . mysql_error());
$domupdate_query = "UPDATE {$pro_mysql_domain_table} SET generate_flag='yes' WHERE name='{$edit_domain}' LIMIT 1;";
$domupdate_result = mysql_query($domupdate_query) or die("Cannot execute query \"{$domupdate_query}\"");
updateUsingCron("gen_vhosts='yes',restart_apache='yes',gen_named='yes',reload_named ='yes',restart_qmail='yes',qmail_newu='yes',gen_qmail='yes',gen_fetchmail='yes'");
triggerDomainListUpdate();
}
function DTCdeleteAdmin($adm_to_del)
{
global $pro_mysql_admin_table;
global $pro_mysql_domain_table;
global $pro_mysql_vps_table;
global $pro_mysql_dedicated_table;
global $pro_mysql_tik_queries_table;
global $pro_mysql_cronjob_table;
global $pro_mysql_ssl_ips_table;
global $conf_demo_version;
global $conf_mysql_db;
if (!isFtpLogin($adm_to_del)) {
echo "Admin to delete is not in correct format line " . __LINE__ . " file " . __FILE__;
die;
}
$adm_query = "SELECT * FROM {$pro_mysql_admin_table} WHERE adm_login='******'";
$result = mysql_query($adm_query) or die("Cannot execute query \"{$adm_query}\" !!!");
$num_rows = mysql_num_rows($result);
if ($num_rows != 1) {
die("User not found for deletion of {$adm_to_del} !!!");
}
$row_virtual_admin = mysql_fetch_array($result);
$the_admin_path = $row_virtual_admin["path"];
// delete the user also mailboxs, ftp accounts, domains and subdomains in database
$query = "SELECT * FROM {$pro_mysql_domain_table} WHERE owner='{$adm_to_del}';";
$result = mysql_query($query) or die("Cannot execute query \"{$query}\" !!!");
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$row = mysql_fetch_array($result);
//echo "Deleting ".$_REQUEST["delete_admin_user"]." / ".$row_virtual_admin["adm_pass"].$row["name"];
deleteUserDomain($_REQUEST["delete_admin_user"], $row_virtual_admin["adm_pass"], $row["name"]);
}
if ($conf_demo_version == "no") {
system("rm -rf {$the_admin_path}");
}
// Make all SSL vhosts the user registered available again
$q = "UPDATE {$pro_mysql_ssl_ips_table} SET available='yes' WHERE adm_login='******';";
$r = mysql_query($q) or die("Cannot execute query {$q} line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
deleteMysqlUserAndDB($adm_to_del);
// Delete all VPS of the user, and set all its IPs as available
$q = "SELECT * FROM {$pro_mysql_vps_table} WHERE owner='{$adm_to_del}';";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
$n = mysql_num_rows($r);
for ($i = 0; $i < $n; $i++) {
$vps = mysql_fetch_array($r);
$q2 = "UPDATE {$pro_mysql_vps_ip_table} SET available='yes' WHERE vps_server_hostname='" . $vps["vps_server_hostname"] . "' AND vps_xen_name='" . $vps["vps_xen_name"] . "';";
$r2 = mysql_query($q2) or die("Cannot execute query \"{$q2}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
$q2 = "DELETE FROM {$pro_mysql_vps_stats_table} WHERE vps_server_hostname='" . $vps["vps_server_hostname"] . "' AND vps_xen_name='" . $vps["vps_xen_name"] . "';";
$r2 = mysql_query($q2) or die("Cannot execute query \"{$q2}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
// Unload (eg: destroy) the VPS directly
remoteVPSAction($vps["vps_server_hostname"], $vps["vps_xen_name"], "destroy_vps");
VPS_Server_Subscribe_To_Lists($vps["vps_server_hostname"]);
}
$q = "DELETE FROM {$pro_mysql_vps_table} WHERE owner='{$adm_to_del}';";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
// Delete all dedicated servers of the admin
$q = "DELETE FROM {$pro_mysql_dedicated_table} WHERE owner='{$adm_to_del}';";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
// Delete all support tickets of the admin
$q = "DELETE FROM {$pro_mysql_tik_queries_table} WHERE adm_login='******';";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error());
$adm_query = "DELETE FROM {$pro_mysql_admin_table} WHERE adm_login='******'";
mysql_query($adm_query) or die("Cannot execute query \"{$adm_query}\" !!!");
// Tell the cron job to activate the changes (in case there was some shared accounts. Todo: check if there is some...)
$adm_query = "UPDATE {$pro_mysql_cronjob_table} SET qmail_newu='yes',restart_qmail='yes',reload_named='yes',\n\trestart_apache='yes',gen_vhosts='yes',gen_named='yes',gen_qmail='yes',gen_webalizer='yes',gen_backup='yes',gen_ssh='yes',gen_fetchmail='yes' WHERE 1;";
mysql_query($adm_query);
triggerDomainListUpdate();
}
