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

[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.

[Mystics]

Originally posted by 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.

Have you adjusted the existing templates and created the new templates? Seems so, if you don't have done that

[TELEK]

yeah, I did

[genial]

Originally posted by Lionel
Does this only count members or can it count guests too?

the current release count only members.

i will release a new version of this hack in the near future, which counts members and guests. guests will be differentiated through their ip, that means two guests with the same ip will be counted as one guest and a guest with different ips (surfing the web through a proxy-server) will be counted as more guests.

[Lionel]

Originally posted by genial
the current release count only members.

i will release a new version of this hack in the near future, which counts members and guests. guests will be differentiated through their ip, that means two guests with the same ip will be counted as one guest and a guest with different ips (surfing the web through a proxy-server) will be counted as more guests.

Great because it can only look good when you display more.

[TELEK]

OK, I figured out how to work it, kind of. I don't understand what templates are, and how template sets work. The reason why it wasn't working was because the style set I was using, had the template set Hyren Village selected, and the templates I made for the hack were in default template set. But when i switch my style to default, the layout changes. Should I put those templates you make (for the hack) in every template set?

[Mystics]

Originally posted by TELEK
Should I put those templates you make (for the hack) in every template set?

Yes! If you want to use the hack in every of your styles! But if you never use the default template set, you only have to insert the hack into your "Village"-Style-Templates.

[Erwin]

Hi genial,

Iinstalled the updated code. No way of knowing if it does work until tonight, but it looks like it's working. The numbers did change.

Just one IMPORTANT NOTE for potential installers:

Remove the "color" variable from the first code change if you do NOT have the color hack installed (or whatever that color variable is for) - otherwise your index.php will not work as you will get a database error!

Will let you know if there are any problems. Thanks!

[Erwin]

On second thoughts, I don't think the updated code is working. On the "visitors who have visited today" I am seeing members who was on definitely yesterday according to my timezone, and not since. I think you are using the DEFAULT timezone for VB - not the server one, but the default one, not the member's own timezone.

Server time zone: GMT -6
VB default: GMT 0
My timezone: GMT +10

Instead of using GMT -6 which was what it was using, it is now using GMT 0 (I think).

Anyone else with the same problem?

[genial]

Originally posted by Erwin Loh
Just one IMPORTANT NOTE for potential installers:

Remove the "color" variable from the first code change if you do NOT have the color hack installed (or whatever that color variable is for) - otherwise your index.php will not work as you will get a database error!

uups sorry, i overlooked this.

i have fixed this little mistake in the posted code.

i will check the fix for the timezone problem tomorrow, if i find time for.

[DarkReaper]

Cool.

http://www.seriouscommunity.com

Installed there earlier today