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.

[Snake]

Thanks!

[lexx27]

It worked for the 2 first hours. No it hasnt changed for 2 or 3 hours.

[Paul M]

Originally Posted by tcs

It uses sessions table in the mysql. It changes the cleanup.php to leave the sessions table alone for 24hrs to collect the data.

Will this screw-up the who's online displays then ?

[JTyson]

Originally Posted by Paul M

Will this screw-up the who's online displays then ?

Doesnt seem to, http://www.fuo-motorsports.com/forum/

I had to change cleanup2.php aswell

[tcs]

Originally Posted by Paul M

Will this screw-up the who's online displays then ?

No it will not. Online Sessions are closed and changed by the timeout settings in you admincp.

Originally Posted by bspiller82

I got that error to. Are you saying if you wait an hour then run it, the error will not happen?

Is there a way to change the time from saying last 1 hours to last 24 if it logs the last 24 why have it say last hour?

The script will count up to 24hrs. It will track visitor throughout the day.

You change the code to do an hourly cleanup? Leave the cleanup.php original and it will do an hourly cleanup with no additional code changes.

I have never had to mess with cleanup2.php. When you first install this hack it will only track the time from the last sessions cleanup. After a cleanup it will start over or reset to 1hr again.

[caliman]

tcs ... is there a fix for this? i am holding off because of this error.

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

[tcs]

Lines 24 to 28 should look like this:

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

You are looking for a ] extra, missing or out if place.

Post you lines and I will see if I can find it.

[JTyson]

Originally Posted by tcs

Lines 24 to 28 should look like this:

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

You are looking for a ] extra, missing or out if place.

Post you lines and I will see if I can find it.

Might want to update your readme file as the error is in the code.

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

[tcs]

The one in the readme is the correct one. The code on my test site was wrong and had an error I missed.

The code you posted should work fine.

[caliman]

tcs -

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

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