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

[eXtremeTim]

Originally Posted by Zeitgeist

That's the same problem I'm having, too. The hack isn't working! Didn't the author noticed that? Where's the bug? :ermm:

I have the same problem as them. The most users ever online in a day resets at midnight.

I will look and see if i can figure out what is going on in a little while.

[Zeitgeist]

Originally Posted by eXtremeTim

I have the same problem as them. The most users ever online in a day resets at midnight.

I will look and see if i can figure out what is going on in a little while.

Thanks, extreme. I think you can compare the code from the vB 2.x.x hack with this new hack and so you might be able to find the wrong code in this hack.

[Jean147]

was looking for that. Thx a lot. :top

[eXtremeTim]

Fixed it.

Here are my changes

Find:

PHP Code:

if ((int)$maxusers['maxonline'] <= $totalonline)
{
    $time = time();
    $maxloggedin = "$totalonline " . $time . " " . $maxusers['maxonline'] . " " . $maxusers['maxonlinedate'];
    $maxusers[0] = $totalonline;
    $maxusers[1] = $time;
} 


Replace with:

PHP Code:

    if (intval($maxusers['maxonline']) <= $totalonline)
    {
        $maxusers[0] = $totalonline;
        $maxusers[1] = TIMENOW;
    } 


Now Find:

PHP Code:

if ((int)$maxusers[2] <= $numbertodayonline) {
    $time = time();
    $maxloggedin = $maxusers[0] . " " . $maxusers[1] . " $numbertodayonline " . $time;
    $maxusers[2] = $numbertodayonline;
    $maxusers[3] = $time;
} 


Replace with:

PHP Code:

    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)) . "')");
} 


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

[eXtremeTim]

This hack only works if whosonline is on so make sure that you have it turned on.

[eXtremeTim]

I have not been able to recreate your problem I have check all the code im using and this looks like the only parts i changed. Check and make sure you did the replaces correctly.

[Zeitgeist]

That's a screenshot of my forum after replacing the variables with yours. I'm 100% sure that I've made exactly what you've posted. Who's online is enabled and I haven't made any other changes to index.php *confused*

[eXtremeTim]

Originally Posted by Zeitgeist

That's a screenshot of my forum after replacing the variables with yours. I'm 100% sure that I've made exactly what you've posted. Who's online is enabled and I haven't made any other changes to index.php *confused*

Mind posting the whole whosonline block of code you have? I will compare it to mine and see if there are anymore differences. That way i can see if you messed up or if i left something out or if its working becuase of some other change i have done on my board. Seing as my board is already heavily modified. You can check it out on mine running the code i have posted. http://www.extremechatforums.com/forum/index.php

[Zeitgeist]

That's the whole code of the hack:

// ### WHO WAS ONLINE TODAY ########################
	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')."\";");

[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