vb.org Archive - vbMicroStats: page load time, queries, GZIP and PHP version

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vbMicroStats: page load time, queries, GZIP and PHP version (https://vborg.vbsupport.ru/showthread.php?t=35811)

Quote:

Originally posted by NTLDR
The update in Post 306 (above) also worked fine for me with the updated 2.2.6 db_mysql.php on vB 2.2.4

Thanks for the update ;)

I'm glad it's working for two of us. Beyond Compare came to the rescue. :)

The update in 306 is working for me also

The update for the new db_mysql is working for me, too.

However, the hack itself wasn't properly working before that, nor is it now. My percentages are completely odd:

Page generated in 0.4714550 seconds (163.74% PHP / -63.74% MySQL) with 20 queries

Page generated in 1.6309210 seconds (-6.54% PHP / 106.54% MySQL) with 20 queries

Page generated in -0.6399480 seconds (36.72% PHP / 63.28% MySQL) with 20 queries
(percentages good, generation time negative... wow)

I even had 5K~ and -5K~ percentages, a few times.

WHAT AM I DOING WRONG?! :'(

I am using php version 4.0.4pl1 on my own computer, might this be the cause of the problem?

hmm kurafire. wierd, it looks like a previous version bug.. this is how i updated the new db_mysql.php:

find:

Code:

  function query($query_string) {

    global $query_count;

    // do query



    $this->query_id = mysql_query($query_string,$this->link_id);

    if (!$this->query_id) {

      $this->halt("Invalid SQL: ".$query_string);

    }



    $query_count++;



    return $this->query_id;

  }

replace it with:

Code:

  function query($query_string) {

    global $query_count,$querytime,$pagestarttime;

    // do query



    $pageendtime=microtime();

    $starttime=explode(" ",$pagestarttime);

    $endtime=explode(" ",$pageendtime);



    $beforetime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];



    $this->query_id = mysql_query($query_string,$this->link_id);

    if (!$this->query_id) {

      $this->halt("Invalid SQL: ".$query_string);

    }



    $query_count++;



    $pageendtime=microtime();

    $starttime=explode(" ",$pagestarttime);

    $endtime=explode(" ",$pageendtime);



    $aftertime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];

    $querytime+=$aftertime-$beforetime;



    return $this->query_id;

  }

and it's working perfectly. make sure you download the latest version and follow the steps in there, you probably have 1.6 installed. also get the latest php binaries. let me know please.

I used your new code there, but it's still giving me freakish results.

I *did* 'adopt' a small change by FireFly because without it, my forum looked like a weird rainbow-thing. He said it was something to do with my low PHP version (4.0.4pl1) - might it be that this also caused the mess-up, or is it more logical that my php-version is the problem?

I tried installing new binaries of PHP but for some strange reason, the version never changed. I uninstalled and re-installed like 4 times, didn't work. :(

i know what is it!! upgrade your php binaries!! it hapened the same thing to another user who used PHP4.01. also make sure that your file says: vbMicroStats version 1.7
if it doesnt, delete all your temp files and download it again. let me know how it goes.

hm...anything working with the new update?

what do you mean anything working with the new update?
i do not understand. if you refer to the new db_mysql.php file, read above few posts...

ok, i placed a link on the first post.. so is easy for everyone to get the new db_mysql.php file and the hack update.

nakkid: I'll try, though I think I have to uninstall apache, mysql & php all at once, before it'll work. Like I said, for some weird reason, upgrading didn't do jack sh** the past 4 times :(

*makes note to do this in the afternoon*

thx :)

Hallo Nakkid,
me again. Well I found out that my provider is not using the latest php. Hes still got php 4.0.4pl. So I guess thats my problem.

Ive asked him to install a newer version and he sais he will do soon but would like to know why. So sorry, but I have to ask you why. What version do I need and why?

regards Tina

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 (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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.01780 seconds Memory Usage 1,747KB 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 (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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: