Index: openacs-4/packages/acs-tcl/tcl/security-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/security-procs.xql,v diff -u -N -r1.10 -r1.10.2.1 --- openacs-4/packages/acs-tcl/tcl/security-procs.xql 20 Nov 2017 15:36:44 -0000 1.10 +++ openacs-4/packages/acs-tcl/tcl/security-procs.xql 8 Jan 2020 17:24:47 -0000 1.10.2.1 @@ -1,55 +1,55 @@ - + update users set second_to_last_visit = last_visit, last_visit = current_timestamp, n_sessions = n_sessions + 1 where user_id = :user_id - + - - + + - + delete from sec_session_properties where last_hit < :expires - + - - + + select password, salt from users where user_id = :user_id - - + + - + select property_value, secure_p from sec_session_properties where session_id = :id and module = :module and property_name = :name - + - + select token from secret_tokens where token_id = :token_id - - + + insert into sec_session_properties (session_id, module, property_name, secure_p, last_hit) @@ -72,10 +72,10 @@ - + - update users - set password = :new_password, + update users + set password = :new_password, salt = :salt, password_changed_date = current_timestamp where user_id = :user_id