Collaboration diagram for ilSCORMOfflineMode:

Public Member Functions
	__construct ()
	Constructor. More...

	getSopManifestEntries ()

	getLmManifestEntries ()

	tracking2sop ()

	getClientIdSop ()

	il2sopUserData ()

	il2sopSahsUser ()

	sop2il ()

	scormPlayerUnloadForSop2il ($data)

	setOfflineMode ($a_mode)

	getOfflineMode ()

Static Public Member Functions
static	checkIfAnyoneIsInOfflineMode ($obj_id)

static	usersInOfflineMode ($obj_id)

static	stopOfflineModeForUser ($obj_id, $user_id)

static	encodeuri ($path)

Data Fields
	$type

	$obj_id

	$offlineMode

	$cmd_url

	$lm_cmd_url

	$player12_url

	$player2004_url

	$som_url

	$sop_dir

	$som_dir

	$scripts_dir

	$sop_index

	$sop_appcache

	$lm_dir

	$lm_index

	$lm_appcache

	$lm_imsmanifest_xml

	$imsmanifest

	$debug = false

Private Member Functions
	read ()

Detailed Description

Class ilSCORMOfflineMode.

Class for scorm offline player connection

Author: Uwe Kohnle kohnl.nosp@m.e@in.nosp@m.terne.nosp@m.tleh.nosp@m.rer-g.nosp@m.mbh..nosp@m.de; Stefan Schneider schne.nosp@m.ider.nosp@m.@hrz..nosp@m.uni-.nosp@m.marbu.nosp@m.rg.d.nosp@m.e

Version

Id: class.ilSCORMOfflineMode.php

Definition at line 16 of file class.ilSCORMOfflineMode.php.

Constructor & Destructor Documentation

◆ __construct()

ilSCORMOfflineMode::__construct ( )

Constructor.

Parameters

int $a_id Object ID @access public

Definition at line 46 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilias = $DIC['ilias'];
        $this->ilias = $ilias;
        $this->id = $_GET['ref_id'];
        $this->obj_id = ilObject::_lookupObjectId($_GET['ref_id']);
        include_once "./Modules/ScormAicc/classes/class.ilObjSAHSLearningModule.php";
        $this->type = ilObjSAHSLearningModule::_lookupSubType($this->obj_id);
        $this->cmd_url = './ilias.php?baseClass=ilSAHSPresentationGUI&cmd=';
        $this->lm_cmd_url = './ilias.php?baseClass=ilSAHSPresentationGUI&ref_id=' . $this->id . '&cmd=';
        $this->lm_info_url = $this->lm_cmd_url . 'infoScreen';
        $this->player12_url = $this->cmd_url . 'offlineMode_player12';
        $this->player2004_url = $this->cmd_url . 'offlineMode_player2004';
        $this->som_url = $this->cmd_url . 'offlineMode_som';
        $this->offlineMode = 'online';
        $this->sop_index = './Modules/ScormAicc/sop/sop_index.html';
        $this->sop_appcache = './Modules/ScormAicc/sop/sop.appcache';
        $this->sop_dir = './Modules/ScormAicc/templates/sop/';
        $this->som_dir = './Modules/ScormAicc/templates/som/';
        $this->scripts_dir = './Modules/ScormAicc/scripts/';
        $this->images_dir = './templates/default/images/scorm/';
        $this->pouchdb_js = './libs/bower/bower_components/pouchdb/dist/pouchdb.min.js';
        $this->jquery_js = './libs/bower/bower_components/jquery/dist/jquery.min.js';
        $this->bootstrap_js = './libs/bower/bower_components/bootstrap/dist/js/bootstrap.min.js';
        $this->bootstrap_css = './libs/bower/bower_components/bootstrap/dist/css/bootstrap.min.css';
        $this->read();
    }

References $_GET, $DIC, ilObject\_lookupObjectId(), ilObjSAHSLearningModule\_lookupSubType(), and read().

Here is the call graph for this function:

Member Function Documentation

◆ checkIfAnyoneIsInOfflineMode()

static ilSCORMOfflineMode::checkIfAnyoneIsInOfflineMode ( $obj_id )

