Index: openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql 7 Aug 2017 23:47:59 -0000 1.8 +++ openacs-4/packages/acs-tcl/tcl/security-procs-oracle.xql 20 Nov 2017 15:36:44 -0000 1.9 @@ -3,19 +3,6 @@ oracle8.1.6 - - - - update users - set second_to_last_visit = last_visit, - last_visit = sysdate, - n_sessions = n_sessions + 1 - where user_id = :user_id - - - - - @@ -73,15 +60,4 @@ - - - - update users - set password = :new_password, - salt = :salt, - password_changed_date = sysdate - where user_id = :user_id - - - Index: openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql,v diff -u -r1.13 -r1.14 --- openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql 7 Aug 2017 23:47:59 -0000 1.13 +++ openacs-4/packages/acs-tcl/tcl/security-procs-postgresql.xql 20 Nov 2017 15:36:44 -0000 1.14 @@ -19,22 +19,8 @@ select sec_session_property__upsert(:session_id, :module, :name, :value, :secure, :last_hit) from dual - - + - - - - update users - set second_to_last_visit = last_visit, - last_visit = now(), - n_sessions = n_sessions + 1 - where user_id = :user_id - - - - - @@ -55,16 +41,5 @@ - - - - update users - set password = :new_password, - salt = :salt, - password_changed_date = current_timestamp - where user_id = :user_id - - - 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 -r1.9 -r1.10 --- openacs-4/packages/acs-tcl/tcl/security-procs.xql 28 Jun 2015 19:05:43 -0000 1.9 +++ openacs-4/packages/acs-tcl/tcl/security-procs.xql 20 Nov 2017 15:36:44 -0000 1.10 @@ -1,6 +1,19 @@ + + + + update users + set second_to_last_visit = last_visit, + last_visit = current_timestamp, + n_sessions = n_sessions + 1 + where user_id = :user_id + + + + + @@ -59,5 +72,14 @@ + + + update users + set password = :new_password, + salt = :salt, + password_changed_date = current_timestamp + where user_id = :user_id + +