Example #1
0
$ilDB->manipulateF("UPDATE adm_set_templ_value SET setting = %s, value = %s\n\t\t\t\tWHERE setting = %s AND value = %s", array('text', 'text', 'text', 'text'), array('question_set_type', 'RANDOM_QUEST_SET', 'random_test', '1'));
?>
<#4028>
<?php 
$ilCtrlStructureReader->getStructure();
?>
<#4029>
<?php 
$ilDB->manipulateF("UPDATE qpl_questions SET add_cont_edit_mode = %s WHERE add_cont_edit_mode IS NULL", array('text'), array('default'));
?>
<#4030>
<?php 
include_once './Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php';
$orgu_type_id = ilDBUpdateNewObjectType::addNewType('orgu', 'Organisational Unit');
$rbac_ops = array(ilDBUpdateNewObjectType::RBAC_OP_EDIT_PERMISSIONS, ilDBUpdateNewObjectType::RBAC_OP_VISIBLE, ilDBUpdateNewObjectType::RBAC_OP_READ, ilDBUpdateNewObjectType::RBAC_OP_WRITE, ilDBUpdateNewObjectType::RBAC_OP_DELETE, ilDBUpdateNewObjectType::RBAC_OP_COPY);
ilDBUpdateNewObjectType::addRBACOperations($orgu_type_id, $rbac_ops);
$parent_types = array('root', 'orgu');
ilDBUpdateNewObjectType::addRBACCreate('create_orgu', 'Create OrgUnit', $parent_types);
$ilCtrlStructureReader->getStructure();
?>

<#4031>
<?php 
// create object data entry
$id = $ilDB->nextId("object_data");
$ilDB->manipulateF("INSERT INTO object_data (obj_id, type, title, description, owner, create_date, last_update) " . "VALUES (%s, %s, %s, %s, %s, %s, %s)", array("integer", "text", "text", "text", "integer", "timestamp", "timestamp"), array($id, "orgu", "__OrgUnitAdministration", "Organisationsal Units", -1, ilUtil::now(), ilUtil::now()));
// create object reference entry
$ref_id = $ilDB->nextId('object_reference');
$res = $ilDB->manipulateF("INSERT INTO object_reference (ref_id, obj_id) VALUES (%s, %s)", array("integer", "integer"), array($ref_id, $id));
// put in tree
$tree = new ilTree(ROOT_FOLDER_ID);
?>
<#3797>
<?php 
if ($ilDB->tableColumnExists('cmi_objective', 'id')) {
    $ilDB->modifyTableColumn('cmi_objective', 'id', array('type' => 'text', 'length' => 4000, 'notnull' => false, 'default' => null));
}
?>
<#3798>
<?php 
include_once './Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php';
$setting = new ilSetting();
$chtr_perms = $setting->get("ilchtrperms");
if (!$chtr_perms) {
    $type_id = ilDBUpdateNewObjectType::getObjectTypeId('chtr');
    if ($type_id) {
        ilDBUpdateNewObjectType::addRBACOperations($type_id, array(ilDBUpdateNewObjectType::RBAC_OP_DELETE, ilDBUpdateNewObjectType::RBAC_OP_COPY));
    }
    $setting->set("ilchtrperms", 1);
}
?>
<#3799>
<?php 
include_once './Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php';
$grp_type_id = ilDBUpdateNewObjectType::getObjectTypeId('grp');
if ($grp_type_id) {
    $ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('create_crsr');
    ilDBUpdateNewObjectType::addRBACOperation($grp_type_id, $ops_id);
    $ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('create_catr');
    ilDBUpdateNewObjectType::addRBACOperation($grp_type_id, $ops_id);
}
?>