Source for file helper.php
Documentation is available at helper.php
* @subpackage mod_whosonline
* @copyright Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
* Helper for mod_whosonline
* @subpackage mod_whosonline
* @return array The number of Users and Guests online.
// Calculate number of guests and users
$query =
$db->getQuery(true)
->select('guest, client_id')
->where('client_id = 0');
$sessions = (array)
$db->loadObjectList();
foreach ($sessions as $session)
// If guest increase guest count by 1
if ($session->guest ==
1)
// If member increase member count by 1
if ($session->guest ==
0)
$result['user'] =
$user_array;
$result['guest'] =
$guest_array;
* Show online member names
* @param mixed $params The parameters
* @return array (array) $db->loadObjectList() The names of the online users.
$query =
$db->getQuery(true)
->select($db->quoteName(array('a.username', 'a.time', 'a.userid', 'a.client_id')))
->from('#__session AS a')
->where($db->quoteName('a.userid') .
' != 0')
->where($db->quoteName('a.client_id') .
' = 0')
->group($db->quoteName(array('a.username', 'a.time', 'a.userid', 'a.client_id')));
if (!$user->authorise('core.admin') &&
$params->get('filter_groups', 0) ==
1)
$groups =
$user->getAuthorisedGroups();
$query->join('LEFT', '#__user_usergroup_map AS m ON m.user_id = a.userid')
->join('LEFT', '#__usergroups AS ug ON ug.id = m.group_id')
->where('ug.id in (' .
implode(',', $groups) .
')')
return (array)
$db->loadObjectList();
Documentation generated on Tue, 19 Nov 2013 15:04:21 +0100 by phpDocumentor 1.4.3