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)
-
-
-