From fd610589ed6060333075a4e61efc29a3f7e98798 Mon Sep 17 00:00:00 2001 From: Tim Almdal Date: Fri, 27 Feb 2009 21:09:00 +0000 Subject: This implements table prefix for all the queries in core, user, exif, tag, search, comment and notification modules (Ticket #68) (missed this one) --- modules/exif/helpers/exif_task.php | 14 +++++++------- 1 file changed, 7 insertions(+), 7 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 82d78f4c..6fdcdcf7 100644 --- a/modules/exif/helpers/exif_task.php +++ b/modules/exif/helpers/exif_task.php @@ -23,16 +23,16 @@ class exif_task_Core { // Delete extra exif_records $db->query( - "DELETE `exif_records`.* FROM `exif_records` " . - "LEFT JOIN `items` ON (`exif_records`.`item_id` = `items`.`id`) " . - "WHERE `items`.`id` IS NULL"); + "DELETE `[exif_records]`.* FROM `exif_records` " . + "LEFT JOIN `[items]` ON (`[exif_records]`.`item_id` = `[items]`.`id`) " . + "WHERE `[items]`.`id` IS NULL"); // Insert missing exif_records $db->query( - "INSERT INTO `exif_records`(`item_id`) (" . - " SELECT `items`.`id` FROM `items` " . - " LEFT JOIN `exif_records` ON (`exif_records`.`item_id` = `items`.`id`) " . - " WHERE `exif_records`.`id` IS NULL)"); + "INSERT INTO `[exif_record]`(`item_id`) (" . + " SELECT `[items]`.`id` FROM `[items]` " . + " LEFT JOIN `[exif_records]` ON (`[exif_records]`.`item_id` = `[items]`.`id`) " . + " WHERE `[exif_records]`.`id` IS NULL)"); list ($remaining, $total, $percent) = self::_get_stats(); return array(Task_Definition::factory() -- cgit v1.2.3