Index: openacs-4/packages/dotlrn/www/spam-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/spam-oracle.xql,v diff -u -r1.2.6.2 -r1.2.6.3 --- openacs-4/packages/dotlrn/www/spam-oracle.xql 22 Jul 2004 05:58:37 -0000 1.2.6.2 +++ openacs-4/packages/dotlrn/www/spam-oracle.xql 11 Aug 2004 22:45:06 -0000 1.2.6.3 @@ -36,8 +36,7 @@ acs_objects where (acs_rels.object_id_one = $community_id and acs_rels.object_id_two = parties.party_id - and (acs_rels.rel_type in ('$rel_types_str') - or acs_rels.object_id_two in ($recipients_str)) + $query_restriction and parties.party_id = acs_objects.object_id and parties.party_id in (select acs_rels.object_id_two from acs_rels, membership_rels