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.1 -r1.2
--- openacs-4/packages/acs-admin/www/users/one.xql 27 Apr 2001 01:41:12 -0000 1.1
+++ openacs-4/packages/acs-admin/www/users/one.xql 28 Apr 2001 19:58:38 -0000 1.2
@@ -3,32 +3,36 @@
- select first_names, last_name, email, coalesce(screen_name,'< none set up >') 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,'< none set up >') as screen_name,
+ creation_date, creation_ip, last_visit, member_state, email_verified_p
+ from cc_users
+ where user_id = :user_id
- 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'
- 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