From 97916f9a31574776b13b975ee87f0483cd65fa9b Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Tue, 18 Oct 2005 04:28:16 +0000
Subject: Bug 305979: Removing a user account who was requested to set a flag
 at least once may return wrong information - Patch by Frédéric Buclin
 <LpSolit@gmail.com> r=wurblzap a=justdave
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 editusers.cgi | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/editusers.cgi b/editusers.cgi
index 049bfabf7..d967123a7 100755
--- a/editusers.cgi
+++ b/editusers.cgi
@@ -428,7 +428,7 @@ if ($action eq 'search') {
         'SELECT COUNT(*) FROM bugs_activity WHERE who = ?',
         undef, $otherUserID);
     $vars->{'flags'}{'requestee'} = $dbh->selectrow_array(
-        'SELECT COUNT(*) FROM flags WHERE requestee_id = ?',
+        'SELECT COUNT(*) FROM flags WHERE requestee_id = ? AND is_active = 1',
         undef, $otherUserID);
     $vars->{'flags'}{'setter'} = $dbh->selectrow_array(
         'SELECT COUNT(*) FROM flags WHERE setter_id = ?',
-- 
cgit v1.2.3-24-g4f1b