Index: openacs-4/packages/acs-admin/www/users/one.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.xql,v diff -u -r1.16 -r1.17 --- openacs-4/packages/acs-admin/www/users/one.xql 27 Oct 2014 16:38:58 -0000 1.16 +++ openacs-4/packages/acs-admin/www/users/one.xql 3 Sep 2024 15:37:29 -0000 1.17 @@ -1,27 +1,6 @@ - - - select live_revision as revision_id, - coalesce(title,'view this portrait') as portrait_title - from acs_rels a, cr_items c, cr_revisions cr - where a.object_id_two = c.item_id - and c.live_revision = cr.revision_id - and a.object_id_one = :user_id - and a.rel_type = 'user_portrait_rel' - - - - - - select distinct lower(groups.group_name) as 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) - - - select group_id, rel_id, party_names.party_name as group_name