Include status 9 users as well.

diff --git a/gen/ldap.gen b/gen/ldap.gen
index 1146e17e7690dcffbbfd7d0ea16f0e42bc7031b2..c5de58b862fb21dcfd107188ebb94740711e5993 100755 (executable)
--- a/gen/ldap.gen
+++ b/gen/ldap.gen
@@ -19,7 +19,7 @@ $dbh = DBI->connect("dbi:Oracle:moira", "moira", "moira")
     || exit $MR_DBMS_ERR;
 
 $sth = $dbh->prepare("SELECT login, first, middle, last, clearid FROM users " .
-                    "WHERE status = 1");
+                    "WHERE status = 1 OR status = 9");
 
 $sth->execute;
 
@@ -88,7 +88,7 @@ while (($name) = $sth0->fetchrow_array) {
                          "WHERE l.name = " . $dbh->quote($name) .
                          "AND i.list_id = l.list_id " .
                          "AND i.member_id = u.users_id " .
-                         "AND u.status = 1 " .
+                         "AND (u.status = 1 OR u.status = 9)" .
                          "AND member_type = 'USER'")
                          || exit $MR_DBMS_ERR;
     $sth->execute;