Index: openacs-4/packages/chat-portlet/www/chat-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat-portlet/www/chat-portlet-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/chat-portlet/www/chat-portlet-postgresql.xql	1 Oct 2018 17:56:56 -0000	1.6
@@ -0,0 +1,49 @@
+<?xml version="1.0"?>
+     
+<queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="rooms_list">
+  <querytext>
+    select rm.room_id, 
+           rm.pretty_name as pretty_name, 
+           rm.description as description, 
+           rm.moderated_p, 
+           rm.active_p, 
+           rm.archive_p,
+           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
+          and obj.context_id IN ($sep_package_ids)
+          and rm.active_p = 't'
+    order by rm.pretty_name
+  </querytext>
+</fullquery>
+
+<fullquery name="rooms_list_all">
+  <querytext>
+    select rm.room_id, 
+           rm.pretty_name as pretty_name, 
+           rm.description as description, 
+           rm.moderated_p, 
+           rm.active_p, 
+           rm.archive_p,
+           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 and rm.active_p = 't'
+    order by rm.pretty_name
+  </querytext>
+</fullquery>
+
+</queryset>
+