# HG changeset patch # User bsw # Date 1340892525 -7200 # Node ID d3d7a01624f61da8c82b3eadf89e1587b057f137 # Parent 344e5fdce8c9b9a3e2be5db904f264db61729297 Forbid sending of notifications for events more than 3 days in future or past instead of 7 days diff -r 344e5fdce8c9 -r d3d7a01624f6 model/event.lua --- a/model/event.lua Thu Jun 28 13:52:42 2012 +0200 +++ b/model/event.lua Thu Jun 28 16:08:45 2012 +0200 @@ -66,8 +66,8 @@ local members_to_notify = Member:new_selector() :join("event_seen_by_member", nil, { "event_seen_by_member.seen_by_member_id = member.id AND event_seen_by_member.notify_level <= member.notify_level AND event_seen_by_member.id = ?", self.id } ) :add_where("member.activated NOTNULL AND member.notify_email NOTNULL") - -- SAFETY FIRST, NEVER send notifications for events more then 7 days in past or future - :add_where("now() - event_seen_by_member.occurrence BETWEEN '-7 days'::interval AND '7 days'::interval") + -- 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") :exec() print (_("Event #{id} -> #{num} members", { id = self.id, num = #members_to_notify }))