Show useronline on memberlist

A hack which shows if the user is online or not within a column on the memberlist. Pretty simple.

Hack suggested by Ifrani.

Last updated on 05th of November 2001 08:20 GMT

I had hoped to just add to the original SQL query to make this hack work, obviously this didn't seem possible with the errors that people have been having with sessions.

Redocumented adding an extra query.

[Ifrani]

Originally posted by Syphin
er... uuh... its showing multiple sessions for me... O.o i have the updated one installed too... O.o

Yep, I have the same problem...

@PPN
Can u help us, please ?

[Scott MacVicar]

updated documentation, it doesn't look like i could do it with one query.

[JJR512]

Does the updated documentation fix the problem mentioned by myself, Syphin, and Ifrani?

[JJR512]

There is a problem with the new directions.

In the "memberlist.php" section, the stuff you say to look for in the second part of that step (starts with if ($userinfo[receivepm]) {) is actually in the file online.php file.

[JJR512]

OK, I installed the new version. There were only a few other people online at the time. I still show up twice, but everybody else online only showed up once. I talked to another person who was online by ICQ and he confirmed that to him, I showed up twice, and everybody else online only showed up once. So there's still something not quite right here.

[Syphin]

Originally posted by JJR512
OK, I installed the new version. There were only a few other people online at the time. I still show up twice, but everybody else online only showed up once. I talked to another person who was online by ICQ and he confirmed that to him, I showed up twice, and everybody else online only showed up once. So there's still something not quite right here.

same thing here... >_<


-Syphin

[Scott MacVicar]

did you return the Query to,

PHP Code:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE $condition AND user.userid = userfield.userid
                                ".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction
                          LIMIT ".($limitlower-1).",$perpage"); 


[Freddie Bingham]

Don't add that select query as this will achieve the same thing and will not add any queries or overhead, just add this to the code and make the html changes to the templates as described above:

find:

PHP Code:

if ($userinfo[receivepm]) {
      eval("\$userinfo[pmlink] = \"".gettemplate("postbit_sendpm")."\";");
    } else {
      $userinfo[pmlink] = " ";
    } 


below it add:

PHP Code:

if($userinfo['lastactivity'] > $datecut and !$userinfo['invisible'] and $userinfo['lastvisit'] != $userinfo['lastactivity']) {
      eval("\$userinfo[online] = \"".gettemplate("postbit_online")."\";");
    }
    else {
      eval("\$userinfo[online] = \"".gettemplate("postbit_offline")."\";");
    } 


You can apply this to any page to show whether a user is online or offline without touching the session table.

[Scott MacVicar]

But i've noticed that sometimes the user profile doesn't update and the session query slows a different time from the one within the userprofile.

[Freddie Bingham]

If the last* times in the user table aren't updating than there is a problem with the doshutdown() function not activating. If this was the case than you would notice that users would not be showing up on the "Browsing this forum" feature as that information is set in the same query that updates the lastvisit & lastactivity times in the user table.