Administrative and Maintenance Tools - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

What is it?

This utility makes a comparison between the tables and fields in your database and the out-of-the-box vBulletin tables and fields.

It reports the following differences:

• The out-of-the-box vBulletin tables that are not in the database
• The database tables that are not a part of out-of-the-box vBulletin
• The out-of-the-box vBulletin fields that are not in the vBulletin tables
• The fields that are in the vBulletin tables but not a part of out-of-the-box vBulletin

New Features

• Ability to delete extraneous tables and fields from the compareutility.php file
  • Don't screw up your vBulletin database!

Installation

1. FTP the compareutility.php file into your /admincp directory in ASCII mode.
2. Go to the following page with your browser: http://www.YOUR-DOMAIN.com/YOUR-FORUM-DIR/YOUR-ADMINCP-DIR/compareutility.php
3. You need to set the following to yes to access the compareutility.php file:
   • ACP -> Usergroups -> Administrator Permissions -> Edit Permissions -> Can Run Maintenance Tools
4. To add a link to compareutility.php under the ACP -> Maintenance sidebar see this post.

UN-installation

1. Delete the compareutility.php file from your server.
2. Delete the cpnav_compare_db.xml from your server (from this post).

vBulletin version?

• Only tested on vBulletin 4.0.0 PL1 and 4.0.1
• May not work correctly on vBulletin 4.0.2
• May work on vBulletin 3.5 and up
• Won't work on less than vBulletin 3.5
• The vB3 version is located here

Screenshot

• None, run the script to see the report.

[Hornstar]

one of these days I should run this to help me clean up my database. I'm just a little worried that I will screw something major up or remove a field that is required by a hack.

[Leo Brazil]

Great Idea. Sometimes you remove a hack and always leave behide something on database. It's good to keep it clean.

Thank you

Edit: This should be default on vB just like the check files on maitenance menu.

[Bouncer222]

Isn't this part of the diagnostics feature? That feature does pretty much everything you posted here.

[Wayne Luke]

Originally Posted by Bouncer222

Isn't this part of the diagnostics feature? That feature does pretty much everything you posted here.

Actually, no. This isn't part of the default diagnostics in vBulletin. Personally, I wish it was as it would make my job easier but until then this works well enough.

[AzzidReign]

I'm going to be using this when I upgrade to 4.x. I never used your 3.8.x one but I'll be using this one! Thanks.

[Zaiaku]

Nice work. Tagging for future use for now then then into install.

[Bram H]

Would love to use this hack, as we have installed so many mods the last years. And i am sure it needs some cleaning.
But like Hornstar i am too frightened to mess something up badly

[fly]

It looks like there a genius coder that used a ' in his table names. it doesn't appear that your script likes those.

[yaghoub]

i install it but ant things not show in admincp for reviwe this hack going to ..adress