Index: openacs-4/packages/file-storage/www/move-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/move-oracle.xql,v diff -u -N --- openacs-4/packages/file-storage/www/move-oracle.xql 15 Mar 2019 09:45:54 -0000 1.9.2.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,38 +0,0 @@ - - - - - - - - - - - oracle - 8.1.6 - - - - - select - cf.folder_id, ci1.parent_id, cf.label, ci1.level_num - from cr_folders cf, (select item_id, parent_id, level as level_num from - cr_items - where cr_items.item_id not in ($object_id_list) - connect by (prior item_id=parent_id and parent_id not in ($object_id_list)) - start with cr_items.item_id = :root_folder_id - - ) ci1 - where - ci1.item_id=cf.folder_id - and exists (select 1 - from acs_object_party_privilege_map m - where m.object_id = cf.folder_id - and m.party_id = :user_id - and m.privilege = 'write') - order by level_num, cf.label - - - -