Index: openacs-4/packages/acs-admin/www/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/Attic/index-oracle.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-admin/www/index-oracle.xql 31 Dec 2003 01:03:44 -0000 1.4 +++ openacs-4/packages/acs-admin/www/index-oracle.xql 23 Feb 2009 21:30:11 -0000 1.5 @@ -8,9 +8,10 @@ select s.node_id, site_node.url(node_id) as node_url, instance_name - from site_nodes s, apm_packages p + from site_nodes s, apm_packages p, apm_package_types t where s.object_id = p.package_id - and p.package_key = 'acs-subsite' + and p.package_key = t.package_key + and t.implements_subsite_p = 't' Index: openacs-4/packages/acs-admin/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/Attic/index-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-admin/www/index-postgresql.xql 31 Dec 2003 01:03:44 -0000 1.4 +++ openacs-4/packages/acs-admin/www/index-postgresql.xql 23 Feb 2009 21:30:11 -0000 1.5 @@ -8,9 +8,10 @@ select s.node_id, site_node__url(node_id) as node_url, instance_name - from site_nodes s, apm_packages p + from site_nodes s, apm_packages p, apm_package_types t where s.object_id = p.package_id - and p.package_key = 'acs-subsite' + and p.package_key = t.package_key + and t.implements_subsite_p is true