Index: openacs-4/packages/lorsm/tcl/lorsm-callback-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/tcl/lorsm-callback-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/lorsm/tcl/lorsm-callback-procs.xql 7 Jun 2006 14:05:44 -0000 1.2
+++ openacs-4/packages/lorsm/tcl/lorsm-callback-procs.xql 12 Dec 2008 14:25:33 -0000 1.3
@@ -1,36 +1,46 @@
-
-
- select track_id from
- lorsm_student_track
- where user_id = :user_id
-
-
+
+
+ select track_id from
+ lorsm_student_track
+ where user_id = :user_id
+
+
-
-
- select community_id
- from lorsm_student_bookmark
- where user_id = :user_id
-
-
-
-
-
- update lorsm_student_track
- set user_id = :to_user_id
- where user_id = :from_user_id
-
-
-
-
-
- update lorsm_student_bookmark
- set user_id = :to_user_id
- where user_id = :from_user_id
-
-
-
-
\ No newline at end of file
+
+
+ select community_id
+ from lorsm_student_bookmark
+ where user_id = :user_id
+
+
+
+
+
+ update lorsm_student_track
+ set user_id = :to_user_id
+ where user_id = :from_user_id
+
+
+
+
+
+ update lorsm_student_bookmark
+ set user_id = :to_user_id
+ where user_id = :from_user_id
+
+
+
+
+
+ select count(1) as result
+ from ( select distinct l.course_id
+ from lorsm_student_track l
+ where l.community_id=:comm_id
+ group by l.course_id) as t
+
+
+
+