Код: Выделить всё
<?php
$link1 = mysql_connect("localhost", "xxxx", "yyyy") or
die("Could not connect: " . mysql_error());
mysql_select_db("abills", $link1);
$result_ab = mysql_query("select DECODE(password,'zzzzzz'),id from users", $link1);
$link2 = mysql_connect("localhost", "xxxx", "yyyy") or
die("Could not connect: " . mysql_error());
mysql_select_db("postfixadmin", $link2);
$result_pa = mysql_query("select password,name from mailbox", $link2);
$buff = array();
while ($row_pa = mysql_fetch_array($result_pa, MYSQL_NUM)) {
$buff[$row_pa[1]] = $row_ab[1];
}
while ($row_ab = mysql_fetch_array($result_ab, MYSQL_NUM)) {
$buff[$row_ab[1]] = $row_ab[0];
}
$res = mysql_query ("TRUNCATE TABLE aliases",$link2);
$res = mysql_query ("TRUNCATE TABLE mailbox",$link2);
foreach ($buff as $login => $password)
{
#print $login . ' | ' . $password . "\r\n";
$res = mysql_query ("insert into alias (address, goto, domain, created, modified, active) values (\"$login@domain.net.ua\", \"$login@domain.net.ua\", \"domain.net.ua\", now(), now(), 1)",$link2);
$res = mysql_query ("insert into mailbox (username, password, name, maildir, quota, local_part, domain, created, modified, active) values
(\"$login@domain.net.ua\", \"$password\", \"$login\", \"domain.net.ua/$login/\", 0, \"$login\", \"domain.net.ua\", now(), now(), 1)",$link2);
}
mysql_free_result($result_pa);
mysql_free_result($result_ab);
?>
Код: Выделить всё
$result_ab = mysql_query("select DECODE(password,'zzzzzz'),id from users", $link1);
Далее все это забрасывается в /etc/crontab:
Код: Выделить всё
1 3 * * * root php /путь/к/скрипту/скрипт.php