vb.org Archive - vBMicrostats

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vBMicrostats (https://vborg.vbsupport.ru/showthread.php?t=116027)

But it shouldn't be going into negative numbers should it? And I also notice when they get really high, the page takes forever to load.

Quote:

Originally Posted by Boofo

Is it normal for this:

to flucuate to this:

constantly? That is the report bad post page (with 7 queries) and it seems to go back and forth with almost every page refresh, or two. Not complaining, Teck, just curious. ;)

EDIT: Well, I just had this one show up on the same page:

;)

i seen that too i think its vbulletin itself.... cause mine is doing the same thing every so many pages loads too it never really reads the same...

Quote:

Originally Posted by Boofo

But it shouldn't be going into negative numbers should it?

Yes, it should go into negative values Bobby, because we only count the query execution time.
Once we have that specific value, we deduct from it the script start time, in order to obtain the the PHP execution time.

Let's don't count the DB connection time, first. In init.php, find this line:

Code:

$db->mstimer_stop();

Replace it with:

Code:

$db->mstimer_stop(false);

Then let me know if the time is also erratic. The code mod will not add anymore how long it takes to do the DB connection to the total SQL/query execution time. I belive the time will still be erratic, only smaller values will be processed for SQL.
One more time, vBMicroStats reads ONLY what is happening behind the script, it does not affect in anyway the vBulletin functionment.

Make me a favor. Disable vBMicroStats (code, etc.), enable the debug mode and look at the explained pages, while refreshing the page several times, the same way you do now with vBMicroStats enabled.

Post the results here. On my forums, they are almost identical in both cases.
However, we need to find out why we get SQL spikes once in a while.
With SQL is simple, you cannot have SOMETIMES certain results. Is either NEVER or ALL THE TIME.

Great mod!

But, how come the server avarages aren't showing up? I have it setup correctly in the adminCP.

Also, on vb3.0.x it always did show.

(to clearify, all other functions seem to be working allright)

You used my vBMicroStats for VB 3.0? It should show, it's the same code.
Let me know... maybe you changed the server software since then?
I will post a fix once I have more info from you.

Quote:

Originally Posted by HakkieDEV

i have the very same problem

using 3.5.4 - didnt use any previous hacks

In vBMicroStats Global Hook, find:

Code:

                if ($vbulletin->options['vb_mstats_server'] AND $stats = @exec('uptime 2>&1') AND trim($stats) != '' AND preg_match("#: ([\d.,]+),?\s+([\d.,]+),?\s+([\d.,]+)$#", $stats, $regs))

                {

                        $regs[1] = vb_number_format($regs[1], 2);

                        $regs[2] = vb_number_format($regs[2], 2);

                        $regs[3] = vb_number_format($regs[3], 2);

                        $server_status = '<strong>' . $regs[1] . '</strong> : ' . $regs[2] . ' : ' . $regs[3] . ' | ';

                }

Replace it with:

Code:

                if ($vbulletin->options['vb_mstats_server'])

                {

                        if ($stats = @exec('uptime 2>&1') AND trim($stats) != '' AND preg_match("#: ([\d.,]+),?\s+([\d.,]+),?\s+([\d.,]+)$#", $stats, $regs))

                        {

                                $regs[1] = vb_number_format($regs[1], 2);

                                $regs[2] = vb_number_format($regs[2], 2);

                                $regs[3] = vb_number_format($regs[3], 2);

                                $server_status = '<strong>' . $regs[1] . '</strong> : ' . $regs[2] . ' : ' . $regs[3] . ' | ';

                        }

                }

The original code works. Let me know if that fix it.

not for me

here is what my output is with ALL options set to yes

Page generated in 0.44428802 seconds (91.86% PHP - 8.14% MySQL) with 7 queries
3,737.15KB Used | DEBUG Mode OFF | GZIP ON (level 1) | NO Uncached Templates

Raptor, if I understand correctly, you see the server loads into your Admin CP, but not into every page?
It just doesn't make sense. It was working perfectly for everyone, all of the sudden we have 2 members letting me know the server loads are not showing.
The original version should work perfectly, no code mod needed.

It's working perfectly on my server.
Anyone else have the server loads showing with the latest version?

Possibly not ticked in the admincp to show?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01321 seconds Memory Usage 1,746KB 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 (4)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages: