From 06bdd610fc586bb4dd3f306e0bb6365fcf001f31 Mon Sep 17 00:00:00 2001
From: Vincent Zanotti <vincent.zanotti@polytechnique.org>
Date: Wed, 30 Apr 2008 15:31:09 +0200
Subject: [PATCH] Adds an helper for newsletter's bounces processing --
 analyzes email from its standard input, and checks that the email is in the
 database (otherwise prompting the root to look for the real email address in
 the bounce's headers).

Signed-off-by: Vincent Zanotti <vincent.zanotti@polytechnique.org>
---
 bin/emails.broken.helper.php | 67 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 67 insertions(+)
 create mode 100755 bin/emails.broken.helper.php

diff --git a/bin/emails.broken.helper.php b/bin/emails.broken.helper.php
new file mode 100755
index 0000000..c88db0b
--- /dev/null
+++ b/bin/emails.broken.helper.php
@@ -0,0 +1,67 @@
+#!/usr/bin/php5 -q
+<?php
+/***************************************************************************
+ *  Copyright (C) 2003-2008 Polytechnique.org                              *
+ *  http://opensource.polytechnique.org/                                   *
+ *                                                                         *
+ *  This program is free software; you can redistribute it and/or modify   *
+ *  it under the terms of the GNU General Public License as published by   *
+ *  the Free Software Foundation; either version 2 of the License, or      *
+ *  (at your option) any later version.                                    *
+ *                                                                         *
+ *  This program is distributed in the hope that it will be useful,        *
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
+ *  GNU General Public License for more details.                           *
+ *                                                                         *
+ *  You should have received a copy of the GNU General Public License      *
+ *  along with this program; if not, write to the Free Software            *
+ *  Foundation, Inc.,                                                      *
+ *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
+ ***************************************************************************/
+
+ini_set('include_path', '.:../include:/usr/share/php');
+
+require_once('connect.db.inc.php');
+require_once('xorg.inc.php');
+require_once('emails.inc.php');
+
+$opts = getopt('o:');
+if (($opts['o'] && $opts['o'] == '-') || empty($opts['o'])) {
+    printf("Usage: emails.broken.helper.php -o <file>\n");
+    exit(1);
+} else {
+    $output = $opts['o'];
+}
+
+$input_fd = fopen("php://stdin", "r");
+$output_fd = fopen($output, "a");
+
+while ($_email = fgets($input_fd)) {
+    $_email = trim($_email);
+    $email = valide_email($_email);
+    if (empty($email) || $email=='@') {
+        printf(">> %s: invalid email\n", $_email);
+        continue;
+    }
+
+    $sel = XDB::query(
+            "SELECT  e1.uid, e1.panne != 0 AS panne, count(e2.uid) AS nb_mails, u.nom, u.prenom, u.promo, a.alias
+               FROM  emails        AS e1
+          LEFT JOIN  emails        AS e2 ON (e1.uid = e2.uid AND FIND_IN_SET('active', e2.flags) AND e1.email != e2.email)
+         INNER JOIN  auth_user_md5 AS u  ON (e1.uid = u.user_id)
+         INNER JOIN  aliases       AS a  ON (u.user_id = a.id AND FIND_IN_SET('bestalias',a.flags))
+              WHERE  e1.email = {?}
+           GROUP BY  e1.uid", $email);
+    if ($sel->numRows() > 0) {
+        fwrite($output_fd, $email . "\n");
+    } else {
+        printf(">> %s: email not in the database\n", $_email);
+    }
+}
+
+fclose($input_fd);
+fclose($output_fd);
+
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+?>
-- 
2.1.4