From c04ff8e02f01691dc2e325efc523e43f3aebaf95 Mon Sep 17 00:00:00 2001 From: Tim Almdal Date: Sat, 28 Feb 2009 06:37:28 +0000 Subject: Change the pattern to identify tables that need prefix substitution to mirror the drupal pattern of using braces {}. --- modules/search/helpers/search_task.php | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'modules/search/helpers/search_task.php') diff --git a/modules/search/helpers/search_task.php b/modules/search/helpers/search_task.php index 0071f2e0..7aba640e 100644 --- a/modules/search/helpers/search_task.php +++ b/modules/search/helpers/search_task.php @@ -21,16 +21,16 @@ class search_task_Core { static function available_tasks() { // Delete extra search_records Database::instance()->query( - "DELETE `[search_records]`.* FROM `[search_records]` " . - "LEFT JOIN `[items]` ON (`[search_records]`.`item_id` = `[items]`.`id`) " . - "WHERE `[items]`.`id` IS NULL"); + "DELETE {search_records}.* FROM {search_records} " . + "LEFT JOIN {items} ON ({search_records}.`item_id` = {items}.`id`) " . + "WHERE {items}.`id` IS NULL"); // Insert missing search_records Database::instance()->query( - "INSERT INTO `[search_records]`(`item_id`) (" . - " SELECT `[items]`.`id` FROM `[items]` " . - " LEFT JOIN `[search_records]` ON (`[search_records]`.`item_id` = `[items]`.`id`) " . - " WHERE `[search_records]`.`id` IS NULL)"); + "INSERT INTO {search_records}(`item_id`) (" . + " SELECT {items}.`id` FROM {items} " . + " LEFT JOIN {search_records} ON ({search_records}.`item_id` = {items}.`id`) " . + " WHERE {search_records}.`id` IS NULL)"); list ($remaining, $total, $percent) = self::_get_stats(); return array(Task_Definition::factory() -- cgit v1.2.3