diff options
| author | mkanat%kerio.com <> | 2005-02-20 17:02:06 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-02-20 17:02:06 +0100 |
| commit | d7958942a691a719be4d3433b5a24817c8646f9a (patch) | |
| tree | 179648890480c617db96828c6b2a705f74a04d2d /Bugzilla | |
| parent | e547dd6d7b7b9a3c2135c56dd6b7a433743fd4b1 (diff) | |
| download | bugzilla-d7958942a691a719be4d3433b5a24817c8646f9a.tar.gz bugzilla-d7958942a691a719be4d3433b5a24817c8646f9a.tar.xz | |
Bug 280502: Replace "INTERVAL" with Bugzilla::DB function call
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/Search.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Token.pm | 3 |
2 files changed, 3 insertions, 2 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 82cbb9aa6..a1058fbe5 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -906,7 +906,7 @@ sub init { $unitinterval = 'YEAR'; } my $cutoff = "DATE_SUB(NOW(), " . - "INTERVAL $quantity $unitinterval)"; + $dbh->sql_interval("$quantity $unitinterval"); my $assigned_fieldid = &::GetFieldID('assigned_to'); push(@supptables, "LEFT JOIN longdescs comment_$table " . "ON comment_$table.who = bugs.assigned_to " . diff --git a/Bugzilla/Token.pm b/Bugzilla/Token.pm index 4c70d4bad..73f074185 100644 --- a/Bugzilla/Token.pm +++ b/Bugzilla/Token.pm @@ -119,7 +119,8 @@ sub IssuePasswordToken { LEFT JOIN tokens ON tokens.userid = profiles.userid AND tokens.tokentype = 'password' - AND tokens.issuedate > DATE_SUB(NOW(), INTERVAL 10 MINUTE) + AND tokens.issuedate > DATE_SUB(NOW(), " . + $dbh->sql_interval('10 MINUTE') . ") WHERE login_name = $quotedloginname"); my ($userid, $toosoon) = &::FetchSQLData(); |