diff options
| author |   justdave%syndicomm.com <> | 2003-02-12 16:21:39 +0000 |
|---|---|---|
| committer | justdave%syndicomm.com <> | 2003-02-12 16:21:39 +0000 |
| commit | 6f1cb53a2d3d74f2dd29334879ca66eb0fe91ec6 (patch) | |
| tree | 09b77a0f5d73de7e4bb16132cfb5bf1d9a057807 /whineatnews.pl | |
| parent | Give all FAQ questions an id so the anchor name doesn't have to be randomly g... (diff) | |
| download | bugzilla-6f1cb53a2d3d74f2dd29334879ca66eb0fe91ec6.tar.gz bugzilla-6f1cb53a2d3d74f2dd29334879ca66eb0fe91ec6.tar.bz2 bugzilla-6f1cb53a2d3d74f2dd29334879ca66eb0fe91ec6.zip | |
Bug 58020: include bug summaries in whinemail.
Patch by pbaker@where2getit.com (Paul Baker)
r= jouni, a= justdave
Diffstat (limited to 'whineatnews.pl')
| -rwxr-xr-x | whineatnews.pl | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/whineatnews.pl b/whineatnews.pl index 2a3bdf1b9..a0a30205e 100755 --- a/whineatnews.pl +++ b/whineatnews.pl @@ -32,19 +32,24 @@ require "globals.pl"; ConnectToDatabase(); -SendSQL("select bug_id,login_name from bugs,profiles where " . +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"); my %bugs; +my %desc; my @row; while (@row = FetchSQLData()) { - my ($id, $email) = (@row); + my ($id, $desc, $email) = (@row); if (!defined $bugs{$email}) { $bugs{$email} = []; } + if (!defined $desc{$email}) { + $desc{$email} = []; + } push @{$bugs{$email}}, $id; + push @{$desc{$email}}, $desc; } @@ -59,7 +64,8 @@ foreach my $email (sort (keys %bugs)) { my $msg = PerformSubsts($template, \%substs); foreach my $i (@{$bugs{$email}}) { - $msg .= " ${urlbase}show_bug.cgi?id=$i\n" + $msg .= " " . shift(@{$desc{$email}}) . "\n"; + $msg .= " -> ${urlbase}show_bug.cgi?id=$i\n"; } my $sendmailparam = Param('sendmailnow') ? '' : "-ODeliveryMode=deferred"; |