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
+
+