Administrative and Maintenance Tools - ZH - Debug Mode

This modification was brought to you by
KXDesign

http://www.kxdesign.com/

~Hack name
Debug Mode

~Hack description
Enables debug mode in admincp/modcp and forums

~Hack options

• Turn on/off in forums
• Turn on/off in admincp
• Turn on/off in modcp
• Turn on/off in archive

~Hack info
File uploads: 0
Template edits: 0
File edits: 0
Plugins: 4
SQL Queries: 0
Phrases: 9
Settings: 4

Install time: 2 sec
Install level: Easy

~Hack installation
Step 1: Import product



~Hack screenshots
None


~Hack copyright
This may not be distributed,released or claimed as your work without author's permission.

New version here,with explain feature http://www.kxdesign.com/plugins/53-kx-debug-mode.html

[Andreas]

Originally Posted by Ziki

Not possible with a plugin,for that you have to edit the files

Believe me, it is (to some great extend - the only query you miss is datastore setup) - i've already done this:

• Create a plugin with execution order = 1 on init_startup
• Check if explain=1, otherweise done
• Copy the Resouce ID # o fthe mySQL connection and all other stuff you need from $db
• Require class_database_explain.php
• Unset $db, create a new object of class vB_Database_Explain and set the properties

And you're done

Sample Code

PHP Code:

if ($condition_to_activate_explain)
{

    switch (strtolower($vbulletin->config['Database']['dbtype']))
    {
        // load standard MySQL class
        case 'mysql':
        case '':
        {
            require_once(DIR . '/includes/class_database_explain.php');
            $newdb =& new vB_Database_Explain($vbulletin);
            break;
        }
    
        // load MySQLi class
        case 'mysqli':
        {
            require_once(DIR . '/includes/class_database_explain.php');
            $newdb =& new vB_Database_MySQLi_Explain($vbulletin);
            break;
        }
    }
    if (!empty($newdb))
    {
        $newdb->appname = $db->appname;
        $newdb->appshortname = $db->appshortname;
        $newdb->database = $db->database;
        $newdb->connection_master = $db->connection_master;
        $newdb->connection_slave =& $newdb->connection_master;
        $newdb->connection_recent = $db->connection_recent;
        $newdb->multiserver = $db->multiserver;
        $newdb->shutdownqueries = $db->shutdownqueries;
        $newdb->sql = $db->sql;
        $newdb->reporterror = $db->reporterror;
        $newdb->error = $db->error;
        $newdb->errno = $db->errno;
        $newdb->maxpacket = $db->maxpacket;
        $newdb->locked = $db->locked;
        $newdb->querycount = $db->querycount;
        $db = $newdb;
        $vbulletin->db =& $db;
    } 
} 


[Ziki]

New version here,with explain feature http://www.kxdesign.com/plugins/53-kx-debug-mode.html