diff options
| -rw-r--r-- | core/models/item.php | 7 | ||||
| -rw-r--r-- | modules/tag/helpers/tag_installer.php | 17 | ||||
| -rw-r--r-- | modules/tag/models/tag.php | 25 |
3 files changed, 49 insertions, 0 deletions
diff --git a/core/models/item.php b/core/models/item.php index 4481a3a9..ba759c2b 100644 --- a/core/models/item.php +++ b/core/models/item.php @@ -21,6 +21,13 @@ class Item_Model extends ORM_MPTT { protected $children = 'items'; protected $has_one = array("owner" => "user"); + function __construct($id=null) { + parent::__construct($id); + if (!in_array("tags", $this->has_and_belongs_to_many) && module::is_installed("tag")) { + $this->has_and_belongs_to_many[] = "tags"; + } + } + /** * Is this item an album? * @return true if it's an album diff --git a/modules/tag/helpers/tag_installer.php b/modules/tag/helpers/tag_installer.php index 03823ff3..7c10be97 100644 --- a/modules/tag/helpers/tag_installer.php +++ b/modules/tag/helpers/tag_installer.php @@ -20,14 +20,31 @@ class tag_installer { public static function install() { Kohana::log("debug", "tag_installer::install"); + $db = Database::instance(); $version = module::get_version("tags"); Kohana::log("debug", "tag: $version"); if ($version == 0) { + $db->query("CREATE TABLE IF NOT EXISTS `tags` ( + `id` int(9) NOT NULL auto_increment, + `tag_text` varchar(255) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY(`display_name`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8;"); + + $db->query("CREATE TABLE IF NOT EXISTS `items_tags` ( + `item_id` int(9) NOT NULL, + `tag_id` int(9) NOT NULL, + PRIMARY KEY (`item_id`, `tag_id`), + UNIQUE KEY(`tag_id`, `item_id`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8;"); module::set_version("tag", 1); } } public static function uninstall() { + $db = Database::instance(); + $db->query("DROP TABLE IF EXISTS `tags`;"); + $db->query("DROP TABLE IF EXISTS `items_tags`;"); module::delete("tag"); } } diff --git a/modules/tag/models/tag.php b/modules/tag/models/tag.php new file mode 100644 index 00000000..0bf85843 --- /dev/null +++ b/modules/tag/models/tag.php @@ -0,0 +1,25 @@ +<?php defined("SYSPATH") or die("No direct script access."); +/** + * Gallery - a web based photo album viewer and editor + * Copyright (C) 2000-2008 Bharat Mediratta + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or (at + * your option) any later version. + * + * This program is distributed in the hope that it will be useful, but + * WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA 02110-1301, USA. + */ +class Tag_Model extends ORM { + protected $has_and_belongs_to_many = array("items"); + + var $rules = array( + "name" => "required|length[4,32]"); +}
\ No newline at end of file |