X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Femails.broken.php;h=d371854d05e2adb880b7591e8005c6f3e5ee0d81;hb=12a587df92f7bc9efeb91c1a2d27f763070b8609;hp=d1a31f7db05e903be76cf2d8240a6ce71a8a84bb;hpb=162b07eb856e3f1d9269c70c6f4491a5f19e89f5;p=platal.git diff --git a/bin/emails.broken.php b/bin/emails.broken.php index d1a31f7..d371854 100755 --- a/bin/emails.broken.php +++ b/bin/emails.broken.php @@ -1,7 +1,7 @@ #!/usr/bin/php5 -q addTo("\"{$x['prenom']} {$x['nom']}\" <{$x['alias']}@polytechnique.org>"); + $mail->addTo("\"{$x['prenom']} {$x['nom']}\" <{$x['alias']}@" . $globals->mail->domain . '>'); $mail->assign('x', $x); $mail->assign('email', $email); $mail->send(); - echo "$email : mail envoyé\n"; + echo "$email : mail envoyé\n"; } if (!isset($list[$x['alias']])) { @@ -88,7 +87,7 @@ foreach ($emails as $_email) { $list[$x['alias']][] = $email; } } else { - echo "$email : cette addresse n'est pas dans la base\n"; + echo "$email : cette adresse n'est pas dans la base\n"; } } @@ -96,6 +95,10 @@ XDB::execute("UPDATE emails SET panne_level = panne_level - 1 WHERE flags = 'active' AND panne_level > 1 AND last != CURDATE()"); +XDB::execute("UPDATE emails + SET panne_level = 0 + WHERE flags = 'active' AND panne_level = 1 + AND DATE_ADD(last, INTERVAL 1 YEAR) < CURDATE()"); $csv = "nom;prenom;promo;alias;bounce;nbmails\n"; foreach ($list as $alias=>$mails) { @@ -115,4 +118,5 @@ $fo = fopen($output, 'w+'); fwrite($fo, $csv); fclose($fo); +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>