+/*
+ * Retrieve the users with no active redirection, but still one working
+ * inactive redirection.
+ */
+if ($opt_verbose) {
+ $res = XDB::query("SELECT u.hruid, ei.email
+ FROM auth_user_md5 AS u
+ LEFT JOIN emails AS ea ON (ea.uid = u.user_id AND ea.flags='active')
+ INNER JOIN emails AS ei ON (ei.uid = u.user_id AND ei.flags='')
+ WHERE FIND_IN_SET('googleapps', u.mail_storage) = 0 AND ea.email IS NULL
+ GROUP BY u.user_id");
+
+ 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";
+}
+