Index: openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql,v
diff -u -r1.3 -r1.3.4.1
--- openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql	28 Aug 2003 09:41:42 -0000	1.3
+++ openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql	17 Dec 2004 16:13:13 -0000	1.3.4.1
@@ -4,12 +4,18 @@
 
 <fullquery name="dbqd.acs-subsite.www.shared.community-member.user_contributions">
   <querytext>
-select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) as object_name
-from acs_objects a, acs_object_types at
-where a.object_type = at.object_type
-and a.creation_user = :user_id
-order by at.pretty_name, creation_date desc
+	select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) as object_name
+	from acs_objects a, acs_object_types at
+	where a.object_type = at.object_type
+	and a.creation_user = :user_id
+	order by at.pretty_name, creation_date desc
   </querytext>
 </fullquery>
 
+<fullquery name="show_email_info">
+  <querytext>
+	select show_email from users where user_id = :user_id
+ </querytext>
+</fullquery>
+
 </queryset>