diff options
| author | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 00:19:12 +0000 |
|---|---|---|
| committer | Tim Almdal <tnalmdal@shaw.ca> | 2009-02-27 00:19:12 +0000 |
| commit | 2b1f68a6546b7a2743efaca2f224c1de90e17d1d (patch) | |
| tree | a36fdd0648205c78b04e46ff448a59b59736f06a | |
| parent | d097b4fc027ff558bf5f580298c7bed3696dcd3d (diff) | |
Continue the journey of replacing raw sql with ORM or Database method
calls (Ticket #68)
| -rw-r--r-- | modules/tag/controllers/admin_tags.php | 2 | ||||
| -rw-r--r-- | modules/tag/helpers/tag_event.php | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/tag/controllers/admin_tags.php b/modules/tag/controllers/admin_tags.php index 1d800fce..d6ae310b 100644 --- a/modules/tag/controllers/admin_tags.php +++ b/modules/tag/controllers/admin_tags.php @@ -50,7 +50,7 @@ class Admin_Tags_Controller extends Admin_Controller { $form = tag::get_delete_form($tag); if ($form->validate()) { $name = $tag->name; - Database::instance()->query("DELETE from `items_tags` where `tag_id` = $tag->id"); + Database::instance()->delete("items_tags", array("tag_id" => "$tag->id")); $tag->delete(); message::success(t("Deleted tag %tag_name", array("tag_name" => $name))); log::success("tags", t("Deleted tag %tag_name", array("tag_name" => $name))); diff --git a/modules/tag/helpers/tag_event.php b/modules/tag/helpers/tag_event.php index 7192edec..47391355 100644 --- a/modules/tag/helpers/tag_event.php +++ b/modules/tag/helpers/tag_event.php @@ -54,7 +54,7 @@ class tag_event_Core { "AND `id` IN (SELECT `tag_id` from `items_tags` WHERE `item_id` = $item->id)"); $db->query("DELETE FROM `tags` WHERE `count` = 0 AND `id` IN (" . "SELECT `tag_id` from `items_tags` WHERE `item_id` = $item->id)"); - $db->query("DELETE FROM `items_tags` WHERE `item_id` = $item->id;"); + $db->delete("items_tags", array("item_id" => "$item->id")); } } |