public static function getRegistration($pkgIdPK, $userIdPK)
{
global $ilDB;
$reg = null;
$set = $ilDB->query("SELECT * FROM rep_robj_xscl_reg " . " WHERE pkg_id = " . $ilDB->quote($pkgIdPK, "integer") . " AND usr_id = " . $ilDB->quote($userIdPK, "integer"));
while ($rec = $ilDB->fetchAssoc($set)) {
$reg = new ilObjScormCloudReg($pkgIdPK, $rec["usr_id"]);
$reg->setCompletion($rec["completion"]);
$reg->setSatisfaction($rec["satisfaction"]);
$reg->setScore($rec["score"]);
$reg->setTotalTime($rec["total_time"]);
$reg->setExistsOnCloud($rec["exists_on_cloud"]);
$reg->setAttemptCount($rec["attempt_cnt"]);
$reg->setVersion($rec["version"]);
$reg->setLastAccess($rec["last_access"]);
if (!$reg->getExistsOnCloud()) {
if ($reg->isRegistrationCreatedInScormCloud()) {
$reg->setExistsOnCloud(true);
$reg->doUpdate();
}
}
}
return $reg;
}