| | |
| | | $app->db->query($sql); |
| | | } |
| | | } // endif spamfilter policy |
| | | |
| | | //** If the domain name has been changed, change the domain in all mailbox records |
| | | if($this->oldDataRecord['domain'] != $this->dataRecord['domain']) { |
| | | $app->uses('getconf'); |
| | | $mail_config = $app->getconf->get_server_config($this->dataRecord["server_id"],'mail'); |
| | | $mailusers = $app->db->queryAllRecords("SELECT * FROM mail_user WHERE email like '%@".addslashes($this->oldDataRecord['domain'])."'"); |
| | | if(is_array($mailusers)) { |
| | | foreach($mailusers as $rec) { |
| | | // setting Maildir, Homedir, UID and GID |
| | | $mail_parts = explode("@",$rec['email']); |
| | | $maildir = str_replace("[domain]",$this->dataRecord['domain'],$mail_config["maildir_path"]); |
| | | $maildir = str_replace("[localpart]",$mail_parts[0],$maildir); |
| | | $maildir = addslashes($maildir); |
| | | //$app->db->query("UPDATE mail_user SET maildir = '$maildir' WHERE mailuser_id = ".$rec['mailuser_id']); |
| | | //$rec_new = $app->db->queryOneRecord("SELECT * FROM mail_user WHERE mailuser_id = ".$rec['mailuser_id']); |
| | | $app->db->datalogUpdate('mail_user', "maildir = '$maildir'", 'mailuser_id', $rec['mailuser_id']); |
| | | } |
| | | } |
| | | } // end if domain name changed |
| | | |
| | | } |
| | | |
| | | } |