Index: openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql,v
diff -u -r1.12.2.1 -r1.12.2.2
--- openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql	17 Oct 2002 12:59:53 -0000	1.12.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-large-oracle.xql	13 Mar 2003 14:25:23 -0000	1.12.2.2
@@ -41,6 +41,7 @@
             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 users.email_verified_p = 't'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types
Index: openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql	17 Oct 2002 12:59:53 -0000	1.1.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-large-postgresql.xql	13 Mar 2003 14:25:24 -0000	1.1.2.2
@@ -41,6 +41,7 @@
             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 users.email_verified_p = 't'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types
Index: openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql,v
diff -u -r1.13.2.1 -r1.13.2.2
--- openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql	17 Oct 2002 12:59:53 -0000	1.13.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql	13 Mar 2003 14:25:24 -0000	1.13.2.2
@@ -52,6 +52,7 @@
             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 users.email_verified_p = 't'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types
Index: openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql	17 Oct 2002 12:59:53 -0000	1.1.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql	13 Mar 2003 14:25:24 -0000	1.1.2.2
@@ -52,6 +52,7 @@
             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 users.email_verified_p = 't'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types
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.2.1 -r1.13.2.2
--- openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql	17 Oct 2002 12:59:53 -0000	1.13.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-small-oracle.xql	13 Mar 2003 14:25:24 -0000	1.13.2.2
@@ -36,6 +36,7 @@
             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 users.email_verified_p = 't'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types
Index: openacs-4/packages/dotlrn/www/admin/users-chunk-small-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-small-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/dotlrn/www/admin/users-chunk-small-postgresql.xql	17 Oct 2002 12:59:53 -0000	1.1.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-small-postgresql.xql	13 Mar 2003 14:25:24 -0000	1.1.2.2
@@ -37,6 +37,7 @@
             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 users.email_verified_p = 't'
             and not exists (select 1
                             from acs_rels a,
                                  dotlrn_user_types