vb.org Archive

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)

Viruseater 04-01-2002 02:48 AM

Got it worked out Nakkid, thanks.

I've got 1.6 running on the current board, which I just put into production. www.clanservers.net/forum and I'll do the upgrade next.

Like the hack, and it's got some great debug features.

great job

Jawelin 04-01-2002 09:12 AM

Quote:

Originally posted by nakkid
i dont know what to say Jawelin. anyone else have the same problem? so far everyone is really happy with 1.7...
Absolutely NO PROBLEM, Nakkid.
I went deeper only to investigate better why times reported are so different each other.
As said before, version 1.7 is absolutely stable and works perfectly... Never had negative (or > 100) values any more...
Even, I verified global.php is called only once.

The strange even is the greatest processing time is taken by the 'eval ... forumhome template', not by my 38 queries on the homepage.... :nervous: :nervous:

Thanks again for support.
I exposed my search results only to have some number to talk about.
Bye

TECK 04-02-2002 02:13 PM

Quote:

Originally posted by Jawelin
As said before, version 1.7 is absolutely stable and works perfectly... Never had negative (or > 100) values any more...
Even, I verified global.php is called only once.

ok.. just wanted to make sure i understood you corectly. ;)

dyt4 04-02-2002 03:56 PM

just another little question about time I obtain always page generated in between 0.5 and 1.5 seconds . But I look at my watch it's often 10 or 20 seconds with my ISDN connection and 2 seconds with my DSL connection at work ???

TECK 04-02-2002 04:04 PM

do you have v1.7 installed?
on my localhost (no internet connection) i got up to 2.600000seconds to load a page, depending what i was doing.
look here at vB.org:
[high]Page generated in 5.97940302 seconds (74.72% PHP - 25.28% MySQL) with 38 queries.[/high]

Jawelin 04-02-2002 07:55 PM

I definetively don't think the connection speed could affect any way the page generation time on the server side (i.e. php + sql time ARE server times)....
:)
I'm talking about different measurements of the same server-side time in different page 'breakpoints'... let's say.

TECK 04-03-2002 08:08 PM

actually it depends a little in your pc performance. if you have a slow pc, the time it takes to load the page will reflect it. ;)
i did a test, on several pc's, at work... to load vB.org. i got different values (huge ones) on winXP, win2k and win98 (P4, P2 and AMD). here there are the results:
win98(AMD) - 4.00 seconds
win2k(P2) - 2.00 seconds
winXP(P4) - 0.80 seconds

internet connection: T1 (all cases)

Admin 04-04-2002 05:16 AM

Actually nakkid it has nothing to do with that. From the second the server gets a request for the PHP page the parser is doing all the work, not your computer.

TECK 04-04-2002 06:29 AM

this is wierd. i wonder why i got those stats. all pc's were connected to the same network.

thanks for the explanation firefly.

Legacy 04-07-2002 04:14 AM

Page generated in 1,018,162,977.218 seconds(100.00% PHP - 0.00% MySQL) with 28 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression enabled (level 2). [details]

MySQL always comes up 0.00%...anyone know why??

TECK 04-07-2002 04:17 AM

yes. edit properly global.php

| 1. Find this code:
+--------------------------------------------------------------------------+
if (isset($showqueries)) {
$pagestarttime=microtime();
}
+--------------------------------------------------------------------------+
|
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
$pagestarttime=microtime();
+--------------------------------------------------------------------------+

Legacy 04-07-2002 04:19 AM

Yup...just saw that thread.....thx

FWC 04-07-2002 04:25 AM

Quote:

Originally posted by Legacy
Page generated in 1,018,162,977.218 seconds(100.00% PHP - 0.00% MySQL) with 28 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression enabled (level 2). [details]

MySQL always comes up 0.00%...anyone know why??

You modified admin/global.php instead of global.php in the forums root directory. Take the mods out of admin/global.php and add them to forums/global.php.

TECK 04-07-2002 04:29 AM

good point FWC. although.. is indicated in the install file clearly:
Code:

+-----------------------------------------------+
| File: forum/global.php (2 changes)            |
+-----------------------------------------------+
| 1. Find this code:
+--------------------------------------------------------------------------+
if (isset($showqueries)) {
  $pagestarttime=microtime();
}
+--------------------------------------------------------------------------+
|
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
$pagestarttime=microtime();
+--------------------------------------------------------------------------+

:)

FWC 04-07-2002 04:31 AM

Quote:

Originally posted by nakkid
good point FWC. although.. is indicated in the install file clearly
Yep. But, I made the same mistake so I know the cause of the symptom when I see it. :)

Legacy 04-07-2002 04:41 AM

I Edited the correct file..Problem is what your file is telling me and what my 2 Global files say are Diffrent
im on 2.2.5 and I just re-dl the VB files..

if (isset($showqueries)) {
$pagestarttime=microtime();
}

is in the /admin/global.php

My /forum/global.php has this

if (isset($showqueries)) {
$pagestarttime = microtime();
} else {
$pagestarttime = 0;
}

Thes came straight from VB where i just DL the files from

