From d78749d85e240d8ae7d241fd7a7ed2dfc2f179c7 Mon Sep 17 00:00:00 2001 From: zacheiss Date: Fri, 5 Apr 2002 22:53:50 +0000 Subject: [PATCH] Include status 9 users. --- gen/warehouse.pc | 2 +- gen/www.pc | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/gen/warehouse.pc b/gen/warehouse.pc index b08f3a8a..4f8c0a11 100644 --- a/gen/warehouse.pc +++ b/gen/warehouse.pc @@ -96,7 +96,7 @@ int main(int argc, char **argv) SELECT login, clearid, first, last, middle FROM users WHERE (status = 1 or status = 2 or status = 5 OR - status = 6 or status = 7); + status = 6 or status = 7 or status = 9); EXEC SQL OPEN x; while (1) { diff --git a/gen/www.pc b/gen/www.pc index 339eb30a..db0529a4 100644 --- a/gen/www.pc +++ b/gen/www.pc @@ -234,7 +234,7 @@ void group(FILE *out) EXEC SQL WHENEVER SQLERROR GOTO sqlerr; EXEC SQL DECLARE user_cursor CURSOR FOR - SELECT login FROM users WHERE status=1 OR status=2 OR status=6 + SELECT login FROM users WHERE status=1 OR status=2 OR status=6 OR status=9 ORDER by login; EXEC SQL OPEN user_cursor; -- 2.45.2