ILIAS  Release_4_3_x_branch Revision 61807
 All Data Structures Namespaces Files Functions Variables Groups Pages
Public Member Functions | Data Fields | Private Member Functions | Private Attributes | Static Private Attributes
ilSCORM13Player Class Reference
+ Collaboration diagram for ilSCORM13Player:

Public Member Functions

 __construct ()
& executeCommand ()
 execute command
 getRTEjs ()
 getDataDirectory ()
 getPlayer ()
 getInlineCSS ()
 Get inline css.
 getCPData ()
 getADLActData ()
 pingSession ()
 scormPlayerUnload ()
 getScope ()
 getSuspendData ()
 suspendADLActData ()
 readGObjective ()
 writeGObjective ($g_data)
 readSharedData ($sco_node_id)
 writeSharedData ($sco_node_id)
 specialPage ()
 fetchCMIData ()
 persistCMIData ($data=null)
 quoteJSONArray ($a_array)
 getMimetype ($filename)
 estimate content type for a filename by extension first do it for common static web files from external list if not found peek into file by slow php function mime_content_type()
 getCookie ()
 getting and setting Scorm2004 cookie Cookie contains enrypted associative array of sahs_lm.id and permission value you may enforce stronger symmetrical encryption by adding RC4 via mcrypt()
 setCookie ($cook)
 readFile ($path)
 Try to find file, identify content type, write it to buffer, and stop immediatly If no file given, read file from PATH_INFO, check permission by cookie, and write out and stop.
 get_max_attempts ()
 Get max.
 get_Module_Version ()
 get_actual_attempts ()
 Get number of actual attempts for the user.
 increase_attempt ()
 Increases attempts by one for this package.
 resetSharedData ()
 save_module_version ()
 save the active module version to scorm_tracking
 getDataDirectory2 ()
 openLog ()
 downloadLog ()
 liveLogContent ()
 debugGUI ()
 postLogEntry ()
 get_last_visited ($a_obj_id, $a_user_id)
 functions for last_visited_sco
 set_last_visited ($a_obj_id, $a_user_id, $last_visited)

Data Fields

const ENABLE_GZIP = 0
const NONE = 0
const READONLY = 1
const WRITEONLY = 2
const READWRITE = 3
 $packageId
 $jsMode
 $ilias
 $slm
 $tpl

Private Member Functions

 normalizeFields ($table, &$node)
 maps API data structure type to internal datatype on a node and accepts only valid values, dropping invalid ones from input
 getCMIData ($userId, $packageId)
 setCMIData ($userId, $packageId, $data)
 getNodeData ($sco_id, $fh)
 logTmpName ()
 summaryFileName ()
 logFileName ()
 logDirectory ()
 getLogFileList ($s_delete, $s_download, $s_open)
 getLogTemplate ()
 getDebugValues ($test_sco=false)
 getStructureFlat ($data)
 createSummary ($api_data)

Private Attributes

 $userId

Static Private Attributes

static $schema

Detailed Description

Author
Hendrik Holtmann holtm.nosp@m.ann@.nosp@m.mac.c.nosp@m.om, Alfred Kohnert alfre.nosp@m.d.ko.nosp@m.hnert.nosp@m.@big.nosp@m.foot..nosp@m.com, Uwe Kohnle kohnl.nosp@m.e@in.nosp@m.terne.nosp@m.tleh.nosp@m.rer-g.nosp@m.mbh..nosp@m.de
Version
$Id$ ilSCORM13Player:

Definition at line 13 of file ilSCORM13Player.php.

Constructor & Destructor Documentation

ilSCORM13Player::__construct ( )

Definition at line 126 of file ilSCORM13Player.php.

References $_GET, $_REQUEST, $GLOBALS, $ilCtrl, $ilias, $ilUser, $lng, $tpl, and ilObject\_lookupObjectId().

{
global $ilias, $tpl, $ilCtrl, $ilUser, $lng;
//erase next?
if ($_REQUEST['learnerId']) {
$this->userId = $_REQUEST['learnerId'];
} else {
$this->userId = $GLOBALS['USER']['usr_id'];
}
$this->packageId = (int) $_REQUEST['packageId'];
$this->jsMode = strpos($_SERVER['HTTP_ACCEPT'], 'text/javascript')!==false;
$this->page = $_REQUEST['page'];
$this->slm =& new ilObjSCORM2004LearningModule($_GET["ref_id"], true);
$this->ilias =& $ilias;
$this->tpl =& $tpl;
$this->ctrl =& $ilCtrl;
$this->packageId=ilObject::_lookupObjectId($_GET['ref_id']);
$this->ref_id = $_GET['ref_id'];
$this->userId=$ilUser->getID();
if ($_GET['envEditor'] != null) {
$this->envEditor = $_GET['envEditor'];
} else {
$this->envEditor = 0;
}
}

+ Here is the call graph for this function:

Member Function Documentation

ilSCORM13Player::createSummary (   $api_data)
private

Definition at line 2532 of file ilSCORM13Player.php.

References $res.

