Index: openacs-4/packages/cms/www/modules/sitemap/delete-items-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/sitemap/delete-items-oracle.xql,v diff -u -N --- openacs-4/packages/cms/www/modules/sitemap/delete-items-oracle.xql 13 Apr 2005 20:15:19 -0000 1.5 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,77 +0,0 @@ - - - - oracle8.1.6 - - - - - select - item_id, - nvl(content_item.get_title(item_id),name) title, - content_item.get_path(item_id) path, - pretty_name as content_type_pretty, - content_symlink.is_symlink(item_id) is_symlink, - content_folder.is_folder(item_id) is_folder, - content_template.is_template(item_id) is_template - from - cr_items i, acs_object_types t - where - i.content_type = t.object_type - and - item_id in ([join $clip_items ","]) - and - -- permissions check - acs_permission.permission_p( item_id, :user_id, 'write' ) = 't' - order by - -- this way parents are deleted after their children - item_id desc - - - - - - - - - begin - $delete_proc ( - $delete_key => :del_item_id - ); - end; - - - - - - - content_symlink.del - - - - - - - - content_folder.del - - - - - - - - content_template.del - - - - - - - - content_item.del - - - - -