ILIAS  Release_3_10_x_branch Revision 61812
 All Data Structures Namespaces Files Functions Variables Groups Pages
class.ilOnlineTracking.php
Go to the documentation of this file.
1 <?php
2 /*
3  +-----------------------------------------------------------------------------+
4  | ILIAS open source |
5  +-----------------------------------------------------------------------------+
6  | Copyright (c) 1998-2001 ILIAS open source, University of Cologne |
7  | |
8  | This program is free software; you can redistribute it and/or |
9  | modify it under the terms of the GNU General Public License |
10  | as published by the Free Software Foundation; either version 2 |
11  | of the License, or (at your option) any later version. |
12  | |
13  | This program is distributed in the hope that it will be useful, |
14  | but WITHOUT ANY WARRANTY; without even the implied warranty of |
15  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
16  | GNU General Public License for more details. |
17  | |
18  | You should have received a copy of the GNU General Public License |
19  | along with this program; if not, write to the Free Software |
20  | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
21  +-----------------------------------------------------------------------------+
22 */
23 
39 {
40  // Static
41  function _getOnlineTime($a_user_id)
42  {
43  global $ilDB;
44 
45  $query = "SELECT * FROM ut_online WHERE usr_id = '".$a_user_id."'";
46  $res = $ilDB->query($query);
47  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
48  {
49  $access_time = $row->access_time;
50  $online_time = $row->online_time;
51  }
52  return (int) $online_time;
53  }
54 
55 
56 
57  function _addUser($a_user_id)
58  {
59  global $ilDB;
60 
61  $query = "SELECT * FROM ut_online WHERE usr_id = '".$a_user_id."'";
62  $res = $ilDB->query($query);
63 
64  if($res->numRows())
65  {
66  return false;
67  }
68  $query = "INSERT INTO ut_online SET usr_id = '".$a_user_id."', access_time = '".time()."'";
69  $ilDB->query($query);
70 
71  return true;
72  }
73 
74  function _updateAccess($a_usr_id)
75  {
76  global $ilDB,$ilias;
77 
78  $query = "SELECT * FROM ut_online WHERE usr_id = '".$a_usr_id."'";
79  $res = $ilDB->query($query);
80 
81  if(!$res->numRows())
82  {
83  return false;
84  }
85  while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
86  {
87  $access_time = $row->access_time;
88  $online_time = $row->online_time;
89  }
90 
91  $time_span = (int) $ilias->getSetting("tracking_time_span",300);
92 
93  if(($diff = time() - $access_time) <= $time_span)
94  {
95  $query = "UPDATE ut_online SET online_time = online_time + '".$diff."', access_time = '".time().
96  "' WHERE usr_id = '".$a_usr_id."'";
97  $ilDB->query($query);
98  }
99  else
100  {
101  $query = "UPDATE ut_online SET access_time = '".time().
102  "' WHERE usr_id = '".$a_usr_id."'";
103  $ilDB->query($query);
104  }
105  return true;
106  }
107 }
108 ?>