{

/**

const INVALID_ID = 501;

/**

const UNIT_NOT_EXISTS = 502;

/**

const CANNOT_INSERT_UNIT = 503;

/**

const PROJECT_NOT_EXISTS = 504;

/**

const INVALID_LOGIN = 505;

/**

const INVALID_SCORE = 506;

/**

const INVALID_DATA = 507;

/**

const DATABASE_ERROR = 508;

/**

const UNSUPPORTED_CONTENT = 509;

/**

const GENERAL_ERROR = 599;

{

/**

const MAXIMUM_NAME_LENGTH = 40;

const COMPLETION_OPTIONS_DEFAULT = 0;

const COMPLETION_OPTIONS_AUTOCOMPLETE = 1;

const COMPLETION_OPTIONS_COMPLETEWITHQUESTION = 2;

const COMPLETION_OPTIONS_COMPLETEAFTERSECONDS = 3;

const COMPLETION_OPTIONS_HIDECOMPLETEUNITICON = 4;

/**

function __construct($array) {

if (!is_array($array)) {

if (eF_checkParameter($array, 'id')) {

$result = eF_getTableData("content", "*", "id=$array");

if (sizeof($result) == 0) {

throw new EfrontContentException(_UNITDOESNOTEXIST.": $array", EfrontContentException :: UNIT_NOT_EXISTS);

} else {

$array = $result[0];

}

} else {

throw new EfrontContentException(_INVALIDID.": $array", EfrontContentException :: INVALID_ID);

}

}

if (G_VERSIONTYPE != 'community') { #cpp#ifndef COMMUNITY

if (G_VERSIONTYPE != 'standard') { #cpp#ifndef STANDARD

//SCORM 2004 If SCORM 2004 content add the appropriate information to the unit object

$scorm2004 = in_array($array['scorm_version'], EfrontContentTreeSCORM :: $scorm2004Versions);

if ($scorm2004 && !in_array('package_ID', array_keys($array))) {

//pr(array_keys($array));

$array = $this -> convertToScorm($array);

}

} #cpp#endif

} #cpp#endif

//pr($array['options']);exit;

if (unserialize($array['options'])) {

$array['options'] = unserialize($array['options']);

} else {

$array['options'] = false;

}

$persist = false;

if (is_array($array['options']) && (isset($array['options']['hide_complete_unit']) || isset($array['options']['auto_complete']) || isset($array['options']['questions']))) { //ugprade from 3.6.9

$array['options'] = $this->upgradeUnitOptions($array['options']);

$persist = true;

}

parent :: __construct($array);

if ($persist) {

$this->persist();

}

}

private function upgradeUnitOptions($options) {

$newOptions = $options;

if ($newOptions['complete_question'] && $newOptions['questions']) {

$newOptions['complete_unit_setting'] = self::COMPLETION_OPTIONS_COMPLETEWITHQUESTION;

$newOptions['complete_question'] = $newOptions['questions'];

} else if ($newOptions['complete_question'] && $newOptions['complete_question']) {

$newOptions['complete_unit_setting'] = self::COMPLETION_OPTIONS_COMPLETEWITHQUESTION;

$newOptions['complete_question'] = $newOptions['complete_question'];

} else if ($newOptions['auto_complete']) {

$newOptions['complete_unit_setting'] = self::COMPLETION_OPTIONS_AUTOCOMPLETE;

} else if ($newOptions['hide_complete_unit']) {

$newOptions['complete_unit_setting'] = self::COMPLETION_OPTIONS_HIDECOMPLETEUNITICON;

} else {

$newOptions['complete_unit_setting'] = self::COMPLETION_OPTIONS_DEFAULT;

}

if (isset($newOptions['hide_complete_unit'])) {

unset($newOptions['hide_complete_unit']);

}

if (isset($newOptions['auto_complete'])) {

unset($newOptions['auto_complete']);

}

if (isset($newOptions['questions'])) {

unset($newOptions['questions']);

}

return $newOptions;

}

/**

public function convertToScorm($array) {

$result = eF_getTableData("scorm_sequencing_content_to_organization as c, scorm_sequencing_organizations as o", "*", "c.content_ID=".$array['id']." AND c.organization_content_ID = o.content_ID");

$array['package_ID'] = $result[0]['content_ID'];

$array['objectives_global_to_system'] = $result[0]['objectives_global_to_system'];

$array['shared_data_global_to_system'] = $result[0]['shared_data_global_to_system'];

$result = eF_getTableData("scorm_sequencing_control_mode", "*", "content_ID=".$array['id']);

if (!empty($result)) {

$array = array_merge($array, $result[0]);

}

$result = eF_getTableData("scorm_sequencing_constrained_choice", "*", "content_ID=".$array['id']);

if (!empty($result)) {

$array = array_merge($array, $result[0]);

}

$result = eF_getTableData("scorm_sequencing_completion_threshold", "*", "content_ID=".$array['id']);

if (!empty($result)) {

$array = array_merge($array, $result[0]);

}

$result = eF_getTableData("scorm_sequencing_delivery_controls", "*", "content_ID=".$array['id']);

if (!empty($result)) {

$array = array_merge($array, $result[0]);

}

$result = eF_getTableData("scorm_sequencing_hide_lms_ui", "*", "content_ID=".$array['id']);

if (!empty($result)) {

$array['hide_lms_ui'] = unserialize($result[0]['options']);

} else {

$array['hide_lms_ui'] = false;

}

$limit_condition = eF_getTableData("scorm_sequencing_limit_conditions", "*", "content_ID = '".$array['id']."'");

if (empty($limit_condition)) {

$array['limit_condition_attempt_control'] = 'false';

} else {

$array['limit_condition_attempt_control'] = 'true';

$array = array_merge($array, $limit_condition[0]);

}

$result = eF_getTableData("scorm_sequencing_rollup_considerations", "*", "content_ID = '".$array['id']."'");

if (!empty($result)) {

$array = array_merge($array, $result[0]);

}

$result = eF_getTableData("scorm_sequencing_rollup_controls", "*", "content_ID = '".$array['id']."'");

if (!empty($result)) {

$array = array_merge($array, $result[0]);

}

//SCORM 2004 Rollup rules

$result = eF_getTableData("scorm_sequencing_rollup_rules", "*", "content_ID = ".$array['id']);

$array['rollup_rules'] = $result;

foreach ($result as $key => $value) {

$result = eF_getTableData("scorm_sequencing_rollup_rule", "*", "scorm_sequencing_rollup_rules_ID = ".$value['id']);

$array['rollup_rules'][$key]['rollup_rule'] = $result;

}

//SCORM 2004 Rules

$result = eF_getTableData("scorm_sequencing_rules", "*", "content_ID = ".$array['id']);

$array['rules'] = $result;

foreach ($result as $key => $value) {

$result = eF_getTableData("scorm_sequencing_rule", "*", "scorm_sequencing_rules_ID = ".$value['id']);

$array['rules'][$key]['rule'] = $result;

}

return $array;

}

/**

public function persist() {

$fields = array('name' => $this['name'],

'data' => $this['data'],

'parent_content_ID' => $this['parent_content_ID'],

'lessons_ID' => $this['lessons_ID'],

'timestamp' => $this['timestamp'],

'ctg_type' => $this['ctg_type'],

'active' => $this['active'],

'linked_to' => $this['linked_to'],

'previous_content_ID' => $this['previous_content_ID'],

'options' => !is_array($this['options']) && $this['options'] ? $this['options'] : serialize($this['options']),

'metadata' => $this['metadata']);

//The special string efront#special#text is used in order to remove the (heavy) content from the nodes when traversing it. However,

//there is a chance that the tree traversal persists values as well. So, using this special string, we know that we must not

//alter the content

if ($this['data'] == 'efront#special#text') {

unset($fields['data']);

}

EfrontEvent::triggerEvent(array("type" => EfrontEvent::CONTENT_MODIFICATION, "lessons_ID" => $this['lessons_ID'], "entity_ID" => $this['id'], "entity_name" => $this['name']));

eF_updateTableData("content", $fields, "id=".$this['id']);

$result = eF_getTableData("content", "id", "linked_to={$this['id']}");

foreach ($result as $value) {

eF_updateTableData("content", array('name' => $this['name'], 'data' => $this['data'], 'ctg_type' => $this['ctg_type'], 'metadata' => $this['metadata']), "id={$value['id']}");

}

return true;

}

/**

public function setSearchKeywords() {

EfrontSearch :: removeText('content', $this['id'], 'data'); //Refresh the search keywords

EfrontSearch :: insertText($this['data'], $this['id'], "content", "data");

EfrontSearch :: removeText('content', $this['id'], 'title'); //Refresh the search keywords

EfrontSearch :: insertText($this['name'], $this['id'], "content", "title");

}

/**

public function delete() {

if ($this['ctg_type'] == 'tests' || $this['ctg_type'] == 'feedback') {

$result = eF_getTableData("tests", "id, content_ID", "content_ID=".$this['id']);

if (sizeof($result) > 0) {

$test = new EfrontTest($result[0]);

$test -> delete();

}

}

$result = eF_getTableData("lesson_conditions", "*", "lessons_ID=".$this['lessons_ID']);

foreach ($result as $value) {

$conditionOptions = unserialize($value['options']);

if (($value['type'] == 'specific_unit' || $condition['type'] == 'specific_test') && $conditionOptions[0] == $this['id']) {

eF_deleteTableData("lesson_conditions", "id=".$value['id']);

}

}

eF_deleteTableData("content", "id=".$this['id']); //Delete Unit from database

eF_deleteTableData("scorm_data", "content_ID=".$this['id']); //Delete Unit from scorm_data

eF_deleteTableData("comments", "content_ID=".$this['id']); //Delete comments of this unit

eF_deleteTableData("users_to_content", "content_ID=".$this['id']); //Delete time data for the unit

eF_deleteTableData("rules", "content_ID=".$this['id']." OR rule_content_ID=".$this['id']); //Delete rules associated with this unit

eF_updateTableData("questions", array("content_ID" => 0), "content_ID=".$this['id']); //Remove association of questions with this unit but not delete them

EfrontSearch :: removeText('content', $this['id'], ''); //Delete keywords

//Delete scorm data related to the unit

if (G_VERSIONTYPE != 'community') { #cpp#ifndef COMMUNITY

if (G_VERSIONTYPE != 'standard') { #cpp#ifndef STANDARD

EfrontContentTreeSCORM :: deleteSCORMContentOrganization($this['id']);

} #cpp#endif

} #cpp#endif

}

/**

public function activate() {

$this['active'] = 1;

$this -> persist();

if ($this['ctg_type'] == 'tests') {

$result = eF_getTableData("tests", "id", "content_ID=".$this['id']);

if (sizeof($result) > 0) {

$test = new EfrontTest($result[0]['id']);

if (!$test -> test['active']) {

$test -> activate();

}

}

}

}

/**

public function deactivate() {

if ($this['ctg_type'] == 'tests') {

$result = eF_getTableData("tests", "id", "content_ID=".$this['id']);

if (sizeof($result) > 0) {

$test = new EfrontTest($result[0]['id']);

if ($test -> test['active']) {

$test -> deactivate();

}

}

}

$this['active'] = 0;

$this -> persist();

}

/**

public function getQuestions($returnObjects = false) {

$questions = array();

$result = eF_getTableData("questions", "*", "content_ID=".$this['id']);

if (sizeof($result) > 0) {

foreach ($result as $value) {

$returnObjects ? $questions[$value['id']] = QuestionFactory :: factory($value) : $questions[$value['id']] = $value;

}

}

return $questions;

}

/**

public function isTest(){

if (parent::offsetGet('ctg_type') == "tests"){

return true;

}

else{

return false;

}

}

public function toXML(){

$xml = '<?xml version="1.0" encoding="UTF-8"?>' ."\n";

$xml .= "\t" . '<unit>';

$xml .= "\t\t<name>".parent::offsetGet('name')."</name>\n";

$xml .= "\t\t<ctg_type>".parent::offsetGet('ctg_type')."</ctg_type>\n";

$xml .= "\t</unit>";

return $xml;

}

public function fromXML($xmlstr){

$xml = new SimpleXMLElement($xmlstr);

parent::offsetSet('name', (string)$xml->unit->name);

parent::offsetSet('ctg_type', (string)$xml->unit->ctg_type);

}

/**

public function getPrerequisite(){

if (parent::offsetGet('previous_content_ID') != "0"){

return parent::offsetGet('previous_content_ID');

}

else

return false;

}

/**

public function getFiles($returnObjects = false) {

$files = array();

$data = parent :: offsetGet('data');

preg_match_all("/view_file\.php\?file=(\d+)/", $data, $matchesId);

$filesId = $matchesId[1];

preg_match_all("#(".G_SERVERNAME.")*content/lessons/(.*)\"#U", $data, $matchesPath);

$filesPath = $matchesPath[2];

try {

foreach ($filesId as $file) {

$file = trim($file, "';");

$returnObjects ? $files[] = new EfrontFile($file) : $files[] = $file;

}

foreach ($filesPath as $file) {

$returnObjects ? $files[] = new EfrontFile(G_LESSONSPATH.html_entity_decode(urldecode($file))) : $files[] = G_LESSONSPATH.html_entity_decode(urldecode($file));

}

} catch (Exception $e) {

//don't halt for non-existing files

}

return $files;

}

/**

public static function createUnit($fields = array()) {

if (!isset($fields['lessons_ID'])) {

return false;

}

!isset($fields['name']) ? $fields['name'] = 'Default unit' : null;

!isset($fields['timestamp']) ? $fields['timestamp'] = time() : null;

!isset($fields['ctg_type']) ? $fields['ctg_type'] = 'theory' : null;

if (!isset($fields['metadata'])) {

$defaultMetadata = array('title' => $fields['name'],

'creator' => $GLOBALS['currentUser'] -> user['name'].' '.$GLOBALS['currentUser'] -> user['surname'],

'publisher' => $GLOBALS['currentUser'] -> user['name'].' '.$GLOBALS['currentUser'] -> user['surname'],

'contributor' => $GLOBALS['currentUser'] -> user['name'].' '.$GLOBALS['currentUser'] -> user['surname'],

'date' => date("Y/m/d", $fields['timestamp']),

'type' => 'content');

$fields['metadata'] = serialize($defaultMetadata);

}

$newId = eF_insertTableData("content", $fields);

$result = eF_getTableData("content", "*", "id=".$newId); //We perform an extra step/query for retrieving data, sinve this way we make sure that the array fields will be in correct order (forst id, then name, etc)

$unit = new EfrontUnit($result[0]);

EfrontSearch :: insertText(htmlspecialchars($fields['name'], ENT_QUOTES), $unit['id'], "content", "title");

EfrontEvent::triggerEvent(array("type" => EfrontEvent::CONTENT_CREATION, "lessons_ID" => $fields['lessons_ID'], "entity_ID" => $unit['id'], "entity_name" => $fields['name']));

return $unit;

}

{

/**

public $lessonId = 0;

/**

protected $rules = false;

/**

public static $scorm2004Versions = array('CAM 1.3' , '2004 3rd Edition', '2004 4th Edition');

/**

function __construct($lesson, $data = false) {

if ($lesson instanceof EfrontLesson) {

$lessonId = $lesson -> lesson['id'];

} elseif (!eF_checkParameter($lesson, 'id')) {

throw new EfrontContentException(_INVALIDLESSONID.': '.$lesson, EfrontContentException :: INVALID_ID);

} else {

$lessonId = $lesson;

}

$this -> lessonId = $lessonId; //Set the lesson id

$this -> data = $data; //Is used in reset()

$this -> reset(); //Initialize content tree

$firstUnit = $this -> getFirstNode();

$this -> currentUnitId = $firstUnit['id'];

}

/**

public function reset() {

if ($this -> data) {

$result = eF_getTableData("content", "*, data != '' as has_data", "lessons_ID = '".$this -> lessonId."'");

} else {

$fields = eF_getTableFields("content");

unset($fields[array_search('data', $fields)]);

$result = eF_getTableData("content", implode(",", $fields).", data != '' as has_data", "lessons_ID = '".$this -> lessonId."'");

}

if (sizeof($result) == 0) {

$this -> tree = new RecursiveArrayIterator(array());

return;

}

$scorm2004Units = array();

$units = array();

foreach ($result as $unit) {

$units[$unit['id']] = $unit;

if (G_VERSIONTYPE != 'community') { #cpp#ifndef COMMUNITY

if (G_VERSIONTYPE != 'standard') { #cpp#ifndef STANDARD

if (in_array($unit['scorm_version'], EfrontContentTreeSCORM :: $scorm2004Versions)) {

$scorm2004Units[] = $unit['id'];

}

} #cpp#endif

} #cpp#endif

}

if (!empty($scorm2004Units)) {

$units = $this -> convertUnitsTo2004($units, $scorm2004Units);

}

//$units = eF_getTableData("content", "id,name,parent_content_ID,lessons_ID,timestamp,ctg_type,active,previous_content_ID", "lessons_ID = '".$this -> lessonId."'");

$rejected = array();

foreach ($units as $node) { //Assign previous content ids as keys to the previousNodes array, which will be used for sorting afterwards

if (!$this -> data) {

$node['has_data'] ? $node['data'] = 'efront#special#text' : $node['data'] = ''; //Eliminate with 'efront#special#text' data for units that don't have any content, and set an empty space ' ' for units that have content. This is done so that the toHTML can handle differently the ones from the others. The efront#special#text is checked by persist() in order to leave data unchanged in case we are updating

}

$node = new EfrontUnit($node); //We convert arrays to array objects, which is best for manipulating data through iterators

if (!isset($previousNodes[$node['previous_content_ID']])) {

$previousNodes[$node['previous_content_ID']] = $node;

} else {

$rejected[$node['id']] = $node; //$rejected holds cut off units, which do not have a valid previous_content_ID

}

}

$node = 0;

$count = 0;

$nodes = array(); //$count is used to prevent infinite loops

while (sizeof($previousNodes) > 0 && isset($previousNodes[$node]) && $count++ < 10000) { //Order the nodes array according to previous_content_ID information. if $previousNodes[$node] is not set, it means that there are illegal previous content id entries in the array (for example, a unit reports as previous a non-existent unit). In this case, all the remaining units in the $previousNodes array are rejected

$nodes[$previousNodes[$node]['id']] = $previousNodes[$node]; //Assign the previous node to be the array key

$newNode = $previousNodes[$node]['id'];

unset($previousNodes[$node]);

$node = $newNode;

}

if (sizeof($previousNodes) > 0) { //If $previousNodes is not empty, it means there are invalid (orphan) units in the array, so append them to the $rejected list

foreach ($previousNodes as $value) {

$rejected[$value['id']] = $value;

}

}

$tree = $nodes;

$count = 0; //$count is used to prevent infinite loops

while (sizeof($tree) > 1 && $count++ < 50000) { //We will merge all branches under the main tree branch, the 0 node, so its size will become 1

foreach ($nodes as $key => $value) {

if ($value['parent_content_ID'] == 0 || in_array($value['parent_content_ID'], array_keys($nodes))) { //If the unit parent is in the $nodes array keys - which are the unit ids- or it is 0, then it is valid

$parentNodes[$value['parent_content_ID']][] = $value; //Find which nodes have children and assign them to $parentNodes

$tree[$value['parent_content_ID']][$value['id']] = array(); //We create the "slots" where the node's children will be inserted. This way, the ordering will not be lost

} else {

$rejected = $rejected + array($value['id'] => $value); //Append units with invalid parents to $rejected list

unset($nodes[$key]); //Remove the invalid unit from the units array, as well as from the parentUnits, in case a n entry for it was created earlier

unset($parentNodes[$value['parent_content_ID']]);

}

}

if (isset($parentNodes)) { //If the unit was rejected, there won't be a $parentNodes array

$leafNodes = array_diff(array_keys($nodes), array_keys($parentNodes)); //Now, it's easy to see which nodes are leaf nodes, just by subtracting $parentNodes from the whole set

foreach ($leafNodes as $leaf) {

$parent_id = $nodes[$leaf]['parent_content_ID']; //Get the leaf's parent

$tree[$parent_id][$leaf] = $tree[$leaf]; //Append the leaf to its parent's tree branch

unset($tree[$leaf]); //Remove the leaf from the main tree branch

unset($nodes[$leaf]); //Remove the leaf from the nodes set

}

unset($parentNodes); //Reset $parentNodes; new ones will be calculated at the next loop

}

}

if (sizeof($tree) > 0 && !isset($tree[0])) { //This is a special case, where only one node exists in the tree

$tree = array($tree);

}

isset($tree[0]) ? $tree = $tree[0] : $tree = array();

if (sizeof($rejected) > 0) { //Append rejected nodes to the end of the tree array, updating their parent/previous information

foreach (new EfrontNodeFilterIterator(new RecursiveIteratorIterator(new RecursiveArrayIterator($tree), RecursiveIteratorIterator :: SELF_FIRST)) as $lastUnit); //Advance to the last tree node

isset($lastUnit) ? $previousId = $lastUnit['id'] : $previousId = 0; //There is a chance that no normal units exist in the tree. In this case, there will be no $lastUnit

foreach ($rejected as $id => $node) { //Update broken nodes

$node['parent_content_ID'] = 0;

$node['previous_content_ID'] = $previousId;

$node -> persist(); //Persist changes to the database

$tree[$id] = $node;

$previousId = $id;

}

}

$this -> tree = new RecursiveArrayIterator($tree);

//Create arrays for assigning the immediate children and the parents of each unit. These will come especially handy for SCORM 2004 calculations

$this -> immediateDescendants = array();

$this -> nodeParents = array();

foreach (new EfrontNodeFilterIterator(new RecursiveIteratorIterator(new RecursiveArrayIterator($tree), RecursiveIteratorIterator :: SELF_FIRST)) as $key => $value) {

foreach(array_keys((array)$value) as $member) {

!is_numeric($member) OR $this -> immediateDescendants[$key][] = $member;

}

if (isset($this -> nodeParents[$value['parent_content_ID']]) && $this -> nodeParents[$value['parent_content_ID']]) {

$this -> nodeParents[$key] = array_merge(array($value['parent_content_ID']), $this -> nodeParents[$value['parent_content_ID']]);

} else {

$this -> nodeParents[$key] = array($value['parent_content_ID']);

}

}

//pr($this -> nodeParents);

//pr($this -> immediateDescendants);

}

public function convertUnitsTo2004($units, $scorm2004Units) {

$scormContentIds = implode(",", $scorm2004Units);

$result = eF_getTableData("scorm_sequencing_content_to_organization as c, scorm_sequencing_organizations as o", "c.content_ID, c.organization_content_ID, o.objectives_global_to_system, o.shared_data_global_to_system", "c.content_ID in ($scormContentIds) AND c.organization_content_ID = o.content_ID");

foreach ($result as $value) {

$units[$value['content_ID']]['package_ID'] = $value['organization_content_ID'];

$array['objectives_global_to_system'] = $value['objectives_global_to_system'];

$array['shared_data_global_to_system'] = $value['shared_data_global_to_system'];

}

$result = eF_getTableData("scorm_sequencing_control_mode", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

$result = eF_getTableData("scorm_sequencing_constrained_choice", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

$result = eF_getTableData("scorm_sequencing_completion_threshold", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

$result = eF_getTableData("scorm_sequencing_delivery_controls", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

$result = eF_getTableData("scorm_sequencing_hide_lms_ui", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']]['hide_lms_ui'] = unserialize($value['options']);

}

$result = eF_getTableData("scorm_sequencing_limit_conditions", "*", "content_ID in ($scormContentIds)");

foreach ($scorm2004Units as $value) { //First, assign to every SCORM unit the 'false' for the limit_condition_attempt_control...

$units[$value]['limit_condition_attempt_control'] = 'false';

}

foreach ($result as $value) { //...and then set it to true where applicable

$units[$value['content_ID']]['limit_condition_attempt_control'] = 'true';

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

$result = eF_getTableData("scorm_sequencing_rollup_considerations", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

$result = eF_getTableData("scorm_sequencing_rollup_controls", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $value);

}

//SCORM 2004 Rollup rules

//First get all rollup rules to an array and assign them to each rollup rull group, based on scorm_sequencing_rollup_rules_ID

$allRollupRules = array();

$result = eF_getTableData("scorm_sequencing_rollup_rule", "*");

foreach ($result as $value) {

$allRollupRules[$value['scorm_sequencing_rollup_rules_ID']][] = $value;

}

//Now, asssign the rollup rule and the group to the unit

$result = eF_getTableData("scorm_sequencing_rollup_rules", "*", "content_ID in ($scormContentIds)");

foreach ($result as $value) {

$value['rollup_rule'] = $allRollupRules[$value['id']];

$units[$value['content_ID']]['rollup_rules'][] = $value;

// $units[$value['content_ID']]['rollup_rules']['rollup_rule'] = $allRollupRules[$value['id']];

}

//First get all sequencing rules to an array and assign them to each sequencing rull group, based on scorm_sequencing_rules_ID

$allRules = array();

$result = eF_getTableData("scorm_sequencing_rule", "*");

foreach ($result as $value) {

$allRules[$value['scorm_sequencing_rules_ID']][] = $value;

//$allRollupRules[$value['scorm_sequencing_rollup_rules_ID']][] = array('rollup_rule' => $value);

}

//Now, asssign the sequencing rule and the group to the unit

$result = eF_getTableData("scorm_sequencing_rules", "*", "content_ID in ($scormContentIds)");

foreach ($result as $key => $value) {

$value['rule'] = $allRules[$value['id']];

$units[$value['content_ID']]['rules'][] = $value;

// $units[$value['content_ID']]['rules']['rule'] = $allRules[$value['id']];

// $value['rule'] = $allRules[$value['id']]['rule'];

// $units[$value['content_ID']]['rules'][$key] = $value;

//$units[$value['content_ID']] = array_merge($units[$value['content_ID']], $allRules[$value['id']]);

}

// pr($value);

return $units;

}

/**

public function removeNode($removeId) {

$iterator = new EfrontNodeFilterIterator(new RecursiveIteratorIterator($this -> tree, RecursiveIteratorIterator :: SELF_FIRST)); //Get an iterator for the current tree. This iterator returns only whole unit arrays and not unit members separately (such as id, timestamp etc)

$iterator -> rewind(); //Initialize iterator

while ($iterator -> valid() && $iterator -> key() != $removeId) { //Forward iterator index until you reach the designated element, which has an index equal to the unit id that will be removed

$iterator -> next();

}

if ($iterator -> valid()) {

$iterator -> current() -> delete(); //Delete the current unit from the database

$previousUnit = $this -> getPreviousNode($iterator -> key()); //Get the deleted unit's previous unit

$iterator -> offsetUnset($removeId); //Delete the unit from the content tree

if ($previousUnit) { //If we are deleting the first unit, there is no previous unit

$nextUnit = $this -> getNextNode($previousUnit['id']); //Get the previous unit's next unit, which still points to the old unit

if ($nextUnit) { //If we are deleting the last unit, there is not next unit

$nextUnit['previous_content_ID'] = $previousUnit['id']; //Update the next unit to point at the deleted unit' previous unit

$nextUnit -> persist(); //Persist these changes to the database