TECK 04-07-2002 04:46 AM

vBulletin v2.2.5 Update

In the new VB version, there is a little minor change in forum/global.php.
Find the code:
PHP Code:

if (isset($showqueries)) {
  
$pagestarttime microtime();
} else {
  
$pagestarttime 0;


Replace it with:
PHP Code:

$pagestarttime microtime(); 


Viruseater 04-07-2002 04:48 AM

Read back the rest of the thread.

You have to edit the global.php file if you've got 1.7 I don't think 1.6 instructs that.

FYI make sure you don't hack the one in the wrong directory, that's what I did.

Anyway, that's why it's giving yout those stats, like I said, read the thread, it's already been answered

TECK 04-07-2002 04:49 AM

Viruseater.. he's right. 225 changed. :ermm:

Legacy 04-07-2002 04:50 AM

That did the trick nakkid

Great Hack...thx for the Support...

Page generated in 0.277 seconds(78.57% PHP - 21.43% MySQL) with 28 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression enabled (level 2). [details]

Viruseater 04-07-2002 04:55 AM

Quote:

Originally posted by nakkid
Viruseater.. he's right. 225 changed. :ermm:
Well crap.

Looks like I'm the one that needs to re-read the thread. Sorry.

:D

TECK 04-07-2002 04:57 AM

dont worry.. :) i did this mistake one zillion times.. :D

FWC 04-07-2002 05:05 AM

Quote:

Originally posted by nakkid
dont worry.. :) i did this mistake one zillion times.. :D
Damn, that's one more than me! :)

TECK 04-07-2002 05:08 AM

lol.. :D

NTLDR 04-10-2002 10:13 PM

Hi nakkid,

I've tried loads of times to install this hack, on both a fresh install of 2.2.5 and a hacked install of 2.2.4.

I've tried manually applying the hack... and creating a vbhacker file to make the changes, but I've yet to get it working, I know the hack works as its on so many other forums.

I've attached a screenshout of the output I get on a fresh unhacked (other than the vbmicrostats hack) 2.2.5 install, any ideas on what I'm doing wrong?

Thanks In Advance,
Lee

Xelation 04-10-2002 11:12 PM

um nakkid, when I go to put the {getmicrostats} in the footer... this is what comes up...

Powered by: vBulletin Version 2.2.5
Copyright ©2000, 2001, Jelsoft Enterprises Limited.
{getmicrostats}

you know whats wrong?

Xanthine 04-10-2002 11:18 PM

Sounds like you forgot to add something to your replacements?

*edit* Maybe not, I dont see a step to add them in the install file. Not sure now.

NTLDR 04-10-2002 11:52 PM

Quote:

Originally posted by Xelation
um nakkid, when I go to put the {getmicrostats} in the footer... this is what comes up...

Powered by: vBulletin Version 2.2.5
Copyright ?2000, 2001, Jelsoft Enterprises Limited.
{getmicrostats}

you know whats wrong?

Thats the same as what I get (see the screen shot on the last page), but my templates don't work properly either though :(

I don't think this hack likes me :p

TECK 04-10-2002 11:57 PM

i just installed the hack in v225, following at letter the instructions included in the text file. it works perfectly. please check your steps carefully, especially the files you have to edit (forum/global.php and NOT [high]forum/admin/global.php[/high])

NTLDR 04-11-2002 01:06 PM

Hi nakkid,

I've tried installing it again, and I know I've edited the correct files, the part that is causing the error for me is replacing the follwoing in admin/fuctions.php:

This:
PHP Code:

