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.4 -r1.5
--- openacs-4/packages/chat/www/index-postgresql.xql	24 Jun 2007 15:21:19 -0000	1.4
+++ openacs-4/packages/chat/www/index-postgresql.xql	19 Nov 2007 01:14:16 -0000	1.5
@@ -11,9 +11,6 @@
            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)
@@ -27,28 +24,5 @@
   </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
-    where rm.room_id = obj.object_id     
-    order by rm.pretty_name
-  </querytext>
-</fullquery>
-
 </queryset>