Index: openacs-4/packages/acs-admin/www/users/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/one-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/users/one-postgresql.xql	29 Apr 2001 00:47:48 -0000	1.1
+++ openacs-4/packages/acs-admin/www/users/one-postgresql.xql	29 Apr 2001 01:28:46 -0000	1.2
@@ -5,11 +5,12 @@
 
 <fullquery name="user_contributions">      
       <querytext>
-      select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) 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 object_name, creation_date
+      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 object_name, creation_date
       </querytext>
 </fullquery>
 
Index: openacs-4/packages/acs-admin/www/users/one.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-admin/www/users/one.xql	29 Apr 2001 00:47:48 -0000	1.4
+++ openacs-4/packages/acs-admin/www/users/one.xql	29 Apr 2001 01:28:46 -0000	1.5
@@ -3,21 +3,24 @@
 
 <fullquery name="user_info">      
       <querytext>
-      select first_names, last_name, email, coalesce(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
+      select first_names, last_name, email,
+          coalesce(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, coalesce(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'
+      select live_revision as revision_id,
+          coalesce(title,'view this portrait') as 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>