The Arcive of Official vBulletin Modifications Site.

24h Visitors' Statistics (members and guests) · **Released**: 02-12-2005

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:

Code:

Total users last {1}h

Step 4

FORUMHOME template modification

Find:

Code:

			<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:

Code:

			<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

bmroyer · #32 04-27-2005, 08:19 AM

Code:

Step 3. ##################################################################

Add new phrase

Phrase Type: GLOBAL
Varname: active_users_24h
Text: Total users last {1}h

Where do I do that at? which file?

ALcorn · #33 04-27-2005, 08:23 AM

Quote:

Originally Posted by bmroyer

Where do I do that at? which file?

Do it in phrase manager in your Admin Control Panel

bmroyer · #34 04-27-2005, 08:33 AM

thanks much

bmroyer · #35 04-27-2005, 11:09 PM

I just had a database error, I didn't think it was caused by this mod until now. My site just came back up, and I noticed that the users within 24 hours reset and is now at 1 hour.

Here is the error i got:

Quote:

<html><head><title> Database Error</title><style type="text/css"></style></head><body></table></td></tr></table></form><blockquote><p class="error"> </p><p class="error"><b>There seems to have been a slight problem with the database.</b><br />Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:bmroyer@gmail.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote></body></html>

ALcorn · #36 04-28-2005, 07:51 AM

Quote:

Originally Posted by bmroyer

I just had a database error, I didn't think it was caused by this mod until now. My site just came back up, and I noticed that the users within 24 hours reset and is now at 1 hour.

This error is not related to this mod, but I have also noticed that the 24H Visitors stats are reset when the database is out, so let's say "it's by design".

bmroyer · #37 04-28-2005, 12:34 PM

Quote:

Originally Posted by ALcorn

This error is not related to this mod, but I have also noticed that the 24H Visitors stats are reset when the database is out, so let's say "it's by design".

so then what is the problem? I had the old vbadvanced, and deleted the cms index, then replaced with the new version of the cms index..would that be why?

ALcorn · #38 04-28-2005, 01:15 PM

Quote:

Originally Posted by bmroyer

so then what is the problem? I had the old vbadvanced, and deleted the cms index, then replaced with the new version of the cms index..would that be why?

Again, your problem is related to the connectivity to your MySQL database and not to this mod, so we could't help you in this topic. Sorry.

arob42 · #39 05-05-2005, 08:07 PM

Can this hack be modified to report unique visits by members and guests? If not, any pointers before I go in and attempt the modification myself? Sure appreciate your help. Thanks.

--Robert

DesiFlavour · #40 01-06-2006, 12:15 AM

The instructions on the initial post by the author and the ones in the attached text file are different, which ones am i suppose to follow? I've followed the ones from the attached file only and the mod doesn't seem right... figures its showing simply cannot be accurate.

Help please?

photongbic · #41 03-29-2006, 11:23 AM

Will this work with vB 3.5.4?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04978 seconds Memory Usage 2,328KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (4)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!