From fd2de5b298b45b4925cac77be76940313d5b7830 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Wed, 16 Nov 2005 09:09:51 +0000
Subject: [PATCH] =?utf8?q?Bug=20288557:=20Show=20in=20the=20request=20queu?=
 =?utf8?q?e=20those=20requests=20tied=20to=20secure=20bugs=20for=20which?=
 =?utf8?q?=20the=20user=20is=20the=20QA=20contact=20-=20Patch=20by=20Fr?=
 =?utf8?q?=C3=A9d=C3=A9ric=20Buclin=20<LpSolit@gmail.com>=20r/a=3Dmyk?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 request.cgi | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/request.cgi b/request.cgi
index 4c6e7600f2..344fb20281 100755
--- a/request.cgi
+++ b/request.cgi
@@ -95,9 +95,9 @@ sub queue {
                   ON flags.requestee_id  = requestees.userid
           INNER JOIN bugs
                   ON flags.bug_id = bugs.bug_id
-           LEFT JOIN products
+          INNER JOIN products
                   ON bugs.product_id = products.id
-           LEFT JOIN components
+          INNER JOIN components
                   ON bugs.component_id = components.id
            LEFT JOIN bug_group_map AS bgmap
                   ON bgmap.bug_id = bugs.bug_id
@@ -112,7 +112,9 @@ sub queue {
     " WHERE     ((bgmap.group_id IS NULL) OR
                  (ccmap.who IS NOT NULL AND cclist_accessible = 1) OR
                  (bugs.reporter = $::userid AND bugs.reporter_accessible = 1) OR
-                 (bugs.assigned_to = $::userid))";
+                 (bugs.assigned_to = $::userid) " .
+                 (Param('useqacontact') ? "OR
+                 (bugs.qa_contact = $::userid))" : ")");
     
     # Non-deleted flags only
     $query .= " AND flags.is_active = 1 ";
-- 
2.47.2