Index: openacs-4/packages/scorm-importer/tcl/import-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/scorm-importer/tcl/Attic/import-procs.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/scorm-importer/tcl/import-procs.xql 14 May 2010 23:30:31 -0000 1.3
+++ openacs-4/packages/scorm-importer/tcl/import-procs.xql 18 May 2010 02:00:23 -0000 1.4
@@ -4,51 +4,56 @@
- insert into cp_package (cp_package_id) values (:scorm_course_id)
+ insert into cp_package
+ (cp_package_id)
+ values
+ (:scorm_course_id)
-
+
update cp_package
- set jsdata = :jsdata,
- xmldata = :xmldata,
- activitytree = :activity_tree,
- global_to_system = :global_to_system
- where cp_package_id = :scorm_course_id
+ set jsdata = :jsdata,
+ xmldata = :xmldata,
+ activitytree = :activity_tree,
+ global_to_system = :global_to_system
+ where cp_package_id = :scorm_course_id
insert into cp_node
- (cp_node_id, nodename, cp_package_id)
+ (cp_node_id, nodename, cp_package_id)
values
- (:cp_node_id, :nodename, :cp_package_id)
+ (:cp_node_id, :nodename, :cp_package_id)
insert into cp_tree
- (child, depth, cp_package_id, parent, rgt)
+ (child, depth, cp_package_id, parent, rgt)
values
- (:cp_node_id, :depth, :cp_package_id, :parent, '0')
+ (:cp_node_id, :depth, :cp_package_id, :parent, '0')
insert into cp_[string tolower ${nodename}]
- ([join $attributes ", "])
+ ([join $attributes ", "])
values
- (:[join $attributes ", :"])
+ (:[join $attributes ", :"])
- update cp_tree set rgt = :rgt where child = :cp_node_id
+ update cp_tree
+ set rgt = :rgt
+ where child = :cp_node_id