Index: openacs-4/packages/dotlrn/www/dotlrn-main-portlet.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/dotlrn-main-portlet.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/dotlrn/www/dotlrn-main-portlet.xql	4 Mar 2002 23:54:00 -0000	1.3
+++ openacs-4/packages/dotlrn/www/dotlrn-main-portlet.xql	16 Mar 2002 02:02:07 -0000	1.4
@@ -8,9 +8,9 @@
              dotlrn_class_instances_full.url,
              acs_permission.permission_p(community_id, :user_id, 'admin') as admin_p
       from dotlrn_class_instances_full,
-           dotlrn_member_rels_full
-      where dotlrn_member_rels_full.user_id = :user_id
-      and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id
+           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
     </querytext>
   </fullquery>
 
@@ -21,9 +21,9 @@
              dotlrn_clubs_full.url,
              acs_permission.permission_p(community_id, :user_id, 'admin') as admin_p
       from dotlrn_clubs_full,
-           dotlrn_member_rels_full
-      where dotlrn_member_rels_full.user_id = :user_id
-      and dotlrn_member_rels_full.community_id = dotlrn_clubs_full.club_id
+           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
     </querytext>
   </fullquery>
 </queryset>