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.

[greenhybrid]

I'm getting the following error. Any idea?

Parse error: parse error, unexpected ']' in /home/gh/public_html/discuss/includes/functions.php on line 1997

[venomx]

My site seems to use like 80%+ mysql.. that scares me and I dunno why it does

[TECK]

Using some of those vb3 'portals', as frontpage? Is normal, they are known for killing your server with a large number of queries that scan the hole tables, instead of small to the point sections.
Remove the portal and stick with the normal vb3 forumhome.

[ChrisLM2001]

Teck,

Can you add an option of memory used per page (like vB's debug mode) for Admins? Finding it useful in tracking down bloat, and it'll be a handy addition for Admins who are monitoring their memory limits.

Love this mod. Comes in so handy monitoring day-to-day performance at a glance.

Chris

[greenhybrid]

It's been weeks and still no help?

[PitchouneN64ngc]

Originally Posted by greenhybrid

It's been weeks and still no help?

This hack has no problem during the installation. What is the code on the line 1997 in ./includes/functions.php (include 4-5 lines before and after the line 1997)?

[greenhybrid]

I made the replacements again so I could find the line.

PHP Code:

    $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"; 


What was 1997 before I think is 1996 now. That would be

PHP Code:

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


[greenhybrid]

This time when I installed AGAIN I got this error:

Parse error: parse error, unexpected T_STRING, expecting '{' in /home/gh/public_html/discuss/includes/db_mysql.php on line 188

Line 188 is the last {

PHP Code:

    function shutdown_query($query_string, $arraykey = 0)
    {
        global $shutdownqueries;

        if (NOSHUTDOWNFUNC AND !$arraykey)
        {
            return $this->query($query_string);
        }
        elseif ($arraykey)
        {
            $shutdownqueries["$arraykey"] = $query_string;
        }
        else
        {
            $shutdownqueries[] = $query_string;
        }
    }    function query($query_string, $query_type = 'mysql_query')
    {
        global $query_count, $querytime, $pagestarttime;

        $pageendtime = microtime();
        $starttime = explode(' ', $pagestarttime);
        $endtime = explode(' ', $pageendtime); 


[PitchouneN64ngc]

Place the line :

PHP Code:

function query($query_string, $query_type = 'mysql_query') 


At the next line, maybe PHP confuses with the } before.

[greenhybrid]

Then we get a

Parse error: parse error, unexpected ')', expecting ',' or ';' in /home/gh/public_html/discuss/includes/db_mysql.php on line 50

PHP Code:

        // connect to db server

        global $querytime;
        // do query