Index: openacs-4/packages/file-storage/www/copy-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/copy-postgresql.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/file-storage/www/copy-postgresql.xql 8 Aug 2006 21:26:49 -0000 1.6 +++ openacs-4/packages/file-storage/www/copy-postgresql.xql 23 Oct 2008 13:59:02 -0000 1.7 @@ -15,7 +15,7 @@ - select fs.object_id, fs.name, + select fs.object_id, fs.name, fs.parent_id, acs_permission__permission_p(fs.object_id, :user_id, 'read') as copy_p, fs.type from fs_objects fs where fs.object_id in ([template::util::tcl_to_sql_list $object_id]) @@ -48,7 +48,7 @@ select - cf.folder_id, cf.label, tree_level(ci1.tree_sortkey) as level_num + cf.folder_id, ci1.parent_id, cf.label, tree_level(ci1.tree_sortkey) as level_num from cr_folders cf, cr_items ci1, cr_items ci2 where ci1.tree_sortkey between ci2.tree_sortkey and