| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Student/JimMartinson/Lab12/Joomla/modules/mod_users_latest/ |
Upload File : |
<?php
/**
* @package Joomla.Site
* @subpackage mod_users_latest
* @copyright Copyright (C) 2005 - 2014 Open Source Matters, Inc. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
// no direct access
defined('_JEXEC') or die;
class modUsersLatestHelper
{
// get users sorted by activation date
static function getUsers($params)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.id, a.name, a.username, a.registerDate');
$query->order('a.registerDate DESC');
$query->from('#__users AS a');
$user = JFactory::getUser();
if (!$user->authorise('core.admin') && $params->get('filter_groups', 0) == 1)
{
$groups = $user->getAuthorisedGroups();
if (empty($groups))
{
return array();
}
$query->leftJoin('#__user_usergroup_map AS m ON m.user_id = a.id');
$query->leftJoin('#__usergroups AS ug ON ug.id = m.group_id');
$query->where('ug.id in (' . implode(',', $groups) . ')');
$query->where('ug.id <> 1');
}
$db->setQuery($query, 0, $params->get('shownumber'));
$result = $db->loadObjectList();
return (array) $result;
}
}