// ###################### Start dovars #######################
function dovars($newtext,$sendheader=1) {
  
// parses replacement vars

  
global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg;
  static 
$vars;

  if (
connection_status()) {
    exit;
  }

  if (!isset(
$vars)) {
    
$vars=$DB_site->query("SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'$replacementsetid') ORDER BY replacementsetid DESC,replacementid DESC");
  } else {
    
$DB_site->data_seek(0,$vars);
  }

  while (
$var=$DB_site->fetch_array($vars)) {
    if (
$var['findword']!="") {
      
$newtext=str_replace($var['findword'],$var['replaceword'],$newtext);
    }
  } 

With This:
PHP Code:

// ###################### Start dovars #######################
function dovars($newtext,$sendheader=1) {
  
// parses replacement vars

  
global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg,$microstats;
  static 
$vars;

  if (
connection_status()) {
    exit;
  }

  if (!isset(
$vars)) {
    
$vars=$DB_site->query("SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'$replacementsetid') ORDER BY replacementsetid DESC,replacementid DESC");
  } else {
    
$DB_site->data_seek(0,$vars);
  }

  
$findwords=array(=> '{getmicrostats}');
  
$replacewords=array(=> $microstats);
  
$i=1;

  while (
$var=$DB_site->fetch_array($vars) and $i++) {
    if (
$var['findword']!="") {
      
$findwords[$i]=$var['findword'];
      
$replacewords[$i]=$var['replaceword'];
    }
  }

  
$newtext=str_replace($findwords,$replacewords,$newtext); 

Which causes my templates not to work and my forums look like this https://vborg.vbsupport.ru/attachmen...&postid=239359 (Screen Shot From Earlier Post).

I know I must be doing something stupid for it not to work!

TECK 04-11-2002 01:47 PM

it should not give you any trouble. there are several people who installed this hack and they didnt encountered any problem. check the install steps. i would compare the files and follow slowly the code to identify the problem. let me know if you found the bug. :)

hypedave 04-11-2002 04:44 PM

okay I just installed this hack and I am stumped at this point

what does no templete mode mean ???
then where exactly do I place {getmicrostats}
forgive me, I have been up for quite some time, I think it time for me go to bed, lol. as a normal day I would have this figured out

+-----------------------------------------------+
| 'no template' Mod |
+-----------------------------------------------+
| Find this code:
+--------------------------------------------------------------------------+
eval("\$microstats = \"".gettemplate('home_microstats')."\";");
+--------------------------------------------------------------------------+
|
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
$microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
$adminstats";
+--------------------------------------------------------------------------+
|
|
+-----------------------------------------------+
| FINAL STEPS |
+-----------------------------------------------+
| To call your vbMicroStats, simply place the string {getmicrostats}
| anywhere you want in your templates (for example in footer).
|
| NOTE: The higher you place the string in your templates,
| the more inacurate your data will be.
|
| The variables you can use are:
|
| $digits - number of digits for microtime
| $trimmedtime - the time your page is loaded
| $query_count - number of queries executed
| $versionphp - PHP version
| $percentphp - PHP percent page usage
| $percentsql - MySQL percent page usage
| $gziptext - GZIP compression library
| $gziplevel - GZIP compression level
| $debugmode - script Debug mode
|
| NOTE: If you want to have more(less) then 7 digits in your microtime,
| change the value '7' to what ever suits better your forum.
|
|
| Upload the modified files. You are done.
+--------------------------------------------------------------------------+

NTLDR 04-11-2002 04:49 PM

Well I've narrowed it down to being a problem with replacing

This Code:
PHP Code:

while ($var=$DB_site->fetch_array($vars)) {
    if (
$var['findword']!="") {
      
$newtext=str_replace($var['findword'],$var['replaceword'],$newtext);
    }
  } 

With This Code:
PHP Code:

  while ($var=$DB_site->fetch_array($vars) and $i++) {
    if (
$var['findword']!="") {
      
$findwords[$i]=$var['findword'];
      
$replacewords[$i]=$var['replaceword'];
    }
  }

  
$newtext=str_replace($findwords,$replacewords,$newtext); 

In particualr, removing this line:
PHP Code:

$newtext=str_replace($var['findword'],$var['replaceword'],$newtext); 

Which stops all my replacements working and I get what was in that screen shot.

The worst thing is I know this hack works as many other people use it!!

TECK 04-11-2002 07:53 PM

please install vbMicroStats in a unhacked test board. you will see it works. i always test my hacks on a unhacked board. let me know please how it went.

NTLDR 04-11-2002 09:20 PM

Quote:

Originally posted by nakkid
please install vbMicroStats in a unhacked test board. you will see it works. i always test my hacks on a unhacked board. let me know please how it went.
Hi nakkid,

Not sure if you were saything this to me or not, but that was what I got on a unhacked 2.2.5 board and the problem above was what I got :(

Thanks for your help,

Regards,
Lee

hypedave 04-11-2002 09:27 PM

Quote:

Originally posted by nakkid
please install vbMicroStats in a unhacked test board. you will see it works. i always test my hacks on a unhacked board. let me know please how it went.

okay I tryed this on my unhacked board
and my hacked board

is you instructions when it gets to this part here

| 'no template' Mod

thats where I am lost

from

| 'no template' Mod
on down

NTLDR 04-11-2002 10:35 PM

Quote:

Originally posted by hypedave



okay I tryed this on my unhacked board
and my hacked board

is you instructions when it gets to this part here

| 'no template' Mod

thats where I am lost

from

| 'no template' Mod
on down

You ahve 2 choices, either hard code the display into the fuctions.php file or add a template, if you have followed the instructions to that point, just create a template in your admin cp called home_microstats and put the following in it:

Code:

    $microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
                  $adminstats";

Then hopefully it will work for you! Unlike mine, lol

TECK 04-11-2002 10:40 PM

correct. is up to you to chose the one you want. any of them will work. ;)
be aware please, you posted the information in the wrong way. if you do this and post the code you mentioned above:
Code:

    $microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
                  $adminstats";

your template will not be displayed properly. the code segment you listed is for the option that you have to hardcode into the forum/global.php file.

hypedave 04-11-2002 11:02 PM

thankyou, thankyou

Page generated in 0.7612060 seconds (82.86% PHP - 17.14% MySQL) with 37 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression enabled (level 1). [details]

TECK 04-11-2002 11:04 PM

i'm glad you got it working. good luck with your site. :)
although, try to keep your queries under 40, if you dont want to see your host knocking at your door... :D


All times are GMT. The time now is 04:17 AM.

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.01931 seconds
  • Memory Usage 1,871KB
  • 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
  • (7)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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