From ed20d719e2df695ed2c9127f364886b902d82a24 Mon Sep 17 00:00:00 2001 From: "travis%sedsystems.ca" <> Date: Sat, 29 Jan 2005 03:01:27 +0000 Subject: Bug 257315 : type of delta_ts in bugs table should not be timestamp Patch by Tomas Kopal r=vladd, LpSolit a=justdave --- editproducts.cgi | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'editproducts.cgi') diff --git a/editproducts.cgi b/editproducts.cgi index 8fe1a5ec5..b10a238fc 100755 --- a/editproducts.cgi +++ b/editproducts.cgi @@ -1176,12 +1176,12 @@ if ($action eq 'updategroupcontrols') { my ($removed, $timestamp) = FetchSQLData(); LogActivityEntry($bugid, "bug_group", $removed, "", $::userid, $timestamp); + my $diffed = ""; if ($mailiscurrent != 0) { - SendSQL("UPDATE bugs SET lastdiffed = " . SqlQuote($timestamp) - . " WHERE bug_id = $bugid"); + $diffed = ", lastdiffed = " . SqlQuote($timestamp); } - SendSQL("UPDATE bugs SET delta_ts = " . SqlQuote($timestamp) - . " WHERE bug_id = $bugid"); + SendSQL("UPDATE bugs SET delta_ts = " . SqlQuote($timestamp) . + $diffed . " WHERE bug_id = $bugid"); PopGlobalSQLState(); $count++; } @@ -1210,12 +1210,12 @@ if ($action eq 'updategroupcontrols') { my ($added, $timestamp) = FetchSQLData(); LogActivityEntry($bugid, "bug_group", "", $added, $::userid, $timestamp); + my $diffed = ""; if ($mailiscurrent != 0) { - SendSQL("UPDATE bugs SET lastdiffed = " . SqlQuote($timestamp) - . " WHERE bug_id = $bugid"); + $diffed = ", lastdiffed = " . SqlQuote($timestamp); } - SendSQL("UPDATE bugs SET delta_ts = " . SqlQuote($timestamp) - . " WHERE bug_id = $bugid"); + SendSQL("UPDATE bugs SET delta_ts = " . SqlQuote($timestamp) . + $diffed . " WHERE bug_id = $bugid"); PopGlobalSQLState(); $count++; } -- cgit v1.2.3-24-g4f1b