Index: openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql	7 Dec 2001 22:46:40 -0000	1.4
+++ openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql	16 Jan 2003 13:40:37 -0000	1.5
@@ -44,27 +44,26 @@
  
 <fullquery name="context">      
       <querytext>
-      
-  select acs_object__name(context_id)
-  from acs_objects
-  where object_id = :object_id
 
+SELECT acs_object__name(context_id) as context_name, context_id, security_inherit_p
+  FROM acs_objects
+ WHERE object_id = :object_id
+
       </querytext>
 </fullquery>
 
  
 <fullquery name="children">      
       <querytext>
       
-	select object_id as c_object_id,acs_object__name(object_id) as c_name
+	select object_id as c_object_id,acs_object__name(object_id) as c_name, object_type as c_type
 	from acs_objects o
 	where context_id = :object_id
               and exists (select 1
-                          from all_object_party_privilege_map
+                          from acs_permissions_all
                           where object_id = o.object_id
-                          and party_id = :user_id
+                          and grantee_id = :user_id
                           and privilege = 'admin')    
-    
       </querytext>
 </fullquery>