$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