| | |
| | | $app->error('Reseller: '.$app->tform->wordbook["limit_maildomain_txt"]); |
| | | } |
| | | } |
| | | |
| | | |
| | | parent::onShowNew(); |
| | | } |
| | | |
| | |
| | | $clients = $app->db->queryAllRecords($sql); |
| | | $client_select = ''; |
| | | if($_SESSION["s"]["user"]["typ"] == 'admin') $client_select .= "<option value='0'></option>"; |
| | | $tmp_data_record = $app->tform->getDataRecord($this->id); |
| | | if(is_array($clients)) { |
| | | foreach( $clients as $client) { |
| | | $selected = ($client["groupid"] == $this->dataRecord["sys_groupid"])?'SELECTED':''; |
| | | $selected = ($client["groupid"] == $tmp_data_record["sys_groupid"])?'SELECTED':''; |
| | | $client_select .= "<option value='$client[groupid]' $selected>$client[name]</option>\r\n"; |
| | | } |
| | | } |
| | |
| | | // Fill the client select field |
| | | $sql = "SELECT groupid, name FROM sys_group, client WHERE sys_group.client_id = client.client_id AND client.parent_client_id = ".$client['client_id']; |
| | | $clients = $app->db->queryAllRecords($sql); |
| | | $client_select = '<option value="'.$client['client_id'].'">'.$client['contact_name'].'</option>'; |
| | | $tmp = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = ".$client['client_id']); |
| | | $client_select = '<option value="'.$tmp['groupid'].'">'.$client['contact_name'].'</option>'; |
| | | $tmp_data_record = $app->tform->getDataRecord($this->id); |
| | | if(is_array($clients)) { |
| | | foreach( $clients as $client) { |
| | | $selected = @($client["groupid"] == $this->dataRecord["sys_groupid"])?'SELECTED':''; |
| | | $selected = @($client["groupid"] == $tmp_data_record["sys_groupid"])?'SELECTED':''; |
| | | $client_select .= "<option value='$client[groupid]' $selected>$client[name]</option>\r\n"; |
| | | } |
| | | } |
| | |
| | | |
| | | } |
| | | |
| | | |
| | | /* |
| | | * Now we have to check, if we should use the domain-module to select the domain |
| | | * or not |
| | | */ |
| | | $app->uses('ini_parser,getconf'); |
| | | $settings = $app->getconf->get_global_config('domains'); |
| | | if ($settings['use_domain_module'] == 'y'){ |
| | | $client_group_id = $_SESSION["s"]["user"]["default_group"]; |
| | | $sql = "SELECT domain FROM domain WHERE sys_groupid =" . $client_group_id; |
| | | $domains = $app->db->queryAllRecords($sql); |
| | | $domain_select = ''; |
| | | if(is_array($domains)) { |
| | | foreach( $domains as $domain) { |
| | | $domain_select .= "<option value=" . $domain['domain'] . ">" . $domain['domain'] . "</option>\r\n"; |
| | | } |
| | | } |
| | | $app->tpl->setVar("domain_option",$domain_select); |
| | | } |
| | | |
| | | |
| | | // Get the spamfilter policys for the user |
| | |
| | | $app->db->datalogDelete('spamfilter_users', 'id', $tmp_user["id"]); |
| | | } |
| | | } // endif spamfilter policy |
| | | |
| | | //** If the domain name has been changed, change the domain in all mailbox records |
| | | if($this->oldDataRecord['domain'] != $this->dataRecord['domain']) { |
| | | //** If the domain name or owner has been changed, change the domain and owner in all mailbox records |
| | | if($this->oldDataRecord['domain'] != $this->dataRecord['domain'] || (isset($this->dataRecord['client_group_id']) && $this->oldDataRecord['sys_groupid'] != $this->dataRecord['client_group_id'])) { |
| | | $app->uses('getconf'); |
| | | $mail_config = $app->getconf->get_server_config($this->dataRecord["server_id"],'mail'); |
| | | |
| | | //* Update the mailboxes |
| | | $mailusers = $app->db->queryAllRecords("SELECT * FROM mail_user WHERE email like '%@".mysql_real_escape_string($this->oldDataRecord['domain'])."'"); |
| | | $sys_groupid = (isset($this->dataRecord['client_group_id']))?$this->dataRecord['client_group_id']:$this->oldDataRecord['sys_groupid']; |
| | | if(is_array($mailusers)) { |
| | | foreach($mailusers as $rec) { |
| | | // setting Maildir, Homedir, UID and GID |
| | |
| | | $maildir = str_replace("[localpart]",$mail_parts[0],$maildir); |
| | | $maildir = mysql_real_escape_string($maildir); |
| | | $email = mysql_real_escape_string($mail_parts[0].'@'.$this->dataRecord['domain']); |
| | | $app->db->datalogUpdate('mail_user', "maildir = '$maildir', email = '$email'", 'mailuser_id', $rec['mailuser_id']); |
| | | $app->db->datalogUpdate('mail_user', "maildir = '$maildir', email = '$email', sys_groupid = '$sys_groupid'", 'mailuser_id', $rec['mailuser_id']); |
| | | } |
| | | } |
| | | |
| | |
| | | foreach($forwardings as $rec) { |
| | | $destination = mysql_real_escape_string(str_replace($this->oldDataRecord['domain'],$this->dataRecord['domain'],$rec['destination'])); |
| | | $source = mysql_real_escape_string(str_replace($this->oldDataRecord['domain'],$this->dataRecord['domain'],$rec['source'])); |
| | | $app->db->datalogUpdate('mail_forwarding', "source = '$source', destination = '$destination'", 'forwarding_id', $rec['forwarding_id']); |
| | | $app->db->datalogUpdate('mail_forwarding', "source = '$source', destination = '$destination', sys_groupid = '$sys_groupid'", 'forwarding_id', $rec['forwarding_id']); |
| | | } |
| | | } |
| | | |