static

Definition at line 464 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $res = $ilDB->queryF(
            "SELECT count(*) cnt FROM sahs_user WHERE obj_id=%s AND offline_mode = 'offline'",
            array('integer'),
            array($obj_id)
        );
        $val_rec = $ilDB->fetchAssoc($res);
        if ($val_rec["cnt"] == 0) {
            return false;
        }
        return true;
    }

References $DIC, $ilDB, $obj_id, and $res.

Referenced by ilObjSCORM2004LearningModuleGUI\initPropertiesForm(), and ilObjSCORMLearningModuleGUI\initPropertiesForm().

Here is the caller graph for this function:

◆ encodeuri()

static ilSCORMOfflineMode::encodeuri ( $path )

static

Definition at line 508 of file class.ilSCORMOfflineMode.php.

    {
        return implode('/', array_map('rawurlencode', explode('/', $path)));
    }

Referenced by getLmManifestEntries(), and getSopManifestEntries().

Here is the caller graph for this function:

◆ getClientIdSop()

ilSCORMOfflineMode::getClientIdSop ( )

Definition at line 248 of file class.ilSCORMOfflineMode.php.

    {
        $iliasDomain = substr(ILIAS_HTTP_PATH, 7);
        if (substr($iliasDomain, 0, 1) == "\/") {
            $iliasDomain = substr($iliasDomain, 1);
        }
        if (substr($iliasDomain, 0, 4) == "www.") {
            $iliasDomain = substr($iliasDomain, 4);
        }
        return $iliasDomain . ';' . CLIENT_ID;
    }

References ILIAS_HTTP_PATH.

◆ getLmManifestEntries()

ilSCORMOfflineMode::getLmManifestEntries ( )

Definition at line 146 of file class.ilSCORMOfflineMode.php.

    { // ToDo: database support !!
        global $DIC;
        $log = $DIC['log'];
        $log->write("getLmManifestEntries");
        $this->lm_dir = ilUtil::getWebspaceDir("filesystem") . '/lm_data/lm_' . $this->obj_id;
        $manifest_string = "";
        $objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->lm_dir));
        foreach ($objects as $name => $object) {
            if (preg_match('/\/\.+/', $name)) {
                continue;
            }
            if (preg_match('/\.zip$/', $name)) {
                continue;
            }
            //$manifest_string .= preg_replace('/^\./','./Modules/ScormAicc',$name) . "\n"; // for cli
            $manifest_string .= self::encodeuri($name) . "\n";
        }
        //$log->write($manifest_string);
        return $manifest_string;
    }

References $DIC, $log, $name, $obj_id, encodeuri(), and ilUtil\getWebspaceDir().

Here is the call graph for this function:

◆ getOfflineMode()

ilSCORMOfflineMode::getOfflineMode ( )

Definition at line 440 of file class.ilSCORMOfflineMode.php.

    {
        return $this->offlineMode;
    }

References $offlineMode.

◆ getSopManifestEntries()

ilSCORMOfflineMode::getSopManifestEntries ( )

