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

[jerx]

I don' t think it works with 3.5.4. Is anyone able to port this hack to 3.5.4? I am especially interested in the guest count.

[MikeLR]

Is there allready a version for 3.6.x? I'm interested in the counting of the guests.

[wezoo]

i would like to count guests too !!!!

[|Jordan|]

I'm having some problems with this hack.

It displays the statistics fine, but it doesnt reset after 24 hours. It just shows 24hours and the numbers keep going up. I did all the file edits/uploads.

[Mysticales]

Hrm I wonder.. you see we had this on 3.0 and I know we got it working on 3.5.4 as well.. even external JS showing on html.. but issues is this.. if you get flooded with users.. it made your forums crawl to a stop. (2000+ users that is) which show up as a guest on forums..

Anyone have any new word on this? Seems the way we have it isnt caching anymore like it used to... Im willing to work with anyone who KNOWS javascript, external stats posting and understand how this loads.. which case we could work together to make it not only cache the data it gets.. but works right on external displaying.

[Realbigsource]

Do you guys have any mod like this that I can just upload with product manager, I dont want to mess with these code and mess up my forum.?