These instances are already mounted
elsewhere. Selecting one of them will create an additional location
for the same application:
"
-db_foreach packages_mounted_select {
- select package_id, acs_object.name(package_id) as name
- from
- apm_packages
- where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
- and exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
-} {
+db_foreach packages_mounted_select {} {
doc_body_append "
+doc_body_append "
The packages are centralized services and are
-probably not meant to be mounted anywhere:
+probably not meant to be mounted anywhere:
"
-db_foreach packages_singleton_select {
- select package_id, acs_object.name(package_id) as name
- from
- apm_packages
- where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
- and apm_package.singleton_p(package_key) = 1
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
-} {
+db_foreach packages_singleton_select {} {
doc_body_append "
$name"
}
Index: openacs-4/packages/acs-subsite/www/admin/site-map/new-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/new-oracle.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/www/admin/site-map/new-oracle.xql 30 Apr 2001 20:11:24 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,25 +0,0 @@
-
-
-
- oracle8.1.6
-
-
-
-
- begin
- :1 := site_node.new (
- node_id => :new_node_id,
- parent_id => :parent_id,
- name => :name,
- directory_p => :directory_p,
- pattern_p => :pattern_p,
- creation_user => :user_id,
- creation_ip => :ip_address
- );
- end;
-
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/new-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/new-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/www/admin/site-map/new-postgresql.xql 30 Apr 2001 20:11:24 -0000 1.2
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,24 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
-
- select site_node__new (
- :new_node_id,
- :parent_id,
- :name,
- null,
- :directory_p,
- :pattern_p,
- :user_id,
- :ip_address
- )
-
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/new.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/new.tcl,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/new.tcl 13 Mar 2001 22:59:26 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/new.tcl 21 Jun 2002 19:08:33 -0000 1.2
@@ -1,53 +1,41 @@
ad_page_contract {
- @author Rafael Schloming (rhs@mit.edu)
- @creation-date 2000-09-09
- @cvs-id $Id$
+ @author Rafael Schloming (rhs@mit.edu)
+ @creation-date 2000-09-09
+ @version $Id$
} {
- new_node_id:naturalnum
- parent_id:integer,notnull
- name:notnull
- node_type:notnull
- {expand:integer,multiple {}}
- {root_id:integer {}}
+ parent_id:integer,notnull
+ name:notnull
+ node_type:notnull
+ {expand:integer,multiple {}}
+ {root_id:integer {}}
} -validate {
- name_root_ck -requires name:notnull {
- if {[string match "*/*" $name]} {
- ad_complain
+ name_root_ck -requires name:notnull {
+ if {[string match "*/*" $name]} {
+ ad_complain
+ }
}
- }
-
- name_duplicate_ck -requires name_root_ck {
- if { [db_string site_node_duplicate_name_root_ck {
- select decode(count(*), 0, 0, 1)
- from site_nodes
- where name = :name
- and parent_id = :parent_id
- and node_id <> :new_node_id
- } -default 0]} {
- ad_complain
- }
- }
-
- node_type_ck -requires node_type:notnull {
- switch $node_type {
- folder {
- set directory_p t
- set pattern_p t
- }
-
- file {
- set directory_p f
- set pattern_p f
- }
-
- default {
- ad_complain
- }
- }
- }
-
+ name_duplicate_ck -requires name_root_ck {
+ if { [db_string site_node_duplicate_name_root_ck {} -default 0]} {
+ ad_complain
+ }
+ }
+ node_type_ck -requires node_type:notnull {
+ switch $node_type {
+ folder {
+ set directory_p t
+ set pattern_p t
+ }
+ file {
+ set directory_p f
+ set pattern_p f
+ }
+ default {
+ ad_complain
+ }
+ }
+ }
} -errors {
name_root_ck {Folder or file names cannot contain '/'}
name_duplicate_ck {The URL mapping you are creating is already in use. Please delete the other one or change your URL.}
@@ -58,25 +46,14 @@
set ip_address [ad_conn peeraddr]
db_transaction {
- set node_id [db_exec_plsql node_new {
- begin
- :1 := site_node.new (
- node_id => :new_node_id,
- parent_id => :parent_id,
- name => :name,
- directory_p => :directory_p,
- pattern_p => :pattern_p,
- creation_user => :user_id,
- creation_ip => :ip_address
- );
- end;
- }]
+ set node_id [site_node::new \
+ -name $name \
+ -parent_id $parent_id \
+ -directory_p $directory_p \
+ -pattern_p $pattern_p \
+ ]
} on_error {
- if {![db_string site_node_new_doubleclick_protect {
- select decode(count(*), 0, 0, 1)
- from site_nodes
- where node_id = :new_node_id
- } -default 0]} {
+ if {![db_string site_node_new_doubleclick_protect {} -default 0]} {
ad_return_complaint "Error Creating Site Node" "The following error was generated
when attempting to create the site node:
@@ -86,7 +63,7 @@
}
if {[lsearch $expand $parent_id] == -1} {
- lappend expand $parent_id
+ lappend expand $parent_id
}
-ad_returnredirect .?[export_url_vars expand:multiple root_id]
+ad_returnredirect ".?[export_url_vars expand:multiple root_id]"
Index: openacs-4/packages/acs-subsite/www/admin/site-map/new.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/new.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/new.xql 30 Apr 2001 20:11:24 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/new.xql 21 Jun 2002 19:08:33 -0000 1.2
@@ -1,28 +1,21 @@
-
-
-
- select case when count(*) = 0 then 0 else 1 end
- from site_nodes
- where name = :name
- and parent_id = :parent_id
- and node_id <> :new_node_id
-
-
-
+
+
+ select case when count(*) = 0 then 0 else 1 end
+ from site_nodes
+ where name = :name
+ and parent_id = :parent_id
+
+
-
-
-
-
- select case when count(*) = 0 then 0 else 1 end
- from site_nodes
- where node_id = :new_node_id
-
+
+
+ select case when count(*) = 0 then 0 else 1 end
+ from site_nodes
+ where node_id = :node_id
-
+
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/package-new-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/package-new-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/www/admin/site-map/package-new-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,13 +0,0 @@
-
-
-postgresql7.1
-
-
-
- select case when count(*) = 0 then 0 else 1 end
- from apm_packages
- where package_id = :new_package_id
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/package-new.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/package-new.tcl,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/package-new.tcl 13 Mar 2001 22:59:26 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/package-new.tcl 21 Jun 2002 19:08:33 -0000 1.2
@@ -2,28 +2,25 @@
ad_page_contract {
- @author rhs@mit.edu
- @creation-date 2000-09-13
- @cvs-id $Id$
+ @author rhs@mit.edu
+ @creation-date 2000-09-13
+ @version $Id$
+
} {
- new_package_id:naturalnum
- node_id:integer,notnull
- instance_name:notnull
- package_key:notnull
- {expand:integer,multiple {}}
- root_id:integer,optional
+ new_package_id:integer,notnull
+ node_id:integer,notnull
+ instance_name:notnull
+ package_key:notnull
+ {expand:integer,multiple ""}
+ root_id:integer,optional
}
set context_id [ad_conn package_id]
db_transaction {
- set package_id [site_node_create_package_instance -package_id $new_package_id $node_id $instance_name $context_id $package_key]
+ set package_id [site_node_create_package_instance -package_id $new_package_id $node_id $instance_name $context_id $package_key]
} on_error {
- if {![db_string package_new_doubleclick_ck {
- select decode(count(*), 0, 0, 1)
- from apm_packages
- where package_id = :new_package_id
- } -default 0]} {
+ if {![db_string package_new_doubleclick_ck {} -default 0]} {
ad_return_complaint "Error Creating Package" "The following error was generated
when attempting to create the package
@@ -32,4 +29,4 @@
}
}
-ad_returnredirect .?[export_url_vars expand:multiple root_id]
+ad_returnredirect ".?[export_url_vars expand:multiple root_id]"
Index: openacs-4/packages/acs-subsite/www/admin/site-map/package-new.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/package-new.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/package-new.xql 30 Apr 2001 20:11:24 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/package-new.xql 21 Jun 2002 19:08:33 -0000 1.2
@@ -1,15 +1,13 @@
+
-
-
-
- select case when count(*) = 0 then 0 else 1 end
- from apm_packages
- where package_id = :new_package_id
-
-
-
+
+
+ select case when count(*) = 0 then 0 else 1 end
+ from apm_packages
+ where package_id = :new_package_id
+
+
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/parameter-set-2.tcl,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-2.tcl 13 Mar 2001 22:59:26 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-2.tcl 21 Jun 2002 19:08:33 -0000 1.2
@@ -1,8 +1,11 @@
ad_page_contract {
+
Set parameters on a package instance.
+
@author Bryan Quinn (bquinn@arsdigita.com)
@date 12 September 2000
- @cvs-id $Id$
+ @version $Id$
+
} {
package_key:notnull
package_id:naturalnum,notnull
@@ -12,14 +15,8 @@
ad_require_permission $package_id admin
-ns_log Notice "[array names params]"
-
if { [catch {
- db_foreach apm_parameters_set {
- select parameter_id, parameter_name
- from apm_parameters
- where package_key = :package_key
- } {
+ db_foreach apm_parameters_set {} {
if {[info exists params($parameter_id)]} {
ad_parameter -set $params($parameter_id) -package_id $package_id $parameter_name $package_key
}
@@ -29,4 +26,4 @@
[ad_quotehtml $errmsg]
."
} else {
ad_returnredirect index
-}
\ No newline at end of file
+}
Index: openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/parameter-set-2.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-2.xql 30 Apr 2001 20:11:24 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-2.xql 21 Jun 2002 19:08:33 -0000 1.2
@@ -1,15 +1,14 @@
+
-
-
-
- select parameter_id, parameter_name
- from apm_parameters
- where package_key = :package_key
-
-
-
+
+
+ select parameter_id,
+ parameter_name
+ from apm_parameters
+ where package_key = :package_key
+
+
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/parameter-set-oracle.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-oracle.xql 20 Nov 2001 17:46:28 -0000 1.4
+++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-oracle.xql 21 Jun 2002 19:08:33 -0000 1.5
@@ -1,35 +1,34 @@
- oracle8.1.6
+ oracle8.1.6
-
-
-
- select package_key, acs_object.name(package_id) instance_name
- from apm_packages
- where package_id = :package_id
+
+
+ select package_key,
+ acs_object.name(package_id) instance_name
+ from apm_packages
+ where package_id = :package_id
+
+
-
-
+
+
+ select p.parameter_id,
+ p.parameter_name,
+ p.package_key,
+ nvl(p.description, 'No Description') description,
+ v.attr_value,
+ nvl(p.section_name, 'No Section Name') section_name
+ from apm_parameters p,
+ (select v.parameter_id,
+ v.attr_value
+ from apm_parameter_values v
+ where v.package_id = :package_id) v
+ where p.parameter_id = v.parameter_id(+)
+ and p.package_key = (select package_key from apm_packages where package_id = :package_id)
+ $additional_sql
+
+
-
-
-
-
-select p.parameter_id, p.parameter_name, p.package_key,
- nvl(p.description, 'No Description') description,
- v.attr_value,
- nvl(p.section_name, 'No Section Name') section_name
-from apm_parameters p, (select parameter_id, attr_value
- from apm_parameter_values v
- where v.package_id = :package_id) v
-where p.parameter_id = v.parameter_id(+)
- and p.package_key = (select package_key from apm_packages where package_id = :package_id)
-$additional_sql
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/parameter-set-postgresql.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql 20 Nov 2001 17:46:28 -0000 1.6
+++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql 21 Jun 2002 19:08:33 -0000 1.7
@@ -1,35 +1,34 @@
- postgresql7.1
+ postgresql7.1
-
-
-
- select package_key, acs_object__name(package_id) as instance_name
- from apm_packages
- where package_id = :package_id
+
+
+ select package_key,
+ acs_object__name(package_id) as instance_name
+ from apm_packages
+ where package_id = :package_id
+
+
-
-
+
+
+ select p.parameter_id,
+ p.parameter_name,
+ p.package_key,
+ coalesce(p.description, 'No Description') as description,
+ v.attr_value,
+ coalesce(p.section_name, 'No Section Name') as section_name
+ from apm_parameters p left outer join
+ (select v.parameter_id,
+ v.attr_value
+ from apm_parameter_values v
+ where v.package_id = :package_id) v
+ on p.parameter_id = v.parameter_id
+ where p.package_key = (select package_key from apm_packages where package_id = :package_id)
+ $additional_sql
+
+
-
-
-
-
-select p.parameter_id, p.parameter_name, p.package_key,
- coalesce(p.description, 'No Description') as description,
- v.attr_value,
- coalesce(p.section_name, 'No Section Name') as section_name
-from apm_parameters p left outer join (select parameter_id, attr_value
- from apm_parameter_values v
- where v.package_id = :package_id) v
- on p.parameter_id = v.parameter_id
-where p.package_key = (select package_key from apm_packages where package_id = :package_id)
-$additional_sql
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/parameter-set.tcl,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set.tcl 20 Nov 2001 17:46:28 -0000 1.4
+++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set.tcl 21 Jun 2002 19:08:33 -0000 1.5
@@ -1,20 +1,20 @@
ad_page_contract {
+
Set parameters on a package instance.
+
@author Bryan Quinn (bquinn@arsdigita.com)
@date 12 September 2000
- @cvs-id $Id$
+ @version $Id$
+
} {
package_id:naturalnum,notnull
{orderby ""}
}
ad_require_permission $package_id admin
-db_1row package_info {
- select package_key, acs_object.name(package_id) instance_name
- from apm_packages
- where package_id = :package_id
-}
+db_1row package_info {}
+
set table_def [list \
[list parameter_name "Parameter Name"] \
[list description "Description"]]
Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmount.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/unmount.tcl,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/unmount.tcl 13 Mar 2001 22:59:26 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/unmount.tcl 21 Jun 2002 19:08:33 -0000 1.2
@@ -2,23 +2,16 @@
ad_page_contract {
- @author rhs@mit.edu
- @creation-date 2000-09-12
- @cvs-id $Id$
+ @author rhs@mit.edu
+ @creation-date 2000-09-12
+ @version $Id$
+
} {
- node_id:integer,notnull
- {expand:integer,multiple {}}
- root_id:integer,optional
+ node_id:integer,notnull
+ {expand:integer,multiple ""}
+ root_id:integer,optional
}
-db_transaction {
- db_dml unmount {
- update site_nodes
- set object_id = null
- where node_id = :node_id
- }
+site_node::unmount -node_id $node_id
- site_nodes_sync
-}
-
-ad_returnredirect .?[export_url_vars expand:multiple root_id]
+ad_returnredirect ".?[export_url_vars expand:multiple root_id]"
Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmount.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/unmount.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/www/admin/site-map/unmount.xql 30 Apr 2001 20:11:24 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,15 +0,0 @@
-
-
-
-
-
-
- update site_nodes
- set object_id = null
- where node_id = :node_id
-
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql 30 Apr 2001 20:11:24 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-oracle.xql 21 Jun 2002 19:08:33 -0000 1.2
@@ -1,42 +1,34 @@
- oracle8.1.6
+ oracle8.1.6
-
-
-
- select package_id, acs_object.name(package_id) as name
- from
- apm_packages
- where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
- and apm_package.singleton_p(package_key) = 0
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
+
+
+ select package_id, acs_object.name(package_id) as name
+ from apm_packages
+ where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
+ acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
+ and apm_package.singleton_p(package_key) = 0
+ and not exists (select 1
+ from site_nodes
+ where object_id = package_id)
+ order by name
+
+
-
-
+
+
+ select package_id, acs_object.name(package_id) as name
+ from apm_packages
+ where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
+ acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
+ and apm_package.singleton_p(package_key) = 1
+ and not exists (select 1
+ from site_nodes
+ where object_id = package_id)
+ order by name
+
+
-
-
-
-
- select package_id, acs_object.name(package_id) as name
- from
- apm_packages
- where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
- and apm_package.singleton_p(package_key) = 1
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql 30 Apr 2001 20:11:24 -0000 1.2
+++ openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql 21 Jun 2002 19:08:33 -0000 1.3
@@ -1,42 +1,34 @@
- postgresql7.1
+ postgresql7.1
-
-
-
- select package_id, acs_object__name(package_id) as name
- from
- apm_packages
- where (acs_permission__permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read') = 't')
- and apm_package__singleton_p(package_key) = 0
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
+
+
+ select package_id, acs_object__name(package_id) as name
+ from apm_packages
+ where (acs_permission__permission_p(package_id, :user_id, 'read') = 't' or
+ acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read') = 't')
+ and apm_package__singleton_p(package_key) = 0
+ and not exists (select 1
+ from site_nodes
+ where object_id = package_id)
+ order by name
+
+
-
-
+
+
+ select package_id, acs_object__name(package_id) as name
+ from apm_packages
+ where (acs_permission__permission_p(package_id, :user_id, 'read') = 't' or
+ acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read') = 't')
+ and apm_package__singleton_p(package_key) = 1
+ and not exists (select 1
+ from site_nodes
+ where object_id = package_id)
+ order by name
+
+
-
-
-
-
- select package_id, acs_object__name(package_id) as name
- from
- apm_packages
- where (acs_permission__permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read') = 't')
- and apm_package__singleton_p(package_key) = 1
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
-
-
-
-
-
Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmounted.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/unmounted.tcl,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/site-map/unmounted.tcl 13 Mar 2001 22:59:26 -0000 1.1
+++ openacs-4/packages/acs-subsite/www/admin/site-map/unmounted.tcl 21 Jun 2002 19:08:33 -0000 1.2
@@ -2,10 +2,10 @@
Display all readable unmounted packages
- @author bquinn@arsdigita.com
- @creation-date 2000-09-12
- @cvs-id $Id$
-} {
+ @author bquinn@arsdigita.com
+ @creation-date 2000-09-12
+ @version $Id$
+
}
doc_body_append "[ad_header "Unmounted Packages"]
@@ -20,18 +20,7 @@
set user_id [ad_conn user_id]
-db_foreach packages_normal_select {
- select package_id, acs_object.name(package_id) as name
- from
- apm_packages
- where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
- and apm_package.singleton_p(package_key) = 0
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
-} {
+db_foreach packages_normal_select {} {
doc_body_append "
"
-db_foreach packages_singleton_select {
- select package_id, acs_object.name(package_id) as name
- from
- apm_packages
- where (acs_permission.permission_p(package_id, :user_id, 'read') = 't' or
- acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't')
- and apm_package.singleton_p(package_key) = 1
- and not exists (select 1
- from site_nodes
- where object_id = package_id)
- order by name
-} {
+db_foreach packages_singleton_select {} {
doc_body_append "