Definition at line 75 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $log = $DIC['log'];
        $log->write("getSopManifestEntries ");
        $manifest_string = "";
        if (!$this->debug) {
            // if ($this->type == "scorm2004") {
            $BASE_DIR = './Modules/Scorm2004/';
            $manifest_string .= ilUtil::getImagePath("scorm/asset.svg", false) . "\n";
            $manifest_string .= ilUtil::getImagePath("scorm/completed.svg", false) . "\n";
            $manifest_string .= ilUtil::getImagePath("scorm/not_attempted.svg", false) . "\n";
            $manifest_string .= ilUtil::getImagePath("scorm/running.svg", false) . "\n";
            $manifest_string .= ilUtil::getImagePath("scorm/incomplete.svg", false) . "\n";
            $manifest_string .= ilUtil::getImagePath("scorm/passed.svg", false) . "\n";
            $manifest_string .= ilUtil::getImagePath("scorm/failed.svg", false) . "\n";
            // $manifest_string .= ilUtil::getImagePath("scorm/browsed.svg",false) . "\n";
            $manifest_string .= ilUtil::getStyleSheetLocation() . "\n";
            $manifest_string .= $BASE_DIR . 'templates/default/player.css' . "\n";
            $manifest_string .= $BASE_DIR . 'scripts/buildrte/rte.js' . "\n";
            $manifest_string .= $BASE_DIR . 'scripts/ilNestedList.js' . "\n";
            $manifest_string .= iljQueryUtil::getLocaljQueryPath() . "\n";
            $manifest_string .= $this->player2004_url . "\n";
            // } else {
            $manifest_string .= $this->player12_url . "\n";
            // }
            $manifest_string .= $this->som_url . "\n";
            // $log->write("Manifest: ".$manifest_string);
            $objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->sop_dir));
            foreach ($objects as $name => $object) {
                if (preg_match('/\/\.+/', $name)) {
                    continue;
                }
                //$manifest_string .= preg_replace('/^\./','./Modules/ScormAicc',$name) . "\n"; // for cli
                $manifest_string .= self::encodeuri($name) . "\n";
            }
            $objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->som_dir));
            foreach ($objects as $name => $object) {
                if (preg_match('/\/\.+/', $name)) {
                    continue;
                }
                //$manifest_string .= preg_replace('/^\./','./Modules/ScormAicc',$name) . "\n"; // for cli
                $manifest_string .= self::encodeuri($name) . "\n";
            }
            
            $objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->scripts_dir));
            foreach ($objects as $name => $object) {
                if (preg_match('/\/\.+/', $name)) { //UK statt .+ .js und SCORM-Scripts weg
                    continue;
                }
                //$manifest_string .= preg_replace('/^\./','./Modules/ScormAicc',$name) . "\n"; // for cli
                $manifest_string .= self::encodeuri($name) . "\n";
            }
            $objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->images_dir));
            foreach ($objects as $name => $object) {
                if (preg_match('/\/\.+/', $name)) {
                    continue;
                }
                //$manifest_string .= preg_replace('/^\./','./Modules/ScormAicc',$name) . "\n"; // for cli
                $manifest_string .= self::encodeuri($name) . "\n";
            }
            
            $manifest_string .= $this->pouchdb_js . "\n";
            $manifest_string .= $this->jquery_js . "\n";
            $manifest_string .= $this->bootstrap_js . "\n";
            $manifest_string .= $this->bootstrap_css . "\n";
        }
        //$log->write($manifest_string);
        return $manifest_string;
    }

References $DIC, $log, $name, encodeuri(), ilUtil\getImagePath(), iljQueryUtil\getLocaljQueryPath(), and ilUtil\getStyleSheetLocation().

Here is the call graph for this function:

◆ il2sopSahsUser()

ilSCORMOfflineMode::il2sopSahsUser ( )

Definition at line 274 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
        $package_attempts = 0;
        $module_version = 1;//if module_version in sop is different...
        $last_visited = "";
        $first_access = null;
        $last_access = null;
        $last_status_change = null;
        $total_time_sec = null;
        $sco_total_time_sec = 0;
        $status = 0;
        $percentage_completed = 0;
        $user_data = "";
 
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
        $res = $ilDB->queryF(
            'SELECT * FROM sahs_user WHERE obj_id=%s AND user_id=%s',
            array('integer','integer'),
            array($this->obj_id,$ilUser->getID())
        );
        while ($row = $ilDB->fetchAssoc($res)) {
            $package_attempts = $row['package_attempts'];
            $module_version = $row['module_version'];
            $last_visited = $row['last_visited'];
            if ($row['first_access'] != null) {
                $first_access = strtotime($row['first_access']) * 1000;//check Oracle!
            }
            if ($row['last_access'] != null) {
                $last_access = strtotime($row['last_access']) * 1000;//check Oracle!
            }
            $total_time_sec = $row['total_time_sec'];
            $sco_total_time_sec = $row['sco_total_time_sec'];
            $status = $row['status'];
            $percentage_completed = $row['percentage_completed'];
        }
        if ($first_access == null) {
            include_once './Services/Tracking/classes/class.ilChangeEvent.php';
            $all = ilChangeEvent::_lookupReadEvents($this->obj_id, $ilUser->getID());
            foreach ($all as $event) {
                $first_access = strtotime($event['first_access']) * 1000;//
            }
        }
        return array($package_attempts, $module_version, $last_visited, $first_access, $last_access, $last_status_change, $total_time_sec, $sco_total_time_sec, $status, $percentage_completed, $user_data);
    }

References $DIC, $ilDB, $ilUser, $res, and ilChangeEvent\_lookupReadEvents().

Referenced by tracking2sop().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ il2sopUserData()

ilSCORMOfflineMode::il2sopUserData ( )

Definition at line 260 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilUser = $DIC['ilUser'];
        return array(
            $ilUser->getLogin(),
            "",
            $ilUser->getFirstname(),
            $ilUser->getLastname(),
            $ilUser->getUTitle(),
            $ilUser->getGender(),
            $ilUser->getID()
            );
    }

References $DIC, and $ilUser.

Referenced by tracking2sop().

Here is the caller graph for this function:

◆ read()

ilSCORMOfflineMode::read ( )

private

Definition at line 445 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
        $res = $ilDB->queryF(
            'SELECT offline_mode FROM sahs_user WHERE obj_id=%s AND user_id=%s',
            array('integer','integer'),
            array($this->obj_id,$ilUser->getId())
        );
        while ($row = $ilDB->fetchAssoc($res)) {
            if ($row['offline_mode'] != null && $row['offline_mode'] != '') {
                $this->offlineMode = $row['offline_mode'];
            } else {
                $this->offlineMode = "online";
            }
        }
    }

References $DIC, $ilDB, $ilUser, and $res.

Referenced by __construct().

Here is the caller graph for this function:

◆ scormPlayerUnloadForSop2il()

ilSCORMOfflineMode::scormPlayerUnloadForSop2il ( $data )

Definition at line 395 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
        $first_access = null;
        if ($data->first_access != null) {
            $first_access = date('Y-m-d H:i:s', round($data->first_access / 1000));
        }
        $last_access = null;
        $i_last_access = null;
        if ($data->last_access != null) {
            $i_last_access = round($data->last_access / 1000);
            $last_access = date('Y-m-d H:i:s', $i_last_access);
            include_once("./Services/Tracking/classes/class.ilChangeEvent.php");
            ilChangeEvent::_updateAccessForScormOfflinePlayer($this->obj_id, $ilUser->getId(), $i_last_access, $first_access);
        }
        $last_status_change = null;
        if ($data->last_status_change != null) {
            $last_status_change = date('Y-m-d H:i:s', round($data->last_status_change / 1000));
        }
        $GLOBALS['DIC']['ilLog']->write('first_access=' . $first_access);
        $res = $ilDB->queryF(
            'UPDATE sahs_user SET first_access=%s, last_access=%s, last_status_change=%s, last_visited=%s, module_version=%s WHERE obj_id=%s AND user_id=%s',
            array('timestamp','timestamp','timestamp','text','integer','integer','integer'),
            array($first_access,$last_access,$last_status_change,$data->last_visited,$data->module_version, $this->obj_id,$ilUser->getId())
        );
 
        //populate last_status_change
        return true;
    }

References $data, $DIC, $GLOBALS, $ilDB, $ilUser, $res, and ilChangeEvent\_updateAccessForScormOfflinePlayer().

Here is the call graph for this function:

◆ setOfflineMode()

ilSCORMOfflineMode::setOfflineMode ( $a_mode )

Definition at line 428 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
        $res = $ilDB->queryF(
            'UPDATE sahs_user SET offline_mode=%s WHERE obj_id=%s AND user_id=%s',
            array('text','integer','integer'),
            array($a_mode, $this->obj_id,$ilUser->getId())
        );
        $this->offlineMode = $a_mode;
    }

References $DIC, $ilDB, $ilUser, and $res.

◆ sop2il()

ilSCORMOfflineMode::sop2il ( )

Definition at line 324 of file class.ilSCORMOfflineMode.php.

    {
        //              sleep(5);
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
        $in = file_get_contents("php://input");
        $GLOBALS['DIC']['ilLog']->write($in);
        $ret = array('msg' => array(),'err' => array());
        
        if (!$in || $in == "") {
            $ret['err'][] = "no post data recieved";
            print(json_encode($ret));
            exit;
        }
        $userId = $ilUser->getID();
        $result = true;
 
        if ($this->type == 'scorm2004') {
            $lm_set = $ilDB->queryF('SELECT default_lesson_mode, interactions, objectives, comments, time_from_lms FROM sahs_lm WHERE id = %s', array('integer'), array($this->obj_id));
            while ($lm_rec = $ilDB->fetchAssoc($lm_set)) {
                $defaultLessonMode = ($lm_rec["default_lesson_mode"]);
                $interactions = (ilUtil::yn2tf($lm_rec["interactions"]));
                $objectives = (ilUtil::yn2tf($lm_rec["objectives"]));
                $comments = (ilUtil::yn2tf($lm_rec["comments"]));
                $time_from_lms = (ilUtil::yn2tf($lm_rec["time_from_lms"]));
            }
            include_once './Modules/Scorm2004/classes/class.ilSCORM2004StoreData.php';
            $data = json_decode($in);
            $GLOBALS['DIC']['ilLog']->write('cmi_count=' . count($data->cmi));
            for ($i = 0; $i < count($data->cmi); $i++) {
                if ($result == true) {
                    //$a_r=array();
                    $cdata = $data->cmi[$i];
                    $a_r = ilSCORM2004StoreData::setCMIData(
                        $userId,
                        $this->obj_id,
                        $data->cmi[$i],//json_decode($data->cmi[$i]),
                        $comments,
                        $interactions,
                        $objectives
                        );
                    if (!is_array($a_r)) {
                        $result = false;
                    }
                }
            }
            if ($result == true) {
                $result = ilSCORM2004StoreData::syncGlobalStatus($userId, $this->obj_id, $data, $data->now_global_status, $time_from_lms);
            }
        } else {
            include_once "./Modules/ScormAicc/classes/SCORM/class.ilObjSCORMTracking.php";
            $data = json_decode($in);
            $result = ilObjSCORMTracking::storeJsApiCmi($userId, $this->obj_id, $data);
            if ($result == true) {
                $result = ilObjSCORMTracking::syncGlobalStatus($userId, $this->obj_id, $data, $data->now_global_status);
            }
        }
        if ($result == true) {
            $result = self::scormPlayerUnloadForSOP2il($data);
        }
 
        if ($result == false) {
            $ret['err'][] = "invalid post data recieved";
        } else {
            $ret['msg'][] = "post data recieved";
        }
        header('Content-Type: text/plain; charset=UTF-8');
        print json_encode($ret);
    }

References $data, $DIC, $GLOBALS, $i, $ilDB, $ilUser, $in, $lm_set, $result, $ret, exit, print, ilSCORM2004StoreData\setCMIData(), ilObjSCORMTracking\storeJsApiCmi(), ilObjSCORMTracking\syncGlobalStatus(), ilSCORM2004StoreData\syncGlobalStatus(), and ilUtil\yn2tf().

Here is the call graph for this function:

◆ stopOfflineModeForUser()

static ilSCORMOfflineMode::stopOfflineModeForUser	(	$obj_id,
		$user_id
	)

static

Definition at line 497 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $res = $ilDB->queryF(
            "UPDATE sahs_user SET offline_mode='online' WHERE obj_id=%s AND user_id=%s",
            array('integer','integer'),
            array($obj_id,$user_id)
        );
    }

References $DIC, $ilDB, $obj_id, and $res.

Referenced by ilObjSCORMLearningModuleGUI\confirmedStopUserOfflineMode().

Here is the caller graph for this function:

◆ tracking2sop()

ilSCORMOfflineMode::tracking2sop ( )

