Index: openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql,v diff -u -r1.10.2.1 -r1.10.2.2 --- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 20 Nov 2003 21:24:02 -0000 1.10.2.1 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 21 Nov 2003 01:39:14 -0000 1.10.2.2 @@ -169,6 +169,7 @@ and u.user_id = m.member_id and m.rel_id = mr.rel_id and m.group_id = (select acs.magic_object_id('registered_users') from dual) + and m.container_id = m.group_id and mr.member_state = 'approved' and u.email_verified_p = 't'; Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql,v diff -u -r1.22.2.1 -r1.22.2.2 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 20 Nov 2003 21:24:03 -0000 1.22.2.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 21 Nov 2003 01:39:14 -0000 1.22.2.2 @@ -154,6 +154,7 @@ and m.rel_id = mr.rel_id and amo.name = 'registered_users' and m.group_id = amo.object_id + and m.container_id = m.group_id and mr.member_state = 'approved' and u.email_verified_p = 't';