From f5a7c7d2472f5a4940343785ab9619247f8895a5 Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@hardison.net>
Date: Tue, 30 Sep 2014 18:01:38 -0400
Subject: Bug 1070317 - Bugzilla::Flag's attribute modification_date is
 affected by the user's timezone and differs from the database copy after a
 call to $flag->update() r=dkl, a=justdave

---
 Bugzilla/Flag.pm | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/Flag.pm b/Bugzilla/Flag.pm
index 6e2096729..772a39325 100644
--- a/Bugzilla/Flag.pm
+++ b/Bugzilla/Flag.pm
@@ -454,14 +454,15 @@ sub create {
 sub update {
     my $self = shift;
     my $dbh = Bugzilla->dbh;
-    my $timestamp = shift || $dbh->selectrow_array('SELECT NOW()');
+    my $timestamp = shift || $dbh->selectrow_array('SELECT LOCALTIMESTAMP(0)');
 
     my $changes = $self->SUPER::update(@_);
 
     if (scalar(keys %$changes)) {
         $dbh->do('UPDATE flags SET modification_date = ? WHERE id = ?',
                  undef, ($timestamp, $self->id));
-        $self->{'modification_date'} = format_time($timestamp, '%Y.%m.%d %T');
+        $self->{'modification_date'} =
+          format_time($timestamp, '%Y.%m.%d %T', Bugzilla->local_timezone);
         Bugzilla->memcached->clear({ table => 'flags', id => $self->id });
     }
     return $changes;
-- 
cgit v1.2.3-24-g4f1b