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.8 -r1.9 --- openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs.xql 10 Nov 2005 15:00:56 -0000 1.8 +++ openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs.xql 29 Nov 2005 11:28:26 -0000 1.9 @@ -29,15 +29,15 @@ update acs_mail_lite_mail_log set last_mail_date = sysdate - where user_id = :user_id + where party_id = :user_id - insert into acs_mail_lite_mail_log (user_id, last_mail_date) + insert into acs_mail_lite_mail_log (party_id, last_mail_date) values (:user_id, sysdate) @@ -48,15 +48,15 @@ update acs_mail_lite_bounce set bounce_count = bounce_count + 1 - where user_id = :user_id + where party_id = :user_id - insert into acs_mail_lite_bounce (user_id, bounce_count) + insert into acs_mail_lite_bounce (party_id, bounce_count) values (:user_id, 1) @@ -66,7 +66,7 @@ delete from acs_mail_lite_bounce - where user_id in (select user_id + where party_id in (select party_id from acs_mail_lite_mail_log where last_mail_date < sysdate - :max_days_to_bounce) @@ -78,7 +78,7 @@ update users set email_bouncing_p = 't' - where user_id in (select user_id + where user_id in (select party_id from acs_mail_lite_bounce where bounce_count >= :max_bounce_count)