auth->check_module_permissions('mail'); // Loading classes $app->uses('tpl,tform,tform_actions'); $app->load('tform_actions'); class page_action extends tform_actions { function onBeforeDelete() { global $app; $conf; $domain = $this->dataRecord['domain']; // Before we delete the email domain, // we will delete all depending records. // Delete all forwardings where the osurce or destination belongs to this domain $records = $app->db->queryAllRecords("SELECT forwarding_id as id FROM mail_forwarding WHERE source like '%@".$app->db->quote($domain)."' OR destination like '%@".$app->db->quote($domain)."'"); foreach($records as $rec) { $app->db->datalogDelete('mail_forwarding','forwarding_id',$rec['id']); } // Delete all fetchmail accounts where destination belongs to this domain $records = $app->db->queryAllRecords("SELECT mailget_id as id FROM mail_get WHERE destination like '%@".$app->db->quote($domain)."'"); foreach($records as $rec) { $app->db->datalogDelete('mail_get','mailget_id',$rec['id']); } // Delete all mailboxes where destination belongs to this domain $records = $app->db->queryAllRecords("SELECT mailuser_id as id FROM mail_user WHERE email like '%@".$app->db->quote($domain)."'"); foreach($records as $rec) { $app->db->datalogDelete('mail_user','mailuser_id',$rec['id']); } // Delete all spamfilters that belong to this domain $records = $app->db->queryAllRecords("SELECT id FROM spamfilter_users WHERE email = '@".$app->db->quote($domain)."'"); foreach($records as $rec) { $app->db->datalogDelete('spamfilter_users','id',$rec['id']); } } } $page = new page_action; $page->onDelete(); ?>