class.multimediaTag.php

Vai alla documentazione di questo file.

<?php
class multimediaTag extends propertyObject {

        private $_controller;
        public static $_tbl_tag = "multimedia_tag";
        
        function __construct($id, $instance) {
                
                $this->_controller = $instance;
                $this->_tbl_data = self::$_tbl_tag;
                
                $this->_fields_label = array(
                        'name'=>_("Nome")
                );
                
                parent::__construct($id);
                
                $this->_model_label = $this->id ? $this->name : '';
        }

        public static function getAllList($instance, $options) {

                $db = db::instance();

                $res = array();
                $rows = $db->select(array('id', 'name'), self::$_tbl_tag, "instance='$instance'", 'name', null);
                if(count($rows)) {
                        foreach($rows as $row) {
                                if(gOpt('jsescape', $options, false)) {
                                        $name = jsVar($row['name']);
                                }
                                else {
                                        $name = htmlChars($row['name']);
                                }
                                $res[$row['id']] = $name;
                        }
                }

                return $res;
                
        }

        public static function saveTag($instance, $tag) {

                $db = db::instance();

                if($tag == '') return null;

                $rows = $db->select('id', self::$_tbl_tag, "instance='$instance' AND name='$tag'", null);
                if(count($rows) and $rows) {
                        return $rows[0]['id'];
                }
                else {
                        $query = "INSERT INTO ".self::$_tbl_tag." (instance, name) VALUES ('$instance', '$tag')";
                        $res = $db->actionquery($query);
                        return $db->getlastid(self::$_tbl_tag);
                }

        }
        
}

?>