- Xdb::execute("UPDATE emails
- SET panne_level = $panne_level
- WHERE panne_level > $panne_level");
+ Xdb::execute('UPDATE emails
+ SET panne_level = {?}
+ WHERE panne_level > {?}',
+ $panne_level, $panne_level);
+}
+
+/*
+ * Retrieve the users with no active redirection, but still one working
+ * inactive redirection.
+ */
+if ($opt_verbose) {
+ $res = XDB::query("SELECT a.hruid, ei.email
+ FROM accounts AS a
+ LEFT JOIN emails AS ea ON (ea.uid = a.uid AND ea.flags = 'active')
+ INNER JOIN emails AS ei ON (ei.uid = a.uid AND ei.flags = '')
+ INNER JOIN email_options AS eo ON (eo.uid = a.uid)
+ WHERE NOT FIND_IN_SET('googleapps', eo.storage) AND ea.email IS NULL
+ GROUP BY a.uid");
+
+ if ($res->numRows()) {
+ $result = $res->fetchAllAssoc();
+ echo "Camarades n'ayant plus d'adresses actives, mais ayant une adresse inactive :\n";
+ foreach ($result as $user) {
+ echo '* ' . $user['email'] . ' pour ' . $user['hruid'] . "\n";
+ }
+ }
+ echo "\n";