Who was online today [available in english & german]

Hack Name: Who was online today
Hack Version: 1.0.2
For vB Version:: 2.x
Originally Created by: genial @ Skats Board (Contact)
Documentation, Translation, a few changes and posted by: Mystics

Description:
This Hack adds something like the "Currently Active Users:"-Feature of vBulletin.
The difference is, instead of showing the users, who are currently online, it shows
all Users, who were online on a day and it also displays "Most users ever online on a day".

Summary of the Features:

• Shows "Number of Active Users Today"
• Shows "Most users ever online on a day"
• Shows last online time for each User while pointing the Mouse Cursor on it's name (=mouseover) in the list

Important: The Hack only works 100% correct, when each member is in the same time zone as the Server!

Files to edit: index.php
Templates to edit: forumhome
New Templates: forumhome_todayloggedinusers, forumhome_todayloggedinuser

I have attached the Install Instructions in a Text File.
The Instruction is in English and in German.

I will attach a Screenshot in a Reply to this Thread!

Post any Questions into this Thread!

Updates in 1.0.1: Inserted the two new templates into the template precaching (first step)

Updates in 1.0.2: Fixed a little Bug with the "Most users ever online on a day"-Count
(Replace '$maxusers[2] = $todayonline;' with '$maxusers[2] = $numbertodayonline;' in index.php)

Info: You can find an other version of this Hack here. In this other version the usernames of the members, who were already online today, are not shown on the Forum-Mainpage; the names are shown in an extra File (like online.php), onlinetoday.php (Screenshot).

So, depending on which version of the Hack you prefer, you have to download this:
Version with usernames on the main Site of the Forum

or this:
Version with usernames on extra site (onlinetoday.php)

Regards,
Mystics

[eva2000]

i double checked and the

Active users today figure is resetting itself based on my server time ?

it's 5 pm where I am and it was reset to zero just now.. i checked and my server time is 12 am....

probably no way to fix that since every member would then see a different figure from different time zones ?

or can you define in the script the reset time or allow vB admins to define that time ?

i.e. based on the vB admin's GMT offset time..

[Erwin]

Eva is absolutely right, the same thing happens to me, so I figure it must be set to the server's time.

[genial]

Originally posted by eva2000
Active users today figure is resetting itself based on my server time ?

yes so it is. the active users today figure will be reseted on 0:00 am servertime.

our server is in the same timezone as the members and so that was not importend for me and i didn't consider that.

i will see to fix it, so that showing to the members the active today figure according to there members-timezone and the todayrecord to the selected timezone in the vbb-options.

[Admin]

Great hack, I love the concept.

One thing, you might want to consider indexing the lastactivity column in the user table, otherwise the query scans a HUGE table (several thousands sometimes! )

[genial]

Originally posted by FireFly
One thing, you might want to consider indexing the lastactivity column in the user table, otherwise the query scans a HUGE table

it's a good idea.

i will consider this in the next release of this hack, because the next release needs changes in the database for count guests.

[Admin]

Just installed this here btw, works great.

[genial]

@all with the timezoneproblem of this hack:

i am not sure if this changes fix the problem, because our server is in the same timezone as the members and so i can't test it.

please test the changes for me.

find:

PHP Code:

$todayusers=$DB_site->query("SELECT userid, username, usergroupid, lastactivity, invisible FROM user 
                WHERE lastactivity > " . mktime(0,0,0,date("m"),date("d"),date("Y")) . " 
                ORDER BY username"); 


and replace with:

PHP Code:

$unixtoday = mktime(0,0,0,date("m"),date("d"),date("Y"));
$unixtoday = $timeoffset * 3600 + $unixtoday;
$numbertodayonlinerecord = $DB_site->query("SELECT COUNT(*) AS count FROM user 
                                  WHERE lastactivity > " . $unixtoday . " 
                                  ORDER BY username");
$numbertodayonlinerecord = $numbertodayonlinerecord[count];
$unixtoday = $bbuserinfo[timeoffset] * 3600 + $unixtoday;
$todayusers=$DB_site->query("SELECT userid,username,usergroupid,lastactivity,invisible,lastpost FROM user 
                                  WHERE lastactivity > " . $unixtoday . " 
                                  ORDER BY username"); 


and find:

PHP Code:

if ((int)$maxusers[2] <= $numbertodayonline) {
    $time = time();
    $maxloggedin = $maxusers[0] . " " . $maxusers[1] . " $numbertodayonline " . $time;
    $DB_site->query("UPDATE template SET template='$maxloggedin' WHERE title='maxloggedin'");
    $maxusers[2] = $numbertodayonline;
    $maxusers[3] = $time;
} 


replace with:

PHP Code:

if ((int)$maxusers[2] <= $numbertodayonlinerecord) {
    $time = time();
    $maxloggedin = $maxusers[0] . " " . $maxusers[1] . " $numbertodayonlinerecord " . $time;
    $DB_site->query("UPDATE template SET template='$maxloggedin' WHERE title='maxloggedin'");
    $maxusers[2] = $numbertodayonlinerecord;
    $maxusers[3] = $time;
  } 


[genial]

<font size="3">important: please notice</font>

the fix for the timezone problem has changed at this moment, please check your code if you have this fix installed before.

[Lionel]

Does this only count members or can it count guests too?

[TELEK]

Ok, I did everything in the instructions, and nothing happened. I did the one on the seperate page. Anyways, nothing changed on the main page, and if I go to onlinetoday.php, it is just a blank white page.