Class ilObjSCORMTracking. More...
Inheritance diagram for ilObjSCORMTracking:
Public Member Functions | |
| ilObjSCORMTracking () | |
| Constructor public. | |
| extractData () | |
| store ($ref_id=0, $sahs_id=0, $extractData=1) | |
| _insertTrackData ($a_sahs_id, $a_lval, $a_rval, $a_ref_id) | |
Detailed Description
Class ilObjSCORMTracking.
Definition at line 30 of file class.ilObjSCORMTracking.php.
Member Function Documentation
| ilObjSCORMTracking::_insertTrackData | ( | $ | a_sahs_id, | |
| $ | a_lval, | |||
| $ | a_rval, | |||
| $ | a_ref_id | |||
| ) |
Definition at line 154 of file class.ilObjSCORMTracking.php.
Referenced by ilSCORMItem::insertTrackData(), ilAICCUnit::insertTrackData(), and ilAICCCourse::insertTrackData().
{
global $ilDB, $ilUser;
$q = "INSERT INTO scorm_tracking (user_id, sco_id, lvalue, rvalue, ref_id) ".
" VALUES (".$ilDB->quote($ilUser->getId()).",".$ilDB->quote($a_sahs_id).
",".$ilDB->quote($a_lval).",".$ilDB->quote($a_rval).
",".$ilDB->quote($a_ref_id).")";
$ilDB->query($q);
}
Here is the caller graph for this function:
| ilObjSCORMTracking::extractData | ( | ) |
Definition at line 42 of file class.ilObjSCORMTracking.php.
Referenced by store().
{
$this->insert = array();
if (is_array($_GET["iL"]))
{
foreach($_GET["iL"] as $key => $value)
{
$this->insert[] = array("left" => $value, "right" => $_GET["iR"][$key]);
}
}
if (is_array($_POST["iL"]))
{
foreach($_POST["iL"] as $key => $value)
{
$this->insert[] = array("left" => $value, "right" => $_POST["iR"][$key]);
}
}
$this->update = array();
if (is_array($_GET["uL"]))
{
foreach($_GET["uL"] as $key => $value)
{
$this->update[] = array("left" => $value, "right" => $_GET["uR"][$key]);
}
}
if (is_array($_POST["uL"]))
{
foreach($_POST["uL"] as $key => $value)
{
$this->update[] = array("left" => $value, "right" => $_POST["uR"][$key]);
}
}
}
Here is the caller graph for this function:
| ilObjSCORMTracking::ilObjSCORMTracking | ( | ) |
Constructor public.
Definition at line 36 of file class.ilObjSCORMTracking.php.
References $ilias.
{
global $ilias;
}
| ilObjSCORMTracking::store | ( | $ | ref_id = 0, |
|
| $ | sahs_id = 0, |
|||
| $ | extractData = 1 | |||
| ) |
Definition at line 77 of file class.ilObjSCORMTracking.php.
References $_GET, $_POST, $ilUser, $q, $ref_id, $set, $user_id, and extractData().
Referenced by ilObjHACPTracking::putparam().
{
global $ilDB, $ilUser;
if (empty($ref_id))
$ref_id=$_GET["ref_id"];
if (empty($sahs_id))
$sahs_id = ($_GET["sahs_id"] != "") ? $_GET["sahs_id"] : $_POST["sahs_id"];
if ($extractData==1)
$this->extractData();
if (is_object($ilUser))
{
$user_id = $ilUser->getId();
}
// writing to scorm test log
$f = fopen("content/scorm.log", "a");
fwrite($f, "\nCALLING SCORM store()\n");
if ($ref_id <= 1)
{
fwrite($f, "Error: No ref_id given.\n");
}
else
{
foreach($this->insert as $insert)
{
$q = "SELECT * FROM scorm_tracking WHERE ".
" user_id = ".$ilDB->quote($user_id).
" AND sco_id = ".$ilDB->quote($sahs_id).
" AND lvalue = ".$ilDB->quote($insert["left"]);
$set = $ilDB->query($q);
if ($rec = $set->fetchRow(DB_FETCHMODE_ASSOC))
{
fwrite($f, "Error Insert, left value already exists. L:".$insert["left"].",R:".
$insert["right"].",sahs_id:".$sahs_id.",user_id:".$user_id."\n");
}
else
{
$q = "INSERT INTO scorm_tracking (user_id, sco_id, ref_id, lvalue, rvalue) VALUES ".
"(".$ilDB->quote($user_id).",".$ilDB->quote($sahs_id).",".
$ilDB->quote($ref_id).",".
$ilDB->quote($insert["left"]).",".$ilDB->quote($insert["right"]).")";
$ilDB->query($q);
fwrite($f, "Insert - L:".$insert["left"].",R:".
$insert["right"].",sahs_id:".$sahs_id.",user_id:".$user_id."\n");
}
}
foreach($this->update as $update)
{
$q = "SELECT * FROM scorm_tracking WHERE ".
" user_id = ".$ilDB->quote($user_id).
" AND sco_id = ".$ilDB->quote($sahs_id).
" AND lvalue = ".$ilDB->quote($update["left"]);
$set = $ilDB->query($q);
if ($rec = $set->fetchRow(DB_FETCHMODE_ASSOC))
{
$q = "REPLACE INTO scorm_tracking (user_id, sco_id, ref_id, lvalue, rvalue) VALUES ".
"(".$ilDB->quote($user_id).",".$ilDB->quote($sahs_id).",".
$ilDB->quote($ref_id).",".
$ilDB->quote($update["left"]).",".$ilDB->quote($update["right"]).")";
$ilDB->query($q);
fwrite($f, "Update - L:".$update["left"].",R:".
$update["right"].",sahs_id:".$sahs_id.",user_id:".$user_id."\n");
}
else
{
fwrite($f, "ERROR Update, left value does not exist. L:".$update["left"].",R:".
$update["right"].",sahs_id:".$sahs_id.",user_id:".$user_id."\n");
}
}
}
fclose($f);
}
Here is the call graph for this function:
Here is the caller graph for this function:
The documentation for this class was generated from the following file:
- content/classes/SCORM/class.ilObjSCORMTracking.php
