Index: openacs-4/contrib/obsolete-packages/bboard/www/forum.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/www/forum.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/bboard/www/forum.xql	29 Jun 2001 20:37:18 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/bboard/www/forum.xql	1 Dec 2001 22:25:58 -0000	1.2
@@ -5,9 +5,11 @@
       <querytext>
       
 	select count(*) as uncategorized_count
-            from bboard_messages_by_category b
-	    where category_id is null
-              and forum_id = :forum_id
+            from bboard_forum_message_map msg
+	    where forum_id = :forum_id
+              and not exists (select 1
+                              from bboard_category_message_map cat
+                              where msg.message_id = cat.message_id)
     
       </querytext>
 </fullquery>
@@ -17,10 +19,13 @@
       <querytext>
       
 	select count(*) as uncategorized_count
-            from bboard_messages_by_category b
-	    where category_id is null
-              and forum_id = :forum_id
-
+            from bboard_forum_message_map msg
+	    where forum_id = :forum_id
+              and status = 'approved'
+              and not exists (select 1
+                              from bboard_category_message_map cat
+                              where msg.message_id = cat.message_id)
+    
       </querytext>
 </fullquery>