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; }