# HG changeset patch
# User bsw
# Date 1345226723 -7200
# Node ID 3f0e418875517526df29fe317bda110dcbbd0c1d
# Parent  a7f97f535d7eeec715389416be583795f60634d4
Do not notify a member about events caused by the member him/herself

diff -r a7f97f535d7e -r 3f0e41887551 model/event.lua
--- a/model/event.lua	Fri Aug 17 20:00:03 2012 +0200
+++ b/model/event.lua	Fri Aug 17 20:05:23 2012 +0200
@@ -68,6 +68,8 @@
     :add_where("member.activated NOTNULL AND member.notify_email NOTNULL")
     -- SAFETY FIRST, NEVER send notifications for events more then 3 days in past or future
     :add_where("now() - event_seen_by_member.occurrence BETWEEN '-3 days'::interval AND '3 days'::interval")
+    -- do not notify a member about the events caused by the member
+    :add_where("event_seen_by_member.member_id ISNULL OR event_seen_by_member.member_id != member.id")
     :exec()
     
   print (_("Event #{id} -> #{num} members", { id = self.id, num = #members_to_notify }))