Ejemplo n.º 1
0
    $ilDB->manipulate("INSERT INTO rbac_ta " . "(typ_id, ops_id) VALUES (" . $ilDB->quote($typ_id, "integer") . "," . $ilDB->quote(3, "integer") . ")");
    $ilDB->manipulate("INSERT INTO rbac_ta " . "(typ_id, ops_id) VALUES (" . $ilDB->quote($typ_id, "integer") . "," . $ilDB->quote(4, "integer") . ")");
}
?>
<#3379>
<?php 
$setting = new ilSetting();
$sk_step = (int) $setting->get('sk_db');
if ($sk_step <= 4) {
    // add skill tree and root node
    $nid = $ilDB->nextId("skl_tree_node");
    $ilDB->manipulate("INSERT INTO skl_tree_node " . "(obj_id, type, title, create_date) VALUES (" . $ilDB->quote($nid, "integer") . "," . $ilDB->quote("skrt", "text") . "," . $ilDB->quote("Skill Tree Root Node", "text") . "," . $ilDB->now() . ")");
    $skill_tree = new ilTree(1);
    $skill_tree->setTreeTablePK("skl_tree_id");
    $skill_tree->setTableNames('skl_tree', 'skl_tree_node');
    $skill_tree->addTree(1, $nid);
}
?>
<#3380>
<?php 
$setting = new ilSetting();
$sk_step = (int) $setting->get('sk_db');
if ($sk_step <= 6) {
    $fields = array('id' => array('type' => 'integer', 'length' => 4, 'notnull' => true), 'skill_id' => array('type' => 'integer', 'length' => 4, 'notnull' => true), 'nr' => array('type' => 'integer', 'length' => 2, 'notnull' => true), 'title' => array('type' => 'text', 'length' => 200, 'notnull' => false), 'description' => array('type' => 'clob'));
    $ilDB->createTable('skl_level', $fields);
    $ilDB->createSequence('skl_level');
    $ilDB->addPrimaryKey("skl_level", array("id"));
}
?>
<#3381>
<?php