ILIAS  Release_4_2_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 ()
 getScope ()
 getSuspendData ()
 suspendADLActData ()
 readGObjective ()
 writeGObjective ()
 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 ()

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)
 removeCMIData ($userId, $packageId, $cp_node_id=null)
 setCMIData ($userId, $packageId, $data, $a_ref_id)
 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, $lng, $tpl, and ilObject\_lookupObjectId().

{
global $ilias, $tpl, $ilCtrl, $ilUser, $lng;
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 2563 of file ilSCORM13Player.php.

References $ilDB, and $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 2183 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 2133 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 163 of file ilSCORM13Player.php.

References $_GET, $cmd, $ilias, $ilLog, $lng, debugGUI(), downloadLog(), fetchCMIData(), getADLActData(), getCPData(), getPlayer(), getRTEjs(), getSuspendData(), liveLogContent(), openLog(), persistCMIData(), postLogEntry(), readGObjective(), readSharedData(), specialPage(), suspendADLActData(), writeGObjective(), 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;
default:
$this->getPlayer();
break;
}
}

+ Here is the call graph for this function:

ilSCORM13Player::fetchCMIData ( )

Definition at line 1062 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 1732 of file ilSCORM13Player.php.

References $ilDB, $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_max_attempts ( )

Get max.

number of attempts allowed for this package

Definition at line 1702 of file ilSCORM13Player.php.

References $ilDB, $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 1716 of file ilSCORM13Player.php.

References $ilDB, $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 449 of file ilSCORM13Player.php.

References $data, $ilDB, 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 1119 of file ilSCORM13Player.php.

References $ilDB, $res, $result, and $row.

{
global $ilDB;
$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 ($this->slm->getComments()) $q = 'SELECT cmi_comment.*
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';
break;
case "correct_response":
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';
break;
case "interaction":
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';
break;
case "objective":
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) $tmp_result[] = str_replace(' ','T',$value);
else $tmp_result[] = $value;
}
$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 1635 of file ilSCORM13Player.php.

References $_COOKIE.

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

Definition at line 423 of file ilSCORM13Player.php.

References $ilDB, and $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 265 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 2105 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 2231 of file ilSCORM13Player.php.

References $ilDB, and $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 409 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.gif",false));
$is_tpl->setVariable('IC_COMPLETED', ilUtil::getImagePath("scorm/completed_s.gif",false));
$is_tpl->setVariable('IC_NOTATTEMPTED', ilUtil::getImagePath("scorm/not_attempted_s.gif",false));
$is_tpl->setVariable('IC_RUNNING', ilUtil::getImagePath("scorm/running_s.gif",false));
$is_tpl->setVariable('IC_INCOMPLETE', ilUtil::getImagePath("scorm/incomplete_s.gif",false));
$is_tpl->setVariable('IC_PASSED', ilUtil::getImagePath("scorm/passed_s.gif",false));
$is_tpl->setVariable('IC_FAILED', ilUtil::getImagePath("scorm/failed_s.gif",false));
$is_tpl->setVariable('IC_BROWSED', ilUtil::getImagePath("scorm/browsed.gif",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 2147 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 2226 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 1621 of file ilSCORM13Player.php.

References $filename, and $mimetypes.

{
$mimetypes = array();
require_once('classes/mimemap.php');
$info = pathinfo($filename);
$ext = $mimetypes[$info['extension']];
return $ext ? $ext : mime_content_type($filename);
}
ilSCORM13Player::getNodeData (   $sco_id,
  $fh 
)
private

Definition at line 1892 of file ilSCORM13Player.php.

References $ilDB, $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 275 of file ilSCORM13Player.php.

References $_GET, $config, $ilias, $ilSetting, $lng, exit, get_actual_attempts(), 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"],
'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"],
'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()
);
//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 252 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 486 of file ilSCORM13Player.php.

References $data, $ilDB, $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 2543 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 506 of file ilSCORM13Player.php.

References $data, $ilDB, 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 1756 of file ilSCORM13Player.php.

References $ilDB, $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 2177 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 2113 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 1949 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("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"));
$logtpl->parseCurrentBlock();
fwrite($fHandle2,$logtpl->get());
fclose($fHandle2);
}
return $filename;
}
ilSCORM13Player::logTmpName ( )
private

