Index: openacs-4/packages/chat/tcl/chat-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/chat-procs-oracle.xql,v
diff -u -N -r1.2 -r1.2.8.1
--- openacs-4/packages/chat/tcl/chat-procs-oracle.xql	24 Jun 2006 14:23:41 -0000	1.2
+++ openacs-4/packages/chat/tcl/chat-procs-oracle.xql	2 Jul 2016 10:41:20 -0000	1.2.8.1
@@ -51,15 +51,6 @@
       </querytext>
 </fullquery>
 
- <fullquery name="chat_user_name.get_chat_user_name">
-      <querytext>
-       begin
-	    :1 := person.name(:user_id);
-	end;
-      </querytext>
-</fullquery>
-
-
 <fullquery name="chat_user_grant.grant_user">
       <querytext>
        begin
@@ -226,4 +217,4 @@
       </querytext>
 </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>
Index: openacs-4/packages/chat/tcl/chat-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/tcl/chat-procs-postgresql.xql,v
diff -u -N -r1.6 -r1.6.6.1
--- openacs-4/packages/chat/tcl/chat-procs-postgresql.xql	19 Nov 2007 01:14:16 -0000	1.6
+++ openacs-4/packages/chat/tcl/chat-procs-postgresql.xql	2 Jul 2016 10:41:20 -0000	1.6.6.1
@@ -49,13 +49,6 @@
 </fullquery>
 
 
- <fullquery name="chat_user_name.get_chat_user_name">
-      <querytext>
-          select person__name(:user_id);
-      </querytext>
-</fullquery>
-
-
  <fullquery name="chat_user_grant.grant_user">
       <querytext>
          begin
Index: openacs-4/packages/chat/www/chat-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/chat-oracle.xql,v
diff -u -N
--- openacs-4/packages/chat/www/chat-oracle.xql	24 Jun 2006 14:23:41 -0000	1.2
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,19 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="select_msg_items">
-  <querytext>
-	select to_char(creation_date, 'DD.MM.YYYY HH24:MI:SS') as creation_date_pretty, 
-	       creation_user, 
-	       msg
-    from chat_msgs 
-    where room_id  = :room_id 
-      and rownum <= 20 
-    order by creation_date desc
-  </querytext>
-</fullquery>
-
-</queryset>
-
Index: openacs-4/packages/chat/www/chat-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/chat-postgresql.xql,v
diff -u -N
--- openacs-4/packages/chat/www/chat-postgresql.xql	24 Jun 2006 14:23:41 -0000	1.2
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,19 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-<rdbms><type>postgresql</type><version>7.1</version></rdbms>
-
-<fullquery name="select_msg_items">
-  <querytext>
-	select to_char(creation_date, 'DD.MM.YYYY hh24:mi:ss') as creation_date_pretty, 
-	       creation_user, 
-	       msg
-    from chat_msgs 
-    where room_id  = :room_id 
-    order by creation_date desc
-    limit 20 
-  </querytext>
-</fullquery>
-
-</queryset>
-
Index: openacs-4/packages/chat/www/room-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/room-oracle.xql,v
diff -u -N -r1.2 -r1.2.8.1
--- openacs-4/packages/chat/www/room-oracle.xql	24 Jun 2006 14:23:42 -0000	1.2
+++ openacs-4/packages/chat/www/room-oracle.xql	2 Jul 2016 10:41:20 -0000	1.2.8.1
@@ -2,26 +2,6 @@
 <queryset>
 <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-
-<fullquery name="list_moderators">
-  <querytext>
-    select party_id, acs_object.name(party_id) as name
-    from acs_object_party_privilege_map
-    where object_id = :room_id
-    and privilege = 'chat_room_moderate'
-  </querytext>
-</fullquery>
-
-<fullquery name="list_user_allow">
-  <querytext>
-    select distinct party_id, acs_object.name(party_id) as name
-    from acs_object_party_privilege_map
-    where object_id = :room_id
-    and (privilege = 'chat_read' or privilege = 'chat_write')
- </querytext>
-</fullquery>
-
-
 <fullquery name="list_user_ban">
   <querytext>
    select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email
Index: openacs-4/packages/chat/www/room-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/room-postgresql.xql,v
diff -u -N -r1.2 -r1.2.8.1
--- openacs-4/packages/chat/www/room-postgresql.xql	24 Jun 2006 14:23:42 -0000	1.2
+++ openacs-4/packages/chat/www/room-postgresql.xql	2 Jul 2016 10:41:20 -0000	1.2.8.1
@@ -2,24 +2,6 @@
 <queryset>
 <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="list_moderators">
-  <querytext>
-    select party_id, acs_object__name(party_id) as name
-    from acs_object_party_privilege_map
-    where object_id = :room_id
-    and privilege = 'chat_room_moderate'
-  </querytext>
-</fullquery>
-
-<fullquery name="list_user_allow">
-  <querytext>
-    select distinct party_id, acs_object__name(party_id) as name
-    from acs_object_party_privilege_map
-    where object_id = :room_id
-    and (privilege = 'chat_read' or privilege = 'chat_write')
- </querytext>
-</fullquery>
-
 <fullquery name="list_user_ban">
   <querytext>
    select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email