class.ilOnlineTracking.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilOnlineTracking
{
        protected static $last_access_time = null;

        public static function getOnlineTime($a_user_id)
        {
                global $ilDB;

                $res = $ilDB->query('SELECT online_time FROM ut_online WHERE usr_id = ' . $ilDB->quote($a_user_id, 'integer'));
                while($row = $ilDB->fetchAssoc($res))
                {
                        return (int)$row['online_time'];
                }

                return 0;
        }

        public static function addUser($a_user_id)
        {
                global $ilDB;

                $res = $ilDB->query('SELECT access_time FROM ut_online WHERE usr_id = ' . $ilDB->quote($a_user_id, 'integer'));
                if($ilDB->numRows($res))
                {
                        $row = $ilDB->fetchAssoc($res);
                        self::$last_access_time = (int)$row['access_time'];
                        return false;
                }

                $ilDB->manipulateF(
                        'INSERT INTO ut_online (usr_id, access_time) VALUES (%s, %s)',
                        array('integer', 'integer'),
                        array($a_user_id, time())
                );
                self::$last_access_time = time();

                return true;
        }

        public static function updateAccess(ilObjUser $user)
        {
                global $ilDB, $ilSetting;

                if(null === self::$last_access_time)
                {
                        $query = 'SELECT access_time FROM ut_online WHERE usr_id = ' . $ilDB->quote($user->getId(), 'integer');
                        $res   = $ilDB->query($query);
                        if(!$ilDB->numRows($res))
                        {
                                return false;
                        }
                        $row = $ilDB->fetchAssoc($res);
                        self::$last_access_time = $row['access_time'];
                }

                $time_span = (int)$ilSetting->get('tracking_time_span', 300);
                if(($diff = time() - self::$last_access_time) <= $time_span)
                {
                        $ilDB->manipulateF(
                                'UPDATE ut_online SET online_time = online_time + %s, access_time = %s WHERE usr_id = %s',
                                array('integer', 'integer', 'integer'),
                                array($diff, time(), $user->getId())
                        );
                }
                else
                {
                        $ilDB->manipulateF(
                                'UPDATE ut_online SET access_time = %s WHERE usr_id = %s',
                                array('integer', 'integer'),
                                array(time(), $user->getId())
                        );
                }
                return true;
        }
}