Definition at line 1916 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 1106 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 2125 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 1077 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 479 of file ilSCORM13Player.php.

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

Definition at line 2262 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());
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).'";'
.$logdata->errorcode.';'
.$logdata->timespan.';"'
.$errorDescriptions[$logdata->errorcode].'"'."\n";
fwrite($fh_csv,$csv_string);
}
// $sql_txt = "";
$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);
// $sql_txt = $sql_txt.$key." = ".$value.", ";
}
}
//delete files
if ($logdata->action == "DELETE")
{
$filename = $logdata->value;
$path = $this->logDirectory()."/".$filename;
unlink($path);
return;
}
//write TXT
$logtpl = $this->getLogTemplate();
$errorcode = $logdata->errorcode;
$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";
break;
case 'GetValue':
if ($errorcode == 0) $color = "green";
if ($logdata->result == "undefined") $color = "fuchsia";
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";
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", $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 1593 of file ilSCORM13Player.php.

References $ilDB.

{
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 1651 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 570 of file ilSCORM13Player.php.

References $ilDB, $ilLog, $query, $res, and $row.

Referenced by executeCommand().

{
global $ilDB, $ilUser, $ilLog;
//get json string
$g_data = new stdClass();
$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))
{
$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 858 of file ilSCORM13Player.php.

References $ilDB, $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::removeCMIData (   $userId,
  $packageId,
  $cp_node_id = null 
)
private

Definition at line 1244 of file ilSCORM13Player.php.

References $ilDB, $ilLog, and ilLPStatusWrapper\_updateStatus().

{
global $ilDB, $ilLog;
//$ilLog->write("Remove CMI Data");
$delorder = array('correct_response', 'objective', 'interaction', 'comment', 'node');
//error_log("Delete, User:".$userId."Package".$packageId."Node: ".$cp_node_id);
foreach($delorder as $k)
{
if(is_null($cp_node_id))
{
switch($k)
{
case "response":
$q = 'DELETE FROM
cmi_correct_response WHERE cmi_interaction_id IN (
SELECT cmi_interaction.cmi_interaction_id FROM cmi_interaction
INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_interaction.cmi_node_id
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 "interaction":
$q = 'DELETE FROM cmi_interaction
WHERE cmi_node_id IN (
SELECT cmi_node.cmi_node_id 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":
$q = 'DELETE FROM cmi_comment
WHERE cmi_node_id IN (
SELECT cmi_node.cmi_node_id 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 "objective":
$q = 'DELETE FROM cmi_objective
WHERE cmi_node_id IN (
SELECT cmi_node.cmi_node_id 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 "node":
$q = 'DELETE FROM cmi_node
WHERE user_id = %s AND cp_node_id IN (
SELECT cp_node_id FROM cp_node
WHERE slm_id = %s)';
break;
}
$types = array('integer', 'integer');
$values = array($userId, $packageId);
$ilDB->manipulateF($q, $types, $values);
}
else
{
$q = '';
switch($k)
{
case "correct_response":
if ($this->slm->getInteractions())
$q = 'DELETE FROM cmi_correct_response
WHERE cmi_interaction_id IN (
SELECT cmi_interaction.cmi_interaction_id FROM cmi_interaction
INNER JOIN cmi_node ON cmi_node.cmi_node_id = cmi_interaction.cmi_node_id
WHERE cmi_node.cp_node_id = %s
AND cmi_node.user_id = %s)';
break;
case "interaction":
if ($this->slm->getInteractions())
$q = 'DELETE FROM cmi_interaction
WHERE cmi_node_id IN (
SELECT cmi_node.cmi_node_id FROM cmi_node
WHERE cmi_node.cp_node_id = %s
AND cmi_node.user_id = %s)';
break;
case "comment":
if ($this->slm->getComments())
$q = 'DELETE FROM cmi_comment
WHERE cmi_node_id IN (
SELECT cmi_node.cmi_node_id FROM cmi_node
WHERE cmi_node.cp_node_id = %s
AND cmi_node.user_id = %s)';
break;
case "objective":
if ($this->slm->getObjectives())
$q = 'DELETE FROM cmi_objective
WHERE cmi_node_id IN (
SELECT cmi_node.cmi_node_id FROM cmi_node
WHERE cmi_node.cp_node_id = %s
AND cmi_node.user_id = %s)';
break;
case "node":
$q = 'DELETE FROM cmi_node WHERE cp_node_id = %s
AND cmi_node.user_id = %s';
break;
}
if ($q != '') {
$types = array('integer', 'integer');
$values = array($cp_node_id, $userId);
$ilDB->manipulateF($q, $types, $values);
}
}
}
include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
ilLPStatusWrapper::_updateStatus($packageId, $userId);
}

+ Here is the call graph for this function:

ilSCORM13Player::resetSharedData ( )

Definition at line 1809 of file ilSCORM13Player.php.

References $ilDB, and $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 1851 of file ilSCORM13Player.php.

References $ilDB, and $res.

Referenced by getPlayer().

{
global $ilDB, $ilUser;
$res = $ilDB->queryF('
SELECT * 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
{
$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::setCMIData (   $userId,
  $packageId,
  $data,
  $a_ref_id 
)
private

Definition at line 1367 of file ilSCORM13Player.php.

References $data, $ilDB, $ilLog, $result, $ret, $row, ilSCORM2004Tracking\_syncReadEvent(), and ilLPStatusWrapper\_updateStatus().

{
global $ilDB, $ilLog;
$result = array();
$map = array();
if (!$data) return;
$tables = array('node', 'comment', 'interaction', 'objective', 'correct_response');
foreach($tables as $table)
{
$schem = & self::$schema[$table];
//$ilLog->write("SCORM2004 setCMIData, table -".$table."-".$data->objective);
if (!is_array($data->$table)) continue;
$ilLog->write("SCORM2004 setCMIData, table -".$table."-");
// build up numerical index for schema fields
$i = 0;
foreach($schem as &$field)
{
$field['no'] = $i++;
}
// now iterate through data rows from input
foreach($data->$table as &$row)
{
// first fill some fields that could not be set from client side
// namely the database id's depending on which table is processed
switch ($table)
{
case 'correct_response':
$no = $schem['cmi_interaction_id']['no'];
$ilLog->write("SCORM2004 correct_response no: ".$no);
$ilLog->write("SCORM2004 The Row: ".count($row));
$row[$no] = $map['interaction'][$row[$no]];
$ilLog->write("SCORM2004 Value: ".print_r($map['interaction'],true));
case 'comment':
case 'interaction':
$no = $schem['cmi_node_id']['no'];
$row[$no] = $map['node'][$row[$no]];
break;
case 'objective':
$no = $schem['cmi_interaction_id']['no'];
$row[$no] = $map['interaction'][$row[$no]];
$no = $schem['cmi_node_id']['no'];
$row[$no] = $map['node'][$row[$no]];
break;
case 'node':
$no = $schem['user_id']['no'];
$row[$no] = $userId;
break;
}
//$ilLog->write("SCORM2004 setCMIData, row b");
$cp_no = $schem['cp_' . $table . '_id']['no'];
$cmi_no = $schem['cmi_' . $table . '_id']['no'];
// get current id for later use
// this is either a real db id or document unique string generated by client
$cmi_id = $row[$cmi_no];
// set if field to null, so it will be filled up by autoincrement
$row[$cmi_no] = null;
$keys = array();
foreach(array_keys($schem) as $key)
{
$keys[] = $key;
}
//$ilLog->write("SCORM2004 setCMIData, row c");
if($table === 'node')
{
$this->removeCMIData($userId, $packageId, $row[$cp_no]);
}
$ret = false;
$ilLog->write("SCORM2004 Checking table: ".$table);
switch($table)
{
case 'correct_response':
$row[$cmi_no] = $ilDB->nextId('cmi_correct_response');
$ilDB->insert('cmi_correct_response', array(
'cmi_correct_resp_id' => array('integer', $row[$cmi_no]),
'cmi_interaction_id' => array('integer', $row[1]),
'pattern' => array('text', $row[2])
));
break;
case 'comment':
$row[$cmi_no] = $ilDB->nextId('cmi_comment');
$ilDB->insert('cmi_comment', array(
'cmi_comment_id' => array('integer', $row[$cmi_no]),
'cmi_node_id' => array('integer', $row[1]),
'c_comment' => array('clob', $row[2]),
'c_timestamp' => array('timestamp', $row[3]),
'location' => array('text', $row[4]),
'sourceislms' => array('integer', $row[5])
));
break;
case 'interaction':
$row[$cmi_no] = $ilDB->nextId('cmi_interaction');
$ilDB->insert('cmi_interaction', array(
'cmi_interaction_id' => array('integer', $row[$cmi_no]),
'cmi_node_id' => array('integer', $row[1]),
'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[$cmi_no] = $ilDB->nextId('cmi_objective');
$ilDB->insert('cmi_objective', array(
'cmi_interaction_id' => array('integer', $row[0]),
'cmi_node_id' => array('integer', $row[1]),
'cmi_objective_id' => array('integer', $row[$cmi_no]),
'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 'node':
$row[$cmi_no] = $ilDB->nextId('cmi_node');
$node_fields = array(
'accesscount', 'accessduration', 'accessed', 'activityabsduration', 'activityattemptcount',
'activityexpduration', 'activityprogstatus', 'attemptabsduration', 'attemptcomplamount', 'attemptcomplstatus',
'attemptexpduration', 'attemptprogstatus', 'audio_captioning', 'audio_level', 'availablechildren',
'cmi_node_id', 'completion', 'completion_status', 'completion_threshold', 'cp_node_id',
'created', 'credit', 'delivery_speed', 'c_entry', 'c_exit',
'c_language', 'launch_data', 'learner_name', 'location', 'c_max',
'c_min', 'c_mode', 'modified', 'progress_measure', 'c_raw',
'scaled', 'scaled_passing_score', 'session_time', 'success_status', 'suspend_data',
'total_time', 'user_id', 'c_timestamp'
);
$node_types = array(
'integer', 'text', 'text', 'text', 'integer', 'text', 'integer', 'text', 'float', 'integer',
'text', 'integer', 'integer', 'float', 'text', 'integer', 'float', 'text', 'text', 'integer',
'text', 'text', 'float', 'text', 'text', 'text', 'clob', 'text', 'text', 'float',
'float', 'text', 'text', 'float', 'float', 'float', 'float', 'text', 'text', 'clob',
'text', 'integer', 'timestamp'
);
$node_data = array();
foreach($node_fields as $key => $node_field)
{
if($key == 15)
$value = $row[$cmi_no];
else if($key == 42)
$value = date('Y-m-d H:i:s');
else
$value = $row[$key];
$node_data[$node_field] = array($node_types[$key], $value);
}
$ilLog->write("SCORM2004 Want to insert row: ".count($row) );
$ilDB->insert('cmi_node', $node_data);
break;
}
$ret = true;
if(!$ret) //UK: sense?
{
$return = false;
break;
}
// if we process a node save new id into result object that will be feedback for client
if($table === 'node')
{
$result[(string)$row[$cp_no]] = $row[$cmi_no];
}
// add new id to mapping table for later use on dependend elements
$map[$table][$cmi_id] = $row[$cmi_no];
}
}
//UK change here like in lbex_dev 1297-1323
//hier global_objectives
//UK
//hier update_global_status
//analog sendUserLpForObject $scorm_status bestimmen
//mit status_ante um status_changed zu bestimmen
//if status_changed soap-Aufruf starten
//$result["status_changed"]=
//if status_changed opener_reload
//$ilLog->write("SCORM2004 -synching-");
// 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);
return $result;
}

+ Here is the call graph for this function:

ilSCORM13Player::setCookie (   $cook)

Definition at line 1640 of file ilSCORM13Player.php.

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

Definition at line 1033 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 1928 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 538 of file ilSCORM13Player.php.

References $ilDB, 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 ( )

Definition at line 666 of file ilSCORM13Player.php.

References $ilDB, and $ilLog.

Referenced by executeCommand().

{
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 * 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
include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
ilLPStatusWrapper::_updateStatus($package, $user);
echo "1";
}

+ Here is the caller graph for this function:

ilSCORM13Player::writeSharedData (   $sco_node_id)

Definition at line 952 of file ilSCORM13Player.php.

References $ilDB, $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().

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: