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/comment/controllers/admin_comments.php | 2 +- modules/comment/helpers/comment_installer.php | 6 +++--- 2 files changed, 4 insertions(+), 4 deletions(-) (limited to 'modules/comment') diff --git a/modules/comment/controllers/admin_comments.php b/modules/comment/controllers/admin_comments.php index 47e354af..c1a30bd2 100644 --- a/modules/comment/controllers/admin_comments.php +++ b/modules/comment/controllers/admin_comments.php @@ -57,7 +57,7 @@ class Admin_Comments_Controller extends Admin_Controller { public function index() { // Get rid of old deleted/spam comments Database::instance()->query( - "DELETE FROM `[comments]` " . + "DELETE FROM {comments} " . "WHERE state IN ('deleted', 'spam') " . "AND unix_timestamp(now()) - updated > 86400 * 7"); diff --git a/modules/comment/helpers/comment_installer.php b/modules/comment/helpers/comment_installer.php index a7852d05..5c5e9f03 100644 --- a/modules/comment/helpers/comment_installer.php +++ b/modules/comment/helpers/comment_installer.php @@ -23,7 +23,7 @@ class comment_installer { $version = module::get_version("comment"); if ($version == 0) { - $db->query("CREATE TABLE IF NOT EXISTS `[comments]` ( + $db->query("CREATE TABLE IF NOT EXISTS {comments} ( `author_id` int(9) default NULL, `created` int(9) NOT NULL, `guest_email` varchar(128) default NULL, @@ -58,10 +58,10 @@ class comment_installer { static function uninstall() { $db = Database::instance(); - $sql = "SELECT `item_id` FROM `[comments]`"; + $sql = "SELECT `item_id` FROM {comments}"; module::event("item_related_update_batch", $sql); - $db->query("DROP TABLE IF EXISTS `[comments] + $db->query("DROP TABLE IF EXISTS {comments] `;"); module::delete("comment"); } -- cgit v1.2.3