Example #1
0
$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);
$tree->insertNode($ref_id, SYSTEM_FOLDER_ID);
?>

<#4032>
<?php 
require_once "./Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php";
$orgu_type_id = ilDBUpdateNewObjectType::getObjectTypeId('orgu');
if ($orgu_type_id) {
    $adm_ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('cat_administrate_users');
    $shw_ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('read_users');
    if ($adm_ops_id && $shw_ops_id) {
        ilDBUpdateNewObjectType::addRBACOperation($orgu_type_id, $adm_ops_id);
        ilDBUpdateNewObjectType::addRBACOperation($orgu_type_id, $shw_ops_id);
    }
}
?>
<#4033>
<?php 
require_once "./Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php";
$orgu_type_id = ilDBUpdateNewObjectType::getObjectTypeId('orgu');
if ($orgu_type_id) {
    $view_lp = ilDBUpdateNewObjectType::addCustomRBACOperation('view_learning_progress', 'View learning progress from users in this orgu.', 'object', 270);
    $view_lp_rec = ilDBUpdateNewObjectType::addCustomRBACOperation('view_learning_progress_rec', 'View learning progress from users in this orgu and subsequent orgus.', 'object', 280);
    if ($view_lp && $view_lp_rec) {
        ilDBUpdateNewObjectType::addRBACOperation($orgu_type_id, $view_lp);
Example #2
0
<#4440>
<?php 
$ilDB->manipulate("UPDATE settings " . "SET value = " . $ilDB->quote(1370, "text") . " WHERE module = " . $ilDB->quote("blga", "text") . " AND keyword = " . $ilDB->quote("banner_width", "text") . " AND value = " . $ilDB->quote(880, "text"));
$ilDB->manipulate("UPDATE settings " . "SET value = " . $ilDB->quote(1370, "text") . " WHERE module = " . $ilDB->quote("prfa", "text") . " AND keyword = " . $ilDB->quote("banner_width", "text") . " AND value = " . $ilDB->quote(880, "text"));
?>
<#4441>
<?php 
include_once './Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php';
$tgt_ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('copy');
if ($tgt_ops_id) {
    $feed_type_id = ilDBUpdateNewObjectType::getObjectTypeId('feed');
    if ($feed_type_id) {
        // add "copy" to (external) feed
        ilDBUpdateNewObjectType::addRBACOperation($feed_type_id, $tgt_ops_id);
        // clone settings from "write" to "copy"
        $src_ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('write');
        ilDBUpdateNewObjectType::cloneOperation('feed', $src_ops_id, $tgt_ops_id);
    }
}
?>
<#4442>
<?php 
$ilCtrlStructureReader->getStructure();
?>
<#4443>
<?php 
$ilCtrlStructureReader->getStructure();
?>
<#4444>
<?php 
$ilCtrlStructureReader->getStructure();
$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);
}
?>
<#3800>
<?php 
$ilCtrlStructureReader->getStructure();
?>
<#3801>
<?php 
include_once './Services/Migration/DBUpdate_3560/classes/class.ilDBUpdateNewObjectType.php';
$ops_id = ilDBUpdateNewObjectType::getCustomRBACOperationId('copy');
ilDBUpdateNewObjectType::deleteRBACOperation('rcat', $ops_id);
?>
<#3802>
<?php 
$ilCtrlStructureReader->getStructure();
?>

<#3803>
<?php 
if (!$ilDB->tableExists('ecs_crs_mapping_atts')) {
    $fields = array('id' => array('notnull' => true, 'length' => 4, 'type' => 'integer'), "sid" => array("notnull" => true, "length" => 4, "type" => "integer"), "mid" => array("notnull" => true, "length" => 4, "type" => "integer"), "name" => array("notnull" => false, 'length' => 64, "type" => "text"));
    $ilDB->createTable("ecs_crs_mapping_atts", $fields);
    $ilDB->createSequence('ecs_crs_mapping_atts');
    $ilDB->addPrimaryKey('ecs_crs_mapping_atts', array('id'));
}