Index: openacs-4/packages/assessment/www/admin/item-add-display-sb.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/item-add-display-sb.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/assessment/www/admin/item-add-display-sb.xql	10 Dec 2004 11:42:23 -0000	1.2
+++ openacs-4/packages/assessment/www/admin/item-add-display-sb.xql	14 Jan 2005 13:13:37 -0000	1.3
@@ -1,6 +1,18 @@
 <?xml version="1.0"?>
 <queryset>
 
+<fullquery name="item_display">
+      <querytext>
+
+	select r.target_rev_id, o.object_type
+	from as_item_rels r, acs_objects o
+	where r.item_rev_id = :as_item_id
+	and r.rel_type = 'as_item_display_rel'
+	and o.object_id = r.target_rev_id
+
+      </querytext>
+</fullquery>
+
 <fullquery name="update_section_in_assessment">
       <querytext>
 
@@ -38,4 +50,39 @@
       </querytext>
 </fullquery>
 
+<fullquery name="update_item_display">
+      <querytext>
+
+		update as_item_rels
+		set target_rev_id = :as_item_display_id
+		where item_rev_id = :as_item_id
+		and rel_type = 'as_item_display_rel'
+
+      </querytext>
+</fullquery>
+
+<fullquery name="item_data">
+      <querytext>
+
+	    select required_p, max_time_to_complete, points
+	    from as_items
+	    where as_item_id = :as_item_id
+
+      </querytext>
+</fullquery>
+
+<fullquery name="update_item">
+      <querytext>
+
+	    update as_item_section_map
+	    set as_item_id = :as_item_id,
+	        required_p = :required_p,
+	        max_time_to_complete = :max_time_to_complete,
+	        points = :points
+	    where as_item_id = :old_item_id
+	    and section_id = :new_section_id
+
+      </querytext>
+</fullquery>
+
 </queryset>