Members who have visited today (with last 24 hours option).

This modification is no longer available or supported.

A very simple display of all members who have visited the forum 'today' (i.e. since midnight). I looked at the existing hacks that apparently do this, and they either seemed over complicated or had a lot of problems, so I wrote my own simple version.


The main features of Version 2.xx are ;

1. It displays the list on Forum Home under the "Users online" display.

2. The list view is collapsable, so you just see the number.

3. Invisible users are only displayed to those allowed to see them (with a "*")

4. Users who should display as coloured or bold etc should be displayed correctly. (based on the display usergroup)

5. If you 'hover' over a username it will show the time they were last active.

6. The list is in member name order.


If you prefer, then there is an option to make this hack display a rolling 24 hours - un-comment the relevant line in the code.


Addons:
ericgtr has created a CMPS module for this hack, you will find the files here.
paul41598 has created a pop-up display instead of the collapsable display, you will find the files here.

[Paul M]

Originally Posted by RaZor Edge

But on my forum home... it show that all my members have come online today (1898 on 1898)

What's wrong???

I have no idea, what times does it show for each member when you hover over them ?

[RaZor Edge]

Originally Posted by Paul M

I have no idea, what times does it show for each member when you hover over them ?

It show only the time

Ex: 11h31 (a different time for everyone)

[Paul M]

Originally Posted by sabret00the

is this available for the WOL instead of the forumhome?

Not from me. You could do it, but it would mean moving the code to a different place, and then copying the relevant part of the template change - virtually a whole new version really.

[Paul M]

Originally Posted by RaZor Edge

It show only the time

Ex: 11h31 (a different time for everyone)

I take it you are sure they haven't all visited ?

If so, pick a few you are sure haven't, then look at the time when you hover over them, and then check their profiles to see what the Last Active date & time is.

I'll check back later.

[RaZor Edge]

Originally Posted by Paul M

I take it you are sure they haven't all visited ?

If so, pick a few you are sure haven't, then look at the time when you hover over them, and then check their profiles to see what the Last Active date & time is.

I'll check back later.

yes... it's impossible that all my members (100% of 1899) have come today at 11:31!! :nervous:

I will look at this.

[RaZor Edge]

Ok, the time is right... but not the date!!!

Ex:

user 1: 16:32 (Home index time)
Last activity: 11/06/2003 16h32 (in profil)

user 2: 22:00 (Home index time)
Last activity: 26/03/2003 22h00 (in profil)

I've try to re-install a clean version of functions_misc.php but the problem is still there.

I've try to change the date format to the american style, don't work neither...

(I use the latest version of vbulletin)

[BarHopper]

Isnt this, like exactly the same to Garys?

[taffy056]

Nice hack installed with no problems at all

[Paul M]

Originally Posted by floris

Database error in vBulletin 3.0.3:
 
Invalid SQL: SELECT userid, lastactivity, options, username,opentag,closetag
FROM vb3_user
LEFT JOIN vb3_usergroup ON(user.usergroupid = usergroup.usergroupid)
WHERE lastactivity > 1100037600 
mysql error: Unknown table 'user' in on clause
 
mysql error number: 1109

Oopsy?

Floris,

I believe that replacing the four lines of the SQL query with this should work.

PHP Code:

$todaysusers = $DB_site->query("SELECT userid, lastactivity, options, username,opentag,closetag
FROM " . TABLE_PREFIX . "user as user
LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)
WHERE lastactivity > " .$cutoff. " "); 


Please let me know and I will update the instructions.

[Paul M]

Originally Posted by RaZor Edge

Ok, the time is right... but not the date!!!

Can you try replacing the day/month/year lines of the code with these;

PHP Code:

$nowday = vbdate('d', $now. false, false);  
$nowmonth = vbdate('m', $now. false, false);  
$nowyear = vbdate('Y', $now. false, false); 


If that fails then temporarily add the following line above the SQL query ;

echo "Cutoff = ".$cutoff;

this will cause the forumhome to display a line at the top saying something like

Cutoff = 1100044800

post the result back here we can see what cutoff date it has calculated.