Index: openacs-4/packages/acs-tcl/tcl/community-core-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs.xql,v diff -u -r1.31 -r1.32 --- openacs-4/packages/acs-tcl/tcl/community-core-procs.xql 28 May 2018 12:29:03 -0000 1.31 +++ openacs-4/packages/acs-tcl/tcl/community-core-procs.xql 26 Jun 2018 13:45:52 -0000 1.32 @@ -83,7 +83,7 @@ - + select party_id @@ -111,41 +111,4 @@ - - - - - select user_id, - username, - authority_id, - first_names, - last_name, - first_names || ' ' || last_name as name, - email, - url, - screen_name, - priv_name, - priv_email, - email_verified_p, - email_bouncing_p, - no_alerts_until, - last_visit, - to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, - second_to_last_visit, - to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, - n_sessions, - password_question, - password_answer, - password_changed_date, - member_state, - rel_id, - extract(day from current_timestamp - password_changed_date) as password_age_days, - creation_date, - creation_ip - from cc_users - where user_id = :user_id - - - -