From 61ddf0a32846fdf2607043d94af1a0a86b80f6fc Mon Sep 17 00:00:00 2001
From: "bbaetz%student.usyd.edu.au" <>
Date: Mon, 12 Aug 2002 12:42:42 +0000
Subject: Bug 43600 - Convert products/components to use ids instead of names.
 Initial attempt by jake@bugzilla.org, updated by me r=joel, preed

---
 collectstats.pl | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'collectstats.pl')

diff --git a/collectstats.pl b/collectstats.pl
index 4e69ab9b5..a47e2174d 100755
--- a/collectstats.pl
+++ b/collectstats.pl
@@ -67,6 +67,9 @@ sub collect_stats {
     my $dir = shift;
     my $product = shift;
     my $when = localtime (time);
+    my $product_id = get_product_id($product) unless $product eq '-All-';
+
+    die "Unknown product $product" unless ($product_id or $product eq '-All-');
 
     # NB: Need to mangle the product for the filename, but use the real
     # product name in the query
@@ -82,7 +85,7 @@ sub collect_stats {
             if( $product eq "-All-" ) {
                 SendSQL("select count(bug_status) from bugs where bug_status='$status'");
             } else {
-                SendSQL("select count(bug_status) from bugs where bug_status='$status' and product='$product'");
+                SendSQL("select count(bug_status) from bugs where bug_status='$status' and product_id=$product_id");
             }
 
             push @row, FetchOneColumn();
@@ -92,7 +95,7 @@ sub collect_stats {
             if( $product eq "-All-" ) {
                 SendSQL("select count(resolution) from bugs where resolution='$resolution'");
             } else {
-                SendSQL("select count(resolution) from bugs where resolution='$resolution' and product='$product'");
+                SendSQL("select count(resolution) from bugs where resolution='$resolution' and product_id=$product_id");
             }
 
             push @row, FetchOneColumn();
-- 
cgit v1.2.3-24-g4f1b