diff options
Diffstat (limited to 'post_bug.cgi')
| -rwxr-xr-x | post_bug.cgi | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/post_bug.cgi b/post_bug.cgi index 40111ff77..112292171 100755 --- a/post_bug.cgi +++ b/post_bug.cgi @@ -321,9 +321,14 @@ if (UserInGroup("editbugs") && defined($::FORM{'dependson'})) { } } +# get current time +SendSQL("SELECT NOW()"); +my $timestamp = FetchOneColumn(); + + # Build up SQL string to add bug. my $sql = "INSERT INTO bugs " . - "(" . join(",", @used_fields) . ", reporter, creation_ts, " . + "(" . join(",", @used_fields) . ", reporter, creation_ts, delta_ts, " . "estimated_time, remaining_time, deadline) " . "VALUES ("; @@ -337,7 +342,7 @@ $comment = trim($comment); # OK except for the fact that it causes e-mail to be suppressed. $comment = $comment ? $comment : " "; -$sql .= "$::userid, now(), "; +$sql .= "$::userid, $timestamp, $timestamp, "; # Time Tracking if (UserInGroup(Param("timetrackinggroup")) && @@ -414,9 +419,6 @@ while (MoreSQLData()) { # Add the bug report to the DB. SendSQL($sql); -SendSQL("select now()"); -my $timestamp = FetchOneColumn(); - # Get the bug ID back. SendSQL("select LAST_INSERT_ID()"); my $id = FetchOneColumn(); @@ -456,8 +458,8 @@ if (UserInGroup("editbugs")) { while (MoreSQLData()) { push (@list, FetchOneColumn()); } - SendSQL("UPDATE bugs SET keywords = " . - SqlQuote(join(', ', @list)) . + SendSQL("UPDATE bugs SET delta_ts = $timestamp," . + " keywords = " . SqlQuote(join(', ', @list)) . " WHERE bug_id = $id"); } if (defined $::FORM{'dependson'}) { |