Index: openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql	18 Feb 2002 16:50:43 -0000	1.5
+++ openacs-4/packages/dotlrn/www/communities-chunk-oracle.xql	16 Mar 2002 02:02:07 -0000	1.6
@@ -1,14 +1,14 @@
 <?xml version="1.0"?>
 
 <queryset>
-  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-  <fullquery name="select_all_communities_count">
-    <querytext>
-      select count(*)
-      from dotlrn_communities_not_closed dotlrn_communities
-    </querytext>
-  </fullquery>
+    <fullquery name="select_all_communities_count">
+        <querytext>
+            select count(*)
+            from dotlrn_communities_not_closed dotlrn_communities
+        </querytext>
+    </fullquery>
 
   <fullquery name="select_current_memberships">
     <querytext>
@@ -26,9 +26,9 @@
               start with community_type = dotlrn_communities.community_type
               connect by community_type = prior supertype) as root_community_type
       from dotlrn_active_communities dotlrn_communities,
-           dotlrn_member_rels_full
-      where dotlrn_member_rels_full.user_id = :user_id
-      and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id
+           dotlrn_member_rels_approved
+      where dotlrn_member_rels_approved.user_id = :user_id
+      and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id
       order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name
     </querytext>
   </fullquery>
@@ -49,9 +49,9 @@
               start with community_type = dotlrn_communities.community_type
               connect by community_type = prior supertype) as root_community_type
       from dotlrn_communities dotlrn_communities,
-           dotlrn_member_rels_full
-      where dotlrn_member_rels_full.user_id = :user_id
-      and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id
+           dotlrn_member_rels_approved
+      where dotlrn_member_rels_approved.user_id = :user_id
+      and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id
       order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name
     </querytext>
   </fullquery>
@@ -129,9 +129,9 @@
               start with community_type = dotlrn_communities.community_type
               connect by community_type = prior supertype) as root_community_type
       from dotlrn_active_communities dotlrn_communities,
-           dotlrn_member_rels_full
-      where dotlrn_member_rels_full.user_id = :user_id
-      and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id
+           dotlrn_member_rels_approved
+      where dotlrn_member_rels_approved.user_id = :user_id
+      and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id
       and dotlrn_communities.community_type = :community_type
       order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name
     </querytext>
@@ -153,9 +153,9 @@
               start with community_type = dotlrn_communities.community_type
               connect by community_type = prior supertype) as root_community_type
       from dotlrn_communities dotlrn_communities,
-           dotlrn_member_rels_full
-      where dotlrn_member_rels_full.user_id = :user_id
-      and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id
+           dotlrn_member_rels_approved
+      where dotlrn_member_rels_approved.user_id = :user_id
+      and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id
       and dotlrn_communities.community_type = :community_type
       order by root_community_type, dotlrn_communities.community_type, dotlrn_communities.pretty_name
     </querytext>