Back To Programming / Scripting / Coding Forum

Most registered users online stat...

  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Joined: Jun 15, 2003
  • Posts: 4583
  • Loc: Maryland
  • Status: Offline

Post December 15th, 2003, 6:52 pm

I was looking around and I'll be damned if I could find where the most users online stat was gathered/stored. I see where it is called in the template, and I see the definition in the languages, but I can't find it anywhere else.

Anyways if I can find it it'd be cool if we were to add/change it so it counted registered users aswell.

Any ideas where that'd be?!
Pixel Acres V2
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post December 15th, 2003, 6:52 pm

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Online

Post December 15th, 2003, 7:00 pm

That is so strange that you just brought that up. I was just wondering about that today because I was thinking about changing the most users online to only represent the most registered users online at Ozzu, since I am not sure what that number is, and I was curious.

If anything I was thinking about at least filtering out the Google Bot so it would not be counted in the most online user stat, since it highly inflates it.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • musik
  • Legend
  • Super Moderator
  • User avatar
  • Joined: Aug 06, 2003
  • Posts: 6892
  • Loc: up a tree
  • Status: Offline

Post December 15th, 2003, 7:20 pm

Ahhhaaaa!!!! This other forum had like 800 people online in one day... noone could figure why but they swore black and blue it was true!!!


GOOGLE BOT!!! :shock:
Opportunity To Do - Changing the lives of children around the world.
Rose.id.au - Doing Life.
  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Joined: Jun 15, 2003
  • Posts: 4583
  • Loc: Maryland
  • Status: Offline

Post December 15th, 2003, 7:30 pm

there is no instance of "record" in any of the root files (just /phpbb2/).

It'd be really cool if we could figure that out, it'd make a great mod too! :-P
Pixel Acres V2
  • RyTRiX
  • Graduate
  • Graduate
  • User avatar
  • Joined: Mar 28, 2003
  • Posts: 239
  • Loc: Michigan
  • Status: Offline

Post December 15th, 2003, 8:10 pm

musik wrote:
Ahhhaaaa!!!! This other forum had like 800 people online in one day... noone could figure why but they swore black and blue it was true!!!


GOOGLE BOT!!! :shock:


It can be done pretty easy with any proxy testing program.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post December 17th, 2003, 8:16 am

The answer is in the viewonline.php file.

The numbers for online viewers are all determined from analyzing the results of this query:

Code: [ Select ]
//
// Get user list
//
$sql = "SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, s.session_ip
    FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
    WHERE u.user_id = s.session_user_id
        AND s.session_time >= ".( time() - 300 ) . "
    ORDER BY u.username ASC, s.session_ip ASC";
  1. //
  2. // Get user list
  3. //
  4. $sql = "SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, s.session_ip
  5.     FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
  6.     WHERE u.user_id = s.session_user_id
  7.         AND s.session_time >= ".( time() - 300 ) . "
  8.     ORDER BY u.username ASC, s.session_ip ASC";


That's why you couldn't find one specific table record for who's online and what not.

Basically, online status is determined by an analysis of the session_logged_in status. If the session_logged_in status is "0" for session_user_id "-1" there are no guests on line. All guests are assigned "-1" as a user_id. So if that number is positive that is then added to the registered users number for the total.

Any user_id that is a positive number in the session table is a registered logged in user. The code on this page uses the results from the array to create the variables that are used on the viewonline_body.tpl

By modifying the variables here, you should be able to change the results of what is displayed as total users online.

----------------------------------------------------
Well, after rereading above, I realize that doesn't quite answer the question. The record users online is stored in the phpbb_config table, and it's about 50 rows in, so if you're using phpMyAdmin, you have to go to the second page of the table to find it.

I'll see if I can find the query that updates that table row. There should be a way to do what BWM's talking about, but I think you may have to manually reset that most ever to a lower number, or perhaps if you really want to measure it, maybe even zero (start fresh from the anniversary date, perhaps).

I'll let you know if I find the query.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23404
  • Loc: Woodbridge VA
  • Status: Offline

Post December 17th, 2003, 12:27 pm

Here's the code you'll need to change to your liking. It should be moderately easy to change, but as I mentioned before, since our Online online user total will take awhile to exceed the current most ever online, you may want to manually lower that after you've made the change.

It's located near the beginning of the /includes/page_header.php file:

Code: [ Select ]
// Get basic (usernames + totals) online

// situation

//

$logged_visible_online = 0;

$logged_hidden_online = 0;

$guests_online = 0;

$online_userlist = '';



if (defined('SHOW_ONLINE'))

