Index: openacs-4/packages/dotlrn/www/admin/user-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/user-oracle.xql,v
diff -u -N -r1.12 -r1.13
--- openacs-4/packages/dotlrn/www/admin/user-oracle.xql	29 Jun 2004 10:18:06 -0000	1.12
+++ openacs-4/packages/dotlrn/www/admin/user-oracle.xql	23 Nov 2017 09:39:47 -0000	1.13
@@ -3,61 +3,6 @@
 <queryset>
     <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-    <fullquery name="select_dotlrn_user_info">
-        <querytext>
-            select dotlrn_users.*, guest_p
-            from dotlrn_users, dotlrn_guest_status
-            where dotlrn_users.user_id = :user_id
-              and dotlrn_guest_status.user_id(+) = dotlrn_users.user_id
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_portrait_info">      
-        <querytext>
-            select cr_items.live_revision as revision_id,
-                   nvl(cr_revisions.title, 'view this portrait') as portrait_title
-            from acs_rels,
-                 cr_items,
-                 cr_revisions
-            where acs_rels.object_id_two = cr_items.item_id
-            and cr_items.live_revision = cr_revisions.revision_id
-            and acs_rels.object_id_one = :user_id
-            and acs_rels.rel_type = 'user_portrait_rel'
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_member_classes">
-        <querytext>
-            select dotlrn_class_instances_full.*,
-                   dotlrn_member_rels_approved.rel_type,
-                   dotlrn_member_rels_approved.role,
-                   '' as role_pretty_name
-            from dotlrn_class_instances_full,
-                 dotlrn_member_rels_approved
-            where dotlrn_member_rels_approved.user_id = :user_id
-            and dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id
-            order by dotlrn_class_instances_full.department_name,
-                     dotlrn_class_instances_full.department_key,
-                     dotlrn_class_instances_full.pretty_name,
-                     dotlrn_class_instances_full.community_key
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_member_clubs">
-        <querytext>
-            select dotlrn_clubs_full.*,
-                   dotlrn_member_rels_approved.rel_type,
-                   dotlrn_member_rels_approved.role,
-                   '' as role_pretty_name
-            from dotlrn_clubs_full,
-                 dotlrn_member_rels_approved
-            where dotlrn_member_rels_approved.user_id = :user_id
-            and dotlrn_member_rels_approved.community_id = dotlrn_clubs_full.club_id
-            order by dotlrn_clubs_full.pretty_name,
-                     dotlrn_clubs_full.community_key
-        </querytext>
-    </fullquery>
-
     <fullquery name="select_member_subgroups">
         <querytext>
             select dotlrn_communities.*,