auth->check_module_permissions('client');
if($conf['demo_mode'] == true) $app->error('This function is disabled in demo mode.');
$app->uses('tpl,tform');
$app->load('tform_actions');
class page_action extends tform_actions {
// db_table => info_field for onDelete - empty = show only the amount
private $tables = array(
'cron' => '',
'client' => 'contact_name',
'dns_rr' => '',
'dns_soa' => 'origin',
'dns_slave' => 'origin',
'domain' => 'domain',
'ftp_user' => 'username',
'mail_access' => 'source',
'mail_content_filter' => '',
'mail_domain' => 'domain',
'mail_forwarding' => '',
'mail_get' => '',
'mail_mailinglist' => 'listname',
'mail_user' => 'email',
'mail_user_filter' => '',
'shell_user' => 'username',
'spamfilter_users' => '',
'spamfilter_wblist' => '',
'support_message' => '',
'web_domain' => 'domain',
'web_folder' => 'path',
'web_folder_user' => 'username',
'web_database_user' => 'database_user',
);
function onDelete() {
global $app, $conf, $list_def_file, $tform_def_file;
// Loading tform framework
if(!is_object($app->tform)) $app->uses('tform');
if($_POST["confirm"] == 'yes') {
if(isset($_POST['_csrf_id'])) $_GET['_csrf_id'] = $_POST['_csrf_id'];
if(isset($_POST['_csrf_key'])) $_GET['_csrf_key'] = $_POST['_csrf_key'];
parent::onDelete();
} else {
// Check CSRF Token
$app->auth->csrf_token_check('GET');
$app->uses('tpl');
$app->tpl->newTemplate("form.tpl.htm");
$app->tpl->setInclude('content_tpl', 'templates/client_del.htm');
include_once $list_def_file;
// Load table definition from file
$app->tform->loadFormDef($tform_def_file);
$this->id = $app->functions->intval($_REQUEST["id"]);
$this->dataRecord = $app->tform->getDataRecord($this->id);
$client_id = $app->functions->intval($this->dataRecord['client_id']);
$client_group = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = ?", $client_id);
$table_list = array();
$client_group_id = $app->functions->intval($client_group['groupid']);
if($client_group_id > 1) {
foreach($this->tables as $table => $field) {
if($table != '') {
$records = $app->db->queryAllRecords("SELECT * FROM ?? WHERE sys_groupid = ?", $table, $client_group_id);
if(is_array($records) && !empty($records) && $field !== false) {
$data = array();
$number = count($records);
foreach($records as $rec) {
if($field != '' && $field !== false) $data['data'] .= '
'.$rec[$field].'';
}
$data['count'] = $number;
$data['table'] = $table;
$table_list[] = $data;
}
}
}
}
$app->tpl->setVar('id', $this->id);
$app->tpl->setVar('number_records', $number);
$app->tpl->setLoop('records', $table_list);
//* load language file
$lng_file = 'lib/lang/'.$app->functions->check_language($_SESSION['s']['language']).'_client_del.lng';
include $lng_file;
$app->tpl->setVar($wb);
// get new csrf token
$csrf_token = $app->auth->csrf_token_get('client_del');
$app->tpl->setVar('_csrf_id', $csrf_token['csrf_id']);
$app->tpl->setVar('_csrf_key', $csrf_token['csrf_key']);
$app->tpl_defaults();
$app->tpl->pparse();
}
}
function onBeforeDelete() {
global $app, $conf;
$client_id = $app->functions->intval($this->dataRecord['client_id']);
if($client_id > 0) {
// remove the group of the client from the resellers group
$parent_client_id = $app->functions->intval($this->dataRecord['parent_client_id']);
$parent_user = $app->db->queryOneRecord("SELECT userid FROM sys_user WHERE client_id = ?", $parent_client_id);
$client_group = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = ?", $client_id);
$app->auth->remove_group_from_user($parent_user['userid'], $client_group['groupid']);
// delete the group of the client
$app->db->query("DELETE FROM sys_group WHERE client_id = ?", $client_id);
// delete the sys user(s) of the client
$app->db->query("DELETE FROM sys_user WHERE client_id = ?", $client_id);
// Delete all records (sub-clients, mail, web, etc....) of this client.
$client_group_id = $app->functions->intval($client_group['groupid']);
if($client_group_id > 1) {
foreach($this->tables as $table => $field) {
if($table != '') {
//* find the primary ID of the table
$table_info = $app->db->tableInfo($table);
$index_field = '';
foreach($table_info as $tmp) {
if($tmp['option'] == 'primary') $index_field = $tmp['name'];
}
//* Delete the records
if($index_field != '') {
$records = $app->db->queryAllRecords("SELECT * FROM ?? WHERE sys_groupid = ? ORDER BY ?? DESC", $table, $client_group_id, $index_field);
if(is_array($records)) {
foreach($records as $rec) {
$app->db->datalogDelete($table, $index_field, $rec[$index_field]);
//* Delete traffic records that dont have a sys_groupid column
if($table == 'web_domain') {
$app->db->query("DELETE FROM web_traffic WHERE hostname = ?", $rec['domain']);
}
//* Delete mail_traffic records that dont have a sys_groupid
if($table == 'mail_user') {
$app->db->query("DELETE FROM mail_traffic WHERE mailuser_id = ?", $rec['mailuser_id']);
}
}
}
}
}
}
}
$activation_letter_filename = ISPC_ROOT_PATH.'/pdf/activation_letters/c'.$client_id.'-'.$this->dataRecord['activation_code'].'.pdf';
if(is_file($activation_letter_filename)) unlink($activation_letter_filename);
}
}
}
$page = new page_action;
$page->onDelete();