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.2 -r1.3 --- 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 7 Aug 2017 23:48:07 -0000 1.3 @@ -2,26 +2,6 @@ oracle8.1.6 - - - - 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' - - - - - - 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') - - - - select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email