Update of /cvsroot/wtf-tracker/wtf/util
In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv5822/util
Modified Files:
email_notify.pl
Log Message:
Bug fix for 1644793: need to not send reminder emails to inactive user accounts
Index: email_notify.pl
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/util/email_notify.pl,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** email_notify.pl 18 Oct 2006 16:52:50 -0000 1.1.1.1
--- email_notify.pl 21 Mar 2007 17:37:55 -0000 1.2
***************
*** 41,45 ****
LEFT OUTER JOIN work AS w ON e.id = w.employee_id
LEFT OUTER JOIN notes AS n ON e.id = n.employee_id
! WHERE a.name = 'email_notify'
GROUP BY e.id
HAVING
--- 41,45 ----
LEFT OUTER JOIN work AS w ON e.id = w.employee_id
LEFT OUTER JOIN notes AS n ON e.id = n.employee_id
! WHERE a.name = 'email_notify' AND e.active = 1
GROUP BY e.id
HAVING
|
