diff options
Diffstat (limited to 'request.cgi')
-rwxr-xr-x | request.cgi | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/request.cgi b/request.cgi index 131614890..51966238c 100755 --- a/request.cgi +++ b/request.cgi @@ -91,7 +91,7 @@ sub queue { my $status = validateStatus($cgi->param('status')); my $form_group = validateGroup($cgi->param('group')); - my $query = + my $query = # Select columns describing each flag, the bug/attachment on which # it has been set, who set it, and of whom they are requesting it. " SELECT flags.id, flagtypes.name, @@ -102,10 +102,10 @@ sub queue { requesters.realname, requesters.login_name, requestees.realname, requestees.login_name, COUNT(privs.group_id), " . $dbh->sql_date_format('flags.modification_date', '%Y.%m.%d %H:%i') . ", - attachments.ispatch, - bugs.bug_status, - bugs.priority, - bugs.bug_severity " . + attachments.ispatch, + bugs.bug_status, + bugs.priority, + bugs.bug_severity " . # Use the flags and flagtypes tables for information about the flags, # the bugs and attachments tables for target info, the profiles tables # for setter and requestee info, the products/components tables @@ -113,7 +113,7 @@ sub queue { # table to help us weed out secure bugs to which the user should not have # access. " - FROM flags + FROM flags LEFT JOIN attachments ON flags.attach_id = attachments.attach_id INNER JOIN flagtypes @@ -280,22 +280,22 @@ sub queue { foreach my $result (@$results) { my @data = @$result; my $request = { - 'id' => $data[0] , - 'type' => $data[1] , - 'status' => $data[2] , - 'bug_id' => $data[3] , - 'bug_summary' => $data[4] , - 'category' => "$data[5]: $data[6]" , - 'attach_id' => $data[7] , + 'id' => $data[0] , + 'type' => $data[1] , + 'status' => $data[2] , + 'bug_id' => $data[3] , + 'bug_summary' => $data[4] , + 'category' => "$data[5]: $data[6]" , + 'attach_id' => $data[7] , 'attach_summary' => $data[8] , - 'requester' => ($data[9] ? "$data[9] <$data[10]>" : $data[10]) , - 'requestee' => ($data[11] ? "$data[11] <$data[12]>" : $data[12]) , + 'requester' => ($data[9] ? "$data[9] <$data[10]>" : $data[10]) , + 'requestee' => ($data[11] ? "$data[11] <$data[12]>" : $data[12]) , 'restricted' => $data[13] ? 1 : 0, - 'created' => $data[14], - 'ispatch' => $data[15], - 'bug_status' => $data[16], - 'priority' => $data[17], - 'bug_severity' => $data[18], + 'created' => $data[14], + 'ispatch' => $data[15], + 'bug_status' => $data[16], + 'priority' => $data[17], + 'bug_severity' => $data[18], }; push(@requests, $request); } |