From 04fa4c5f8080d8b34eedbc083b3a4a322fbd937c Mon Sep 17 00:00:00 2001
From: "terry%netscape.com" <>
Date: Sat, 6 Mar 1999 04:05:53 +0000
Subject: Fixed bug 3365 -- was generating wrong statistics if there were no
 NEW or no ASSIGNED bugs.

---
 collectstats.pl | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

(limited to 'collectstats.pl')

diff --git a/collectstats.pl b/collectstats.pl
index 6c51d1afc..e35c7aa23 100755
--- a/collectstats.pl
+++ b/collectstats.pl
@@ -52,21 +52,17 @@ sub collect_stats {
     my $product = shift;
     my $when = localtime (time);
 
-    my $query = "select count(bug_status) from bugs where (bug_status='NEW' or  bug_status='ASSIGNED' or bug_status='REOPENED') and product='$product' group by bug_status";
 
     $product =~ s/\//-/gs;
     my $file = join '/', $dir, $product;
     my $exists = -f $file;
 
     if (open DATA, ">>$file") {
-        SendSQL ($query);
-
-        my %count;
         push my @row, &today;
 
-        while (my @n = FetchSQLData())
-        {
-            push @row, @n;
+        foreach my $status ('NEW', 'ASSIGNED', 'REOPENED') {
+            SendSQL("select count(bug_status) from bugs where bug_status='$status' and product='$product'");
+            push @row, FetchOneColumn();
         }
 
         if (! $exists)
-- 
cgit v1.2.3-24-g4f1b