Closed Bug 759763 Opened 13 years ago Closed 13 years ago

consistently use Database time

Categories

(Bugzilla :: Bugzilla-General, defect)

4.3.1
defect
Not set
normal

Tracking

()

RESOLVED DUPLICATE of bug 283076

People

(Reporter: michael.j.tosh, Unassigned)

Details

User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.28) Gecko/20120306 Firefox/3.6.28 (.NET CLR 3.5.30729) Build ID: 20120306064154 Steps to reproduce: Multiple pages call "localtime" to get the current time of the system for display to the user. Bugs, however, are always set using database time. The time source should be consistent. The following files call localtime or localtime(time()): Bugzilla/Search.pm buglist.cgi chart.cgi collectstats.pl importxml.pl report.cgi summarize_time.cgi whine.pl Actual results: my ($now_sec, $now_minute, $now_hour, $now_day, $now_month, $now_year, $now_weekday) = localtime; $now_year = sprintf("%02d", $now_year % 100); $now_month++; Expected results: This could be stored in Bugzilla.pm as a global reference object retrieved from the database. my ($now_minute, $now_hour, $now_day, $now_month, $now_year, $now_weekday) = $dbh->selectrow_array(q{ SELECT MINUTE(NOW()), HOUR(NOW()), DAY(NOW()), MONTH(NOW()), YEAR(NOW()), WEEKDAY(NOW())}); $now_weekday++;
Status: UNCONFIRMED → RESOLVED
Closed: 13 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.