Index: openacs-4/packages/acs-subsite/www/admin/site-map/site-map-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/site-map-oracle.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-subsite/www/admin/site-map/site-map-oracle.xql 13 Jan 2005 13:55:49 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/admin/site-map/site-map-oracle.xql 15 Feb 2005 16:02:19 -0000 1.3 @@ -35,7 +35,8 @@ directory_p, parent_id, n_children, - decode(acs_permission.permission_p(object_id, :user_id, 'admin'), 't', 1, 0) object_admin_p + decode(acs_permission.permission_p(object_id, :user_id, 'admin'), 't', 1, 0) object_admin_p, + (select view_p from site_nodes_selection where node_id=site_map.node_id) as view_p from apm_packages p, (select node_id, site_node.url(node_id) as url, Index: openacs-4/packages/acs-subsite/www/site-map/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/site-map/index-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-subsite/www/site-map/index-oracle.xql 14 Feb 2005 21:56:39 -0000 1.3 +++ openacs-4/packages/acs-subsite/www/site-map/index-oracle.xql 15 Feb 2005 16:02:19 -0000 1.4 @@ -35,7 +35,8 @@ directory_p, parent_id, n_children, - decode(acs_permission.permission_p(object_id, :user_id, 'admin'), 't', 1, 0) object_admin_p + decode(acs_permission.permission_p(object_id, :user_id, 'admin'), 't', 1, 0) object_admin_p, + (select view_p from site_nodes_selection where node_id=site_map.node_id) as view_p from apm_packages p, (select node_id, site_node.url(node_id) as url,