X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Femails.check.php;h=b6aaf86f0824c71f34e73042e340711064b1493e;hb=c974e61c78efb98c0cbe81aa78bfdc47f3c31ead;hp=5ad8bbe26c571eb42649276530fcf0aef04aac82;hpb=010268b2e818de5aa8db1cef05bca1c91701b2f9;p=platal.git diff --git a/bin/cron/emails.check.php b/bin/cron/emails.check.php index 5ad8bbe..b6aaf86 100755 --- a/bin/cron/emails.check.php +++ b/bin/cron/emails.check.php @@ -26,12 +26,12 @@ $panne_level = 3; require('./connect.db.inc.php'); -/* +/* * Check duplicated addresses */ $sql = "SELECT a1.alias, a2.alias, e1.email FROM emails AS e1 - INNER JOIN emails AS e2 ON (e1.email = e2.email AND e1.uid != e2.uid + INNER JOIN emails AS e2 ON (e1.email = e2.email AND e1.uid != e2.uid AND (e1.uid < e2.uid OR NOT FIND_IN_SET('active', e2.flags))) LEFT JOIN emails_watch AS w ON (e1.email = w.email) INNER JOIN aliases AS a1 ON (a1.id = e1.uid AND a1.type = 'a_vie')