CES Debug Mode Switcher

[thincom2000]

CES DEBUG MODE SWITCHER
Version: 1.1.0
vBulletin 3.6.x, 3.7.x, 3.8.x supported

*** NEWS ***
4/13/2009 - created 3.8.x thread

Products to Install: 1
Files to Upload: 1
Template Edits: 0
Files to Edit: 1

What It Does:
Allows enabling/disabling of Debug Mode in the AdminCP.
Allows Debug Mode activation using Usergroup Permissions.
Query Explain works!

What makes it different from other similar mods that turn on Debug Mode in the ACP?
This one does require you to edit config.php (ONCE), but let me repeat the above... Query Explain works, and like the debug info, it uses the Usergroup Permissions. As of the new version, no queries are added.

Known Issues:
none at this time

*** Changelog ***
As of Version 1.1.0:
- updated: reduced file edits
- updated: increased code efficiency

* This mod is offered for free here. Please donate if you like this mod *

[Jasem]

Nice work, thank you!

Installed

[Ziki]

You didn't have t add so much code,query explain works with just enabling the debug mode in config.php.

[thincom2000]

Except then everyone can see it. The point of this mod is to add Usergroup Permissions for it, not simply turn it on or off. This way, for example, you can have debug mode enabled all the time, but only your admins can see it. Additionally, the query explain is not available to any user who knows to add &explain=1 to the URL, because it still uses permissions there too. The debug table at the bottom of the page was also expanded to include some information that was left out of the default table.

[Ziki]

Not true ;),you can look at how my plugin works.

[thincom2000]

In truth this mod used to do it that way, but some of the output was missing on query explain (explain had not been active during datastore fetches etc). We had to turn it on earlier and use output handlers so as not to lose that info.

[Ziki]

Oh OK.

[Sunka]

Installed!
Thank you!

[Digital Jedi]

Just out of curiosity, is Debug Mode supposed to be on in the ACP all the time? I noticed it was active before I set any permissions and before I even switched it on in Options.

[thincom2000]

After you make the file edit, Debug Mode is on all the time. Once set, the permissions and options will modify this on the fly.

[Digital Jedi]

After you make the file edit, Debug Mode is on all the time. Once set, the permissions and options will modify this on the fly.
I mean in my Admin CP. It's stays on all the time in my Admin CP, whether it's on or off. It works correctly in the forum area, but the ACP doesn't change. Is that normal?

[Leo Brazil]

I've been using this mod for awhile but never tried explain (never needed) now I need to keep an eye on something on my board and noticed that explain doesn't work.

Everything works fine, permissions are set up correctly as well as config.php but when I click explain all I can get is a blank screen.

Any idea ?

[thincom2000]

A blank screen usually points to an error that has occurred, but your server is configured not to print the error message to the end user. Please check your server logs for any details.

Side note: I believe that explain doesn't work if vBSEO is installed. In its efforts to achieve link consensus, vBSEO 3.3.0 prevents some query strings from working correctly.

[Leo Brazil]

Hi thincom,

Yes, you're correct. I'm running with vBSEO 3.3.0. I susppected about this but you know, it's hard to confirm.

I was searching about this at vBSEO forums and strange is they have tons of users and I couldn't find any thread from someone complaining about this issue. Somebody should report this issue already.

Can someone here running together with vBSEO confirm this issue ?

[thincom2000]

I used to have similar problems with vBSEO, but since then I have made file edits to fix these issues, so I can't confirm as my memory can't recall the original issue I was having.

Try using the sorting functions in forum display and you will see another variation on this issue.

[Leo Brazil]

I've just opened a thread about this at vBSEO.com as I couldn't find any report about this over there. Let's see what they say.
If I come up with something new I will let people know about it here.

[Alfa1]

I am getting this to work in the ACP, but not in the forum.
vb 3.8.6

Here an excerpt of my config.php:
/*-------------------------------------------------------*\
| ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** |
+---------------------------------------------------------+
| If you get any errors while attempting to connect to |
| MySQL, you will need to email your webhost because we |
| cannot tell you the correct values for the variables |
| in this file. |
\*-------------------------------------------------------*/

$config['Misc']['debug'] = true;
// buffer db explain until permission fetch
if ($_REQUEST['explain'])
{
ob_start();
}
// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysql';

[thincom2000]

Did you set the Usergroup Permissions?
Check the mod's settings and add your IP address to the allow list.

[Alfa1]

The settings where correct. It took some time before it showed. Maybe a caching issue. Works great now.