function rm_rf_user_account($id_user)
{
global $sql, $cfg;
// get domain user data
$query = <<<SQL_QUERY
select
domain_id,
domain_name,
domain_gid,
domain_created_id
from
domain
where
domain_admin_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($id_user));
$domain_id = $rs->fields['domain_id'];
$domain_name = $rs->fields['domain_name'];
$domain_gid = $rs->fields['domain_gid'];
$domain_created_id = $rs->fields['domain_created_id'];
// we have all needed user data - let's delete all data for this user
substract_from_reseller_props($domain_created_id, $domain_id);
// BEGIN - DELETE ALL SYSTEM ENTRIES FOR THIS USER
//fist we'll delete all FTP Accounts
//delete all FTP Accounts
$query = <<<SQL_QUERY
delete from
ftp_users
where
gid = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_gid));
while (!$rs->EOF) {
$rs->MoveNext();
}
// delete the group
$query = <<<SQL_QUERY
\t delete from
\t ftp_group
\twhere
\tgid = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_gid));
//let's delete all Subdomains for this user
$delete_status = $cfg['ITEM_DELETE_STATUS'];
$query = <<<SQL_QUERY
\t update
\t subdomain
\t set
\t subdomain_status = ?
\twhere
\tdomain_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($delete_status, $domain_id));
//let's delete all domain aliases for this user
$query = <<<SQL_QUERY
update
domain_aliasses
set
alias_status = ?
where
domain_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($delete_status, $domain_id));
while (!$rs->EOF) {
$rs->MoveNext();
}
//let's delete all mail accounts for this user
$query = <<<SQL_QUERY
\t update
\t mail_users
\t set
\t status = ?
\twhere
\tdomain_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($delete_status, $domain_id));
// delete all htaccess entries for this user
$query = <<<SQL_QUERY
\t delete from
\t htaccess
\twhere
\tdmn_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_id));
$query = <<<SQL_QUERY
\t delete from
\t htaccess_groups
\twhere
\tdmn_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_id));
$query = <<<SQL_QUERY
\t delete from
\t htaccess_users
\twhere
\tdmn_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_id));
// end of delete htaccess entires
while (!$rs->EOF) {
$rs->MoveNext();
}
// Lets Delete SQL DBs and Users
$query = <<<SQL_QUERY
\tselect
\t\t\tsqld_id
\tfrom
\tsql_database
\twhere
\tdomain_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($domain_id));
while (!$rs->EOF) {
$db_id = $rs->fields['sqld_id'];
delete_sql_database($sql, $domain_id, $db_id);
$rs->MoveNext();
}
// END - DELETE ALL SYSTEM ENTRIES FOR THIS USER
// BEGIN - DELETE ALL GUI ENTRIES FOR THIS USER
// delete the layout settings
$query = <<<SQL_QUERY
\t delete from
\t user_gui_props
\twhere
\tuser_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($id_user));
// update reseller props
//delete all tickets for this user
$query = <<<SQL_QUERY
\t delete from
\t tickets
\twhere
ticket_from = ?
or
ticket_to = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($id_user, $id_user));
//let's delete the main domain for this user
$query = <<<SQL_QUERY
\t update
\t domain
\t set
\t domain_status = ?
\twhere
\tdomain_admin_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($delete_status, $id_user));
// delete the user acount
$query = <<<SQL_QUERY
\t delete from
\t admin
\twhere
\tadmin_id = ?
SQL_QUERY;
$rs = exec_query($sql, $query, array($id_user));
}
/* ERR - we have domain aliases for this domain */
set_page_message(tr('Domain you are trying to remove has domain alias!<br> first remove them !'));
header("Location: users.php");
die;
}
/* check for subdomains */
$query = "select count(subdomain_id) as subnum from subdomain where domain_id=?";
$res = exec_query($sql, $query, array($del_id));
$data = $res->FetchRow();
if ($data['subnum'] > 0) {
/* ERR - we have subdomain for this domain */
set_page_message(tr('Domain you are trying to remove has subdomains accounts !<br> first remove them !'));
header("Location: users.php");
die;
}
substract_from_reseller_props($_SESSION['user_id'], $del_id);
$query = "update domain set domain_status='delete' where domain_id=?";
$res = exec_query($sql, $query, array($del_id));
send_request();
/* delete admin of this domain */
$query = "select domain_admin_id,domain_name from domain where domain_id=?";
$res = exec_query($sql, $query, array($del_id));
$dat = $res->FetchRow();
$query = "delete from admin where admin_id=?";
$res = exec_query($sql, $query, array($dat[domain_admin_id]));
/* delete the quota section */
$query = "delete from quotalimits where name=?";
$res = exec_query($sql, $query, array($dat[domain_admin_id]));
$admin_login = $_SESSION['user_logged'];
write_log("{$admin_login}: delete domain {$dat['domain_name']}");
$_SESSION['ddel'] = '_yes_';
