| | 117 | |
|---|
| | 118 | |
|---|
| | 119 | /* |
|---|
| | 120 | * Updates the database fields ispcp.mail_users.mail_addr to the right mail address |
|---|
| | 121 | * written by Christian Hernmarck, Feb 2008 |
|---|
| | 122 | * Since it does not delete or add any field, it may be run several times... |
|---|
| | 123 | */ |
|---|
| | 124 | function _databaseUpdate_2() { |
|---|
| | 125 | global $sql; // we need the gloabl database connection |
|---|
| | 126 | |
|---|
| | 127 | $sqlUpd = array(); // we need several SQL Statements... |
|---|
| | 128 | |
|---|
| | 129 | // domain mail + forward |
|---|
| | 130 | $sqlUpd[] = "UPDATE `mail_users`, `domain` |
|---|
| | 131 | SET `mail_addr` = CONCAT(`mail_acc`,'@',`domain_name`) |
|---|
| | 132 | WHERE `mail_users`.`domain_id` = `domain`.`domain_id` |
|---|
| | 133 | AND (`mail_type` = 'normal_mail' OR `mail_type` = 'normal_forward')"; |
|---|
| | 134 | |
|---|
| | 135 | // domain-alias mail + forward |
|---|
| | 136 | $sqlUpd[] = "UPDATE `mail_users`, `domain_aliasses` |
|---|
| | 137 | SET `mail_addr` = CONCAT(`mail_acc`,'@',`alias_name`) |
|---|
| | 138 | WHERE `mail_users`.`domain_id` = `domain_aliasses`.`domain_id` AND `mail_users`.`sub_id` = `domain_aliasses`.`alias_id` |
|---|
| | 139 | AND (`mail_type` = 'alias_mail' OR `mail_type` = 'alias_forward')"; |
|---|
| | 140 | |
|---|
| | 141 | // subdomain mail + forward |
|---|
| | 142 | $sqlUpd[] = "UPDATE `mail_users`, `subdomain`, `domain` |
|---|
| | 143 | SET `mail_addr` = CONCAT(`mail_acc`,'@',`subdomain_name`,'.',`domain_name`) |
|---|
| | 144 | WHERE `mail_users`.`domain_id` = `subdomain`.`domain_id` AND `mail_users`.`sub_id` = `subdomain`.`subdomain_id` |
|---|
| | 145 | AND `mail_users`.`domain_id` = `domain`.`domain_id` |
|---|
| | 146 | AND (`mail_type` = 'subdom_mail' OR `mail_type` = 'subdom_forward')"; |
|---|
| | 147 | |
|---|
| | 148 | // domain catchall |
|---|
| | 149 | $sqlUpd[] = "UPDATE `mail_users`, `domain` |
|---|
| | 150 | SET `mail_addr` = CONCAT('@',`domain_name`) |
|---|
| | 151 | WHERE `mail_users`.`domain_id` = `domain`.`domain_id` |
|---|
| | 152 | AND `mail_type` = 'normal_catchall'"; |
|---|
| | 153 | |
|---|
| | 154 | // domain-alias catchall |
|---|
| | 155 | $sqlUpd[] = "UPDATE `mail_users`, `domain_aliasses` |
|---|
| | 156 | SET `mail_addr` = CONCAT('@',`alias_name`) |
|---|
| | 157 | WHERE `mail_users`.`domain_id` = `domain_aliasses`.`domain_id` AND `mail_users`.`sub_id` = `domain_aliasses`.`alias_id` |
|---|
| | 158 | AND `mail_type` = 'alias_catchall'"; |
|---|
| | 159 | |
|---|
| | 160 | // subdomain catchall |
|---|
| | 161 | $sqlUpd[] = "UPDATE `mail_users`, `subdomain`, `domain` |
|---|
| | 162 | SET `mail_addr` = CONCAT('@',`subdomain_name`,'.',`domain_name`) |
|---|
| | 163 | WHERE `mail_users`.`domain_id` = `subdomain`.`domain_id` AND `mail_users`.`sub_id` = `subdomain`.`subdomain_id` |
|---|
| | 164 | AND `mail_users`.`domain_id` = `domain`.`domain_id` |
|---|
| | 165 | AND `mail_type` = 'subdom_catchall'"; |
|---|
| | 166 | |
|---|
| | 167 | foreach($sqlUpd as $s) // go for it: run them all |
|---|
| | 168 | { |
|---|
| | 169 | $sql->Execute($s); |
|---|
| | 170 | } |
|---|
| | 171 | |
|---|
| | 172 | } // end of _databaseUpdate_2 |
|---|
| | 173 | |
|---|
