vbMicroStats: page load time, queries, GZIP and PHP version

[high]Looking for VB3 version? Is here.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
- load time of specified page in microseconds (with custom no. of digits to show)
- number of queries executed
- server GZIP library compression status
- vBulletin DEBUG mode
- PHP version
- PHP percent page usage
- MySQL percent page usage
- Server Load
[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.
The hack is template based so you can edit it the way you want in few seconds.[/high]
NOTE: From users experiences, this hack will work only with PHP 4.0.6 or higher. Let me know if it works with a lower PHP version.

THE FIX FOR VB2.3.0 IS HERE.

HACK UPDATES
Version 2.1
------------------------------------
Changes:
- added Server Load

NOTE: I spoked with Kevin 'tubedogg' from vBulletin Support team and he explained to me that not all the servers are configured to support the [high]@exec("uptime")[/high].
Contact your host for more details and ask them about this issue.
For a full explanation of your 3 server load values, read more here.

*If you want to have the stats viewable only by admins, read this post.

Version 2.0
------------------------------------
Changes:
- added vBulletin DEBUG Mode
- removed the Details link
- cleaned a little the code to match VB2.2.6
- better explanations into the install file.

Version 1.7
------------------------------------
[high]VB2.2.5:[/high]
Minor change in admin/db_mysql.php. Read more here on how to update your hack.
Minor change in forum/global.php. Read more here on how to update your hack.

Changes:
- corrected negative values on certain servers.

Version 1.6
------------------------------------
Changes:
- PHP version and GZIP library status viewable only to admin.
- added a link to Detailed Stats View (generated by vBulletin), for that specific page. Only admins can view that link.

To see how it looks a Detailed View, click here.

Version 1.5
------------------------------------
Added:
- GZIP library status is now related to your vBulletion options.
- GZIP library compression level.

Version 1.4
------------------------------------
Bugs corrected:
- GZIP library status not displayed properly on certain servers.

Version 1.3
------------------------------------
Bugs corrected:
- vbPortal display code in modules

The hack is template based now.
All you have to do is call it with the {getmicrostats} string, anywhere you want (for example in footer).
You also have the choice to install it as template based or coded directly into your functions.php file.

Version 1.2
------------------------------------
Added the PHP and MySQL page percentage.
(Addon by Chen 'FireFly' Avinadav)

Version 1.1
------------------------------------
vB.org decided to add this hack to their board.

Bugs corrected:
- incorrect time load
- incorrect query count

You like this hack? Please click on the [high]Install[/high] button.
To download the latest version of this hack, click below:

[solent]

Today at 07:54 PM Sonikku said this in Post #810
You have to place the variable into your footer. Preferably towards the bottom. Read the instructions, it tells you what variable to put.

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
| $debugmode - tells if VB is in debug mode
| $versionphp - PHP version
| $percentphp - PHP percent page usage
| $percentsql - MySQL percent page usage
| $gziptext - GZIP compression library
| $gziplevel - GZIP compression level
| $serverload - your average server load

those are the final steps but which variable are you talking about?

maybe you mean the string?

have a look here the site is still not in production
http://www.depfacy.com/forums/showth...=12&forumid=39

well i have tried both by parsing the string and using the template and by inputing the whole thing in the footer template.
here is my footer just to tell me what is wrong.

PHP Code:

</td>
</tr>
</table>
<!-- /content area table -->
</center>
<TABLE WIDTH="100%" BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
<TD><a href="#top"><IMG SRC="{imagesfolder}/footer_01.gif" WIDTH=168 HEIGHT=69 border="0"></a></TD>
<TD background="{imagesfolder}/footer_02.gif" width="100%" height="69"></TD>
<TD><a href="http://www.vbforumskins.com" target="_blank"><IMG SRC="{imagesfolder}/footer_03.gif" WIDTH=530 HEIGHT=69 border="0"></a></TD>
</TR>
<br><center>Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.$adminstats<center>
</TABLE>
</td></tr>
</table>
</center> 


is there any possibility that the page loads very fast that no time of % php and sql are recorded?
This is a dedicated machine of 800MHz and 768MB RAM and 10K rpm SCSI drivers and doesnt do anything else but hosting this board which is currently not used.

Also why can i not see the adminstats ?

[TECK]

Search the thread for answers. Those questions were asked (and answered) several times by many other users.

[Red Blaze]

Sorry TECK, but I'll answer it anyway, some people could be too lazy to search through a 55 page thread. *raises hand* =j

Dude, Just add {getmicrostats} anywhere in your footer Preferably after </table> since there is nothing after it. If you did everything right, {getmicrostats} should call everything that's needed.

[solent]

Today at 10:14 PM Sonikku said this in Post #813
Sorry TECK, but I'll answer it anyway, some people could be too lazy to search through a 55 page thread. *raises hand* =j

Dude, Just add {getmicrostats} anywhere in your footer Preferably after </table> since there is nothing after it. If you did everything right, {getmicrostats} should call everything that's needed.

i aint lazy just missed the replacment thingy.

and what you said sonikku is not the solutions as that is the first thing i did.

well here are my results dunno if they are good but from what i have read over 100 queries i can be in trouble

forumhome
------------------------------
Page generated in 0.16079295 seconds (65.76% PHP - 34.24% MySQL) with 62 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP enabled - level 1] [Server Load: 0.00 ? 0.03 : 0.00]


vbPortal Home
------------------------------
Page generated in 0.18081701 seconds (54.13% PHP - 45.87% MySQL) with 107 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP enabled - level 1] [Server Load: 0.00 ? 0.03 : 0.00]

[Red Blaze]

107 Queries?! o.O;;; Daaaaaaamn! Is that natural? Anyway, if that's what you have, then I suppose you're ok. Check out what I have.

Tell, how many hacks do you have installed? And did you add alot of stuff in the head, and the php include?

[Sanjiyan]

bump for post:

https://vborg.vbsupport.ru/showthrea...954#post385954

[TECK]

Sanjiyan, search the thread (use the search option at the bottom of this page). Is your db_mysql.php file that does this. So check that file, there is your prob, not the hack.

solent, please tell me you don't have a busy site, orelse you will have your server account canceled with 107queries on ONE page.
107queries is EXTREMLY high, a total killer for the server.

[solent]

solent, please tell me you don't have a busy site, orelse you will have your server account canceled with 107queries on ONE page.
107queries is EXTREMLY high, a total killer for the server.

TECK the server is mine and it will be hosted for free in an ISP as they will be our SPONSORS

the server is a 1 800MHZ CPU with 2 cpus cabable, 768MB of SDRAM PC100 and a 7.2K rpm SCSI Drive.

i am running vbportal www.vbportal.com together with vbulletin and maybe that is the reason. vbportal is the beggiset hack made for vbulletin. maybe that is why i am getting all that queries. the server will be probably have 100 concurrent users at the tops.

[Sanjiyan]

Thanks TECK problems solved, and its working now.

I was having the same problem as in this post:
https://vborg.vbsupport.ru/showthrea...047#post332047

[TECK]

Yesterday at 09:19 AM solent said this in Post #818
TECK the server is mine and it will be hosted for free in an ISP as they will be our SPONSORS

the server is a 1 800MHZ CPU with 2 cpus cabable, 768MB of SDRAM PC100 and a 7.2K rpm SCSI Drive.

i am running vbportal www.vbportal.com together with vbulletin and maybe that is the reason. vbportal is the beggiset hack made for vbulletin. maybe that is why i am getting all that queries. the server will be probably have 100 concurrent users at the tops.

Still, you should direct yourself to scripts that use less then 25queries. A script that uses 100queries is really bad written.