Index: openacs-4/packages/assessment/lib/session.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/assessment/lib/session.xql	26 Sep 2006 04:08:36 -0000	1.4
+++ openacs-4/packages/assessment/lib/session.xql	1 Dec 2008 16:57:02 -0000	1.5
@@ -41,4 +41,20 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_session_score">
+    <querytext>
+        select sum(coalesce(points,0))
+        from as_item_data
+        where session_id=:session_id
+    </querytext>
+</fullquery>
+
+<fullquery name="get_max_points">
+     <querytext>
+        select sum(coalesce(i.points,0))
+        from as_items i, as_item_data d
+        where d.session_id = :session_id and i.as_item_id = d.as_item_id
+     </querytext>
+</fullquery>
+   
 </queryset>