Index: openacs-4/packages/assessment/tcl/as-checks-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-checks-procs.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/assessment/tcl/as-checks-procs.xql 26 Jan 2005 23:14:29 -0000 1.3 +++ openacs-4/packages/assessment/tcl/as-checks-procs.xql 27 Jan 2005 18:07:37 -0000 1.4 @@ -311,5 +311,48 @@ + + + select action_id,order_by,user_message,action_perform from as_action_map where inter_item_check_id=:inter_item_check_id + + + + + insert into as_action_map (inter_item_check_id,action_id,order_by,user_message,action_perform) values + (:insert_p,:action_id,:order_by,:user_message,:action_perform) + + + + + + select parameter_id,value,item_id from as_param_map + where inter_item_check_id=:inter_item_check_id + + + + + + insert into as_param_map (parameter_id,value,item_id,inter_item_check_id) values (:parameter_id,:value,:item_id,:insert_p) + + + + + + select inter_item_check_id from as_inter_item_checks where section_id_to =:section_id + + + + + + update as_inter_item_checks set section_id_to=:new_section_id where inter_item_check_id=:check_id + + + + + + select inter_item_check_id from as_inter_item_checks where section_id_from in (select s.section_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id =:assessment_rev_id) + + +