Index: openacs-4/packages/fs-portlet/www/fs-contents-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/fs-portlet/www/Attic/fs-contents-portlet-oracle.xql,v
diff -u -N
--- openacs-4/packages/fs-portlet/www/fs-contents-portlet-oracle.xql 4 Dec 2002 09:54:15 -0000 1.2
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,30 +0,0 @@
-
-
-
-oracle8.1.6
-
-
-
- select file_storage.get_package_id(fs_objects.object_id) as package_id,
- decode(fs_objects.type, 'url', (select site_node.url(site_nodes.node_id)
- from site_nodes
- where site_nodes.object_id = file_storage.get_package_id(fs_objects.parent_id)),
- (select site_node.url(site_nodes.node_id)
- from site_nodes
- where site_nodes.object_id = file_storage.get_package_id(fs_objects.object_id))) as url,
- fs_objects.object_id,
- fs_objects.file_upload_name,
- fs_objects.name,
- fs_objects.live_revision,
- fs_objects.type,
- fs_objects.content_size
- from fs_objects
- where fs_objects.parent_id in ([join $list_of_folder_ids ", "])
- and 't' = acs_permission.permission_p(fs_objects.object_id, :user_id, 'read')
- order by fs_objects.parent_id,
- fs_objects.sort_key,
- fs_objects.name
-
-
-
-
Index: openacs-4/packages/fs-portlet/www/fs-contents-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/fs-portlet/www/Attic/fs-contents-portlet-postgresql.xql,v
diff -u -N
--- openacs-4/packages/fs-portlet/www/fs-contents-portlet-postgresql.xql 4 Dec 2002 09:54:15 -0000 1.3
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,33 +0,0 @@
-
-
-
-postgresql7.1
-
-
-
- select file_storage__get_package_id(fs_objects.object_id) as package_id,
- (CASE
- WHEN fs_objects.type = 'url'
- THEN (select site_node__url(site_nodes.node_id)
- from site_nodes
- where site_nodes.object_id = file_storage__get_package_id(fs_objects.parent_id))
- ELSE (select site_node__url(site_nodes.node_id)
- from site_nodes
- where site_nodes.object_id = file_storage__get_package_id(fs_objects.object_id))
- END) as url,
- fs_objects.object_id,
- fs_objects.file_upload_name,
- fs_objects.name,
- fs_objects.live_revision,
- fs_objects.type,
- fs_objects.content_size
- from fs_objects
- where fs_objects.parent_id in ([join $list_of_folder_ids ", "])
- and 't' = acs_permission__permission_p(fs_objects.object_id, :user_id, 'read')
- order by fs_objects.parent_id,
- fs_objects.sort_key,
- fs_objects.name
-
-
-
-