24h Visitors' Statistics (members and guests)

A very simple display of statistics of all visitors (members and guests) who have visited the forum last 24 hours.

It displays the statistics on Forum Home in the section of "Users online":

example: " Total users last 24h: 2692 (members : 741, guests : 1951) "

There is no additional SQL query.

----------------------------------

Installation (there is in attached file)

Step 1

In index.php

Find:

PHP Code:

    $show['loggedinusers'] = true;
}
else
{
    $show['loggedinusers'] = false;
} 


And insert this code before it:

PHP Code:

    // ############# Oleg Subel - 24h visitors' statistics ###############

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

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

    $time24 = TIMENOW ;
    while ($loggedin24 = $DB_site->fetch_array($forumusers24))
    {
        $userid24 = $loggedin24['userid'];
        if (!$userid24)
        {    // Guest
            $numberguest24++;
        }
        else
        {
            $numberregistered24++;
        }
        if ($loggedin24['lastactivity'] < $time24)
        {
            $time24 = $loggedin24['lastactivity'];
        }
    }
    $time24 = TIMENOW - $time24;
    $time24 = floor($time24 / 3600) + (($time24 % 3600) ? 1 : 0);

    $numbertotal24 = $numberregistered24 + $numberguest24;

    // memory saving
    unset($loggedin24);
    $DB_site->free_result($forumusers24);
    // ############# End of 24h visitors' statistics ############### 


Step 2

In includes/cron/cleanup.php
and in includes/cron/cleanup2.php

Find:

PHP Code:

$DB_site->query("
    ### Delete stale sessions ###
    DELETE FROM " . TABLE_PREFIX . "session
    WHERE lastactivity < " . intval(TIMENOW - $vboptions['cookietimeout'])
); 


And replace with this code:

PHP Code:

$DB_site->query("
    ### Delete stale sessions ###
    DELETE FROM " . TABLE_PREFIX . "session
    WHERE lastactivity < " . intval(TIMENOW - 86400)
); // modified by Oleg S.for 24h visitors' statistics 


Step 3

Add new phrase

Phrase Type: GLOBAL
Varname: active_users_24h
Text:

Total users last {1}h

Step 4

FORUMHOME template modification

Find:

			<a href="online.php?$session[sessionurl]">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)
		</td>

and replace with:

			<a href="online.php?$session[sessionurl]">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)
			&nbsp;&nbsp;&nbsp;&nbsp;<phrase 1="$time24">$vbphrase[active_users_24h]</phrase>: $numbertotal24 (<phrase 1="$numberregistered24" 2="$numberguest24">$vbphrase[x_members_and_y_guests]</phrase>)
		</td>

END

[kall]

Yup, same here.

http://forums.nzboards.com

I think I saw 2 hours once, but that was it.

*edit* Ahh, I was a moron.

You have to edit both of the /includes/cron/ files (as per the instructions), or it doesn't work.

[TTG]

Tried this hack .. idea is good but every time a member comes back to the main page the stats jump up in number = to the number of members / guests viewing main page.

Every main page refresh adds the number of existing viewers to the exisiting total.

[Omega Prime]

Guess this didn't work out...

I added this hack, but like most peple here, I noticed how the member stats kept rising whenever anyone (whether it was someone who visited just now or 10min ago) would add to the stats. After removing it from forumhome (since I was gonna see about working with it later) and adjusting the clock on the server, it shows over 2000 members online! It caused the CPU to max out to 100%, to the point where I had to close the forum and delete the sessions. It seems things are up and running again, but now it shows "Most users ever online was 2142, Today at 09:21 AM.", as well as showing members who are online when they shouldn't be online (within showthread) =/

[Olsufr]

TTG, it is using standard (for vB3) online system. I didn't change anyone here.

[whelck]

Whatever this is doing isn't right. It says in the past 7 hours I've had 4974 members and 576 guests. I don't even have that many registered members.

*uninstalls*

[xtreme-mobile]

am i doing something wrong?

mine just shows like this.... (see screen shot

it just shows amount of threads and thats about it

[Neutral Singh]

Thank You, I was looking for this modification for a long long time !!

[KanyeWest]

this hack i still use today from first realease its awseom

Total users last 24h: 542 (345 members and 197 guests)

www.idenonfire.com/forums/ still usin proudly

[Neutral Singh]

Activity during last 24 hour(s): 891 (74 members and 817 guests and [ARG:3 UNDEFINED] spiders)

Ever since i installed that hack to show web spiders on who is online... the above error is bold is showing up. I think in the following code another query about the spiders has to added... Olsufr, it would be wonderful if you could provide the code for adding the count for spiders too... best regards.

// ############# Oleg Subel - 24h visitors' statistics ###############

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

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

$time24 = TIMENOW ;
while ($loggedin24 = $DB_site->fetch_array($forumusers24))
{
$userid24 = $loggedin24['userid'];
if (!$userid24)
{ // Guest
$numberguest24++;
}
else
{
$numberregistered24++;
}
if ($loggedin24['lastactivity'] < $time24)
{
$time24 = $loggedin24['lastactivity'];
}
}
$time24 = TIMENOW - $time24;
$time24 = floor($time24 / 3600) + (($time24 % 3600) ? 1 : 0);

$numbertotal24 = $numberregistered24 + $numberguest24;

// memory saving
unset($loggedin24);
$DB_site->free_result($forumusers24);
// ############# End of 24h visitors' statistics ###############

[eva01_]

to get rid of that bold error you have to check your file changes again and make sure you did the template changes as well