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