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 --- CGI.pl | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) (limited to 'CGI.pl') diff --git a/CGI.pl b/CGI.pl index 165e5216c..4d7b34047 100644 --- a/CGI.pl +++ b/CGI.pl @@ -246,27 +246,28 @@ sub CheckIfVotedConfirmed { my ($id, $who) = (@_); PushGlobalSQLState(); SendSQL("SELECT bugs.votes, bugs.bug_status, products.votestoconfirm, " . - " bugs.everconfirmed " . + " bugs.everconfirmed, NOW() " . "FROM bugs, products " . "WHERE bugs.bug_id = $id AND products.id = bugs.product_id"); - my ($votes, $status, $votestoconfirm, $everconfirmed) = (FetchSQLData()); + my ($votes, $status, $votestoconfirm, $everconfirmed, $now) = (FetchSQLData()); my $ret = 0; if ($votes >= $votestoconfirm && $status eq $::unconfirmedstate) { - SendSQL("UPDATE bugs SET bug_status = 'NEW', everconfirmed = 1 " . - "WHERE bug_id = $id"); + SendSQL("UPDATE bugs SET bug_status = 'NEW', everconfirmed = 1, " . + "delta_ts = $now WHERE bug_id = $id"); my $fieldid = GetFieldID("bug_status"); SendSQL("INSERT INTO bugs_activity " . "(bug_id,who,bug_when,fieldid,removed,added) VALUES " . - "($id,$who,now(),$fieldid,'$::unconfirmedstate','NEW')"); + "($id,$who,$now,$fieldid,'$::unconfirmedstate','NEW')"); if (!$everconfirmed) { $fieldid = GetFieldID("everconfirmed"); SendSQL("INSERT INTO bugs_activity " . "(bug_id,who,bug_when,fieldid,removed,added) VALUES " . - "($id,$who,now(),$fieldid,'0','1')"); + "($id,$who,$now,$fieldid,'0','1')"); } AppendComment($id, DBID_to_name($who), - "*** This bug has been confirmed by popular vote. ***", 0); + "*** This bug has been confirmed by popular vote. ***", + 0, $now); $vars->{'type'} = "votes"; $vars->{'id'} = $id; -- cgit v1.2.3-24-g4f1b