class.ilECSCommunityCache.php

Go to the documentation of this file.

<?php
class ilECSCommunityCache
{
        protected static $instance = null;
 
        protected $sid = 0;
        protected $cid = 0;
        protected $own_id = 0;
        protected $cname = '';
        protected $mids = array();
 
        protected $entryExists = false;
        
 
        protected function __construct($sid,$cid)
        {
                $this->sid = $sid;
                $this->cid = $cid;
 
                $this->read();
        }
 
        public static function getInstance($a_sid,$a_cid)
        {
                if(isset(self::$instance[$a_sid][$a_cid]))
                {
                        return self::$instance[$a_sid][$a_cid];
                }
                return self::$instance[$a_sid][$a_cid] = new ilECSCommunityCache($a_sid, $a_cid);
        }
 
 
 
        public function getServerId()
        {
                return $this->sid;
        }
 
        public function getCommunityId()
        {
                return $this->cid;
        }
 
        public function setOwnId($a_id)
        {
                $this->own_id = $a_id;
        }
 
        public function getOwnId()
        {
                return $this->own_id;
        }
 
        public function setCommunityName($a_name)
        {
                $this->cname = $a_name;
        }
 
        public function getCommunityName()
        {
                return $this->cname;
        }
 
        public function setMids($a_mids)
        {
                $this->mids = $a_mids;
        }
 
        public function getMids()
        {
                return $this->mids;
        }
 
        public function update()
        {
                global $ilDB;
 
                if(!$this->entryExists)
                {
                        return $this->create();
                }
 
                $query = 'UPDATE ecs_community '.
                        'SET own_id = '.$ilDB->quote($this->getOwnId(),'integer').', '.
                        'cname = '.$ilDB->quote($this->getCommunityName(),'text').', '.
                        'mids = '.$ilDB->quote(serialize($this->getMids()),'text').' '.
                        'WHERE sid = '.$ilDB->quote($this->getServerId(),'integer').' '.
                        'AND cid = '.$ilDB->quote($this->getCommunityId(),'integer');
                $ilDB->manipulate($query);
                return true;
        }
 
 
 
        protected function create()
        {
                global $ilDB;
 
                $query = 'INSERT INTO ecs_community (sid,cid,own_id,cname,mids) '.
                        'VALUES( '.
                        $ilDB->quote($this->getServerId(),'integer').', '.
                        $ilDB->quote($this->getCommunityId(),'integer').', '.
                        $ilDB->quote($this->getOwnId(),'integer').', '.
                        $ilDB->quote($this->getCommunityName(), 'text').', '.
                        $ilDB->quote(serialize($this->getMids()),'text').' '.
                        ')';
                $ilDB->manipulate($query);
                return true;
        }
 
        protected function read()
        {
                global $ilDB;
 
                $this->entryExists = false;
 
                $query = 'SELECT * FROM ecs_community '.
                        'WHERE sid = '.$ilDB->quote($this->getServerId(),'integer').' '.
                        'AND cid = '.$ilDB->quote($this->getCommunityId(),'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->entryExists = true;
                        $this->setOwnId($row->own_id);
                        $this->setCommunityName($row->cname);
                        $this->setMids(unserialize($row->mids));
                }
                return true;
        }
        
        public static function deleteByServerId($a_server_id)
        {
                global $ilDB;
 
                $query = 'DELETE FROM ecs_community'.
                        ' WHERE sid = '.$ilDB->quote($a_server_id,'integer');
                $ilDB->manipulate($query);
                return true;
        }
}
?>