Index: openacs-4/packages/assessment/www/admin/section-form.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/section-form.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/www/admin/section-form.xql 14 Nov 2004 16:43:21 -0000 1.1
+++ openacs-4/packages/assessment/www/admin/section-form.xql 10 Dec 2004 11:42:24 -0000 1.2
@@ -4,17 +4,21 @@
- select section_display_type_id, pagination_style
- from as_section_display_types
+ select cr.title, d.display_type_id
+ from as_section_display_types d, cr_revisions cr, cr_items ci, cr_folders cf
+ where cr.revision_id = d.display_type_id
+ and ci.latest_revision = cr.revision_id
+ and cf.folder_id = ci.parent_id
+ and cf.package_id = :package_id
- select ci.name, cr.title, cr.description, s.definition, s.instructions,
- s.required_p, s.feedback_text, s.max_time_to_complete
+ select ci.name, cr.title, cr.description, s.instructions, s.display_type_id,
+ s.feedback_text, s.max_time_to_complete, s.points
from as_sections s, cr_revisions cr, cr_items ci
where cr.revision_id = s.section_id
and ci.item_id = cr.item_id
@@ -37,8 +41,8 @@
- insert into as_assessment_section_map (assessment_id, section_id, feedback_text, max_time_to_complete, sort_order)
- values (:new_assessment_rev_id, :section_id, :feedback_text, :max_time_to_complete, :sort_order)
+ insert into as_assessment_section_map (assessment_id, section_id, max_time_to_complete, sort_order, points)
+ values (:new_assessment_rev_id, :new_section_id, :max_time_to_complete, :sort_order, :points)
@@ -47,9 +51,9 @@
update as_assessment_section_map
- set feedback_text = :feedback_text,
- max_time_to_complete = :max_time_to_complete,
- section_id = :new_section_id
+ set max_time_to_complete = :max_time_to_complete,
+ points = :points,
+ section_id = :new_section_id
where assessment_id = :new_assessment_rev_id
and section_id = :section_id