VB3 MicroStats

You asked for... but it was available for VB2 only? There you go, you have it now.

Looking for 3.5.4 version? Get it here.

VERSION 1.2 RELEASED
Basically the only difference you will notice is a dropdown menu that will display the unchached templates.
In this way, you can add it to the cache and save one or more queries.

[high]THIS HACK WAS TESTED IN A DEFAULT, CODE UNMODIFIED BOARD.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
REGULAR USERS STATS
- load time of specified page in microseconds (with custom no. of digits to show)
- percentages of PHP/MySQL usage
- number of queries executed

ADMINISTRATOR STATS
- number/name of uncached templates (name highlighted in blue, for uncached template)
- vBulletin DEBUG mode status
- server GZIP library compression status
- average Server Loads

[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.[/high]

IMPORTANT
If you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - [high]90.95%[/high] MySQL) with 17 queries
You probably use a bad piece of code, because vBulletin will never generate those extreme results.
Imagine this: the code uses only 10% the resources to read the actual PHP code and the rest of 90% is used only to scan the tables... WOW!
That means the code forces to read into the database for each user who visits the site at this percentage... if you have 1000 users viewing the page in the same time.. you can get a picture of it...
If you compare this with vBulletin, the software does the opposite, 90% PHP and 10% MySQL... the right way.

DIVISION BY ZERO ERROR? Read this.
INVALID STATS IF MYSQL COMPILED IN A NON-ENGLISH LANGUAGE? Read this.

NOTE: The blue highlighting is not working in Opera 7.23 version. (Thanks Christine)

Have fun.

[djohn]

Originally Posted by PitchouneN64ngc

Have you edited your functions.php file with Dreamweaver?

No, I've used internal FlashFXP editor. However, now everything is fine, that problem accured only once.

[Boofo]

Originally Posted by TECK

The IF should not change anything, except avoid proccesing any not needed functions, while increasing performance.
Do you run a UNIX box? Also, something is wrong there with your server. You cannot have 0 for all average loads, or make it work on Windows, from what I know (if anyone knows a way, please let me know, since I'm not good at server configuration ).

Leave the code as it is (that's why you get zero's)... and check with your host.
Let us all know the results.

Cheers.

They are running Linux and the server load has always worked correctly before. It has always flucuated in the past.

[TECK]

Originally Posted by Boofo

They are running Linux and the server load has always worked correctly before. It has always flucuated in the past.

Thanks for clearing this up. It beats me why the IF would not work, because it should.
Please post the full IF change so others could see it and paste it properly.
If it's working better your way, the hell with the code performance, we will use what's better, right?

Cheers.

[Boofo]

Here's what I did. I changed:

PHP Code:

  if ($stats = @exec('uptime 2>&1') AND trim($stats) != '')
  {
   if (preg_match("/averages?: ([0-9\.]+), [\s]+([0-9\.]+), [\s]+([0-9\.]+)/", $stats, $regs)) 


to:

PHP Code:

  if ( $stats = @exec( 'uptime' ) )
  {
    preg_match( '/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/' , $stats , $regs ); 


and it works right now. Here is a fresh screenshot of my server load (so you can see that it is working).

Sorry about this Floren.

[TECK]

Originally Posted by Boofo

Here's what I did. I changed:

PHP Code:

  if ($stats = @exec('uptime 2>&1') AND trim($stats) != '')
  {
   if (preg_match("/averages?: ([0-9\.]+), [\s]+([0-9\.]+), [\s]+([0-9\.]+)/", $stats, $regs)) 


to:

PHP Code:

  if ( $stats = @exec( 'uptime' ) )
  {
    preg_match( '/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/' , $stats , $regs ); 


and it works right now. Here is a fresh screenshot of my server load (so you can see that it is working).

Sorry about this Floren.

Try this for me please:

  if ($stats = @exec('uptime 2>&1') AND trim($stats) != '')
  {

Let me know if it's working. It should display the stats if the values are not 0 only. Thanks.

[Boofo]

Yes, that works, too.

[TECK]

Ok, let's leave it then this way, what do you think?
Basically, we will remove only the IF in front of PREG_MATCH function... I'm still persistent with the IF... Leave the IF and try to refresh several times the page so you can create a server load. Let me know if it'S displaying the stats. Sorry to bother you but I don't have access to a UNIX server now.

I will update the file when I get back from work.

[Boofo]

Looks good to me.

If I don't remove the IF, the server load doesn't show at all.

[TECK]

Originally Posted by Boofo

Looks good to me.

If I don't remove the IF, the server load doesn't show at all.

Try this line?

			if (preg_match("/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/", $stats, $regs))
			{

Let me know please Bob.
PS. Damn I deleted by accident the image, instead of the file, no more screenshot till tonight... We have one from Bob anyway, heh.

[Boofo]

This is wierd. I re-downloaded your file and put the if code in like you have it in your file and for some reason, it is showing the server load now (with the IF statement). I swear to you that it wasn't working before. I don't know what happened. You have any ideas?