diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2009-12-13 17:03:07 -0800 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2009-12-13 17:03:07 -0800 |
| commit | cb55eea0f3609d802da5fdb0ea1c8b3acb0b8ea9 (patch) | |
| tree | 7e9c42155c118ba78c92e24fb8c1efddd6e55338 | |
| parent | c65cd702fc8e732416f13f4eb21c8e8e95b09c28 (diff) | |
Convert a database query.
| -rw-r--r-- | modules/digibug/controllers/digibug.php | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/modules/digibug/controllers/digibug.php b/modules/digibug/controllers/digibug.php index 25f1ca3e..03f9e812 100644 --- a/modules/digibug/controllers/digibug.php +++ b/modules/digibug/controllers/digibug.php @@ -115,9 +115,10 @@ class Digibug_Controller extends Controller { } private function _clean_expired() { - Database::instance()->query( - "DELETE FROM {digibug_proxies} " . - "WHERE request_date <= (CURDATE() - INTERVAL 10 DAY) " . - "LIMIT 20"); + db::build() + ->delete("digibug_proxies") + ->where("request_date", "<=", new Database_Expression("(CURDATE() - INTERVAL 10 DAY)")) + ->limit(20) + ->execute(); } }
\ No newline at end of file |