From fc65ed17843570b815d4f3d509aff658f2037dff Mon Sep 17 00:00:00 2001 From: "kiko%async.com.br" <> Date: Wed, 14 Jan 2004 21:59:15 +0000 Subject: Fix for bug 229800: whineatnews.pl doesn't whine about REOPENED bugs. Change whine script to look to REOPENED bugs too, and modified text in relevant param to account for this. Patch by joseph@picsel.com (Joseph Heenan). r=kiko, a=myk. --- whineatnews.pl | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'whineatnews.pl') diff --git a/whineatnews.pl b/whineatnews.pl index 330cf7cbd..da8d2a228 100755 --- a/whineatnews.pl +++ b/whineatnews.pl @@ -19,12 +19,13 @@ # Rights Reserved. # # Contributor(s): Terry Weissman +# Joseph Heenan # This is a script suitable for running once a day from a cron job. It # looks at all the bugs, and sends whiny mail to anyone who has a bug -# assigned to them that has status NEW that has not been touched for -# more than 7 days. +# assigned to them that has status NEW or REOPENED that has not been +# touched for more than 7 days. use strict; @@ -33,8 +34,9 @@ require "globals.pl"; ConnectToDatabase(); SendSQL("select bug_id,short_desc,login_name from bugs,profiles where " . - "bug_status = 'NEW' and to_days(now()) - to_days(delta_ts) > " . - Param('whinedays') . " and userid=assigned_to order by bug_id"); + "(bug_status = 'NEW' or bug_status = 'REOPENED') and " . + "to_days(now()) - to_days(delta_ts) > " . Param('whinedays') . + " and userid=assigned_to order by bug_id"); my %bugs; my %desc; -- cgit v1.2.3-24-g4f1b