Index: openacs-4/packages/chat/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/chat/www/index-postgresql.xql	24 Jun 2006 14:23:42 -0000	1.2
+++ openacs-4/packages/chat/www/index-postgresql.xql	7 Jun 2007 09:14:25 -0000	1.3
@@ -11,6 +11,9 @@
            rm.moderated_p, 
            rm.active_p, 
            rm.archive_p,
+           rm.open as open,
+           rm.private as private,
+           rm.comm_name as community,
            acs_permission__permission_p(room_id, :user_id, 'chat_room_admin') as admin_p,
            acs_permission__permission_p(room_id, :user_id, 'chat_read') as user_p,           
            (select site_node__url(site_nodes.node_id)
@@ -24,5 +27,28 @@
   </querytext>
 </fullquery>
 
+<fullquery name="rooms_list2">     
+  <querytext>
+    select distinct rm.room_id as room_id, 
+           rm.pretty_name, 
+           rm.description, 
+           rm.moderated_p, 
+           rm.active_p, 
+           rm.archive_p,
+           rm.private as private,
+           rm.open as open,
+           rm.comm_name as community,
+           acs_permission__permission_p(room_id, :user_id, 'chat_room_admin') as admin_p,
+           acs_permission__permission_p(room_id, :user_id, 'chat_read') as user_p,           
+           (select site_node__url(site_nodes.node_id)
+                   from site_nodes
+                   where site_nodes.object_id = obj.context_id) as base_url
+    from chat_rooms rm, 
+         acs_objects obj,dotlrn_communities_all as dot
+    where rm.room_id = obj.object_id     
+    order by rm.pretty_name
+  </querytext>
+</fullquery>
+
 </queryset>