vb.org Archive
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Most ever Visitors, Posters & Chatters (Add-on) (https://vborg.vbsupport.ru/showthread.php?t=98887)

kennn 04-26-2006 06:05 PM
Hmmm...well it definitely happened and I see no signs of database corruption. Guess I'll just have to keep an eye on it and see how it goes. Thanks for the response.

kennn 04-26-2006 08:40 PM
This really has me curious and I happened to do a MySQL dump yesterday to back up my database, so I decided to do another one today and compare files.

From 04/25/2006:

Code:
INSERT INTO `vb_datastore` VALUES ('maxloggedin', 'a:6:{s:9:"maxonline";i:5;s:13:"maxonlinedate";i:1144430493;s:11:"maxvisitors";i:8;s:15:"maxvisitorsdate";i:1145928403;s:10:"maxposters";i:6;s:14:"maxpostersdate";i:1145918246;}');
From 04/26/2006:

Code:
INSERT INTO `vb_datastore` VALUES ('maxloggedin', 'a:6:{s:9:"maxonline";i:5;s:13:"maxonlinedate";i:1146065294;s:10:"maxposters";i:5;s:14:"maxpostersdate";i:1146067830;s:11:"maxvisitors";i:6;s:15:"maxvisitorsdate";i:1146065007;}');
As you can see, yesterday the maxvisitors was 8 and maxposters was 6 and today they are 6 and 5.

I did a file comparison between both database dumps and there is nothing out of the ordinary - just the usual changes from new posts, events, cron jobs running, etc. No sign of hacking or any corruption that I can see.

I would love to know how these records got changed. All other stats and information are spot on as they should be, even the "most online at once" which VB itself maintains is still correct.

Paul M 04-26-2006 09:24 PM
Well something is resetting the counts - possibly you have something that is rewriting the maxloggedin record without the maxposters & maxvisitors data.

kennn 04-26-2006 10:37 PM
These are the hacks I've got installed:

Number of Threads in User Profile
Show An Avatar On Who's Online
Mood Hack 3.5
bbSpoiler
Timezone Image In Profile
Members Who Have Posted Today
Who Has Read A Thread
Borgs BBCode Pack
Forum Skin In Profile
Join Days
Simple Breadcrumb Below Last Post
Separate Sticky & Normal Threads
Members Who Have Visited Today
Most Ever Visitors, Posters, Chatters

I've gone through the code of each and none of them make any reference to the maxloggedin datastore (except of course for "most ever visitors, posters, chatters").

I am also running vbAdvanced CMPS which does have a "who's online" module which makes references to maxloggedin. Do you think it could be the culprit? Thanks.

kennn 04-26-2006 10:43 PM
I think this is the salient portion of the onlineusers module for CMPS:

Code:
        $maxusers['maxonline'] = $vbulletin->maxloggedin['maxonline'];

        if ($vbulletin->maxloggedin['maxonline'] <= $totalonline)
        {
                $maxusers['maxonline'] = $totalonline;
                $maxusers['maxonlinedate'] = TIMENOW;
                $db->query_write("UPDATE " . TABLE_PREFIX . "datastore SET data='" . addslashes(serialize($maxusers)) . "' WHERE title = 'maxloggedin'");
        }

        $recordusers = $maxusers['maxonline'];
        $recorddate = vbdate($vbulletin->options['dateformat'], $vbulletin->maxloggedin['maxonlinedate'], 1);
        $recordtime = vbdate($vbulletin->options['timeformat'], $vbulletin->maxloggedin['maxonlinedate']);
If you think this might be the culprit, do you have any suggestions on changes I could make to the CMPS module to keep its functionality but prevent it from overwriting your plugin's data (if that is what it is doing)?

I guess I could always turn off that module but I would like to keep it if possible. Thanks!

Paul M 04-27-2006 07:27 AM
Ouch, yes, that is the culprit - it's using an sql query to directly write the maxloggedin record, erasing the maxposters and visitors data, that's very bad of whoever wrote it, the correct way is to use the build_datastore() function;

Try changing this line ;

PHP Code:
$db->query_write("UPDATE " . TABLE_PREFIX . "datastore SET data='" . addslashes(serialize($maxusers)) . "' WHERE title = 'maxloggedin'"); 
to this

PHP Code:
build_datastore('maxloggedin', serialize($vbulletin->maxloggedin)); 

kennn 04-27-2006 03:01 PM
Much thanks, Paul!

I've added your code change to my CMPS onlineusers module and will see how it goes. Hard to believe I'm the first to encounter this. I assume a lot of people are using vBAdvanced CMPS and your plugin. If this change stops the CMPS onlineusers module from stepping on the "most" plugin's toes, I'll call it to their attention over at vbadvanced.com. Thanks again! :)

MorrisMcD 05-06-2006 12:41 AM
Quote:
Originally Posted by kennn
Much thanks, Paul!

I've added your code change to my CMPS onlineusers module and will see how it goes. Hard to believe I'm the first to encounter this. I assume a lot of people are using vBAdvanced CMPS and your plugin. If this change stops the CMPS onlineusers module from stepping on the "most" plugin's toes, I'll call it to their attention over at vbadvanced.com. Thanks again! :)
Wow.. That is some bull.. Anyway.. I disabled that plugin.. That sucks.. It happened to me so I came in search of answers, and I guess I ran into the same problem.. Its the first time its ever happened though which is weird. Also what is weird is it now says the most guests even online was 266 last night at 2am.. I highly doubt this.. My site usually has no more than 30 members/guests online.. Before the stats were reset I think we managed to have like 100 on a one time.. But never 266 guests!

any idea why?

Paul M 05-06-2006 02:20 AM
You obviously had 266 guests - probably a load of spiders.

MorrisMcD 05-06-2006 03:32 PM
Quote:
Originally Posted by Paul M
You obviously had 266 guests - probably a load of spiders.

You think so?? I will check the logs.. I just thought it was odd.. I disabled guest access all last week due to the NFL Draft because I run a Bengals site.. Maybe they were queued up just waiting for it lol


All times are GMT. The time now is 01:34 PM.
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01447 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete