diff options
| author | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 21:07:18 +0000 |
|---|---|---|
| committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 21:07:18 +0000 |
| commit | bd15853708ae73ee69220738a061e10d015d7fb9 (patch) | |
| tree | facfbd5b08e3cbb8e7fa2b4adf433b54d4c0c5bc /core/helpers/access.php | |
| parent | 0b9fe18a6bf4036a05db7f9479d7b55d3fe5c782 (diff) | |
This implements table prefix for all the queries in core, user, exif,
tag, search, comment and notification modules (Ticket #68)
Diffstat (limited to 'core/helpers/access.php')
| -rw-r--r-- | core/helpers/access.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/core/helpers/access.php b/core/helpers/access.php index 8a88bdf5..a9f48c20 100644 --- a/core/helpers/access.php +++ b/core/helpers/access.php @@ -404,8 +404,8 @@ class access_Core { $db = Database::instance(); $field = "{$perm_name}_{$group->id}"; $cache_table = $perm_name == "view" ? "items" : "access_caches"; - $db->query("ALTER TABLE `$cache_table` DROP `$field`"); - $db->query("ALTER TABLE `access_intents` DROP `$field`"); + $db->query("ALTER TABLE `[$cache_table]` DROP `$field`"); + $db->query("ALTER TABLE `[access_intents]` DROP `$field`"); ORM::factory("access_intent")->clear_cache(); } @@ -420,8 +420,8 @@ class access_Core { $db = Database::instance(); $field = "{$perm_name}_{$group->id}"; $cache_table = $perm_name == "view" ? "items" : "access_caches"; - $db->query("ALTER TABLE `$cache_table` ADD `$field` TINYINT(2) NOT NULL DEFAULT 0"); - $db->query("ALTER TABLE `access_intents` ADD `$field` BOOLEAN DEFAULT NULL"); + $db->query("ALTER TABLE `[$cache_table]` ADD `$field` TINYINT(2) NOT NULL DEFAULT 0"); + $db->query("ALTER TABLE `[access_intents]` ADD `$field` BOOLEAN DEFAULT NULL"); $db->update("access_intents", array($field => 0), array("item_id" => 1)); ORM::factory("access_intent")->clear_cache(); } @@ -547,9 +547,9 @@ class access_Core { ->find_all(); foreach ($query as $row) { $db->query( - "UPDATE `access_caches` SET `$field` = {$row->$field} " . + "UPDATE `[access_caches]` SET `$field` = {$row->$field} " . "WHERE `item_id` IN " . - " (SELECT `id` FROM `items` " . + " (SELECT `id` FROM `[items]` " . " WHERE `left` >= $row->left " . " AND `right` <= $row->right)"); } |