class.ilDidacticTemplateObjSettings.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilDidacticTemplateObjSettings
{
 
        public static function lookupTemplateId($a_ref_id)
        {
                global $ilDB;
 
                $query = 'SELECT tpl_id FROM didactic_tpl_objs '.
                        'WHERE ref_id = '.$ilDB->quote($a_ref_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->tpl_id;
                }
                return 0;
        }
 
 
        public static function deleteByObjId($a_obj_id)
        {
                global $ilDB;
 
                $query = 'DELETE FROM didactic_tpl_objs '.
                        'WHERE obj_id = '.$ilDB->quote($a_obj_id,'integer');
                $ilDB->manipulate($query);
                return true;
        }
 
        public static function deleteByTemplateId($a_tpl_id)
        {
                global $ilDB;
 
                $query = 'DELETE FROM didactic_tpl_objs '.
                        'WHERE tpl_id = '.$ilDB->quote($a_tpl_id,'integer');
                $ilDB->manipulate($query);
                return true;
        }
 
        public static function deleteByRefId($a_ref_id)
        {
                global $ilDB;
 
                $query = 'DELETE FROM didactic_tpl_objs '.
                        'WHERE ref_id = '.$ilDB->quote($a_ref_id,'integer');
                $ilDB->manipulate($query);
        }
 
        public static function assignTemplate($a_ref_id,$a_obj_id,$a_tpl_id)
        {
                global $ilDB;
 
                self::deleteByRefId($a_ref_id);
 
                $query = 'INSERT INTO didactic_tpl_objs (ref_id,obj_id,tpl_id) '.
                        'VALUES ( '.
                        $ilDB->quote($a_ref_id,'integer').', '.
                        $ilDB->quote($a_obj_id,'integer').', '.
                        $ilDB->quote($a_tpl_id,'integer').' '.
                        ')';
                $ilDB->manipulate($query);
                return true;
        }
 
}
?>