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.8 -r1.9
--- openacs-4/packages/acs-tcl/tcl/community-core-procs.xql	8 Sep 2003 16:06:15 -0000	1.8
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs.xql	19 Sep 2003 16:13:25 -0000	1.9
@@ -97,69 +97,6 @@
 </fullquery>
 
  
-<fullquery name="acs_user::get.select_user_info_from_user_id">      
-      <querytext>
-
-          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,
-                 second_to_last_visit,
-                 n_sessions,
-                 password_question,
-                 password_answer,
-                 password_changed_date,
-                 member_state,
-                 rel_id
-          from   cc_users 
-          where  user_id = :user_id
-
-      </querytext>
-</fullquery>
- 
-<fullquery name="acs_user::get.select_user_info_from_username">
-      <querytext>
-
-          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,
-                 second_to_last_visit,
-                 n_sessions,
-                 password_question,
-                 password_answer,
-                 password_changed_date,
-                 member_state,
-                 rel_id
-          from   cc_users 
-          where  authority_id = :authority_id
-          and    username = :username
-
-      </querytext>
-</fullquery>
- 
 <fullquery name="acs_user::update.user_update">      
       <querytext>