Index: openacs-4/packages/dotlrn/www/admin/user.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/user.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/dotlrn/www/admin/user.xql 14 Mar 2002 05:40:14 -0000 1.1 +++ openacs-4/packages/dotlrn/www/admin/user.xql 19 Mar 2002 01:23:15 -0000 1.2 @@ -18,35 +18,4 @@ - - - select group_id, - rel_id, - party_names.party_name as group_name - from (select /*+ ORDERED */ distinct rels.rel_id, - object_id_one as group_id, - object_id_two - from acs_rels rels, all_object_party_privilege_map perm - where perm.object_id = rels.rel_id - and perm.privilege = 'read' - and rels.rel_type = 'membership_rel' - and rels.object_id_two = :user_id) r, - party_names - where r.group_id = party_names.party_id - order by lower(party_names.party_name) - - - - - - select groups.group_id, - groups.group_name - from groups, - group_member_map gm - where groups.group_id = gm.group_id - and gm.member_id = :user_id - order by lower(groups.group_name) - - -