From e2709ad366fe63537f987ca6167dc0ac697a6846 Mon Sep 17 00:00:00 2001
From: "terry%netscape.com" <>
Date: Sat, 6 Mar 1999 07:08:23 +0000
Subject: Check qa_contact IDs.

---
 sanitycheck.cgi | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

(limited to 'sanitycheck.cgi')

diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index db9c092eb..0d2f4072f 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -107,13 +107,13 @@ while (@row = FetchSQLData()) {
 undef $profid{0};
 
 
-Status("Checking reporter/assigned_to ids");
-SendSQL("select bug_id,reporter,assigned_to from bugs");
+Status("Checking reporter/assigned_to/qa_contact ids");
+SendSQL("select bug_id,reporter,assigned_to,qa_contact from bugs");
 
 my %bugid;
 
 while (@row = FetchSQLData()) {
-    my($id, $reporter, $assigned_to) = (@row);
+    my($id, $reporter, $assigned_to, $qa_contact) = (@row);
     $bugid{$id} = 1;
     if (!defined $profid{$reporter}) {
         Alert("Bad reporter $reporter in " . BugLink($id));
@@ -121,6 +121,9 @@ while (@row = FetchSQLData()) {
     if (!defined $profid{$assigned_to}) {
         Alert("Bad assigned_to $assigned_to in" . BugLink($id));
     }
+    if ($qa_contact != 0 && !defined $profid{$qa_contact}) {
+        Alert("Bad qa_contact $qa_contact in" . BugLink($id));
+    }
 }
 
 Status("Checking CC table");
-- 
cgit v1.2.3-24-g4f1b