Index: openacs-4/packages/acs-admin/www/users/one-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/users/one-oracle.xql	29 Apr 2001 00:47:48 -0000	1.1
+++ openacs-4/packages/acs-admin/www/users/one-oracle.xql	9 May 2001 22:32:25 -0000	1.2
@@ -3,6 +3,27 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+<fullquery name="user_info">      
+      <querytext>
+      select first_names, last_name, email, nvl(screen_name,'&lt none set up &gt') as screen_name, creation_date, creation_ip, last_visit, member_state, email_verified_p
+from cc_users
+where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="get_item_id">      
+      <querytext>
+      select live_revision as revision_id, nvl(title,'view this portrait') portrait_title
+from acs_rels a, cr_items c, cr_revisions cr 
+where a.object_id_two = c.item_id
+and c.live_revision = cr.revision_id
+and a.object_id_one = :user_id
+and a.rel_type = 'user_portrait_rel'
+      </querytext>
+</fullquery>
+
+ 
 <fullquery name="user_contributions">      
       <querytext>
       select at.pretty_name, at.pretty_plural, a.creation_date, acs_object.name(a.object_id) object_name