The Joomla! Forum ™

Hi,

Module "Who is online" can display usernames but not real names. I have found several hacks to change that, but none corresponds to my config. Not sure if this is because I use Joomla! 1.7 or Kunena (may be it modifies this module?).

I have been able to display real names thansk to the following hack. I am not an expert, so if you identify a bug in the code please tell me! Anyhow it works for me and does not seem to generate issues with other modules or extensions.

1) In (site)\modules\mod_whosonline\helper.php, change :

static function getOnlineUserNames() {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.username, a.time, a.userid, a.usertype, a.client_id');
$query->from('#__session AS a');
$query->where('a.userid != 0');
$query->where('a.client_id = 0');
$query->group('a.userid');
$db->setQuery($query);
return (array) $db->loadObjectList();
}

Replace by :

static function getOnlineUserNames() {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('u.name, u.id, a.username, a.userid');
$query->from('#__users AS u');
$query->innerjoin('#__session AS a ON u.id = a.userid');
$query->where('a.userid != 0');
$query->where('a.client_id = 0');
$db->setQuery($query);
return (array) $db->loadObjectList();
}


2) In (site)\modules\mod_whosonline\tmpl\default.php :

Replace “username” by “name” in following line (twice, lines 27 and 30) :
<?php echo $name->username; ?>
becomes
<?php echo $name->name; ?>


I have already received a lot from Joomla forums, I am glad I can give a bit now !

This is just what I was looking for ...and it works!

Thank you!

how would i do this with the new 2.5 version?

there I have:

static function getOnlineUserNames($params) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.username, a.time, a.userid, a.usertype, a.client_id');
$query->from('#__session AS a');
$query->where('a.userid != 0');
$query->where('a.client_id = 0');
$query->group('a.userid');
$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.userid');
$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);
return (array) $db->loadObjectList();


? Thanks in advance, I cant find the innerjoin query...

bump

Does anyone have a solution for this. I would greatly appreciate it.

I have not yet tested on J2.5, but as soon as I can I will, as I am interested too. Don't expect a solution in the very short term though, I am too busy with other issues right now.
Any help from the community?

1) In (site)\modules\mod_whosonline\helper.php, change :

// show online member names
static function getOnlineUserNames($params) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.username, a.time, a.userid, a.usertype, a.client_id');
$query->from('#__session AS a');
$query->where('a.userid != 0');
$query->where('a.client_id = 0');
$query->group('a.userid');
$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.userid');
$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);
return (array) $db->loadObjectList();
}
}

Replace by :

// show online member names
static function getOnlineUserNames() {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('u.name, u.id, a.username, a.userid');
$query->from('#__users AS u');
$query->innerjoin('#__session AS a ON u.id = a.userid');
$query->where('a.userid != 0');
$query->where('a.client_id = 0');
$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.userid');
$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);
return (array) $db->loadObjectList();
}
}

2) In (site)\modules\mod_whosonline\tmpl\default.php :

Replace “username” by “name” in following line (at line 26):
<?php echo $name->username; ?>
becomes
<?php echo $name->name; ?>

ENJOY!

Almost, you forgot to pass $params into the function.
1)
static function getOnlineUserNames($params) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('u.name, u.id, a.username, a.userid');
$query->from('#__users AS u');
$query->innerjoin('#__session AS a ON u.id = a.userid');
$query->where('a.userid != 0');
$query->where('a.client_id = 0');
$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.userid');
$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);
return (array) $db->loadObjectList();
}
}

2) In (site)\modules\mod_whosonline\tmpl\default.php :

Replace “username” by “name” in following line (at line 26):
<?php echo $name->username; ?>
becomes
<?php echo $name->name; ?>

Can anyone help me figure out how to do this with an override? I have added the default.php page to my templates html/mod_whosonline folder and that works fine, but where does the helper file go? I have it in the same folder now, but that doesn't work.

Thanks
Dan

_________________
Dan Riefstahl
Pixel Point Creative
Your Image is our Mission™
http://www.pixelpointcreative.com