Question Backend users shown as 'online'

The code is from that Joomla! module called mod_whosonline and it shows the correct users logged on (no backend users).

I have no clue what the difference to Kunena is. I didn't look at Kunena (yet). I'm not a PHP developer.

I can only see that mod_whosonline seems to do the job while Kunena reports the backend users as being online too, and I believe that's wrong.

scept1c wrote:

is that a bug or it was meaned to work this way? just to find out if it's supposed to be fixed...

It may depend on how you look at it, although I can't see even a distant reason why the frontend should show backend users.

I think the frontend should be entirely independant of the backend, hence I'd say it's a bug.

Sozzled's explanation that it's alledgendly a bug in Joomla! is something the module mod_whosonline opposes.

I think you're probably right. This looks like it's a long-standing unresolved matter that's been kicking around since Fireboard. The only information that I've found that's remotely associated with this topic was an ancient relic posted nearly 12 months ago ( Remove who's browsing ). In that topic, Matias wrote:

We don't read Joomla session information, so we don't know if the user is still there or not. Yes, it's something to be changed

This would seem to indicate that Kunena performs some other accounting process. As for whether anyone had attended to this irritation, or what is to be don, I don't know.

I found this in Kunena (view.php):

// online - ofline status
if ($fmessage->userid > 0)
{
$sql = "SELECT COUNT(userid) FROM #__session WHERE userid='{$fmessage->userid}'";
$kunena_db->setQuery($sql);
$isonline = $kunena_db->loadResult();

$msg_online = '';

Campared with the same bit in mod_whosonline (helper.php):

$query = 'SELECT DISTINCT a.username' .
' FROM #__session AS a' .
' WHERE client_id = 0' .
' AND a.guest = 0';
$db->setQuery($query);
$result = $db->loadObjectList();

As I said, I'm not a PHP developer, and unfortunately I also know next to nothing about SQL.

Anyway, it looks to me like all that needs to be done is "adjust" the SQL query in Kunena to fix it.

Would anyone with more knowledge in PHP and SQL like to have a go?

We have already fixed this issue in Kunena 1.6 -- it will detect if users are online from Joomla session, not from Kunena session as it used to do.

BTW: K1.5 also shows users that have just logged out as being online. That issue is also fixed.

Cheers! I'm looking forward to it.