diff options
author | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 21:09:00 +0000 |
---|---|---|
committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 21:09:00 +0000 |
commit | fd610589ed6060333075a4e61efc29a3f7e98798 (patch) | |
tree | 75535631f6f2b2bc4e8924e2eae11c2db94761f2 /modules/exif/helpers/exif_task.php | |
parent | bd15853708ae73ee69220738a061e10d015d7fb9 (diff) |
This implements table prefix for all the queries in core, user, exif,
tag, search, comment and notification modules (Ticket #68)
(missed this one)
Diffstat (limited to 'modules/exif/helpers/exif_task.php')
-rw-r--r-- | modules/exif/helpers/exif_task.php | 14 |
1 files changed, 7 insertions, 7 deletions
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() |