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 -N
--- openacs-4/packages/chat-portlet/www/chat-portlet-oracle.xql	9 Nov 2008 23:29:23 -0000	1.2
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,49 +0,0 @@
-<?xml version="1.0"?>
-     
-<queryset>
-<rdbms><type>oracle</type><version>8.1.6</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>
-