+/*
+ * Check dead emails
+ */
+if ($panne_level > 0) {
+ $sql = "SELECT e.email, u.hruid
+ FROM emails AS e
+ INNER JOIN auth_user_md5 AS u ON u.user_id = e.uid
+ WHERE e.panne_level = $panne_level AND e.flags = 'active'
+ ORDER BY u.hruid";
+ $res = Xdb::query($sql);
+
+ if ($res->numRows()) {
+ $result = $res->fetchAllAssoc();
+ echo "Nouvelles adresses en panne detectees :\n";
+ foreach ($result as $assoc) {
+ echo '* ' . $assoc['email'] . ' pour ' . $assoc['hruid'] . "\n";
+ }
+ echo "\n\n";