Index: openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql 16 Feb 2008 19:06:36 -0000 1.5 +++ openacs-4/packages/dotlrn/www/dotlrn-main-portlet-postgresql.xql 26 Feb 2008 16:00:15 -0000 1.6 @@ -20,7 +20,8 @@ tree_level(dotlrn_communities_all.tree_sortkey) as tree_level, coalesce((select tree_level(dotlrn_community_types.tree_sortkey) from dotlrn_community_types - where dotlrn_community_types.community_type = dotlrn_communities_all.community_type), 0) as community_type_level + where dotlrn_community_types.community_type = dotlrn_communities_all.community_type), 0) as community_type_level, + acs_permission__permission_p(dotlrn_communities_all.community_id, :user_id, 'admin') as admin_p from dotlrn_communities_all, dotlrn_member_rels_approved where dotlrn_communities_all.community_id = dotlrn_member_rels_approved.community_id