{



    $user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';

    $sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip

        FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s

        WHERE u.user_id = s.session_user_id

            AND s.session_time >= ".( time() - 300 ) . "

            $user_forum_sql

        ORDER BY u.username ASC, s.session_ip ASC";

    if( !($result = $db->sql_query($sql)) )

    {

        message_die(GENERAL_ERROR, 'Could not obtain user/online information', '', __LINE__, __FILE__, $sql);

    }



    $userlist_ary = array();

    $userlist_visible = array();



    $prev_user_id = 0;

    $prev_user_ip = '';



    while( $row = $db->sql_fetchrow($result) )

    {

        // User is logged in and therefor not a guest

        if ( $row['session_logged_in'] )

        {

            // Skip multiple sessions for one user

            if ( $row['user_id'] != $prev_user_id )

            {

                $style_color = '';

                if ( $row['user_level'] == ADMIN )

                {

                    $row['username'] = '<b>' . $row['username'] . '</b>';

                    $style_color = 'style="color:#' . $theme['fontcolor3'] . '"';

                }

                else if ( $row['user_level'] == MOD )

                {

                    $row['username'] = '<b>' . $row['username'] . '</b>';

                    $style_color = 'style="color:#' . $theme['fontcolor2'] . '"';

                }



                if ( $row['user_allow_viewonline'] )

                {

                    $user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'>' . $row['username'] . '</a>';

                    $logged_visible_online++;

                }

                else

                {

                    $user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'><i>' . $row['username'] . '</i></a>';

                    $logged_hidden_online++;

                }



                if ( $row['user_allow_viewonline'] || $userdata['user_level'] == ADMIN )

                {

                    $online_userlist .= ( $online_userlist != '' ) ? ', ' . $user_online_link : $user_online_link;

                }

            }



            $prev_user_id = $row['user_id'];

        }

        else

        {

            // Skip multiple sessions for one user

            if ( $row['session_ip'] != $prev_session_ip )

            {

                $guests_online++;

            }

        }



        $prev_session_ip = $row['session_ip'];

    }

    $db->sql_freeresult($result);



    if ( empty($online_userlist) )

    {

        $online_userlist = $lang['None'];

    }

    $online_userlist = ( ( isset($forum_id) ) ? $lang['Browsing_forum'] : $lang['Registered_users'] ) . ' ' . $online_userlist;



    $total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online;



    if ( $total_online_users > $board_config['record_online_users'])

    {

        $board_config['record_online_users'] = $total_online_users;

        $board_config['record_online_date'] = time();



        $sql = "UPDATE " . CONFIG_TABLE . "

            SET config_value = '$total_online_users'

            WHERE config_name = 'record_online_users'";

        if ( !$db->sql_query($sql) )

        {

            message_die(GENERAL_ERROR, 'Could not update online user record (nr of users)', '', __LINE__, __FILE__, $sql);

        }



        $sql = "UPDATE " . CONFIG_TABLE . "

            SET config_value = '" . $board_config['record_online_date'] . "'

            WHERE config_name = 'record_online_date'";

        if ( !$db->sql_query($sql) )

        {

            message_die(GENERAL_ERROR, 'Could not update online user record (date)', '', __LINE__, __FILE__, $sql);

        }

    }



    if ( $total_online_users == 0 )

    {

        $l_t_user_s = $lang['Online_users_zero_total'];

    }

    else if ( $total_online_users == 1 )

    {

        $l_t_user_s = $lang['Online_user_total'];

    }

    else

    {

        $l_t_user_s = $lang['Online_users_total'];

    }



    if ( $logged_visible_online == 0 )

    {

        $l_r_user_s = $lang['Reg_users_zero_total'];

    }

    else if ( $logged_visible_online == 1 )

    {

        $l_r_user_s = $lang['Reg_user_total'];

    }

    else

    {

        $l_r_user_s = $lang['Reg_users_total'];

    }



    if ( $logged_hidden_online == 0 )

    {

        $l_h_user_s = $lang['Hidden_users_zero_total'];

    }

    else if ( $logged_hidden_online == 1 )

    {

        $l_h_user_s = $lang['Hidden_user_total'];

    }

    else

    {

        $l_h_user_s = $lang['Hidden_users_total'];

    }



    if ( $guests_online == 0 )

    {

        $l_g_user_s = $lang['Guest_users_zero_total'];

    }

    else if ( $guests_online == 1 )

    {

        $l_g_user_s = $lang['Guest_user_total'];

    }

    else

    {

        $l_g_user_s = $lang['Guest_users_total'];

    }



    $l_online_users = sprintf($l_t_user_s, $total_online_users);

    $l_online_users .= sprintf($l_r_user_s, $logged_visible_online);

    $l_online_users .= sprintf($l_h_user_s, $logged_hidden_online);

    $l_online_users .= sprintf($l_g_user_s, $guests_online);

}
  1. // Get basic (usernames + totals) online
  3. // situation
  5. //
  7. $logged_visible_online = 0;
  9. $logged_hidden_online = 0;
  11. $guests_online = 0;
  13. $online_userlist = '';
  17. if (defined('SHOW_ONLINE'))
  19. {
  23.     $user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = " . intval($forum_id) : '';
  25.     $sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip
  27.         FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
  29.         WHERE u.user_id = s.session_user_id
  31.             AND s.session_time >= ".( time() - 300 ) . "
  33.             $user_forum_sql
  35.         ORDER BY u.username ASC, s.session_ip ASC";
  37.     if( !($result = $db->sql_query($sql)) )
  39.     {
  41.         message_die(GENERAL_ERROR, 'Could not obtain user/online information', '', __LINE__, __FILE__, $sql);
  43.     }
  47.     $userlist_ary = array();
  49.     $userlist_visible = array();
  53.     $prev_user_id = 0;
  55.     $prev_user_ip = '';
  59.     while( $row = $db->sql_fetchrow($result) )
  61.     {
  63.         // User is logged in and therefor not a guest
  65.         if ( $row['session_logged_in'] )
  67.         {
  69.             // Skip multiple sessions for one user
  71.             if ( $row['user_id'] != $prev_user_id )
  73.             {
  75.                 $style_color = '';
  77.                 if ( $row['user_level'] == ADMIN )
  79.                 {
  81.                     $row['username'] = '<b>' . $row['username'] . '</b>';
  83.                     $style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
  85.                 }
  87.                 else if ( $row['user_level'] == MOD )
  89.                 {
  91.                     $row['username'] = '<b>' . $row['username'] . '</b>';
  93.                     $style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
  95.                 }
  99.                 if ( $row['user_allow_viewonline'] )
  101.                 {
  103.                     $user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'>' . $row['username'] . '</a>';
  105.                     $logged_visible_online++;
  107.                 }
  109.                 else
  111.                 {
  113.                     $user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'><i>' . $row['username'] . '</i></a>';
  115.                     $logged_hidden_online++;
  117.                 }
  121.                 if ( $row['user_allow_viewonline'] || $userdata['user_level'] == ADMIN )
  123.                 {
  125.                     $online_userlist .= ( $online_userlist != '' ) ? ', ' . $user_online_link : $user_online_link;
  127.                 }
  129.             }
  133.             $prev_user_id = $row['user_id'];
  135.         }
  137.         else
  139.         {
  141.             // Skip multiple sessions for one user
  143.             if ( $row['session_ip'] != $prev_session_ip )
  145.             {
  147.                 $guests_online++;
  149.             }
  151.         }
  155.         $prev_session_ip = $row['session_ip'];
  157.     }
  159.     $db->sql_freeresult($result);
  163.     if ( empty($online_userlist) )
  165.     {
  167.         $online_userlist = $lang['None'];
  169.     }
  171.     $online_userlist = ( ( isset($forum_id) ) ? $lang['Browsing_forum'] : $lang['Registered_users'] ) . ' ' . $online_userlist;
  175.     $total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online;
  179.     if ( $total_online_users > $board_config['record_online_users'])
  181.     {
  183.         $board_config['record_online_users'] = $total_online_users;
  185.         $board_config['record_online_date'] = time();
  189.         $sql = "UPDATE " . CONFIG_TABLE . "
  191.             SET config_value = '$total_online_users'
  193.             WHERE config_name = 'record_online_users'";
  195.         if ( !$db->sql_query($sql) )
  197.         {
  199.             message_die(GENERAL_ERROR, 'Could not update online user record (nr of users)', '', __LINE__, __FILE__, $sql);
  201.         }
  205.         $sql = "UPDATE " . CONFIG_TABLE . "
  207.             SET config_value = '" . $board_config['record_online_date'] . "'
  209.             WHERE config_name = 'record_online_date'";
  211.         if ( !$db->sql_query($sql) )
  213.         {
  215.             message_die(GENERAL_ERROR, 'Could not update online user record (date)', '', __LINE__, __FILE__, $sql);
  217.         }
  219.     }
  223.     if ( $total_online_users == 0 )
  225.     {
  227.         $l_t_user_s = $lang['Online_users_zero_total'];
  229.     }
  231.     else if ( $total_online_users == 1 )
  233.     {
  235.         $l_t_user_s = $lang['Online_user_total'];
  237.     }
  239.     else
  241.     {
  243.         $l_t_user_s = $lang['Online_users_total'];
  245.     }
  249.     if ( $logged_visible_online == 0 )
  251.     {
  253.         $l_r_user_s = $lang['Reg_users_zero_total'];
  255.     }
  257.     else if ( $logged_visible_online == 1 )
  259.     {
  261.         $l_r_user_s = $lang['Reg_user_total'];
  263.     }
  265.     else
  267.     {
  269.         $l_r_user_s = $lang['Reg_users_total'];
  271.     }
  275.     if ( $logged_hidden_online == 0 )
  277.     {
  279.         $l_h_user_s = $lang['Hidden_users_zero_total'];
  281.     }
  283.     else if ( $logged_hidden_online == 1 )
  285.     {
  287.         $l_h_user_s = $lang['Hidden_user_total'];
  289.     }
  291.     else
  293.     {
  295.         $l_h_user_s = $lang['Hidden_users_total'];
  297.     }
  301.     if ( $guests_online == 0 )
  303.     {
  305.         $l_g_user_s = $lang['Guest_users_zero_total'];
  307.     }
  309.     else if ( $guests_online == 1 )
  311.     {
  313.         $l_g_user_s = $lang['Guest_user_total'];
  315.     }
  317.     else
  319.     {
  321.         $l_g_user_s = $lang['Guest_users_total'];
  323.     }
  327.     $l_online_users = sprintf($l_t_user_s, $total_online_users);
  329.     $l_online_users .= sprintf($l_r_user_s, $logged_visible_online);
  331.     $l_online_users .= sprintf($l_h_user_s, $logged_hidden_online);
  333.     $l_online_users .= sprintf($l_g_user_s, $guests_online);
  335. }



