1.1 --- a/model/event.lua	Fri Jun 22 16:31:07 2012 +0200
     1.2 +++ b/model/event.lua	Fri Jun 22 17:05:54 2012 +0200
     1.3 @@ -53,11 +53,13 @@
     1.4    })[self.state]
     1.5  end
     1.6    
     1.7 -function Event.object:send_notification() 
     1.8 -
     1.9 +function Event.object:send_notification()
    1.10 +  
    1.11    local members_to_notify = Member:new_selector()
    1.12      :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 } )
    1.13      :add_where("member.activated NOTNULL AND member.notify_email NOTNULL")
    1.14 +    -- SAFETY FIRST, NEVER send notifications for events more then 7 days in past or future
    1.15 +    :add_where("now() - event_seen_by_member.occurrence BETWEEN '-7 days'::interval AND '7 days'::interval")
    1.16      :exec()
    1.17      
    1.18    print (_("Event #{id} -> #{num} members", { id = self.id, num = #members_to_notify }))