X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=bin%2Femails.broken.php;h=626286ef8f5dac482144012dc3f4045f81f97050;hb=aa00e0fa28fc74cb714c37da9a46c7c39a19b91b;hp=d1a31f7db05e903be76cf2d8240a6ce71a8a84bb;hpb=162b07eb856e3f1d9269c70c6f4491a5f19e89f5;p=platal.git

diff --git a/bin/emails.broken.php b/bin/emails.broken.php
index d1a31f7..626286e 100755
--- a/bin/emails.broken.php
+++ b/bin/emails.broken.php
@@ -1,7 +1,7 @@
 #!/usr/bin/php5 -q
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2006 Polytechnique.org                              *
+ *  Copyright (C) 2003-2007 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -96,6 +96,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) {