Definition at line 169 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilUser = $DIC['ilUser'];
        $ilias = $DIC['ilias'];
        // $this->setOfflineMode("il2sop");
        header('Content-Type: text/javascript; charset=UTF-8');
 
        include_once "./Modules/ScormAicc/classes/class.ilObjSAHSLearningModule.php";
        $ob = new ilObjSAHSLearningModule($this->id);
        $module_version = $ob->getModuleVersion();
        $sahs_user = $this->il2sopSahsUser();
        $support_mail = "";//TODO
        $scorm_version = "1.2";
        if ($this->type == "scorm2004") {
            $scorm_version = "2004";
        }
        $tree = "";
        
        $learning_progress_enabled = 1;
        include_once './Services/Object/classes/class.ilObjectLP.php';
        $olp = ilObjectLP::getInstance($this->obj_id);
        if ($olp->getCurrentMode() == 0) {
            $learning_progress_enabled = 0;
        }
        
        $certificate_enabled = 0;
 
        $adlact_data = null;
        $ilias_version = $ilias->getSetting("ilias_version");
 
        if ($this->type == 'scorm2004') {
            include_once "./Modules/Scorm2004/classes/ilSCORM13Player.php";
            $ob2004 = new ilSCORM13Player();
            $init_data = json_encode($ob2004->getConfigForPlayer());
            $resources = json_decode($ob2004->getCPDataInit());
            $cmi = $ob2004->getCMIData($ilUser->getID(), $this->obj_id);
            $max_attempt = $ob2004->get_max_attempts();
            $adlact_data = json_decode($ob2004->getADLActDataInit());
        //$globalobj_data = $ob2004->readGObjectiveInit();
        } else {
            include_once "./Modules/ScormAicc/classes/SCORM/class.ilObjSCORMInitData.php";
            $slm_obj = new ilObjSCORMLearningModule($_GET["ref_id"]);
            $init_data = ilObjSCORMInitData::getIliasScormVars($slm_obj);
            $resources = json_decode(ilObjSCORMInitData::getIliasScormResources($this->obj_id));
            $tree = json_decode(ilObjSCORMInitData::getIliasScormTree($this->obj_id));
            $cmi = json_decode(ilObjSCORMInitData::getIliasScormData($this->obj_id));
            $max_attempt = ilObjSCORMInitData::get_max_attempts($this->obj_id);
        }
        //UK max_attempt weg!
        // if ($max_attempt == null) $max_attempt = 0;
        $result = array(
            'client_data' => array(
                $support_mail
            ),
            'user_data' => $this->il2sopUserData(),
            'lm' => array(
                ilObject::_lookupTitle($this->obj_id),
                ilObject::_lookupDescription($this->obj_id),
                $scorm_version,
                1,//active
                $init_data,
                $resources,
                $tree,
                $module_version,
                "", //offline_zip_created!!!!!!!!
                $learning_progress_enabled,
                $certificate_enabled,
                $max_attempt,
                $adlact_data,
                $ilias_version
            ),
            'sahs_user' => $sahs_user,
            'cmi' => $cmi
        );
        
        print(json_encode($result));
    }

References $_GET, $DIC, $ilUser, $result, ilObject\_lookupDescription(), ilObject\_lookupTitle(), ilObjSCORMInitData\get_max_attempts(), ilObjSCORMInitData\getIliasScormData(), ilObjSCORMInitData\getIliasScormResources(), ilObjSCORMInitData\getIliasScormTree(), ilObjSCORMInitData\getIliasScormVars(), ilObjectLP\getInstance(), il2sopSahsUser(), il2sopUserData(), and print.

Here is the call graph for this function:

◆ usersInOfflineMode()

static ilSCORMOfflineMode::usersInOfflineMode ( $obj_id )

static

Definition at line 480 of file class.ilSCORMOfflineMode.php.

    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $users = array();
        $res = $ilDB->queryF(
            "SELECT user_id, lastname, firstname FROM sahs_user, usr_data "
                            . "WHERE sahs_user.obj_id=%s AND sahs_user.offline_mode = 'offline' AND sahs_user.user_id=usr_data.usr_id",
            array('integer'),
            array($obj_id)
        );
        while ($row = $ilDB->fetchAssoc($res)) {
            $users[] = $row;
        }
        return $users;
    }