Index: openacs-4/packages/chat-portlet/www/chat-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat-portlet/www/chat-portlet-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/chat-portlet/www/chat-portlet-oracle.xql	14 Mar 2006 12:23:38 -0000	1.1
+++ openacs-4/packages/chat-portlet/www/chat-portlet-oracle.xql	9 Nov 2008 23:29:23 -0000	1.2
@@ -20,6 +20,7 @@
          acs_objects obj
     where rm.room_id = obj.object_id
           and obj.context_id IN ($sep_package_ids)
+          and rm.active_p = 't'
     order by rm.pretty_name
   </querytext>
 </fullquery>
@@ -39,7 +40,7 @@
                    where site_nodes.object_id = obj.context_id) as base_url
     from chat_rooms rm, 
          acs_objects obj
-    where rm.room_id = obj.object_id
+    where rm.room_id = obj.object_id and rm.active_p = 't'
     order by rm.pretty_name
   </querytext>
 </fullquery>