From 01939a3d9ba7d3947e3637ef4a7808c4d841164e Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Tue, 25 Jul 2006 08:25:44 +0000
Subject: Bug 345652: request.cgi should look at flags.modification_date
 instead of flags.creation_date - Patch by Frédéric Buclin <LpSolit@gmail.com>
 r/a=myk
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

(limited to 'request.cgi')

diff --git a/request.cgi b/request.cgi
index b41361963..a3191bb15 100755
--- a/request.cgi
+++ b/request.cgi
@@ -96,7 +96,7 @@ sub queue {
                 flags.attach_id, attachments.description,
                 requesters.realname, requesters.login_name,
                 requestees.realname, requestees.login_name,
-    " . $dbh->sql_date_format('flags.creation_date', '%Y.%m.%d %H:%i') .
+    " . $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
     # for setter and requestee info, the products/components tables
@@ -224,7 +224,7 @@ sub queue {
                 products.name, components.name, flags.attach_id,
                 attachments.description, requesters.realname,
                 requesters.login_name, requestees.realname,
-                requestees.login_name, flags.creation_date,
+                requestees.login_name, flags.modification_date,
                 cclist_accessible, bugs.reporter, bugs.reporter_accessible,
                 bugs.assigned_to');
 
@@ -247,8 +247,8 @@ sub queue {
     }
 
     # Order the records (within each group).
-    $query .= " , flags.creation_date";
-    
+    $query .= " , flags.modification_date";
+
     # Pass the query to the template for use when debugging this script.
     $vars->{'query'} = $query;
     $vars->{'debug'} = $cgi->param('debug') ? 1 : 0;
-- 
cgit v1.2.3-24-g4f1b