From d2cb217e20d44d7928a0910ac0375740de163bb3 Mon Sep 17 00:00:00 2001
From: Bharat Mediratta <bharat@menalto.com>
Date: Wed, 2 Dec 2009 00:34:34 -0800
Subject: Convert more database calls over to the new format -
 admin/maintenance page loads, the rebuild thumbs/resizes task works - Fixed
 up some conversion bugs in the Cache driver

---
 modules/exif/helpers/exif_task.php | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'modules/exif/helpers/exif_task.php')

diff --git a/modules/exif/helpers/exif_task.php b/modules/exif/helpers/exif_task.php
index 66f69790..e25e2405 100644
--- a/modules/exif/helpers/exif_task.php
+++ b/modules/exif/helpers/exif_task.php
@@ -20,10 +20,11 @@
 class exif_task_Core {
   static function available_tasks() {
     // Delete extra exif_records
-    Database::instance()->query(
-      "DELETE FROM {exif_records} " .
-      "WHERE {exif_records}.`item_id` NOT IN " .
-      "(SELECT `id` FROM {items} WHERE {items}.`type` = 'photo')");
+    db::build()
+      ->delete("exif_records")
+      ->where("item_id", "NOT IN",
+              db::build()->select("id")->from("items")->where("type", "=", "photo"))
+      ->execute();
 
     list ($remaining, $total, $percent) = exif::stats();
     return array(Task_Definition::factory()
-- 
cgit v1.2.3