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.

[PitchouneN64ngc]

You have these errors when you try to view your pages during the installation of this hack or totally after ?

[greenhybrid]

What do you mean? "Installation" is simply editing the 2 files, which I did. I didn't change the templates yet, but that should have nothing to do with the code.

[greenhybrid]

I even added {ms} the template and I'm still getting

Parse error: parse error, unexpected T_STRING in /home/gh/public_html/discuss/includes/functions.php on line 1996

[Mosh]

Originally Posted by greenhybrid

I even added {ms} the template and I'm still getting

It would probably help if you quoted lines 1990 to 2010 from your functions.php file, this may help someone to narrow down your problem.

[greenhybrid]

Something weird is going on. I don't know if it's a Dreamweaver bug or not, but when I open up functions.php again, that same line 1996 is now

PHP Code:

    $ms .= '        <td class="tcat"' . iif($vboptions['allowchangestyles'], '],'],'],' colspan="2"') . '><div class="smallfont">'; 


The same thing had happened before, so I redid the edits. It keeps happening, though!

1990-2010 are

PHP Code:

    $totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], $msdecimal);

    $msphp = vb_number_format(((($totaltime - $querytime) / $totaltime) * 100), 2) . '% PHP';
    $mssql = vb_number_format((($querytime / $totaltime) * 100), 2) . '% MySQL';

    $ms = '<tr align="right">' . "\n";
    $ms .= '        <td class="tcat"' . iif($vboptions['allowchangestyles'], '],'],'],' colspan="2"') . '><div class="smallfont">';
    $ms .= 'Page generated in ' . $totaltime . ' seconds (' . $msphp . ' - ' . $mssql . ') with ';
    $ms .= $query_count . ' queries</div></td>' . "\n";
    $ms .= '</tr>' . "\n";

    if ($bbuserinfo['usergroupid'] == '6')
    {
        $mstemplates = '<select size="1" style="font-size: 10px">' . "\n";
        
        if ($_TEMPLATEQUERIES)
        {
            $mstemplates .= '<option>' . sizeof($_TEMPLATEQUERIES) . ' Uncached Template';
            $mstemplates .= iif(sizeof($_TEMPLATEQUERIES) != '1', 's') . '</option>';

            if (is_array($tempusagecache)) 


[TECK]

Dreamweaver is known for issues like that. Use the Textpad.com editor instead.
You will never have a problem again editing files...

[yinyang]

teck, i really want to install this, but the codes you indicate to replace are different in vb3.07. can we trouble you in updating this to 3.07? please?

[greenhybrid]

They are different, but they're similar. Of course, I'm the one who had the problems before But, you should be able to find the right code.

[greenhybrid]

Then again, maybe that's why I was getting my errors.

[TECK]

I don't have the upgrade available, I will need to pay the 30$ fee in order to do download the latest version...
As soon I can spare a little money, it will be done.