Index: openacs-4/packages/forums/lib/user/post-history-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/user/post-history-chunk.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/forums/lib/user/post-history-chunk.xql	17 Dec 2003 15:45:30 -0000	1.1
+++ openacs-4/packages/forums/lib/user/post-history-chunk.xql	11 Apr 2005 10:38:59 -0000	1.1.2.1
@@ -34,5 +34,15 @@
                      forums_messages.posting_date desc
         </querytext>
     </fullquery>
+    
+    <fullquery name="select_num_post">
+        <querytext>
+            select count(user_id) as num_msg, to_char(max(last_child_post), 'YYYY-MM-DD HH24:MI:SS') as last_post, forums_forums.name, forums_forums.forum_id
+            from forums_messages, forums_forums
+            where forums_messages.user_id = :user_id and forums_forums.forum_id = forums_messages.forum_id and package_id = :package_id
+            group by forums_forums.name, forums_forums.forum_id  
+	    order by forums_forums.name asc
+        </querytext>
+    </fullquery>
 
 </queryset>