Index: openacs-4/packages/acs-subsite/lib/home.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/lib/Attic/home.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/lib/home.xql 29 Aug 2007 13:44:37 -0000 1.1 +++ openacs-4/packages/acs-subsite/lib/home.xql 7 Aug 2017 23:47:57 -0000 1.2 @@ -1,53 +1,19 @@ - - - - select first_names, last_name, email, url, screen_name - from cc_users - where user_id=:user_id - - - - - + -select attr_value -from acs_attribute_values -where object_id = :user_id -and attribute_id = - (select attribute_id - from acs_attributes - where object_type = 'person' - and attribute_name = 'bio') - - - - - - - select cr.publish_date, cr.title as portrait_title, cr.description as portrait_description from cr_revisions cr, cr_items ci, acs_rels a where cr.revision_id = ci.live_revision - and ci.item_id = a.object_id_two + and ci.item_id = a.object_id_two and a.object_id_one = :user_id and a.rel_type = 'user_portrait_rel' - - - select email - from cc_users - where user_iad=:user_id - - - -