Index: openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql	2 Jun 2002 00:05:56 -0000	1.13
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql	4 Dec 2002 09:51:04 -0000	1.14
@@ -24,18 +24,18 @@
                    persons.last_name,
                    parties.email,
                    'f' as read_private_data_p,
-                   acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p
+                   acs_permission.permission_p(:root_object_id, users.user_id, 'admin') as site_wide_admin_p, member_state
             from parties,
                  users,
                  persons,
                  acs_rels,
                  membership_rels
             where parties.party_id = users.user_id
+	    and member_state not in ('banned','deleted','rejected')
             and users.user_id = persons.person_id
             and persons.person_id = acs_rels.object_id_two
             and acs_rels.object_id_one = acs.magic_object_id('registered_users')
             and acs_rels.rel_id = membership_rels.rel_id
-            and membership_rels.member_state = 'approved'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types