diff options
| author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 12:58:28 +0200 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 12:58:28 +0200 |
| commit | 02a049703de6055f09f44f89a5a821814696ce32 (patch) | |
| tree | 5918c91ceea49d280c8c3c0ce795da549a8bf4c6 /Bugzilla/User.pm | |
| parent | 7307c8c748e3245d65a25c016e7d92c6c7ae2aa4 (diff) | |
| download | bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.gz bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.xz | |
Bug 602165: Change sql_interval to sql_date_math, in preparation for
MS-SQL and SQLite support.
Diffstat (limited to 'Bugzilla/User.pm')
| -rw-r--r-- | Bugzilla/User.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm index 595964bf9..8f056dca6 100644 --- a/Bugzilla/User.pm +++ b/Bugzilla/User.pm @@ -1791,12 +1791,13 @@ sub clear_login_failures { sub account_ip_login_failures { my $self = shift; my $dbh = Bugzilla->dbh; - my $time = $dbh->sql_interval(LOGIN_LOCKOUT_INTERVAL, 'MINUTE'); + my $time = $dbh->sql_date_math('LOCALTIMESTAMP(0)', '-', + LOGIN_LOCKOUT_INTERVAL, 'MINUTE'); my $ip_addr = remote_ip(); trick_taint($ip_addr); $self->{account_ip_login_failures} ||= Bugzilla->dbh->selectall_arrayref( "SELECT login_time, ip_addr, user_id FROM login_failure - WHERE user_id = ? AND login_time > LOCALTIMESTAMP(0) - $time + WHERE user_id = ? AND login_time > $time AND ip_addr = ? ORDER BY login_time", {Slice => {}}, $self->id, $ip_addr); return $self->{account_ip_login_failures}; |