Index: openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql,v diff -u -r1.15 -r1.16 --- openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql 27 Oct 2014 16:39:40 -0000 1.15 +++ openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql 20 Nov 2017 13:26:55 -0000 1.16 @@ -50,25 +50,6 @@ - - - - update acs_mail_lite_mail_log - set last_mail_date = sysdate - where party_id = :user_id - - - - - - - - insert into acs_mail_lite_mail_log (party_id, last_mail_date) - values (:user_id, sysdate) - - - - select Index: openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql,v diff -u -r1.14 -r1.15 --- openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql 27 Oct 2014 16:39:41 -0000 1.14 +++ openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql 20 Nov 2017 13:26:55 -0000 1.15 @@ -50,26 +50,6 @@ - - - - - update acs_mail_lite_mail_log - set last_mail_date = current_timestamp - where party_id = :user_id - - - - - - - - insert into acs_mail_lite_mail_log (party_id, last_mail_date) - values (:user_id, current_timestamp) - - - - select Index: openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs.xql,v diff -u -r1.17 -r1.18 --- openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs.xql 9 Jan 2008 16:51:30 -0000 1.17 +++ openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs.xql 20 Nov 2017 13:26:55 -0000 1.18 @@ -9,12 +9,11 @@ where email = :email and party_id = person_id order by party_id desc - limit 1 + fetch first 1 row only - select message_id as id @@ -48,4 +47,23 @@ + + + + update acs_mail_lite_mail_log + set last_mail_date = current_timestamp + where party_id = :user_id + + + + + + + + insert into acs_mail_lite_mail_log (party_id, last_mail_date) + values (:user_id, current_timestamp) + + + +