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 -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/sitemap/delete-items-oracle.xql	27 May 2001 00:22:34 -0000	1.2
+++ openacs-4/packages/cms/www/modules/sitemap/delete-items-oracle.xql	30 May 2001 22:56:27 -0000	1.3
@@ -3,6 +3,34 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+<fullquery name="get_marked_items">      
+      <querytext>
+
+  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
+    cms_permission.permission_p( item_id, :user_id, 'cm_write' ) = 't'
+  order by
+    -- this way parents are deleted after their children
+    item_id desc
+
+      </querytext>
+</fullquery>
+
+
 <fullquery name="delete_items">      
       <querytext>