Specifically here is where the record gets updated:
Code: [ Select ]
if ( $total_online_users > $board_config['record_online_users'])

  {

   $board_config['record_online_users'] = $total_online_users;

   $board_config['record_online_date'] = time();



   $sql = "UPDATE " . CONFIG_TABLE . "

     SET config_value = '$total_online_users'

     WHERE config_name = 'record_online_users'";
  1. if ( $total_online_users > $board_config['record_online_users'])
  3.   {
  5.    $board_config['record_online_users'] = $total_online_users;
  7.    $board_config['record_online_date'] = time();
  11.    $sql = "UPDATE " . CONFIG_TABLE . "
  13.      SET config_value = '$total_online_users'
  15.      WHERE config_name = 'record_online_users'";




Looks like this should be all you have to do:

Code: [ Select ]
// This mod changes "most users ever online" to
// "most logged in registered users ever online".
// Installation - Easy
// Installation time - 5 minutes
// Files to modify - 2


//----------------------------------------------------------------------
// Open /includes/page_header.php

Find:
    $total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online;

Replace with:

    $total_online_users = $logged_visible_online + $logged_hidden_online;


//---------------------------------------------------------------------------
// Open /language/lang_main.php

Find:

$lang['Record_online_users'] = 'Most users ever online was <b>%s</b> on %s'; // first %s = number of users, second %s is the date.

Replace with:

$lang['Record_online_users'] = 'Most logged in registered users ever online was <b>%s</b> on %s'; // first %s = number of users, second %s is the date.

//If you'd like an achievable number to beat, manually reset the record_online_users row in the phpbb_config table to zero or a realistic/achievable number

//save changes to both files
//You're done
  1. // This mod changes "most users ever online" to
  2. // "most logged in registered users ever online".
  3. // Installation - Easy
  4. // Installation time - 5 minutes
  5. // Files to modify - 2
  8. //----------------------------------------------------------------------
  9. // Open /includes/page_header.php
  11. Find:
  12.     $total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online;
  14. Replace with:
  16.     $total_online_users = $logged_visible_online + $logged_hidden_online;
  19. //---------------------------------------------------------------------------
  20. // Open /language/lang_main.php
  22. Find:
  24. $lang['Record_online_users'] = 'Most users ever online was <b>%s</b> on %s'; // first %s = number of users, second %s is the date.
  26. Replace with:
  28. $lang['Record_online_users'] = 'Most logged in registered users ever online was <b>%s</b> on %s'; // first %s = number of users, second %s is the date.
  30. //If you'd like an achievable number to beat, manually reset the record_online_users row in the phpbb_config table to zero or a realistic/achievable number
  32. //save changes to both files
  33. //You're done



ENJOY! :D

------------------------------------
P.S. This thread should probably get shifted to programming.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.

Page 1 of 1

Post Information

  • Total Posts in this topic: 7 posts
  • Users browsing this forum: No registered users and 110 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.