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 -r1.1 -r1.2
--- openacs-4/packages/chat/www/room-oracle.xql	14 Mar 2006 12:16:09 -0000	1.1
+++ openacs-4/packages/chat/www/room-oracle.xql	24 Jun 2006 14:23:42 -0000	1.2
@@ -24,22 +24,14 @@
 
 <fullquery name="list_user_ban">
   <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_ban'
+   select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email
+    from acs_object_party_privilege_map m, persons p, parties pa
+    where m.party_id = p.person_id and m.object_id = :room_id
+    and m.privilege = 'chat_ban' and p.person_id = pa.party_id
+    order by p.last_name, p.first_names
   </querytext>
 </fullquery>
 
-
-<fullquery name="list_transcripts">
-  <querytext>
-   select transcript_id, pretty_name
-    from chat_transcripts
-    where room_id = :room_id
- </querytext>
-</fullquery>
-
 </queryset>