delete spamfilter domain only if domain is changed, update spamfilter_users...

Sergio Cambra

2014-07-03 d4a475caf3f9000b9b66f6839e64b6849abd7abc

delete spamfilter domain only if domain is changed, update spamfilter_users from mailboxes

 interface/web/mail/mail_domain_edit.php

@@ -392,10 +392,13 @@
            //* Update the mailget records
            $app->db->query("UPDATE mail_get SET destination=REPLACE(destination, '".$app->db->quote($this->oldDataRecord['domain'])."', '".$app->db->quote($this->dataRecord['domain'])."'), sys_userid = $client_user_id, sys_groupid = $sys_groupid WHERE destination LIKE '%@".$app->db->quote($this->oldDataRecord['domain'])."'");

            if ($this->oldDataRecord["domain"] != $this->dataRecord['domain']) {
            //* Delete the old spamfilter record
            $tmp = $app->db->queryOneRecord("SELECT id FROM spamfilter_users WHERE email = '@".$app->db->quote($this->oldDataRecord["domain"])."'");
            $app->db->datalogDelete('spamfilter_users', 'id', $tmp["id"]);
            unset($tmp);
            }
            $app->db->query("UPDATE spamfilter_users SET email=REPLACE(email, '".$app->db->quote($this->oldDataRecord['domain'])."', '".$app->db->quote($this->dataRecord['domain'])."'), sys_userid = $client_user_id, sys_groupid = $sys_groupid WHERE email LIKE '%@".$app->db->quote($this->oldDataRecord['domain'])."'");

        } // end if domain name changed