Who Was Online Today on forums

PLEASE CLICK THE INSTALL BUTTON IF INSTALLED!

What does this hack do?

It shows the users who visited your forums in the last 24 hours (or today). This hack works similiarly like the one released for vBulletin 2.

NOTE: If you want to show 'Who was online today' on a separate page from forumhome, then download instructions-newpage.txt and onlinetoday.php instead of instructions-regular.txt

Modifications

• 1 file modification
• 3 template modifications
• 0 queries to run

Features

• supports and uses phrases
• usernames are formatted properly
• invisible users only show to people who are supposed to see them (admins and whoever else you allowed)
• integrated (makes it so that the Who Was Online bar is now collapseable

Screenshots
Look below

Credits: Thanks goes to Mystics, where this hack is based on his

[Zeitgeist]

I've used another hack from vBulletin.nl now(http://www.vbulletin.nl/community/showthread.php?t=1475). At the moment it's working perfectly. I'll see what will happen if we reach 0:00 ... This hack here resets the statistics every day on this time.

[eXtremeTim]

Originally Posted by Zeitgeist

I've used another hack from vBulletin.nl now(http://www.vbulletin.nl/community/showthread.php?t=1475). At the moment it's working perfectly. I'll see what will happen if we reach 0:00 ... This hack here resets the statistics every day on this time.

are you on vb3 rc2???

[Spencer F.]

I got this error when installing:

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, 0, 'last_online_at_x', 'Last online at {1}', 1)
mysql error: Duplicate entry 'last_online_at_x-0-1' for key 2

mysql error number: 1062

Date: Saturday 10th of January 2004 12:35:53 AM
Script: http://www.musicbanter.com/test/admi...php?do=install
Referer: http://www.musicbanter.com/test/admi...php?do=install
Username: admin
IP Address: ***

But I think it worked? Is this normal?

[P.Jackson]

works for me good job

[Kewl]

Originally Posted by Zeitgeist

Sorry, it doesn't work. It resets the date to 01-01-1970 and hides the most users ever online on a day completly.

hmmm same thing for me

did this get fixed? or does it fix itself at midnight?

doesn't give a total either

thanks

[Zeitgeist]

Originally Posted by eXtremeTim

are you on vb3 rc2???

Yes, why?

[Gary King]

Originally Posted by Spencer F.

I got this error when installing:

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, 0, 'last_online_at_x', 'Last online at {1}', 1)
mysql error: Duplicate entry 'last_online_at_x-0-1' for key 2

mysql error number: 1062

Date: Saturday 10th of January 2004 12:35:53 AM
Script: http://www.musicbanter.com/test/admi...php?do=install
Referer: http://www.musicbanter.com/test/admi...php?do=install
Username: admin
IP Address: ***

But I think it worked? Is this normal?

No that shouldn't happen, and as for the problem with counting the most users online on one day record, I will see what I can do to fix this

[eXtremeTim]

try this who was online today code.

This is the exact code from my index.php file for it so.

PHP Code:

// ### WHO WAS ONLINE TODAY ########################
// $maxusers = unserialize($datastore['maxloggedin']);
 if (intval($maxusers['maxonline']) <= $totalonline)
 {
  $maxusers[0] = $totalonline;
  $maxusers[1] = TIMENOW;
 }
$todayloggedinusers = "";
$numbertodayonline = 0;
$numbertodayonlineinvisible = 0;
$todayusers=$DB_site->query("SELECT userid, username, usergroupid, lastactivity, options FROM ".TABLE_PREFIX."user 
       WHERE lastactivity > " . (mktime(0,0,0,date("m"),date("d"),date("Y")) + (($bbuserinfo['timezoneoffset']-$timeoffset)*3600)) . " 
       ORDER BY username");
       
while ($todayuser=$DB_site->fetch_array($todayusers))
{
 $todayuser['options'] = intval($todayuser['options']);
 foreach($_USEROPTIONS AS $optionname => $optionval)
 {
  $todayuser["$optionname"] = iif($todayuser['options'] & $optionval, 1, 0);
 }
 $numbertodayonline++;
 $invisibleuser = '';
 $userid = $todayuser['userid'];
 $lastactivetime = vbdate($vboptions['timeformat'], $todayuser[lastactivity]);
 
 if ($todayuser['invisible']==1 and $bbuserinfo['usergroupid']!=6)
 {
  $numbertodayonlineinvisible++;
  continue;
 }
 if ($todayuser['invisible'] == 1)
 { // Invisible User but show to Admin
  $invisibleuser = '*';
 }
 $username = fetch_musername($todayuser);
 
 if (!$todayloggedinuser)
 {
  eval("\$todayloggedinuser = \"".fetch_template('forumhome_todayloggedinuser')."\";");
 }
 else
 {
  eval("\$todayloggedinuser .= \", ".fetch_template('forumhome_todayloggedinuser')."\";");
 }
}
$DB_site->free_result($todayusers);
if ($bbuserinfo[usergroupid] == 6) {
 $todayonline = $numbertodayonline;
} else {
 $todayonline = $numbertodayonline - $numbertodayonlineinvisible;
}
 if (intval($maxusers['maxonline']) <= $totalonline) {
 $maxloggedin = $maxusers[0] . " " . $maxusers[1] . " $numbertodayonline " . TIMENOW;
 $maxusers[2] = $numbertodayonline;
 $maxusers[3] = TIMENOW;
 $DB_site->query("REPLACE INTO " . TABLE_PREFIX . "datastore (title, data) VALUES ('maxloggedin', '" . addslashes(serialize($maxusers)) . "')");
}
$todayrecordusers = $maxusers[2];
$todayrecorddate = vbdate($vboptions['dateformat'],$maxusers[3]);
eval("\$todayloggedinusers = \"".fetch_template('forumhome_todayloggedinusers')."\";"); 


[Kewl]

strange still same thing

]

[eXtremeTim]

Originally Posted by Kewl

strange still same thing

here is the link if you want to see what it is doing

http://www.pcinnovations.com/forum/index.php?s=

Is that code i put right after the whos online tracking code? Hmm this is strang :-/