Visitor Totals Last 24hrs

ported for 3.5.x.

It's a cool hack if you like to look at your total hits in a 24hr day from both members and guests.

1 PHP Modification to includes/cleanup.php
1 Template Mod. to Forumhome
1 Product Pluggin

Instructions and XML are in the zip.

I will support this hack but should be much trouble with it. Been running it since vB 2.2 I think.

When you first install this hack it will only track from the time the last sessions cleanup was completed. After a sessions cleanup it will start over or reset to 1hr again. Then track the hours in increments for 24hrs. Then clean out the sessions table and start over again. Sessions cleanups should normally occur at midnight.

This hack works if you remove the old code in the cleanup.php and replace it with the new information in the readme.

For information cleanout2.php dose not run hourly like implied in the cron tab. It is set for 5 min after midnight. Jelsoft set it that way and not sure why it is titled a hourly cleanup in the scheduled task. In any event it is needed to reset the script for the next day.

Good luck and I will do my best to answer any questions.

Thanks to Paul M. for pointing out a bug I kept overlooking.

[bspiller82]

How do I fix mine?

$vbulletin->db->query_write("
	DELETE FROM " . TABLE_PREFIX . "cpsession
	WHERE dateline < " . intval(TIMENOW - 3600) . "
	### Delete stale cpsessions ###

Is giving me this error

Parse error: parse error, unexpected ']' in /home/a247xtre/public_html/forums/includes/cron/cleanup.php on line 26

[Paul M]

Originally Posted by caliman

Is this mod compatible with 'who has visited today?'

https://vborg.vbsupport.ru/showthread.php?t=82769

I can't see any reason that this would intefere with my hack.

[caliman]

Thanks Paul.

[caliman]

Hey, mine doesn't seem to work right... if you stay on the site for a while it keeps recounting you as a member and it doesn't seem to go over 1 hour (it's been on past midnight now):

Total users last 1hrs : 13 (10 members and 3 guests)

Any ideas?

[lexx27]

I have the same problem.

[TTG]

Originally Posted by caliman

Hey, mine doesn't seem to work right... if you stay on the site for a while it keeps recounting you as a member and it doesn't seem to go over 1 hour (it's been on past midnight now):

Total users last 1hrs : 13 (10 members and 3 guests)

Any ideas?

Same problem on mine !?

[mclark2112]

Still a problem in IE in the Dark Blue style...Map is all over the place.

[tcs]

$vbulletin->db->query_write("
	DELETE FROM " . TABLE_PREFIX . "session
	WHERE lastactivity < " . intval((TIMENOW - 86400]) . "
        ### Delete stale sessions ###

Is the code to use in cleanup.php only. Do not change what is in cleanup2.php.

I run "who was online today" and have had no issues or conflicts with them working together.

I just installed this on 3 other boards in an attempt to duplicate this problem. So far they are working fine.

Check your cleanup2.php and make sure you did not change the original code. This is the only hack I know that changes the cleanup.php you can re upload a new copy and try again to see if that fixes it.

[amykhar]

Typo in the install file.

$vbulletin->db->query_write("
	DELETE FROM " . TABLE_PREFIX . "session
	WHERE lastactivity < " . intval((TIMENOW - 86400]) . "
        ### Delete stale sessions ###

Should be

$vbulletin->db->query_write("
	DELETE FROM " . TABLE_PREFIX . "session
	WHERE lastactivity < " . intval((TIMENOW - 86400)) . "
        ### Delete stale sessions ###

[amykhar]

I have NOT been able to test this fully. Or even more than making sure it has no parse errors and the numbers add up. But, here is the plugin code for this mod for those of you using my spider's on the forumhome page.

The forumhome template code needs to change as well. My target audience will know how to do that

    $datecut24 = TIMENOW - 86400;
	$numberregistered24 = 0;
	$numberguest24 = 0;
	$numberspiders24 = 0;

	$forumusers24 = $vbulletin->db->query("
		SELECT userid, lastactivity, useragent FROM " . TABLE_PREFIX . "session
		WHERE lastactivity > $datecut24
	");

	$time24 = TIMENOW ;
	while ($loggedin24 = $vbulletin->db->fetch_array($forumusers24))
	{
		$userid24 = $loggedin24['userid'];
		if (!$userid24)
		{	// Guest or spider
		  if (!empty($vbulletin->wol_spiders))
	    {
	   	   if (preg_match('#(' . $vbulletin->wol_spiders['spiderstring'] . ')#si', $loggedin24['useragent'], $agent))
	   	   {
	   	      $numberspiders24++;
	   	   }
	   	   else 
	   	   {
			      $numberguest24++;
			   }
			 }
		}
		else
		{
			$numberregistered24++;
		}
		if ($loggedin24['lastactivity'] < $time24)
		{
			$time24 = $loggedin24['lastactivity'];
		}
	}
	$time24 = TIMENOW - $time24;
	$time24 = floor($time24 / 3600) + (($time24 % 3600) ? 1 : 0);

	$numbertotal24 = $numberregistered24 + $numberguest24 +$numberspiders24;

	unset($loggedin24);
	$vbulletin->db->free_result($forumusers24);