-
Notifications
You must be signed in to change notification settings - Fork 0
/
fix-mbox-alias.php
39 lines (33 loc) · 1018 Bytes
/
fix-mbox-alias.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php
$sqlcnx = mysql_connect("FIXME_HOST","FIXME_USER","FIXME_PASS") or die ("erreur connect");
/////
$sqlaa = "select `gha-mail`.`mailbox`.`username`, `gha-mail`.`mailbox`.`domain`
from `gha-mail`.`mailbox`
";
//where `gha-mail`.`mailbox`.`domain`='toto.com'
/////
$result = mysql_query($sqlaa);
/////
if (!$result) {
die('Requête invalide : ' . mysql_error());
}
/////
while ($row = mysql_fetch_object($result)) {
$sqlab = "select `gha-mail`.`alias`.`address`
from `gha-mail`.`alias`
where `gha-mail`.`alias`.`domain`='$row->domain'
and `gha-mail`.`alias`.`address`='$row->username'";
$resultab = mysql_query($sqlab);
if (!$resultab) {
die('Requête invalide : ' . mysql_error());
}
if(mysql_num_rows($resultab) == 0 )
{
echo "insert into `gha-mail`.`alias` set `address`='$row->username',`goto`='$row->username',`domain`='$row->domain',`created`=NOW(),`modified`=NOW(),`active`=1;\n";
}
mysql_free_result($resultab);
}
/////
mysql_free_result($result);
/////
mysql_close($sqlcnx);