Bug 373278: Add distinctive marking for security bugs in request.cgi

r=pyrzak a=LpSolit

1 files changed, 5 insertions, 2 deletions

diff --git a/request.cgi b/request.cgi
index b54477cb1..e1137b3f2 100755
--- a/request.cgi
+++ b/request.cgi
@@ -113,7 +113,7 @@ sub queue {
                 products.name, components.name,
                 flags.attach_id, attachments.description,
                 requesters.realname, requesters.login_name,
-                requestees.realname, requestees.login_name,
+                requestees.realname, requestees.login_name, COUNT(privs.group_id),
     " . $dbh->sql_date_format('flags.modification_date', '%Y.%m.%d %H:%i') .
     # Use the flags and flagtypes tables for information about the flags,
     # the bugs and attachments tables for target info, the profiles tables
@@ -141,6 +141,8 @@ sub queue {
                   ON bgmap.bug_id = bugs.bug_id
                  AND bgmap.group_id NOT IN (" .
                      $user->groups_as_string . ")
+           LEFT JOIN bug_group_map AS privs
+                  ON privs.bug_id = bugs.bug_id
            LEFT JOIN cc AS ccmap
                   ON ccmap.who = $userid
                  AND ccmap.bug_id = bugs.bug_id
@@ -292,7 +294,8 @@ sub queue {
           'attach_summary'  => $data[8] ,
           'requester'       => ($data[9] ? "$data[9] <$data[10]>" : $data[10]) , 
           'requestee'       => ($data[11] ? "$data[11] <$data[12]>" : $data[12]) , 
-          'created'         => $data[13]
+          'restricted'      => $data[13] ? 1 : 0,
+          'created'         => $data[14]
         };
         push(@requests, $request);
     }