{
global $ilDB;
$csv_data = null;
//csv columns
$columns_fixed = array('id','title','type','attempted');
$ini_data = parse_ini_file("./Modules/Scorm2004/scripts/rtemain/debug_default.ini",true);
$ini_array = $ini_data['summary'];
$colums_variable = array();
$api_keys = array();
foreach ($ini_array as $key => $value) {
if ($value == 1) {
array_push($colums_variable,$key);
array_push($api_keys,$key);
array_push($colums_variable,"Status");
}
}
$header_array = array_merge($columns_fixed, $colums_variable);
$csv_header = implode(";",$header_array);
//get strcuture
$res = $ilDB->queryF(
'SELECT jsdata FROM cp_package WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
$packageData = $ilDB->fetchAssoc($res);
$structure = json_decode($packageData['jsdata'],true);
$this->flat_structure = array(); //used for recursion
$this->getStructureFlat($structure['item']['item']);
foreach ($this->flat_structure as $tree_element) {
$csv_data = $csv_data.$tree_element['id'].";".$tree_element['title'].";".$tree_element['sco'].";";
if ($api_data[$tree_element['id']] != null) {
$csv_data = $csv_data."X".";";
} else {
$csv_data = $csv_data.";";
}
//write api data
$id = $tree_element['id'];
foreach ($api_keys as $api_element) {
if ($api_data[$id]!=null) {
if ($api_data[$id][$api_element]!=null) {
$csv_data = $csv_data.$api_data[$id][$api_element]['value'].";".$api_data[$id][$api_element]['status'].";";
} else {
$csv_data = $csv_data.";;";
}
}
}
$csv_data = $csv_data."\n";
}
$fh = fopen($this->summaryFileName(),"w");
fwrite($fh,$csv_header."\n".$csv_data);
fclose($fh);
unlink($this->logTmpName());
}
ilSCORM13Player::debugGUI ( )

Definition at line 2138 of file ilSCORM13Player.php.

References $lng, ilUtil\getImagePath(), and ilYuiUtil\getLocalPath().

Referenced by executeCommand().

{
global $lng;
$lng->loadLanguageModule("scormdebug");
/* if ($_POST['password'] == $this->slm->getDebugPw()) {
$_SESSION["debug_pw"] = $this->slm->getDebugPw();
}
if ($_SESSION["debug_pw"]!=$this->slm->getDebugPw()) {
$this->tpl = new ilTemplate("tpl.scorm2004.debug_pw.html", false, false, "./Modules/Scorm2004");
$this->tpl->setVariable('SUBMIT', $lng->txt("debugwindow_submit"));
$this->tpl->setVariable('CANCEL', $lng->txt("debugwindow_cancel"));
$this->tpl->setVariable('PASSWORD_ENTER', $lng->txt("debugwindow_password_enter"));
$this->tpl->setVariable('DEBUG_URL','ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=debugGUI&ref_id='.$_GET["ref_id"]);
} else {*/
$this->tpl = new ilTemplate("tpl.scorm2004.debug.html", false, false, "./Modules/Scorm2004");
$this->tpl->setVariable('CONSOLE', $lng->txt("debugwindow_console"));
$this->tpl->setVariable('LOGS', $lng->txt("debugwindow_logs"));
$this->tpl->setVariable('COMMENT', $lng->txt("debugwindow_comment"));
$this->tpl->setVariable('COMMENT_ENTER', $lng->txt("debugwindow_comment_enter"));
$this->tpl->setVariable('START_RECORDING', $lng->txt("debugwindow_start_recording"));
$this->tpl->setVariable('STOP_RECORDING', $lng->txt("debugwindow_stop_recording"));
$this->tpl->setVariable('DELETE_LOGFILE', $lng->txt("debugwindow_delete_logfile"));
$this->tpl->setVariable('SUBMISSION_FAILED', $lng->txt("debugwindow_submission_failed"));
$this->tpl->setVariable('SUBMIT', $lng->txt("debugwindow_submit"));
$this->tpl->setVariable('CANCEL', $lng->txt("debugwindow_cancel"));
$this->tpl->setVariable('FILENAME', $lng->txt("debugwindow_filename"));
$this->tpl->setVariable('DATE', $lng->txt("debugwindow_date"));
$this->tpl->setVariable('ACTION', $lng->txt("debugwindow_action"));
$this->tpl->setVariable('RECORD_IMG', ilUtil::getImagePath("record.png","./Modules/Scorm2004"));
$this->tpl->setVariable('STOP_IMG', ilUtil::getImagePath("stop.png","./Modules/Scorm2004"));
$this->tpl->setVariable('COMMENT_IMG', ilUtil::getImagePath("comment.png","./Modules/Scorm2004"));
$logfile = $this->logFileName().".html";
$this->tpl->setVariable('LOGFILE',$this->logFileName().".html");
$this->tpl->setVariable('FILES_DATA', json_encode($this->getLogFileList($lng->txt("debugwindow_delete"), $lng->txt("debugwindow_download"), $lng->txt("debugwindow_open"))));
// path to latest yui distribution
include_once "Services/YUI/classes/class.ilYuiUtil.php";
$this->tpl->setVariable('PATH_YUI', ilYuiUtil::getLocalPath());
//}
echo $this->tpl->get("DEFAULT", true);
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Player::downloadLog ( )

Definition at line 2088 of file ilSCORM13Player.php.

References $_GET, $filename, and exit.

Referenced by executeCommand().

{
$filename = $_GET['logFile'];
//Header
header("Expires: 0");
header("Cache-Control: private");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: cache");
header("Content-Description: File Transfer");
header("Content-Type: application/octet-stream");
header("Content-disposition: attachment; filename=$filename");
echo file_get_contents($this->logDirectory()."/".$filename);
exit;
}

+ Here is the caller graph for this function:

& ilSCORM13Player::executeCommand ( )

execute command

Definition at line 164 of file ilSCORM13Player.php.

References $_GET, $cmd, $ilias, $ilLog, $ilUser, $lng, debugGUI(), downloadLog(), fetchCMIData(), getADLActData(), getCPData(), getPlayer(), getRTEjs(), getSuspendData(), liveLogContent(), openLog(), persistCMIData(), pingSession(), postLogEntry(), readGObjective(), readSharedData(), scormPlayerUnload(), specialPage(), suspendADLActData(), and writeSharedData().

{
global $ilAccess, $ilLog, $ilUser, $lng, $ilias;
$next_class = $this->ctrl->getNextClass($this);
$cmd = $this->ctrl->getCmd();
if (!$ilAccess->checkAccess("read", "", $_GET["ref_id"]))
{
$ilias->raiseError($lng->txt("permission_denied"), $ilias->error_obj->WARNING);
}
//$ilLog->write("SCORM2004 Player cmd: ".$cmd);
switch($cmd){
case 'getRTEjs':
$this->getRTEjs();
break;
case 'cp':
$this->getCPData();
break;
case 'adlact':
$this->getADLActData();
break;
case 'suspend':
$this->suspendADLActData();
break;
case 'getSuspend':
$this->getSuspendData();
break;
case 'gobjective':
// $this->writeGObjective();
break;
case 'getGobjective':
$this->readGObjective();
break;
case 'getSharedData':
$this->readSharedData($_GET['node_id']);
break;
case 'setSharedData':
$this->writeSharedData($_GET['node_id']);
break;
case 'cmi':
if ($_SERVER['REQUEST_METHOD']=='POST') {
$this->persistCMIData();
//error_log("Saved CMI Data");
} else {
$this->fetchCMIData();
}
break;
case 'specialPage':
$this->specialPage();
break;
case 'debugGUI':
$this->debugGUI();
break;
case 'postLogEntry':
$this->postLogEntry();
break;
case 'liveLogContent':
$this->liveLogContent();
break;
case 'downloadLog':
$this->downloadLog();
break;
case 'openLog':
$this->openLog();
break;
case 'pingSession':
$this->pingSession();
break;
case 'scormPlayerUnload':
$this->scormPlayerUnload();
break;
default:
$this->getPlayer();
break;
}
}

+ Here is the call graph for this function:

ilSCORM13Player::fetchCMIData ( )

Definition at line 1105 of file ilSCORM13Player.php.

References $data.

Referenced by executeCommand().

{
$data = $this->getCMIData($this->userId, $this->packageId);
if ($this->jsMode)
{
header('Content-Type: text/javascript; charset=UTF-8');
print(json_encode($data));
}
else
{
header('Content-Type: text/plain; charset=UTF-8');
print(var_export($data, true));
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::get_actual_attempts ( )

Get number of actual attempts for the user.

Definition at line 1686 of file ilSCORM13Player.php.

References $ilUser, $res, and $row.

Referenced by getPlayer().

{
global $ilDB, $ilUser;
$res = $ilDB->queryF('
SELECT rvalue FROM cmi_custom
WHERE user_id = %s AND sco_id = %s
AND lvalue = %s AND obj_id = %s',
array('integer', 'integer', 'text', 'integer'),
array($this->userId, 0, 'package_attempts', $this->packageId)
);
$row = $ilDB->fetchAssoc($res);
$row['rvalue'] = str_replace("\r\n", "\n", $row['rvalue']);
if($row['rvalue'] == null)
{
$row['rvalue'] = 0;
}
return $row['rvalue'];
}

+ Here is the caller graph for this function:

ilSCORM13Player::get_last_visited (   $a_obj_id,
  $a_user_id 
)

functions for last_visited_sco

Definition at line 2604 of file ilSCORM13Player.php.

Referenced by getPlayer().

{
global $ilDB;
$val_set = $ilDB->queryF('
SELECT rvalue FROM cmi_custom
WHERE user_id = %s
AND sco_id = %s
AND lvalue = %s
AND obj_id = %s',
array('integer','integer', 'text','integer'),
array($a_user_id, 0,'last_visited',$a_obj_id));
$val_rec = $ilDB->fetchAssoc($val_set);
return $val_rec["rvalue"];
}

+ Here is the caller graph for this function:

ilSCORM13Player::get_max_attempts ( )

Get max.

number of attempts allowed for this package

Definition at line 1656 of file ilSCORM13Player.php.

References $res, and $row.

Referenced by getPlayer().

{
global $ilDB;
$res = $ilDB->queryF(
'SELECT max_attempt FROM sahs_lm WHERE id = %s',
array('integer'),
array($this->packageId)
);
$row = $ilDB->fetchAssoc($res);
return $row['max_attempt'];
}

+ Here is the caller graph for this function:

ilSCORM13Player::get_Module_Version ( )

Definition at line 1670 of file ilSCORM13Player.php.

References $res, and $row.

{
global $ilDB;
$res = $ilDB->queryF(
'SELECT module_version FROM sahs_lm WHERE id = %s',
array('integer'),
array($this->packageId));
$row = $ilDB->fetchAssoc($res);
return $row['module_version'];
}
ilSCORM13Player::getADLActData ( )

Definition at line 465 of file ilSCORM13Player.php.

References $data, and $res.

Referenced by executeCommand().

{
global $ilDB;
$res = $ilDB->queryF(
'SELECT activitytree FROM cp_package WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
$data = $ilDB->fetchAssoc($res);
$activitytree = $data['activitytree'];
if(!$activitytree)
{
$activitytree = 'null';
}
if($this->jsMode)
{
header('Content-Type: text/javascript; charset=UTF-8');
print($activitytree);
}
else
{
header('Content-Type: text/plain; charset=UTF-8');
$activitytree = json_decode($activitytree);
print_r($activitytree);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::getCMIData (   $userId,
  $packageId 
)
private

Definition at line 1162 of file ilSCORM13Player.php.

References $res, $result, and $row.

{
global $ilDB;
$i_check=0;
$result = array(
'schema' => array(),
'data' => array()
);
foreach(self::$schema as $k => &$v)
{
$result['schema'][$k] = array_keys($v);
$q = '';
switch ($k)
{
case "node":
$q = 'SELECT cmi_node.*
FROM cmi_node
INNER JOIN cp_node ON cmi_node.cp_node_id = cp_node.cp_node_id
WHERE cmi_node.user_id = %s
AND cp_node.slm_id = %s';
break;
case "comment":
if ($i_check>7) {
$i_check-=8;
if ($this->slm->getComments()) $q = 'SELECT
cmi_comment.cmi_comment_id,
cmi_comment.cmi_node_id,
cmi_comment.c_comment,
cmi_comment.c_timestamp,
cmi_comment.location,
cmi_comment.sourceislms
FROM cmi_comment
INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_comment.cmi_node_id
INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
WHERE cmi_node.user_id = %s
AND cp_node.slm_id = %s
ORDER BY cmi_comment.cmi_comment_id';
}
break;
case "correct_response":
if ($i_check>3) {
$i_check-=4;
if ($this->slm->getInteractions()) $q = 'SELECT cmi_correct_response.*
FROM cmi_correct_response
INNER JOIN cmi_interaction
ON cmi_interaction.cmi_interaction_id = cmi_correct_response.cmi_interaction_id
INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_interaction.cmi_node_id
INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
WHERE cmi_node.user_id = %s
AND cp_node.slm_id = %s
ORDER BY cmi_correct_response.cmi_correct_resp_id';
}
break;
case "interaction":
if ($i_check>1) {
$i_check-=2;
if ($this->slm->getInteractions()) $q = 'SELECT
cmi_interaction.cmi_interaction_id,
cmi_interaction.cmi_node_id,
cmi_interaction.description,
cmi_interaction.id,
cmi_interaction.latency,
cmi_interaction.learner_response,
cmi_interaction.result,
cmi_interaction.c_timestamp,
cmi_interaction.c_type,
cmi_interaction.weighting
FROM cmi_interaction
INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_interaction.cmi_node_id
INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
WHERE cmi_node.user_id = %s
AND cp_node.slm_id = %s
ORDER BY cmi_interaction.cmi_interaction_id';
}
break;
case "objective":
if ($i_check>0) {
if ($this->slm->getObjectives()) $q = 'SELECT
cmi_objective.cmi_interaction_id,
cmi_objective.cmi_node_id,
cmi_objective.cmi_objective_id,
cmi_objective.completion_status,
cmi_objective.description,
cmi_objective.id,
cmi_objective.c_max,
cmi_objective.c_min,
cmi_objective.c_raw,
cmi_objective.scaled,
cmi_objective.progress_measure,
cmi_objective.success_status,
cmi_objective.scope
FROM cmi_objective
INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_objective.cmi_node_id
INNER JOIN cp_node ON cp_node.cp_node_id = cmi_node.cp_node_id
WHERE cmi_node.user_id = %s
AND cp_node.slm_id = %s
ORDER BY cmi_objective.cmi_objective_id';
}
break;
case "package":
$q = 'SELECT usr_data.usr_id user_id,
CONCAT(CONCAT(COALESCE(usr_data.firstname, \'\'), \' \'), COALESCE(usr_data.lastname, \'\')) learner_name,
sahs_lm.id slm_id , sahs_lm.default_lesson_mode "mode", sahs_lm.credit
FROM usr_data, cp_package
INNER JOIN sahs_lm ON cp_package.obj_id = sahs_lm.id
WHERE usr_data.usr_id = %s
AND sahs_lm.id = %s';
break;
}
$result['data'][$k] = array();
if ($q != '') {
$types = array('integer', 'integer');
$values = array($userId, $packageId);
$res = $ilDB->queryF($q, $types, $values);
while($row = $ilDB->fetchAssoc($res))
{
$tmp_result = array();
foreach($row as $key => $value)
{
if ($k == "comment" && $key == "c_timestamp" && strpos($value,' ')==10) $value = str_replace(' ','T',$value);
$tmp_result[] = $value;
if($k=="node" && $key=="additional_tables" && $i_check<$value){
$i_check=$value;
// $GLOBALS['ilLog']->write($i_check);
}
}
$result['data'][$k][] = $tmp_result;
}
}
}
return $result;
}
ilSCORM13Player::getCookie ( )

getting and setting Scorm2004 cookie Cookie contains enrypted associative array of sahs_lm.id and permission value you may enforce stronger symmetrical encryption by adding RC4 via mcrypt()

Definition at line 1589 of file ilSCORM13Player.php.

References $_COOKIE.

{
return unserialize(base64_decode($_COOKIE[IL_OP_COOKIE_NAME]));
}
ilSCORM13Player::getCPData ( )

Definition at line 439 of file ilSCORM13Player.php.

References $res.

Referenced by executeCommand().

{
global $ilDB;
$res = $ilDB->queryF(
'SELECT jsdata FROM cp_package WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
$packageData = $ilDB->fetchAssoc($res);
$jsdata = $packageData['jsdata'];
if (!$jsdata) $jsdata = 'null';
if ($this->jsMode)
{
header('Content-Type: text/javascript; charset=UTF-8');
print($jsdata);
}
else
{
header('Content-Type: text/plain; charset=UTF-8');
$jsdata = json_decode($jsdata);
print_r($jsdata);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::getDataDirectory ( )

Definition at line 273 of file ilSCORM13Player.php.

References ILIAS_WEB_DIR.

Referenced by getPlayer().

{
$webdir=str_replace("/ilias.php","",$_SERVER["SCRIPT_NAME"]);
//load ressources always with absolute URL..relative URLS fail on innersco navigation on certain browsers
$lm_dir=$webdir."/".ILIAS_WEB_DIR."/".$this->ilias->client_id ."/lm_data"."/lm_".$this->packageId;
return $lm_dir;
}

+ Here is the caller graph for this function:

ilSCORM13Player::getDataDirectory2 ( )

Definition at line 2061 of file ilSCORM13Player.php.

References ILIAS_WEB_DIR.

{
$webdir=str_replace("/ilias.php","",$_SERVER["SCRIPT_NAME"]);
//load ressources always with absolute URL..relative URLS fail on innersco navigation on certain browsers
$lm_dir=$webdir."/".ILIAS_WEB_DIR."/".$this->ilias->client_id ."/lm_data"."/lm_".$this->packageId;
return $lm_dir;
}
ilSCORM13Player::getDebugValues (   $test_sco = false)
private

Definition at line 2186 of file ilSCORM13Player.php.

References $ilLog.

Referenced by getPlayer().

{
global $ilDB,$ilLog;
$ini_array = null;
$dvalues = array();
/*
$res = $ilDB->queryF('
SELECT debug_fields
FROM sahs_lm
WHERE id = %s',
array('integer'),
array($this->packageId)
);
$row = $ilDB->fetchAssoc($res);
$debug_fields = $row['debug_fields'];
if ($debug_fields == null) {*/
$debug_fields = parse_ini_file("./Modules/Scorm2004/scripts/rtemain/debug_default.ini",true);
// }
if ($test_sco) {
$ini_array = $debug_fields['test_sco'];
} else {
$ini_array = $debug_fields['normal_sco'];
}
foreach ($ini_array as $key => $value) {
if ($value == 1) {
array_push($dvalues,$key);
}
}
return $dvalues;
}

+ Here is the caller graph for this function:

ilSCORM13Player::getInlineCSS ( )

Get inline css.

Definition at line 425 of file ilSCORM13Player.php.

References ilUtil\getImagePath().

{
$is_tpl = new ilTemplate("tpl.scorm2004.inlinecss.html", true, true, "Modules/Scorm2004");
$is_tpl->setVariable('IC_ASSET', ilUtil::getImagePath("scorm/asset_s.png",false));
$is_tpl->setVariable('IC_COMPLETED', ilUtil::getImagePath("scorm/completed_s.png",false));
$is_tpl->setVariable('IC_NOTATTEMPTED', ilUtil::getImagePath("scorm/not_attempted_s.png",false));
$is_tpl->setVariable('IC_RUNNING', ilUtil::getImagePath("scorm/running_s.png",false));
$is_tpl->setVariable('IC_INCOMPLETE', ilUtil::getImagePath("scorm/incomplete_s.png",false));
$is_tpl->setVariable('IC_PASSED', ilUtil::getImagePath("scorm/passed_s.png",false));
$is_tpl->setVariable('IC_FAILED', ilUtil::getImagePath("scorm/failed_s.png",false));
$is_tpl->setVariable('IC_BROWSED', ilUtil::getImagePath("scorm/browsed.png",false));
return $is_tpl->get();
}

+ Here is the call graph for this function:

ilSCORM13Player::getLogFileList (   $s_delete,
  $s_download,
  $s_open 
)
private

Definition at line 2102 of file ilSCORM13Player.php.

References $_GET, and $data.

{
$data = array();
foreach (new DirectoryIterator($this->logDirectory()) as $fileInfo) {
if ($fileInfo->isDot()) {
continue;
}
$item['filename'] = $fileInfo->getFilename();
$parts = pathinfo($item['filename']);
$fnameparts = preg_split('/_/', $parts['filename'], -1, PREG_SPLIT_NO_EMPTY);
$deleteUrl = '&nbsp;<a href=#'." onclick=\"javascript:deleteFile('".$item['filename']."');\">".$s_delete."</a>";
//no delete for most recent file
if ($this->get_actual_attempts()==$fnameparts[1]) {$deleteUrl="";}
$urlDownload = 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=downloadLog&ref_id='.$_GET["ref_id"].'&logFile='.$fileInfo->getFilename();
$urlOpen = 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=openLog&ref_id='.$_GET["ref_id"].'&logFile='.$fileInfo->getFilename();
$item['date'] = date('Y/m/d H:i:s', $fileInfo->getCTime());
if ($parts['extension'] == "html") {
$item['action'] =$deleteUrl."&nbsp;<a href=".$urlDownload.">".$s_download."</a>&nbsp;<a target=_new href=".$urlOpen.">".$s_open."</a>";
} else {
$item['action'] =$deleteUrl."&nbsp;<a href=".$urlDownload.">".$s_download."</a>";
}
if ($parts['extension'] == "html" || $parts['extension'] == "csv") {
array_push($data,$item);
}
}
usort($data,"datecmp");
return $data;
}
ilSCORM13Player::getLogTemplate ( )
private

Definition at line 2181 of file ilSCORM13Player.php.

{
return new ilTemplate("tpl.scorm2004.debugtxt.txt", true, true, "Modules/Scorm2004");
}
ilSCORM13Player::getMimetype (   $filename)

estimate content type for a filename by extension first do it for common static web files from external list if not found peek into file by slow php function mime_content_type()

Parameters
$filenamerequired
Returns
string mimetype name e.g. image/jpeg

Definition at line 1578 of file ilSCORM13Player.php.

References $filename, and ilObjMediaObject\getMimeType().

{
include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
return ilObjMediaObject::getMimeType($filename);
}

+ Here is the call graph for this function:

ilSCORM13Player::getNodeData (   $sco_id,
  $fh 
)
private

Definition at line 1846 of file ilSCORM13Player.php.

References $ilLog, $res, and $row.

{
global $ilDB,$ilLog;
$fieldList = "cmi_node.cp_node_id, cmi_node.completion_threshold, cmi_node.c_exit, cmi_node.completion_status, cmi_node.progress_measure, cmi_node.success_status, cmi_node.scaled, cmi_node.session_time,".
"cmi_node.c_min, cmi_node.c_max, cmi_node.c_raw, cmi_node.location, cmi_node.suspend_data, cmi_node.scaled_passing_score, cmi_node.total_time";
$res = $ilDB->queryF('
SELECT '.$fieldList.'
FROM cmi_node,cp_node,cp_item
WHERE cp_node.slm_id = %s
AND cp_node.cp_node_id = cp_item.cp_node_id
AND cp_item.id = %s
AND cmi_node.cp_node_id = cp_item.cp_node_id
AND cmi_node.user_id = %s',
array('integer','text','integer'),
array($this->packageId, $sco_id, $this->userId)
);
$row = $ilDB->fetchAssoc($res);
$ilLog->write("DEBUG SQL".$row);
return $row;
}
ilSCORM13Player::getPlayer ( )

Definition at line 283 of file ilSCORM13Player.php.

References $_GET, $ilias, $ilSetting, $ilUser, $lng, exit, get_actual_attempts(), get_last_visited(), get_max_attempts(), getDataDirectory(), getDebugValues(), ilYuiUtil\getLocalPath(), getScope(), ilUtil\getStyleSheetLocation(), increase_attempt(), resetSharedData(), and save_module_version().

Referenced by executeCommand().

{
global $ilUser,$lng, $ilias, $ilSetting;
// player basic config data
if ($this->slm->getSession()) {
$session_timeout = (int)($ilias->ini->readVariable("session","expire"))/2;
} else {
$session_timeout = 0;
}
$config = array
(
'cp_url' => 'ilias.php?baseClass=ilSAHSPresentationGUI' . '&cmd=cp&ref_id='.$_GET["ref_id"],
'cmi_url'=> 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=cmi&ref_id='.$_GET["ref_id"],
'get_adldata_url'=> 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=getSharedData&ref_id='.$_GET["ref_id"],
'set_adldata_url' => 'ilias.php?baseClass=ilSAHSPresentationGUI' . '&cmd=setSharedData&ref_id=' . $_GET["ref_id"],
'adlact_url'=> 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=adlact&ref_id='.$_GET["ref_id"],
'specialpage_url'=> 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=specialPage&ref_id='.$_GET["ref_id"],
'suspend_url'=>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=suspend&ref_id='.$_GET["ref_id"],
'get_suspend_url'=>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=getSuspend&ref_id='.$_GET["ref_id"],
//next 2 lines could be deleted later
'gobjective_url'=>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=gobjective&ref_id='.$_GET["ref_id"],
'get_gobjective_url'=>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=getGobjective&ref_id='.$_GET["ref_id"],
'ping_url' =>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=pingSession&ref_id='.$_GET["ref_id"],
'scorm_player_unload_url' =>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=scormPlayerUnload&ref_id='.$_GET["ref_id"],
'scope'=>$this->getScope(),
'learner_id' => (string) $ilUser->getID(),
'course_id' => (string) $this->packageId,
'learner_name' => $ilUser->getFirstname()." ".$ilUser->getLastname(),
'mode' => 'normal',
'credit' => 'credit',
'auto_review' => $this->slm->getAutoReview(),
'hide_navig' => $this->slm->getHideNavig(),
'debug' => $this->slm->getDebug(),
'package_url' => $this->getDataDirectory()."/",
'session_ping' => $session_timeout,
'envEditor' => $this->envEditor,
'post_log_url'=>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=postLogEntry&ref_id='.$_GET["ref_id"],
'livelog_url'=>'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=liveLogContent&ref_id='.$_GET["ref_id"],
'debug_fields' => $this->getDebugValues(),
'debug_fields_test' => $this->getDebugValues(true),
'sequencing_enabled' => $this->slm->getSequencing(),
'interactions_storable' => $this->slm->getInteractions(),
'objectives_storable' => $this->slm->getObjectives(),
'comments_storable' => $this->slm->getComments(),
'time_from_lms' => $this->slm->getTime_from_lms(),
'auto_last_visited' => $this->slm->getAuto_last_visited(),
'checkSetValues' => $this->slm->getCheck_values()
);
$status['saved_global_status']="";//not yet implemented
$status['last_visited']=null;
if($this->slm->getAuto_last_visited()) $status['last_visited']=$this->get_last_visited($this->packageId, $ilUser->getID());
$config['status'] = $status;
//language strings
$langstrings['btnStart'] = $lng->txt('scplayer_start');
$langstrings['btnExit'] = $lng->txt('scplayer_exit');
$langstrings['btnExitAll'] = $lng->txt('scplayer_exitall');
$langstrings['btnSuspendAll'] = $lng->txt('scplayer_suspendall');
$langstrings['btnPrevious'] = $lng->txt('scplayer_previous');
$langstrings['btnContinue'] = $lng->txt('scplayer_continue');
$langstrings['btnhidetree']=$lng->txt('scplayer_hidetree');
$langstrings['btnshowtree']=$lng->txt('scplayer_showtree');
$langstrings['linkexpandTree']=$lng->txt('scplayer_expandtree');
$langstrings['linkcollapseTree']=$lng->txt('scplayer_collapsetree');
$config['langstrings'] = $langstrings;
//template variables
//$this->tpl = new ilTemplate("tpl.scorm2004.player.html", false, false, "Modules/Scorm2004");
$this->tpl = new ilTemplate("tpl.scorm2004.player.html", true, true, "Modules/Scorm2004");
// include ilias rte css, if given
$rte_css = $this->slm->getDataDirectory()."/ilias_css_4_2/css/style.css";
if (is_file($rte_css))
{
$this->tpl->setCurrentBlock("rte_css");
$this->tpl->setVariable("RTE_CSS", $rte_css);
$this->tpl->parseCurrentBlock();
}
$this->tpl->setVariable('JSON_LANGSTRINGS', json_encode($langstrings));
include_once("./Services/YUI/classes/class.ilYuiUtil.php");
$this->tpl->setVariable('YUI_PATH', ilYuiUtil::getLocalPath());
$this->tpl->setVariable('TREE_JS', "./Services/UIComponent/NestedList/js/ilNestedList.js");
$this->tpl->setVariable($langstrings);
$this->tpl->setVariable('DOC_TITLE', 'ILIAS SCORM 2004 Player');
$this->tpl->setVariable("LOCATION_STYLESHEET", ilUtil::getStyleSheetLocation());
$this->tpl->setVariable('JS_DATA', json_encode($config));
list($tsfrac, $tsint) = explode(' ', microtime());
$this->tpl->setVariable('TIMESTAMP', sprintf('%d%03d', $tsint, 1000*(float)$tsfrac));
$this->tpl->setVariable('BASE_DIR', './Modules/Scorm2004/');
$this->tpl->setVariable('TXT_COLLAPSE',$lng->txt('scplayer_collapsetree'));
if ($this->slm->getDebug()) {
$this->tpl->setVariable('TXT_DEBUGGER',$lng->txt('scplayer_debugger'));
$this->tpl->setVariable('DEBUG_URL',"PopupCenter('ilias.php?baseClass=ilSAHSPresentationGUI&cmd=debugGUI&ref_id=".$_GET["ref_id"]."','Debug',800,600);");
} else {
$this->tpl->setVariable('TXT_DEBUGGER','');
$this->tpl->setVariable('DEBUG_URL','');
}
//set icons path
$this->tpl->setVariable('INLINE_CSS', ilSCORM13Player::getInlineCss());
//include scripts
if ($this->slm->getCacheDeactivated()){
$this->tpl->setVariable('JS_SCRIPTS', 'ilias.php?baseClass=ilSAHSPresentationGUI' .'&cmd=getRTEjs&ref_id='.$_GET["ref_id"]);
} else {
$this->tpl->setVariable('JS_SCRIPTS', './Modules/Scorm2004/scripts/buildrte/rte-min.js');
}
//disable top menu
if ($this->slm->getNoMenu()=="y") {
$this->tpl->setVariable("VAL_DISPLAY", "style=\"display:none;\"");
} else {
$this->tpl->setVariable("VAL_DISPLAY", "");
}
//check for max_attempts and raise error if max_attempts is exceeded
if ($this->get_max_attempts()!=0) {
if ($this->get_actual_attempts() >= $this->get_max_attempts()) {
header('Content-Type: text/html; charset=utf-8');
echo($lng->txt("cont_sc_max_attempt_exceed"));
exit;
}
}
//count attempt
//Cause there is no way to check if the Java-Applet is sucessfully loaded, an attempt equals opening the SCORM player
$this->increase_attempt();
$this->resetSharedData();
$this->save_module_version();
$this->tpl->show("DEFAULT", false);
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Player::getRTEjs ( )

Definition at line 260 of file ilSCORM13Player.php.

Referenced by executeCommand().

{
$js_data = file_get_contents("./Modules/Scorm2004/scripts/buildrte/rte.js");
if (self::ENABLE_GZIP==1) {
ob_start("ob_gzhandler");
header('Content-Type: text/javascript; charset=UTF-8');
} else {
header('Content-Type: text/javascript; charset=UTF-8');
}
echo $js_data;
}

+ Here is the caller graph for this function:

ilSCORM13Player::getScope ( )

Definition at line 515 of file ilSCORM13Player.php.

References $data, $ilUser, $packageId, and $res.

Referenced by getPlayer().

{
global $ilDB, $ilUser;
$res = $ilDB->queryF(
'SELECT global_to_system FROM cp_package WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
$data = $ilDB->fetchAssoc($res);
$gystem = $data['global_to_system'];
if($gystem == 1)
$gsystem = 'null';
else
$gsystem = $this->packageId;
return $gsystem;
}

+ Here is the caller graph for this function:

ilSCORM13Player::getStructureFlat (   $data)
private

Definition at line 2512 of file ilSCORM13Player.php.

References $data.

{
for ($i=0; $i <count($data) ; $i++) {
$element = array();
$element['title'] = $data[$i]['title'];
$element['id'] = $data[$i]['id'];
if ($data[$i]['sco'] == 1) {
$element['sco'] = "sco";
} else {
$element['sco'] = "assset";
}
if ( $data[$i]['href'] !=null ) {
array_push($this->flat_structure,$element);
}
if ($data[$i]['item']!=null) {
$this->getStructureFlat($data[$i]['item']);
}
}
}
ilSCORM13Player::getSuspendData ( )

Definition at line 535 of file ilSCORM13Player.php.

References $data, $ilUser, and $res.

Referenced by executeCommand().

{
global $ilDB, $ilUser;
$res = $ilDB->queryF(
'SELECT data FROM cp_suspend WHERE obj_id = %s AND user_id = %s',
array('integer', 'integer'),
array($this->packageId, $ilUser->getId())
);
$data = $ilDB->fetchAssoc($res);
$suspend_data = $data['data'];
if($this->jsMode)
{
header('Content-Type: text/javascript; charset=UTF-8');
print($suspend_data);
}
else
{
header('Content-Type: text/plain; charset=UTF-8');
$suspend_data = json_decode($suspend_data);
print_r($suspend_data);
}
//delete delivered suspend data
$ilDB->manipulateF(
'DELETE FROM cp_suspend WHERE obj_id = %s AND user_id = %s',
array('integer', 'integer'),
array($this->packageId, $ilUser->getId())
);
}

+ Here is the caller graph for this function:

ilSCORM13Player::increase_attempt ( )

Increases attempts by one for this package.

Definition at line 1710 of file ilSCORM13Player.php.

References $ilUser, $res, and $row.

Referenced by getPlayer().

{
global $ilDB, $ilUser;
//get existing account - sco id is always 0
$res = $ilDB->queryF('
SELECT rvalue FROM cmi_custom
WHERE user_id = %s
AND sco_id = %s
AND lvalue = %s
AND obj_id = %s',
array('integer', 'integer','text', 'integer'),
array($this->userId, 0, 'package_attempts', $this->packageId)
);
$row = $ilDB->fetchAssoc($res);
$tmp_row = $row;
$row['rvalue'] = str_replace("\r\n", "\n", $row['rvalue']);
if($row['rvalue'] == null)
{
$row['rvalue'] = 0;
}
$new_rec = $row['rvalue'] + 1;
//increase attempt by 1
if(!is_array($tmp_row) || !count($tmp_row))
{
$ilDB->manipulateF('
INSERT INTO cmi_custom (rvalue, user_id, sco_id, obj_id, lvalue, c_timestamp)
VALUES(%s, %s, %s, %s, %s, %s)',
array('text', 'integer', 'integer', 'integer', 'text', 'timestamp'),
array($new_rec, $this->userId, 0, $this->packageId, 'package_attempts', date('Y-m-d H:i:s'))
);
}
else
{
$ilDB->manipulateF('
UPDATE cmi_custom
SET rvalue = %s,
c_timestamp = %s
WHERE user_id = %s
AND sco_id = %s
AND obj_id = %s
AND lvalue = %s',
array('text', 'timestamp', 'integer', 'integer', 'integer','text'),
array($new_rec, date('Y-m-d H:i:s'), $this->userId, 0, $this->packageId, 'package_attempts')
);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::liveLogContent ( )

Definition at line 2132 of file ilSCORM13Player.php.

Referenced by executeCommand().

{
header('Content-Type: text/html; charset=UTF-8');
print file_get_contents($this->logFileName().".html");
}

+ Here is the caller graph for this function:

ilSCORM13Player::logDirectory ( )
private

Definition at line 2069 of file ilSCORM13Player.php.

References ilUtil\makeDir().

{
// $logDir=ilUtil::getDataDir()."/SCORMlogs"."/lm_".$this->packageId;
// if (!file_exists($logDir)) ilUtil::makeDirParents($logDir);
$logDir=$this->slm->getDataDirectory()."/logs";
if (!file_exists($logDir)) {
ilUtil::makeDir($logDir);
}
return $logDir;
}

+ Here is the call graph for this function:

ilSCORM13Player::logFileName ( )
private

Definition at line 1903 of file ilSCORM13Player.php.

References $filename, and $lng.

{
global $lng;
$lng->loadLanguageModule("scormdebug");
$filename = $this->logDirectory()."/".$this->packageId."_".$this->get_actual_attempts();
$path_csv = $filename.".csv";
$path_txt = $filename.".html";
if (!file_exists($path_csv)) {
umask(0000);
$fHandle = fopen($path_csv, 'a') or die("can't open file");
$string = '"CourseId";"ScoId";"ScoTitle";"Timestamp";"Action";"Key";"Value";"Return Value";"Errorcode";"Timespan";"ErrorDescription"'."\n";
fwrite($fHandle, $string);
fclose($fHandle);
}
if (!file_exists($path_txt)) {
if (file_exists($this->logTmpName())) {
unlink($this->logTmpName());
}
umask(0000);
$fHandle2 = fopen($path_txt, 'a') or die("can't open file");
$logtpl = $this->getLogTemplate();
$logtpl->setCurrentBlock('NewLog');
$logtpl->setVariable("COURSETITLE", $this->slm->getTitle());
$logtpl->setVariable("COURSEID", $this->packageId);
$logtpl->setVariable("TIMESTAMP", date("d.m.Y H:i",time()));
$logtpl->setVariable("SESSION", $this->get_actual_attempts());
$logtpl->setVariable("error0", $lng->txt("error0"));
$logtpl->setVariable("error101", $lng->txt("error101"));
$logtpl->setVariable("error102", $lng->txt("error102"));
$logtpl->setVariable("error103", $lng->txt("error103"));
$logtpl->setVariable("error104", $lng->txt("error104"));
$logtpl->setVariable("error111", $lng->txt("error111"));
$logtpl->setVariable("error112", $lng->txt("error112"));
$logtpl->setVariable("error113", $lng->txt("error113"));
$logtpl->setVariable("error122", $lng->txt("error122"));
$logtpl->setVariable("error123", $lng->txt("error123"));
$logtpl->setVariable("error132", $lng->txt("error132"));
$logtpl->setVariable("error133", $lng->txt("error133"));
$logtpl->setVariable("error142", $lng->txt("error142"));
$logtpl->setVariable("error143", $lng->txt("error143"));
$logtpl->setVariable("error201", $lng->txt("error201"));
$logtpl->setVariable("error301", $lng->txt("error301"));
$logtpl->setVariable("error351", $lng->txt("error351"));
$logtpl->setVariable("error391", $lng->txt("error391"));
$logtpl->setVariable("error401", $lng->txt("error401"));
$logtpl->setVariable("error402", $lng->txt("error402"));
$logtpl->setVariable("error403", $lng->txt("error403"));
$logtpl->setVariable("error404", $lng->txt("error404"));
$logtpl->setVariable("error405", $lng->txt("error405"));
$logtpl->setVariable("error406", $lng->txt("error406"));
$logtpl->setVariable("error407", $lng->txt("error407"));
$logtpl->setVariable("error408", $lng->txt("error408"));
$logtpl->setVariable("SetValue", $lng->txt("SetValue"));
$logtpl->setVariable("GetValue", $lng->txt("GetValue"));
$logtpl->setVariable("Commit", $lng->txt("Commit"));
$logtpl->setVariable("Initialize", $lng->txt("Initialize"));
$logtpl->setVariable("Terminate", $lng->txt("Terminate"));
$logtpl->setVariable("GetErrorString", $lng->txt("GetErrorString"));
$logtpl->setVariable("GetLastError", $lng->txt("GetLastError"));
$logtpl->setVariable("GetDiagnostic", $lng->txt("GetDiagnostic"));
$logtpl->setVariable("cmi._version", $lng->txt("cmi._version"));
$logtpl->setVariable("cmi.comments_from_learner._children", $lng->txt("cmi.comments_from_learner._children"));
$logtpl->setVariable("cmi.comments_from_learner._count", $lng->txt("cmi.comments_from_learner._count"));
$logtpl->setVariable("cmi.comments_from_learner.n.comment", $lng->txt("cmi.comments_from_learner.n.comment"));
$logtpl->setVariable("cmi.comments_from_learner.n.location", $lng->txt("cmi.comments_from_learner.n.location"));
$logtpl->setVariable("cmi.comments_from_learner.n.timestamp", $lng->txt("cmi.comments_from_learner.n.timestamp"));
$logtpl->setVariable("cmi.comments_from_lms._children", $lng->txt("cmi.comments_from_lms._children"));
$logtpl->setVariable("cmi.comments_from_lms._count", $lng->txt("cmi.comments_from_lms._count"));
$logtpl->setVariable("cmi.comments_from_lms.n.comment", $lng->txt("cmi.comments_from_lms.n.comment"));
$logtpl->setVariable("cmi.comments_from_lms.n.location", $lng->txt("cmi.comments_from_lms.n.location"));
$logtpl->setVariable("cmi.comments_from_lms.n.timestamp", $lng->txt("cmi.comments_from_lms.n.timestamp"));
$logtpl->setVariable("cmi.completion_status", $lng->txt("cmi.completion_status"));
$logtpl->setVariable("cmi.completion_threshold", $lng->txt("cmi.completion_threshold"));
$logtpl->setVariable("cmi.credit", $lng->txt("cmi.credit"));
$logtpl->setVariable("cmi.entry", $lng->txt("cmi.entry"));
$logtpl->setVariable("cmi.exit", $lng->txt("cmi.exit"));
$logtpl->setVariable("cmi.interactions._children", $lng->txt("cmi.interactions._children"));
$logtpl->setVariable("cmi.interactions._count", $lng->txt("cmi.interactions._count"));
$logtpl->setVariable("cmi.interactions.n.id", $lng->txt("cmi.interactions.n.id"));
$logtpl->setVariable("cmi.interactions.n.type", $lng->txt("cmi.interactions.n.type"));
$logtpl->setVariable("cmi.interactions.n.objectives._count", $lng->txt("cmi.interactions.n.objectives._count"));
$logtpl->setVariable("cmi.interactions.n.objectives.n.id", $lng->txt("cmi.interactions.n.objectives.n.id"));
$logtpl->setVariable("cmi.interactions.n.timestamp", $lng->txt("cmi.interactions.n.timestamp"));
$logtpl->setVariable("cmi.interactions.n.correct_responses._count", $lng->txt("cmi.interactions.n.correct_responses._count"));
$logtpl->setVariable("cmi.interactions.n.correct_responses.n.pattern", $lng->txt("cmi.interactions.n.correct_responses.n.pattern"));
$logtpl->setVariable("cmi.interactions.n.weighting", $lng->txt("cmi.interactions.n.weighting"));
$logtpl->setVariable("cmi.interactions.n.learner_response", $lng->txt("cmi.interactions.n.learner_response"));
$logtpl->setVariable("cmi.interactions.n.result", $lng->txt("cmi.interactions.n.result"));
$logtpl->setVariable("cmi.interactions.n.latency", $lng->txt("cmi.interactions.n.latency"));
$logtpl->setVariable("cmi.interactions.n.description", $lng->txt("cmi.interactions.n.description"));
$logtpl->setVariable("cmi.launch_data", $lng->txt("cmi.launch_data"));
$logtpl->setVariable("cmi.learner_id", $lng->txt("cmi.learner_id"));
$logtpl->setVariable("cmi.learner_name", $lng->txt("cmi.learner_name"));
$logtpl->setVariable("cmi.learner_preference._children", $lng->txt("cmi.learner_preference._children"));
$logtpl->setVariable("cmi.learner_preference.audio_level", $lng->txt("cmi.learner_preference.audio_level"));
$logtpl->setVariable("cmi.learner_preference.language", $lng->txt("cmi.learner_preference.language"));
$logtpl->setVariable("cmi.learner_preference.delivery_speed", $lng->txt("cmi.learner_preference.delivery_speed"));
$logtpl->setVariable("cmi.learner_preference.audio_captioning", $lng->txt("cmi.learner_preference.audio_captioning"));
$logtpl->setVariable("cmi.location", $lng->txt("cmi.location"));
$logtpl->setVariable("cmi.max_time_allowed", $lng->txt("cmi.max_time_allowed"));
$logtpl->setVariable("cmi.mode", $lng->txt("cmi.mode"));
$logtpl->setVariable("cmi.objectives._children", $lng->txt("cmi.objectives._children"));
$logtpl->setVariable("cmi.objectives._count", $lng->txt("cmi.objectives._count"));
$logtpl->setVariable("cmi.objectives.n.id", $lng->txt("cmi.objectives.n.id"));
$logtpl->setVariable("cmi.objectives.n.score._children", $lng->txt("cmi.objectives.n.score._children"));
$logtpl->setVariable("cmi.objectives.n.score.scaled", $lng->txt("cmi.objectives.n.score.scaled"));
$logtpl->setVariable("cmi.objectives.n.score.raw", $lng->txt("cmi.objectives.n.score.raw"));
$logtpl->setVariable("cmi.objectives.n.score.min", $lng->txt("cmi.objectives.n.score.min"));
$logtpl->setVariable("cmi.objectives.n.score.max", $lng->txt("cmi.objectives.n.score.max"));
$logtpl->setVariable("cmi.objectives.n.success_status", $lng->txt("cmi.objectives.n.success_status"));
$logtpl->setVariable("cmi.objectives.n.completion_status", $lng->txt("cmi.objectives.n.completion_status"));
$logtpl->setVariable("cmi.objectives.n.progress_measure", $lng->txt("cmi.objectives.n.progress_measure"));
$logtpl->setVariable("cmi.objectives.n.description", $lng->txt("cmi.objectives.n.description"));
$logtpl->setVariable("cmi.progress_measure", $lng->txt("cmi.progress_measure"));
$logtpl->setVariable("cmi.scaled_passing_score", $lng->txt("cmi.scaled_passing_score"));
$logtpl->setVariable("cmi.score._children", $lng->txt("cmi.score._children"));
$logtpl->setVariable("cmi.score.scaled", $lng->txt("cmi.score.scaled"));
$logtpl->setVariable("cmi.score.raw", $lng->txt("cmi.score.raw"));
$logtpl->setVariable("cmi.score.min", $lng->txt("cmi.score.min"));
$logtpl->setVariable("cmi.score.max", $lng->txt("cmi.score.max"));
$logtpl->setVariable("cmi.session_time", $lng->txt("cmi.session_time"));
$logtpl->setVariable("cmi.success_status", $lng->txt("cmi.success_status"));
$logtpl->setVariable("cmi.suspend_data", $lng->txt("cmi.suspend_data"));
$logtpl->setVariable("cmi.time_limit_action", $lng->txt("cmi.time_limit_action"));
$logtpl->setVariable("cmi.total_time", $lng->txt("cmi.total_time"));
$logtpl->setVariable("adl.nav.request", $lng->txt("adl.nav.request"));
$logtpl->setVariable("adl.nav.request_valid.continue", $lng->txt("adl.nav.request_valid.continue"));
$logtpl->setVariable("adl.nav.request_valid.previous", $lng->txt("adl.nav.request_valid.previous"));
$logtpl->setVariable("adl.nav.request_valid.choice", $lng->txt("adl.nav.request_valid.choice"));
$logtpl->setVariable("i_green", $lng->txt("i_green"));
$logtpl->setVariable("i_red", $lng->txt("i_red"));
$logtpl->setVariable("i_orange", $lng->txt("i_orange"));
$logtpl->setVariable("i_fuchsia", $lng->txt("i_fuchsia"));
$logtpl->setVariable("i_gray", $lng->txt("i_gray"));
$logtpl->setVariable("error", $lng->txt("error"));
$logtpl->setVariable("strange_error", $lng->txt("strange_error"));
$logtpl->setVariable("strange_API-Call", $lng->txt("strange_API-Call"));
$logtpl->setVariable("unknown", $lng->txt("unknown"));
$logtpl->setVariable("undefined_color", $lng->txt("undefined_color"));
$logtpl->setVariable("description_for", $lng->txt("description_for"));
$logtpl->setVariable("hide", $lng->txt("hide"));
$logtpl->setVariable("all_API-calls_shown", $lng->txt("all_API-calls_shown"));
$logtpl->setVariable("show_only_important_API-calls", $lng->txt("show_only_important_API-calls"));
$logtpl->setVariable("only_important_API-Calls_shown", $lng->txt("only_important_API-Calls_shown"));
$logtpl->setVariable("show_all_API-calls", $lng->txt("show_all_API-calls"));
$logtpl->setVariable("log_for", $lng->txt("log_for"));
$logtpl->setVariable("started", $lng->txt("started"));
$logtpl->setVariable("nr_session", $lng->txt("nr_session"));
$logtpl->setVariable("id_learning_module", $lng->txt("id_learning_module"));
if($this->slm->getCheck_values()==false) $logtpl->setVariable("CHECK_VALUES", $lng->txt("sent_values_not_checked"));
$logtpl->parseCurrentBlock();
fwrite($fHandle2,$logtpl->get());
fclose($fHandle2);
}
return $filename;
}
ilSCORM13Player::logTmpName ( )
private

Definition at line 1870 of file ilSCORM13Player.php.

References $filename.

{
$filename = $this->logDirectory()."/".$this->packageId.".tmp";
if (!file_exists($filename)) {
umask(0000);
$fHandle = fopen($filename, 'a') or die("can't open file");
fwrite($fHandle, $string);
fclose($fHandle);
}
return $filename;
}
ilSCORM13Player::normalizeFields (   $table,
&  $node 
)
private

maps API data structure type to internal datatype on a node and accepts only valid values, dropping invalid ones from input

Definition at line 1149 of file ilSCORM13Player.php.

{
return;
foreach (self::$schema[$table] as $k => $v)
{
$value = $node->$k;
if (isset($value) && is_string($v) && !preg_match($v, $value))
{
unset($node->$k);
}
}
}
ilSCORM13Player::openLog ( )

Definition at line 2080 of file ilSCORM13Player.php.

References $_GET, $filename, and exit.

Referenced by executeCommand().

{
$filename = $_GET['logFile'];
//Header
header('Content-Type: text/html; charset=UTF-8');
echo file_get_contents($this->logDirectory()."/".$filename);
exit;
}

+ Here is the caller graph for this function:

ilSCORM13Player::persistCMIData (   $data = null)

Definition at line 1120 of file ilSCORM13Player.php.

References $data, and $ilLog.

Referenced by executeCommand().

{
global $ilLog;
if ($this->slm->getDefaultLessonMode() == "browse") {return;}
$data = json_decode(is_string($data) ? $data : file_get_contents('php://input'));
$ilLog->write("SCORM2004 Got data:". file_get_contents('php://input'));
$return = $this->setCMIData($this->userId, $this->packageId, $data, $this->ref_id);
$ilLog->write("SCORM2004 return of persistCMIData: ".json_encode($return));
if ($this->jsMode)
{
header('Content-Type: text/javascript; charset=UTF-8');
print(json_encode($return));
}
else
{
header('Content-Type: text/html; charset=UTF-8');
print(var_export($return, true));
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::pingSession ( )

Definition at line 495 of file ilSCORM13Player.php.

Referenced by executeCommand().

{
//do nothing except returning header
header('Content-Type: text/plain; charset=UTF-8');
print("");
}

+ Here is the caller graph for this function:

ilSCORM13Player::postLogEntry ( )

Definition at line 2217 of file ilSCORM13Player.php.

References $filename, $ilLog, $lng, $path, and $timestamp.

Referenced by executeCommand().

{
global $ilLog,$lng;
$lng->loadLanguageModule("scormdebug");
$logdata = json_decode(file_get_contents('php://input'));
$filename = $this->logFileName();
$tmp_name = $this->logTmpName();
$fh_txt = fopen($filename.".html", 'a') or die("can't open txt file");
$fh_csv = fopen($filename.".csv", 'a') or die("can't open csv file");
$fh_tmp = fopen($tmp_name, 'r') or die("can't open tmp file");
//init tmp file
if (filesize($tmp_name)>0) {
$tmp_content = unserialize(fread($fh_tmp,filesize($tmp_name)));
} else {
$tmp_content = null;
}
fclose($fh_tmp);
//reopen for writing
$fh_tmp2 = fopen($tmp_name, 'w') or die("can't open tmp file");
//write tmp
$tmp_content[$logdata->scoid][$logdata->key]['value'] = $logdata->value;
$tmp_content[$logdata->scoid][$logdata->key]['status'] = $logdata->result;
$tmp_content[$logdata->scoid][$logdata->key]['action'] = $logdata->action;
fwrite($fh_tmp2,serialize($tmp_content));
fclose($fh_tmp2);
$timestamp = date("d.m.Y H:i",time());
$errorcode = $logdata->errorcode;
$fixedFailure = false;
$toleratedFailure = false;
$extraErrorDescription = "";
if ($errorcode == 200000) {
$errorcode = 0;
$toleratedFailure = true;
$extraErrorDescription = "tolerated failure";
}
if ($errorcode>99999) {
$errorcode-=100000;
$fixedFailure = true;
$extraErrorDescription = " failure corrected by ILIAS";
}
if (strpos($logdata->action,"ANALYZE")===false)
{
$errorDescriptions = array("0" => "",
"101" => "General Exeption",
"102" => "General Initialization Failure",
"103" => "Already Initialized",
"104" => "Content Instance Terminated",
"111" => "General Termination Failure",
"112" => "Termination Before Initialization",
"113" => "Termination After Termination",
"122" => "Retrieve Data Before Initialization",
"123" => "Retrieve Data After Termination",
"132" => "Store Data Before Initialization",
"133" => "Store Data After Termination",
"142" => "Commit Before Initialization",
"143" => "Commit After Termination",
"201" => "General Argument Error",
"301" => "General Get Failure",
"351" => "General Set Failure",
"391" => "General Commit Failure",
"401" => "Undefined Data Model Element",
"402" => "Unimplemented Data Model Element",
"403" => "Data Model Element Value Not Initialized",
"404" => "Data Model Element Is Read Only",
"405" => "Data Model Element Is Write Only",
"406" => "Data Model Element Type Mismatch",
"407" => "Data Model Element Value Out Of Range",
"408" => "Data Model Dependency Not Established");
$csv_string = $this->packageId.';"'
.$logdata->scoid.'";"'
.$logdata->scotitle.'";'
.date("d.m.Y H:i",time()).';"'
.$logdata->action.'";"'
.$logdata->key.'";"'
.str_replace("\"","\"\"",$logdata->value).'";"'
.str_replace("\"","\"\"",$logdata->result).'";'
.$errorcode.';'
.$logdata->timespan.';"'
.$errorDescriptions[$errorcode].$extraErrorDescription.'"'."\n";
fwrite($fh_csv,$csv_string);
}
$sqlwrite = false;
if($logdata->action == "Commit" || $logdata->action == "Terminate")
{
$sqlwrite = true;
$sql_data = $this->getNodeData($logdata->scoid,$fh_csv);
foreach ($sql_data as $key => $value) {
$sql_string = $this->packageId.';"'
.$logdata->scoid.'";"'
.$logdata->scotitle.'";'
.$timestamp.';"SQL";"'
.$key.'";"'
.str_replace("\"","\"\"",$value).'";;;;'."\n";
fwrite($fh_csv,$sql_string);
}
}
//delete files
if ($logdata->action == "DELETE")
{
$filename = $logdata->value;
$path = $this->logDirectory()."/".$filename;
unlink($path);
return;
}
//write TXT
$logtpl = $this->getLogTemplate();
$color = "red";
$importantkey=1;
$ArGetValues = array('comments_from_lms','completion_threshold','credit','entry','launch_data','learner_id','learner_name','max_time_allowed','mode','scaled_passing_score','time_limit_action','total_time');
switch ($logdata->action) {
case 'SetValue':
if ($logdata->result == "true" && $errorcode == 0) $color = "green";
if ($color=="green" && $logdata->key == "cmi.exit" && $logdata->value!="suspend") $color = "orange";
if ($fixedFailure == false && $errorcode!=406) $logdata->value = '"'.$logdata->value.'"';
if ($toleratedFailure == true) $color = "fuchsia";
if ($fixedFailure == true) $color = "gray";
break;
case 'GetValue':
if ($errorcode == 0) $color = "green";
break;
case 'Initialize':
if ($errorcode == 0)
{
$color = "green";
$logtpl->setCurrentBlock("InitializeStart");
$logtpl->setVariable("SCO-title", $lng->txt("SCO-title"));
$logtpl->setVariable("SCO_TITLE", $logdata->scotitle);
$logtpl->setVariable("SCO-name", $lng->txt("SCO-name"));
$logtpl->setVariable("SCO_NAME", $logdata->scoid);
$logtpl->setVariable("started", $lng->txt("started"));
$logtpl->setVariable("TIMESTAMP", $timestamp);
$logtpl->setVariable("milliseconds", $lng->txt("milliseconds"));
$logtpl->setVariable("API-call", $lng->txt("API-call"));
$logtpl->setVariable("return_value", $lng->txt("return_value"));
$logtpl->setVariable("error", $lng->txt("error"));
$logtpl->parseCurrentBlock();
}
break;
case 'Commit':
if ($errorcode == 0) $color = "green";
if ($fixedFailure == true) $color = "gray";
break;
case 'Terminate':
if ($errorcode == 0) $color = "green";
break;
case 'GetErrorString':
$importantkey=0;
if ($errorcode == 0) $color = "green";
break;
case 'GetLastError':
$logtpl->setCurrentBlock("GetLastError");
$logtpl->setVariable("TIMESPAN", $logdata->timespan);
$logtpl->setVariable("RESULT", $logdata->result);
$logtpl->parseCurrentBlock();
break;
case 'GetDiagnostic':
$logtpl->setCurrentBlock("GetDiagnostic");
$logtpl->setVariable("TIMESPAN", $logdata->timespan);
$logtpl->setVariable("KEY", $logdata->key);
$logtpl->setVariable("RESULT", $logdata->result);
$logtpl->parseCurrentBlock();
break;
case 'INFO':
$logtpl->setCurrentBlock("INFO");
$logtpl->setVariable("hint", $lng->txt("hint"));
$logtpl->setVariable("KEY", $lng->txt($logdata->key));
$logtpl->setVariable("VALUE", $logdata->value);
$logtpl->parseCurrentBlock();
break;
case 'COMMENT':
$logtpl->setCurrentBlock("COMMENT");
$logtpl->setVariable("comment", $lng->txt("comment"));
$logtpl->setVariable("generated", $lng->txt("generated"));
$logtpl->setVariable("TIMESTAMP", $timestamp);
$logtpl->setVariable("VALUE", $logdata->value);
$logtpl->parseCurrentBlock();
break;
case 'ANALYZE':
$logtpl->setCurrentBlock("ANALYZE");
if (count($logdata->value) == 0) {
$color = "green";
$logtpl->setVariable("ANALYZE_SUMMARY", $lng->txt("no_missing_API-calls"));
$logtpl->setVariable("VALUE", "");
} else {
$tmpvalue = "SetValue(\"".implode("\", ... ),<br/>SetValue(\"",$logdata->value)."\", ... )";
for ($i=0; $i <count($ArGetValues); $i++){
$tmpvalue = str_replace("SetValue(\"cmi.".$ArGetValues[$i]."\", ... )","GetValue(\"cmi.".$ArGetValues[$i]."\")",$tmpvalue);
}
$logtpl->setVariable("ANALYZE_SUMMARY", $lng->txt("missing_API-calls"));
$logtpl->setVariable("VALUE", $tmpvalue);
}
$logtpl->setVariable("summary_for_SCO_without_test", $lng->txt("summary_for_SCO_without_test"));
$logtpl->setVariable("generated", $lng->txt("generated"));
$logtpl->setVariable("TIMESTAMP", $timestamp);
$logtpl->setVariable("COLOR", $color);
$logtpl->parseCurrentBlock();
break;
case 'ANALYZETEST':
$logtpl->setCurrentBlock("ANALYZETEST");
if (count($logdata->value) == 0) {
$color = "green";
$logtpl->setVariable("ANALYZE_SUMMARY", $lng->txt("no_missing_API-calls"));
$logtpl->setVariable("VALUE", "");
} else {
$tmpvalue = "SetValue(\"".implode("\", ... ),<br/>SetValue(\"",$logdata->value)."\", ... )";
for ($i=0; $i <count($ArGetValues); $i++){
$tmpvalue = str_replace("SetValue(\"cmi.".$ArGetValues[$i]."\", ... )","GetValue(\"cmi.".$ArGetValues[$i]."\")",$tmpvalue);
}
$logtpl->setVariable("ANALYZE_SUMMARY", $lng->txt("missing_API-calls"));
$logtpl->setVariable("VALUE", $tmpvalue);
}
$logtpl->setVariable("summary_for_SCO_with_test", $lng->txt("summary_for_SCO_with_test"));
$logtpl->setVariable("generated", $lng->txt("generated"));
$logtpl->setVariable("TIMESTAMP", $timestamp);
$logtpl->setVariable("COLOR", $color);
$logtpl->parseCurrentBlock();
break;
case 'SUMMARY':
$logtpl->setCurrentBlock("SUMMARY");
$logtpl->setVariable("summary_csv", $lng->txt("summary_csv"));
$logtpl->setVariable("TIMESTAMP", $timestamp);
$logtpl->setVariable("summary_download", $lng->txt("summary_download"));
$logtpl->parseCurrentBlock();
break;
default:
$importantkey=0;
$color = "orange";
break;
}
if ($logdata->action == 'SetValue' || $logdata->action == 'GetValue')
{
$logtpl->setCurrentBlock($logdata->action);
$logtpl->setVariable("ACTION", $logdata->action);
$logtpl->setVariable("TIMESPAN", $logdata->timespan);
$logtpl->setVariable("KEY", $logdata->key);
$logtpl->setVariable("VALUE", $logdata->value);
$logtpl->setVariable("RESULT", $logdata->result);
$logtpl->setVariable("ERRORCODE", $errorcode);
$debugfields=$this->getDebugValues(true);
$importantkey=0;
for ($i=0; $i <count($debugfields) ; $i++){
if ($logdata->key == $debugfields[$i]) $importantkey=1;
}
$logtpl->setVariable("IMPORTANTKEY", "".$importantkey);
$logtpl->setVariable("COLOR", $color);
$logtpl->parseCurrentBlock();
}
else if ($logdata->action != 'INFO' && $logdata->action != 'ANALYZE' && $logdata->action != 'ANALYZETEST' && $logdata->action != 'SUMMARY' && $logdata->action != 'COMMENT' && $logdata->action != 'GetDiagnostic' && $logdata->action != 'GetLastError')
{
$logtpl->setCurrentBlock("defaultCall");
$logtpl->setVariable("ACTION", $logdata->action);
$logtpl->setVariable("TIMESPAN", $logdata->timespan);
$logtpl->setVariable("KEY", $logdata->key);
$logtpl->setVariable("VALUE", $logdata->value);
$logtpl->setVariable("RESULT", $logdata->result);
$logtpl->setVariable("ERRORCODE", $errorcode);
$logtpl->setVariable("IMPORTANTKEY", "".$importantkey);
$logtpl->setVariable("COLOR", $color);
$logtpl->parseCurrentBlock();
}
/*
if ($sqlwrite == true) {
$ilLog->write("SQL WRITE");
$logtpl->setCurrentBlock("SqlLog");
$logtpl->setVariable("SQL_STRING", $sql_text);
$logtpl->parseCurrentBlock();
}
*/
//create summary
if ($logdata->action == "SUMMARY") {
$this->createSummary($tmp_content);
}
fwrite($fh_txt,$logtpl->get());
fclose($fh_txt);
fclose($fh_csv);
}

+ Here is the caller graph for this function:

ilSCORM13Player::quoteJSONArray (   $a_array)

Definition at line 1550 of file ilSCORM13Player.php.

{
global $ilDB;
if(!is_array($a_array) or !count($a_array))
{
return array("''");
}
foreach($a_array as $k => $item)
{
if ($item != null) {
$a_array[$k] = $ilDB->quote($item);
} else {
$a_array[$k] = "NULL";
}
}
return $a_array;
}
ilSCORM13Player::readFile (   $path)

Try to find file, identify content type, write it to buffer, and stop immediatly If no file given, read file from PATH_INFO, check permission by cookie, and write out and stop.

Parameters
$pathfilename
Returns
void

Definition at line 1605 of file ilSCORM13Player.php.

References $path.

{
if (headers_sent())
{
die('Error: Cookie could not be established');
}
$SAHS_LM_POSITION = 1; // index position of sahs_lm id in splitted path_info
$comp = explode('/', (string) $path);
$sahs = $comp[$SAHS_LM_POSITION];
$cook = $this->getCookie();
$perm = $cook[$sahs];
if (!$perm)
{
// check login an package access
// TODO add rbac check function here
$perm = 1;
if (!$perm)
{
header('HTTP/1.0 401 Unauthorized');
die('/* Unauthorized */');
}
// write cookie
$cook[$sahs] = $perm;
$this->setCookie($cook);
}
$path = '.' . $path;
if (!is_file($path))
{
header('HTTP/1.0 404 Not Found');
die('/* Not Found ' . $path . '*/');
}
// send mimetype to client
header('Content-Type: ' . $this->getMimetype($path));
// let page be cached in browser for session duration
header('Expires: ' . gmdate('D, d M Y H:i:s', time() + session_cache_expire()*60) . ' GMT');
header('Cache-Control: private');
// now show it to the user and be fine
readfile($path);
die();
}
ilSCORM13Player::readGObjective ( )

Definition at line 599 of file ilSCORM13Player.php.

References $data, $ilLog, $ilUser, $packageId, $query, $res, and $row.

Referenced by executeCommand().

{
global $ilDB, $ilUser, $ilLog;
//get json string
$g_data = new stdClass();
$global_to_system = 1;
$res = $ilDB->queryF('SELECT global_to_system FROM cp_package WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
while($data = $ilDB->fetchAssoc($res))
{
$global_to_system = $data['global_to_system'];
}
$query = 'SELECT objective_id, scope_id, satisfied, measure, user_id,
score_min, score_max, score_raw, completion_status,
progress_measure '
. 'FROM cmi_gobjective, cp_node, cp_mapinfo '
. 'WHERE (cmi_gobjective.objective_id <> %s AND cmi_gobjective.status IS NULL '
. 'AND cp_node.slm_id = %s AND cp_node.nodename = %s '
. 'AND cp_node.cp_node_id = cp_mapinfo.cp_node_id '
. 'AND cmi_gobjective.objective_id = cp_mapinfo.targetobjectiveid) '
. 'GROUP BY objective_id, scope_id, satisfied, measure, user_id,
score_min, score_max, score_raw, completion_status,
progress_measure';
$res = $ilDB->queryF(
$query,
array('text', 'integer', 'text'),
array('-course_overall_status-', $this->packageId, 'mapInfo')
);
while($row = $ilDB->fetchAssoc($res))
{
if (($global_to_system == 1 && $row['scope_id'] == 0) || ($global_to_system == 0 && $row['scope_id'] == $this->packageId))
{
$learner = $row['user_id'];
$objective_id = $row['objective_id'];
if($row['scope_id'] == 0)
{
$scope = "null";
}
else
{
$scope = $row['scope_id'];
}
if($row['satisfied'] != NULL)
{
$toset = $row['satisfied'];
$g_data->{"satisfied"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
if($row['measure'] != NULL)
{
$toset = $row['measure'];
$g_data->{"measure"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
if($row['score_raw'] != NULL)
{
$toset = $row['score_raw'];
$g_data->{"score_raw"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
if($row['score_min'] != NULL)
{
$toset = $row['score_min'];
$g_data->{"score_min"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
if($row['score_max'] != NULL)
{
$toset = $row['score_max'];
$g_data->{"score_max"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
if($row['progress_measure'] != NULL)
{
$toset = $row['progress_measure'];
$g_data->{"progress_measure"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
if($row['completion_status'] != NULL)
{
$toset = $row['completion_status'];
$g_data->{"completion_status"}->{$objective_id}->{$learner}->{$scope} = $toset;
}
}
}
$gobjective_data = json_encode($g_data);
$ilLog->write("SCORM2004 gobjective_data=".$gobjective_data);
if ($this->jsMode)
{
header('Content-Type: text/javascript; charset=UTF-8');
print($gobjective_data);
}
else
{
header('Content-Type: text/plain; charset=UTF-8');
$gobjective_data = json_decode($gobjective_data);
print_r($gobjective_data);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::readSharedData (   $sco_node_id)

Definition at line 901 of file ilSCORM13Player.php.

References $ilUser, $query, $res, $row, and exit.

Referenced by executeCommand().

{
global $ilDB, $ilUser;
$dataStores = array( "data" => array(),
"permissions" => array());
$readPermissions = array();
$query = 'SELECT target_id, read_shared_data, write_shared_data '
. 'FROM cp_datamap '
. 'WHERE slm_id = %s '
. 'AND sco_node_id = %s '
. 'GROUP BY target_id, read_shared_data, write_shared_data';
$res = $ilDB->queryF(
$query,
array('integer', 'integer'),
array($this->packageId, $sco_node_id)
);
//Pass 1: Get all the shared data target_ids
// for this content package
while($row = $ilDB->fetchAssoc($res))
{
$storeVal = ($row['read_shared_data'] == 0 && $row['write_shared_data'] == 1 )
? 'notWritten'
: null;
$dataStores["data"][$row['target_id']] = array( "store" => $storeVal,
"readSharedData" => $row['read_shared_data'],
"writeSharedData" => $row['write_shared_data']);
$dataStores["readPermissions"][$row['target_id']] = $row['read_shared_data'];
}
if(count($dataStores) < 1)
{
//If there are no datastores, then return nothing
echo "";
exit();
}
else if ($dataStores["readPermissions"] != null && array_sum($dataStores["readPermissions"]) != 0)
{
//If there exists at least one readSharedData permission, then
//fill in the existing values (if any) already in the store.
//Create the params to add to the Pass 2 query (get existing values)
$params = array("types" => array("integer", "integer"),
"values" => array($this->userId, $this->packageId));
$paramTemplate = '';
//See if readSharedData is set for each datamap.
//If set to true, then add it to the search query
foreach($dataStores["data"] as $key => $val)
{
if($dataStores["readPermissions"][$key] == 1
&& $dataStores["data"][$key]["store"] != 'notWritten')
{
$params["types"][] = "text";
$params["values"][] = $key;
$paramTemplate .= '%s, ';
}
}
//Get rid of the trailing ', '
$paramTemplate = substr($paramTemplate, 0, strlen($paramTemplate) - 2);
//Pass 2: Query for values previously saved by the user
$query = 'SELECT target_id, store '
. 'FROM adl_shared_data '
. 'WHERE user_id = %s '
. 'AND slm_id = %s '
. 'AND target_id IN (' . $paramTemplate . ')';
$res = $ilDB->queryF(
$query,
$params["types"],
$params["values"]
);
while($row = $ilDB->fetchAssoc($res))
{
$dataStores["data"][$row['target_id']]["store"] = $row['store'];
}
}
header('Content-Type: text/javascript; charset=UTF-8');
echo json_encode($dataStores["data"]);
}

+ Here is the caller graph for this function:

ilSCORM13Player::resetSharedData ( )

Definition at line 1763 of file ilSCORM13Player.php.

References $res.

Referenced by getPlayer().

{
global $ilDB;
//Reset the shared data stores if sharedDataGlobalToSystem is false
$res = $ilDB->queryF('
SELECT shared_data_global_to_system
FROM cp_package
WHERE obj_id = %s',
array('integer'),
array($this->packageId)
);
$shared_global_to_sys = $ilDB->fetchObject($res)->shared_data_global_to_system;
$res = $ilDB->queryF('
SELECT data
FROM cp_suspend
WHERE obj_id = %s
AND user_id = %s',
array('integer', 'integer'),
array($this->packageId, $this->userId)
);
$suspended = false;
$dat = $ilDB->fetchObject($res)->data;
if($dat != null && $dat != '' ) $suspended = true;
if($shared_global_to_sys == 0 && !$suspended)
{
$ilDB->manipulateF('
DELETE FROM adl_shared_data
WHERE slm_id = %s
AND user_id = %s',
array('integer', 'integer'),
array($this->packageId, $this->userId)
);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::save_module_version ( )

save the active module version to scorm_tracking

Definition at line 1805 of file ilSCORM13Player.php.

References $ilUser, and $res.

Referenced by getPlayer().

{
global $ilDB, $ilUser;
$res = $ilDB->queryF('
SELECT rvalue FROM cmi_custom
WHERE user_id = %s
AND sco_id = %s
AND lvalue = %s
AND obj_id = %s',
array('integer', 'integer', 'text', 'integer'),
array($this->userId, 0, 'module_version', $this->packageId)
);
if(!$ilDB->numRows($res))
{
$ilDB->manipulateF('
INSERT INTO cmi_custom (rvalue, user_id, sco_id, obj_id, lvalue, c_timestamp)
VALUES(%s, %s, %s, %s, %s, %s)',
array('text', 'integer', 'integer', 'integer', 'text', 'timestamp'),
array($this->get_Module_Version(), $this->userId, 0, $this->packageId, 'module_version', date('Y-m-d H:i:s'))
);
}
else
{
//optimize: check first if $this->get_Module_Version() = module_version
$ilDB->manipulateF('
UPDATE cmi_custom
SET rvalue = %s,
c_timestamp = %s
WHERE user_id = %s
AND sco_id = %s
AND obj_id = %s
AND lvalue = %s',
array('text', 'timestamp', 'integer', 'integer', 'integer', 'text'),
array($this->get_Module_Version(), date('Y-m-d H:i:s'), $this->userId, 0, $this->packageId, 'module_version')
);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::scormPlayerUnload ( )

Definition at line 502 of file ilSCORM13Player.php.

References $data, $ilUser, ilSCORM2004Tracking\_syncReadEvent(), and set_last_visited().

Referenced by executeCommand().

{
global $ilUser;
$data = json_decode(is_string($data) ? $data : file_get_contents('php://input'));
if($data && is_string($data) && $data!="")
$this->set_last_visited($this->packageId, $this->userId, $data);
include_once("./Modules/Scorm2004/classes/class.ilSCORM2004Tracking.php");
ilSCORM2004Tracking::_syncReadEvent($this->packageId, $this->userId, "sahs", $this->ref_id);
header('Content-Type: text/plain; charset=UTF-8');
print("");
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Player::set_last_visited (   $a_obj_id,
  $a_user_id,
  $last_visited 
)

Definition at line 2621 of file ilSCORM13Player.php.

Referenced by scormPlayerUnload().

{
global $ilDB;
$pre_last_visited=$this->get_last_visited($a_obj_id, $a_user_id);
if ($pre_last_visited == $last_visited) return;
if ($pre_last_visited == null) {
$ilDB->manipulateF('
INSERT INTO cmi_custom (rvalue, user_id, sco_id, obj_id, lvalue, c_timestamp)
VALUES(%s, %s, %s, %s, %s, %s)',
array('text', 'integer', 'integer', 'integer', 'text', 'timestamp'),
array($last_visited, $a_user_id, 0, $a_obj_id, 'last_visited', date('Y-m-d H:i:s'))
);
}
else
{
$ilDB->manipulateF('
UPDATE cmi_custom
SET rvalue = %s,
c_timestamp = %s
WHERE user_id = %s
AND sco_id = %s
AND obj_id = %s
AND lvalue = %s',
array('text', 'timestamp', 'integer', 'integer', 'integer', 'text'),
array($last_visited, date('Y-m-d H:i:s'), $a_user_id, 0, $a_obj_id, 'last_visited')
);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::setCMIData (   $userId,
  $packageId,
  $data 
)
private

Definition at line 1308 of file ilSCORM13Player.php.

References $data, $ilLog, $res, $result, $row, and ilLPStatusWrapper\_updateStatus().

{
global $ilDB, $ilLog;
$result = array();
if (!$data) return;
$i_check=$data->i_check;
$i_set=$data->i_set;
$b_node_update=false;
$cmi_node_id=null;
$a_map_cmi_interaction_id=array();
$tables = array('node', 'comment', 'interaction', 'objective', 'correct_response');
foreach($tables as $table)
{
if (!is_array($data->$table)) continue;
$ilLog->write("SCORM: setCMIData, table -".$table."-");
// now iterate through data rows from input
foreach($data->$table as &$row)
{
$ilLog->write("Checking table: ".$table);
switch($table)
{
case 'node': //is always first and has only 1 row
$res = $ilDB->queryF(
'SELECT cmi_node_id FROM cmi_node WHERE cp_node_id = %s and user_id = %s',
array('integer','integer'),
array($row[19],$userId)
);
$rowtmp=$ilDB->fetchAssoc($res);
$cmi_node_id=$rowtmp['cmi_node_id'];
if ($cmi_node_id!=null) $b_node_update=true;
else {
$cmi_node_id = $ilDB->nextId('cmi_node');
$b_node_update=false;
}
$ilLog->write("setCMIdata with cmi_node_id = ".$cmi_node_id);
$a_data=array(
'accesscount' => array('integer', $row[0]),
'accessduration' => array('text', $row[1]),
'accessed' => array('text', $row[2]),
'activityabsduration' => array('text', $row[3]),
'activityattemptcount' => array('integer', $row[4]),
'activityexpduration' => array('text', $row[5]),
'activityprogstatus' => array('integer', $row[6]),
'attemptabsduration' => array('text', $row[7]),
'attemptcomplamount' => array('float', $row[8]),
'attemptcomplstatus' => array('integer', $row[9]),
'attemptexpduration' => array('text', $row[10]),
'attemptprogstatus' => array('integer', $row[11]),
'audio_captioning' => array('integer', $row[12]),
'audio_level' => array('float', $row[13]),
'availablechildren' => array('text', $row[14]),
'cmi_node_id' => array('integer', $cmi_node_id),
'completion' => array('float', $row[16]),
'completion_status' => array('text', $row[17]),
'completion_threshold' => array('text', $row[18]),
'cp_node_id' => array('integer', $row[19]),
'created' => array('text', $row[20]),
'credit' => array('text', $row[21]),
'delivery_speed' => array('float', $row[22]),
'c_entry' => array('text', $row[23]),
'c_exit' => array('text', $row[24]),
'c_language' => array('text', $row[25]),
'launch_data' => array('clob', $row[26]),
'learner_name' => array('text', $row[27]),
'location' => array('text', $row[28]),
'c_max' => array('float', $row[29]),
'c_min' => array('float', $row[30]),
'c_mode' => array('text', $row[31]),
'modified' => array('text', $row[32]),
'progress_measure' => array('float', $row[33]),
'c_raw' => array('float', $row[34]),
'scaled' => array('float', $row[35]),
'scaled_passing_score' => array('float', $row[36]),
'session_time' => array('text', $row[37]),
'success_status' => array('text', $row[38]),
'suspend_data' => array('clob', $row[39]),
'total_time' => array('text', $row[40]),
'user_id' => array('integer', $userId),
'c_timestamp' => array('timestamp', date('Y-m-d H:i:s')),
'additional_tables' => array('integer', $i_check)
);
if($b_node_update==false) {
$ilLog->write("Want to insert row: ".count($row) );
$ilDB->insert('cmi_node', $a_data);
} else {
$ilDB->update('cmi_node', $a_data, array('cmi_node_id' => array('integer', $cmi_node_id)));
$ilLog->write("updated");
}
if($b_node_update==true) {
//remove
if ($i_set>7) {
$i_set-=8;
if ($this->slm->getComments()) {
$q = 'DELETE FROM cmi_comment WHERE cmi_node_id = %s';
$ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
}
}
if ($i_set>3) {
$i_set-=4;
if ($this->slm->getInteractions()) {
$q = 'DELETE FROM cmi_correct_response
WHERE cmi_interaction_id IN (
SELECT cmi_interaction.cmi_interaction_id FROM cmi_interaction WHERE cmi_interaction.cmi_node_id = %s)';
$ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
}
}
if ($i_set>1) {
$i_set-=2;
if ($this->slm->getInteractions()) {
$q = 'DELETE FROM cmi_interaction WHERE cmi_node_id = %s';
$ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
}
}
if ($i_set>0) {
$i_set=0;
if ($this->slm->getObjectives()) {
$q = 'DELETE FROM cmi_objective WHERE cmi_node_id = %s';
$ilDB->manipulateF($q, array('integer'), array($cmi_node_id));
}
}
//end remove
}
//to send to client
$result[(string)$row[19]] = $cmi_node_id;
break;
case 'comment':
$row[0] = $ilDB->nextId('cmi_comment');
$ilDB->insert('cmi_comment', array(
'cmi_comment_id' => array('integer', $row[0]),
'cmi_node_id' => array('integer', $cmi_node_id),
'c_comment' => array('clob', $row[2]),
'c_timestamp' => array('text', $row[3]),
'location' => array('text', $row[4]),
'sourceislms' => array('integer', $row[5])
));
break;
case 'interaction':
$cmi_interaction_id = $ilDB->nextId('cmi_interaction');
$a_map_cmi_interaction_id[]=array($row[0],$cmi_interaction_id);
$ilDB->insert('cmi_interaction', array(
'cmi_interaction_id' => array('integer', $cmi_interaction_id),
'cmi_node_id' => array('integer', $cmi_node_id),
'description' => array('clob', $row[2]),
'id' => array('text', $row[3]),
'latency' => array('text', $row[4]),
'learner_response' => array('clob', $row[5]),
'result' => array('text', $row[6]),
'c_timestamp' => array('text', $row[7]),
'c_type' => array('text', $row[8]),
'weighting' => array('float', $row[9])
));
break;
case 'objective':
$row[2] = $ilDB->nextId('cmi_objective');
$cmi_interaction_id = null;
if ($row[0] != null) {
for($i=0;$i<count($a_map_cmi_interaction_id);$i++)
if ($row[0] == $a_map_cmi_interaction_id[$i][0]) $cmi_interaction_id=$a_map_cmi_interaction_id[$i][1];
}
$ilDB->insert('cmi_objective', array(
'cmi_interaction_id' => array('integer', $cmi_interaction_id),
'cmi_node_id' => array('integer', $cmi_node_id),
'cmi_objective_id' => array('integer', $row[2]),
'completion_status' => array('text', $row[3]),
'description' => array('clob', $row[4]),
'id' => array('text', $row[5]),
'c_max' => array('float', $row[6]),
'c_min' => array('float', $row[7]),
'c_raw' => array('float', $row[8]),
'scaled' => array('float', $row[9]),
'progress_measure' => array('float', $row[10]),
'success_status' => array('text', $row[11]),
'scope' => array('text', $row[12])
));
break;
case 'correct_response':
$cmi_interaction_id = null;
if ($row[1] !== null) {
for($i=0;$i<count($a_map_cmi_interaction_id);$i++)
if ($row[1] == $a_map_cmi_interaction_id[$i][0]) $cmi_interaction_id=$a_map_cmi_interaction_id[$i][1];
$row[0] = $ilDB->nextId('cmi_correct_response');
$ilDB->insert('cmi_correct_response', array(
'cmi_correct_resp_id' => array('integer', $row[0]),
'cmi_interaction_id' => array('integer', $cmi_interaction_id),
'pattern' => array('text', $row[2])
));
}
break;
}
}
}
$changed_seq_utilities=$data->changed_seq_utilities;
$ilLog->write("SCORM2004 adl_seq_utilities changed: ".$changed_seq_utilities);
if ($changed_seq_utilities == 1) {
$this->writeGObjective($data->adl_seq_utilities);
}
//ATTENTION not at commit - do at unload!
// sync access number and time in read event table
//include_once("./Modules/Scorm2004/classes/class.ilSCORM2004Tracking.php");
//ilSCORM2004Tracking::_syncReadEvent($packageId, $userId, "sahs", $a_ref_id);
// update learning progress status
include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
ilLPStatusWrapper::_updateStatus($packageId, $userId);
// include_once './Modules/Scorm2004/classes/class.ilSCORM2004Tracking.php';
// $new_global_status = ilSCORM2004Tracking::updateGlobalStatus($userId, $packageId,$completed, $satisfied, $measure);
// $ilLog->write("new_global_status=".$new_global_status);
// $saved_global_status=$data->saved_global_status;
// $ilLog->write("saved_global_status=".$saved_global_status);
// $result["new_global_status"]=$new_global_status;
// here put code for soap to MaxCMS e.g. when if($saved_global_status != $new_global_status)
$result["new_global_status"]="";
return $result;
}

+ Here is the call graph for this function:

ilSCORM13Player::setCookie (   $cook)

Definition at line 1594 of file ilSCORM13Player.php.

{
setCookie(IL_OP_COOKIE_NAME, base64_encode(serialize($cook)));
}
ilSCORM13Player::specialPage ( )

Definition at line 1076 of file ilSCORM13Player.php.

References $lng, and ilUtil\getStyleSheetLocation().

Referenced by executeCommand().

{
global $lng;
$specialpages = array (
"_COURSECOMPLETE_" => "seq_coursecomplete",
"_ENDSESSION_" => "seq_endsession",
"_SEQBLOCKED_" => "seq_blocked",
"_NOTHING_" => "seq_nothing",
"_ERROR_" => "seq_error",
"_DEADLOCK_" => "seq_deadlock",
"_INVALIDNAVREQ_" => "seq_invalidnavreq",
"_SEQABANDON_" => "seq_abandon",
"_SEQABANDONALL_" => "seq_abandonall",
"_TOC_" => "seq_toc"
);
$this->tpl = new ilTemplate("tpl.scorm2004.specialpages.html", false, false, "Modules/Scorm2004");
$this->tpl->setVariable("LOCATION_STYLESHEET", ilUtil::getStyleSheetLocation());
$this->tpl->setVariable('TXT_SPECIALPAGE',$lng->txt($specialpages[$this->page]));
if ($this->page!="_TOC_" && $this->page!="_SEQABANDON_" && $this->page!="_SEQABANDONALL_" ) {
$this->tpl->setVariable('CLOSE_WINDOW',$lng->txt('seq_close'));
} else {
$this->tpl->setVariable('CLOSE_WINDOW',"");
}
$this->tpl->show("DEFAULT", false);
}

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

ilSCORM13Player::summaryFileName ( )
private

Definition at line 1882 of file ilSCORM13Player.php.

References $filename.

{
$filename = $this->logDirectory()."/".$this->packageId."_summary_".$this->get_actual_attempts();
$adder = "0";
$suffix = ".csv";
$i = 0;
while (file_exists($filename."_".$adder.$suffix)) {
$i++;
$adder = (string) $i;
}
$retname = $filename."_".$adder.$suffix;
if (!file_exists($retname)) {
umask(0000);
$fHandle = fopen($retname, 'a') or die("can't open file");
fwrite($fHandle, $string);
fclose($fHandle);
}
return $retname;
}
ilSCORM13Player::suspendADLActData ( )

Definition at line 567 of file ilSCORM13Player.php.

References $ilUser, and $res.

Referenced by executeCommand().

{
global $ilDB, $ilUser;
$res = $ilDB->queryF(
'SELECT * FROM cp_suspend WHERE obj_id = %s AND user_id = %s',
array('integer', 'integer'),
array($this->packageId, $ilUser->getId())
);
if(!$ilDB->numRows($res))
{
$ilDB->insert('cp_suspend', array(
'data' => array('clob', file_get_contents('php://input')),
'obj_id' => array('integer', $this->packageId),
'user_id' => array('integer', $ilUser->getId())
));
}
else
{
$ilDB->update('cp_suspend',
array(
'data' => array('clob', file_get_contents('php://input'))
),
array(
'obj_id' => array('integer', $this->packageId),
'user_id' => array('integer', $ilUser->getId())
)
);
}
}

+ Here is the caller graph for this function:

ilSCORM13Player::writeGObjective (   $g_data)

Definition at line 708 of file ilSCORM13Player.php.

References $ilLog, and $ilUser.

{
global $ilDB, $ilUser, $ilLog;
$ilLog->write("SCORM2004 writeGObjective");
$user = $ilUser->getId();
$package = $this->packageId;
//get json string
// $g_data = json_decode(file_get_contents('php://input'));
//iterate over assoziative array
if($g_data == null)
return null;
$rows_to_insert = Array();
foreach($g_data as $key => $value)
{
$ilLog->write("SCORM2004 writeGObjective -key: ".$key);
//objective
//learner = ilias learner id
//scope = null / course
foreach($value as $skey => $svalue)
{
$ilLog->write("SCORM2004 writeGObjective -skey: ".$skey);
//we always have objective and learner id
if($g_data->$key->$skey->$user->$package)
{
$o_value = $g_data->$key->$skey->$user->$package;
$scope = $package;
}
else //UK: is this okay? can $scope=0 and $user->{"null"}; when is $scope used?
{
//scope 0
$o_value = $g_data->$key->$skey->$user->{"null"};
//has to be converted to NULL in JS Later
$scope = 0;
}
//insert into database
$objective_id = $skey;
$toset = $o_value;
$dbuser = $ilUser->getId();
if($key == "status")
{
//special handling for status
$completed = $g_data->$key->$skey->$user->{completed};
$measure = $g_data->$key->$skey->$user->{measure};
$satisfied = $g_data->$key->$skey->$user->{satisfied};
$obj = '-course_overall_status-';
$pkg_id = $this->packageId;
$res = $ilDB->queryF('
SELECT user_id FROM cmi_gobjective
WHERE objective_id =%s
AND user_id = %s
AND scope_id = %s',
array('text', 'integer', 'integer'),
array($obj, $dbuser, $pkg_id)
);
$ilLog->write("SCORM2004 Count is: ".$ilDB->numRows($res));
if(!$ilDB->numRows($res))
{
$ilDB->manipulateF('
INSERT INTO cmi_gobjective
(user_id, status, scope_id, measure, satisfied, objective_id)
VALUES (%s, %s, %s, %s, %s, %s)',
array('integer', 'text', 'integer', 'text', 'text', 'text'),
array($dbuser, $completed, $pkg_id, $measure, $satisfied, $obj)
);
$ilLog->write("SCORM2004 cmi_gobjective Insert status=".$completed." scope_id=".$pkg_id." measure=".$measure." satisfied=".$satisfied." objective_id=".$obj);
}
else
{
$ilDB->manipulateF('
UPDATE cmi_gobjective
SET status = %s,
measure = %s,
satisfied = %s
WHERE objective_id = %s
AND user_id = %s
AND scope_id = %s',
array('text', 'text', 'text', 'text', 'integer', 'integer'),
array($completed, $measure, $satisfied, $obj, $dbuser, $pkg_id)
);
$ilLog->write("SCORM2004 cmi_gobjective Update status=".$completed." scope_id=".$pkg_id." measure=".$measure." satisfied=".$satisfied." objective_id=".$obj);
}
} else //add it to the rows_to_insert
{
//create the row if this is the first time it has been found
if($rows_to_insert[$objective_id] == NULL)
{
$rows_to_insert[$objective_id] = Array();
}
$rows_to_insert[$objective_id][$key] = $toset;
}
}
}
//Get the scope for all the global objectives!!!
$res = $ilDB->queryF("SELECT global_to_system
FROM cp_package
WHERE obj_id = %s",
array('text'),
array($this->packageId)
);
$scope_id = ($ilDB->fetchObject($res)->global_to_system) ? 0 : $this->packageId;
//build up the set to look for in the query
$existing_key_template = "";
foreach(array_keys($rows_to_insert) as $obj_id)
{
$existing_key_template .= "'{$obj_id}',";
}
//remove trailing ','
$existing_key_template = substr($existing_key_template, 0, strlen($existing_key_template) - 1);
$existing_keys = Array();
if($existing_key_template != "")
{
//Get the ones that need to be updated in a single query
$res = $ilDB->queryF("SELECT objective_id
FROM cmi_gobjective
WHERE user_id = %s
AND scope_id = %s
AND objective_id IN ($existing_key_template)",
array('integer', 'integer'),
array($this->userId, $scope_id)
);
while($row = $ilDB->fetchAssoc($res))
{
$existing_keys[] = $row['objective_id'];
}
}
foreach($rows_to_insert as $obj_id => $vals)
{
if(in_array($obj_id, $existing_keys))
{
$ilDB->manipulateF("UPDATE cmi_gobjective
SET satisfied=%s,
measure=%s,
score_raw=%s,
score_min=%s,
score_max=%s,
completion_status=%s,
progress_measure=%s
WHERE objective_id = %s
AND user_id = %s
AND scope_id = %s",
array('text','text', 'text', 'text', 'text', 'text',
'text', 'text', 'integer', 'integer'),
array($vals['satisfied'], $vals["measure"], $vals["score_raw"],
$vals["score_min"], $vals["score_max"],
$vals["completion_status"], $vals["progress_measure"],
$obj_id, $this->userId, $scope_id)
);
} else
{
$ilDB->manipulateF("INSERT INTO cmi_gobjective
(user_id, satisfied, measure, scope_id, status, objective_id,
score_raw, score_min, score_max, progress_measure, completion_status)
VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
array('integer', 'text', 'text', 'integer', 'text', 'text',
'text', 'text', 'text', 'text', 'text'),
array($this->userId, $vals['satisfied'], $vals['measure'],
$scope_id, NULL, $obj_id, $vals['score_raw'],
$vals['score_min'], $vals['score_max'],
$vals['progress_measure'], $vals['completion_status'])
);
}
}
// update learning progress here not necessary because integrated in setCMIdata
// check _updateStatus for cmi_gobjective
// include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
// ilLPStatusWrapper::_updateStatus($package, $user);
return true;
}
ilSCORM13Player::writeSharedData (   $sco_node_id)

Definition at line 995 of file ilSCORM13Player.php.

References $ilUser, $query, $res, and $row.

Referenced by executeCommand().

{
global $ilDB, $ilUser;
$g_data = json_decode(file_get_contents('php://input'));
//Step 1: Get the writeable stores for this SCO that already have values
$query = 'SELECT dm.target_id, sd.store '
. 'FROM cp_datamap dm '
. 'LEFT JOIN adl_shared_data sd '
. 'ON(dm.slm_id = sd.slm_id AND dm.target_id = sd.target_id) '
. 'WHERE sco_node_id = %s '
. 'AND dm.slm_id = %s '
. 'AND write_shared_data = 1 '
. 'AND user_id = %s';
$res = $ilDB->QueryF(
$query,
array('integer', 'integer', 'integer'),
array($sco_node_id, $this->packageId, $this->userId)
);
$dataStores = array();
$originalVals = array();
while($row = $ilDB->fetchAssoc($res))
{
$id = $row['target_id'];
$dataStores[$id] = $g_data->{$id};
$originalVals[$id] = $row['store'];
}
//Step 2: Add the writeable stores
foreach($g_data as $key => $obj)
{
//If it's already created in adl_shared_data, we
//need to update it.
if(array_key_exists($key, $dataStores) )
{
if($obj == 'notWritten') continue;
$query = 'UPDATE adl_shared_data '
. 'SET store = %s '
. 'WHERE user_id = %s '
. 'AND target_id = %s '
. 'AND slm_id = %s ';
$ilDB->manipulateF(
$query,
array('text', 'integer', 'text', 'integer'),
array($dataStores[$key], $this->userId, $key, $this->packageId)
);
} else
{
//Check for writability
$res = $ilDB->queryF(
'SELECT write_shared_data '
. 'FROM cp_datamap '
. 'WHERE target_id = %s '
. 'AND slm_id = %s '
. 'AND sco_node_id = %s',
array('text', 'integer', 'integer'),
array($key, $this->packageId, $sco_node_id));
$row = $ilDB->fetchAssoc($res);
if($row["write_shared_data"] != 1)
{
continue;
}
//If it's writeable, then add the new value into the database
$res = $ilDB->manipulateF(
'INSERT INTO adl_shared_data VALUES (%s, %s, %s, %s)',
array('integer', 'integer', 'text', 'text'),
array($this->packageId, $this->userId, $key, $obj));
}
}
echo "1";
exit();
}

+ Here is the caller graph for this function:

Field Documentation

ilSCORM13Player::$ilias

Definition at line 122 of file ilSCORM13Player.php.

Referenced by __construct(), executeCommand(), and getPlayer().

ilSCORM13Player::$jsMode

Definition at line 120 of file ilSCORM13Player.php.

ilSCORM13Player::$packageId

Definition at line 119 of file ilSCORM13Player.php.

Referenced by getScope(), and readGObjective().

ilSCORM13Player::$schema
staticprivate

Definition at line 23 of file ilSCORM13Player.php.

ilSCORM13Player::$slm

Definition at line 123 of file ilSCORM13Player.php.

ilSCORM13Player::$tpl

Definition at line 124 of file ilSCORM13Player.php.

Referenced by __construct().

ilSCORM13Player::$userId
private

Definition at line 118 of file ilSCORM13Player.php.

const ilSCORM13Player::ENABLE_GZIP = 0

Definition at line 16 of file ilSCORM13Player.php.

const ilSCORM13Player::NONE = 0

Definition at line 18 of file ilSCORM13Player.php.

const ilSCORM13Player::READONLY = 1

Definition at line 19 of file ilSCORM13Player.php.

const ilSCORM13Player::READWRITE = 3

Definition at line 21 of file ilSCORM13Player.php.

const ilSCORM13Player::WRITEONLY = 2

Definition at line 20 of file ilSCORM13Player.php.

The documentation for this class was generated from the following file: