Index: openacs-4/packages/acs-subsite/www/shared/community-member-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/community-member-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/shared/community-member-oracle.xql	17 Dec 2004 16:13:13 -0000	1.1.2.1
@@ -0,0 +1,21 @@
+<?xml version="1.0"?>
+<queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<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
+  </querytext>
+</fullquery>
+
+<fullquery name="show_email_info">
+  <querytext>
+	select show_email from users where user_id = :user_id
+ </querytext>
+</fullquery>
+
+</queryset>