/** * Create a category for a new object (crs,grp, ...) * * @access public * @param object ilias object ('crs','grp',...) * @static */ public static function createCategory($a_obj) { global $lng; include_once './Services/Calendar/classes/class.ilCalendarCategory.php'; include_once './Services/Calendar/classes/class.ilCalendarAppointmentColors.php'; $cat = new ilCalendarCategory(); $cat->setTitle($a_obj->getTitle() ? $a_obj->getTitle() : $lng->txt('obj_' . $a_obj->getType())); $cat->setType(ilCalendarCategory::TYPE_OBJ); $cat->setColor(ilCalendarAppointmentColors::_getRandomColorByType($a_obj->getType())); $cat->setObjId($a_obj->getId()); return $cat->add(); }
$wd = getcwd(); global $ilLog; include_once 'Services/Calendar/classes/class.ilCalendarAppointmentColors.php'; // Create missing crs calendars $query = "SELECT obd.obj_id,obd.title,obd.type FROM object_data AS obd " . "LEFT JOIN cal_categories AS cc on obd.obj_id = cc.obj_id AND cc.type = 2 " . "WHERE cc.obj_id IS NULL and obd.type = 'crs' "; $res = $ilDB->query($query); while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) { $color = ilCalendarAppointmentColors::_getRandomColorByType('crs'); $query = "INSERT INTO cal_categories SET " . "obj_id = " . $ilDB->quote($row->obj_id) . ", " . "title = " . $ilDB->quote($row->title) . ", " . "color = '" . $color . "', " . "type = 2"; $ilDB->query($query); } // Create missing grp calendars $query = "SELECT obd.obj_id,obd.title,obd.type FROM object_data AS obd " . "LEFT JOIN cal_categories AS cc on obd.obj_id = cc.obj_id AND cc.type = 2 " . "WHERE cc.obj_id IS NULL and obd.type = 'grp' "; $res = $ilDB->query($query); while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) { $color = ilCalendarAppointmentColors::_getRandomColorByType('grp'); $query = "INSERT INTO cal_categories SET " . "obj_id = " . $ilDB->quote($row->obj_id) . ", " . "title = " . $ilDB->quote($row->title) . ", " . "color = '" . $color . "', " . "type = 2"; $ilDB->query($query); } ?> <#1257> ALTER TABLE il_wiki_data ADD COLUMN introduction TEXT; <#1258> ALTER TABLE mail_saved CHANGE rcp_to rcp_to TEXT NULL DEFAULT NULL , CHANGE rcp_cc rcp_cc TEXT NULL DEFAULT NULL , CHANGE rcp_bcc rcp_bcc TEXT NULL DEFAULT NULL , CHANGE m_type m_type VARCHAR(255) NULL DEFAULT NULL; <#1259> <?php
/** * Create a category for a new object (crs,grp, ...) * * @access public * @param object ilias object ('crs','grp',...) * @static */ public static function createCategory($a_obj, $a_check_existing = false) { global $lng; include_once './Services/Calendar/classes/class.ilCalendarCategory.php'; include_once './Services/Calendar/classes/class.ilCalendarAppointmentColors.php'; // already existing? do update instead if ($a_check_existing && ilCalendarCategory::_getInstanceByObjId($a_obj->getId())) { return self::updateCategory($a_obj); } $cat = new ilCalendarCategory(); $cat->setTitle($a_obj->getTitle() ? $a_obj->getTitle() : $lng->txt('obj_' . $a_obj->getType())); $cat->setType(ilCalendarCategory::TYPE_OBJ); $cat->setColor(ilCalendarAppointmentColors::_getRandomColorByType($a_obj->getType())); $cat->setObjId($a_obj->getId()); return $cat->add(); }