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_';