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

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

UN-installation

1. Delete the compareutility.php file from your server.

vBulletin version?

• Only tested on vBulletin 3.8.1
• May work on vBulletin 3.5 and up
• Won't work on less than vBulletin 3.5
• The vB4 version is located here

Screenshot

• None, run the script to see the report.

[RTMdotORG]

i see what it does, but what are the positives?

[maasland]

After mucking about a simple check to see what's left behind and ought to be removed, how sweet! Thank you...

[ragtek]

It would be realy cool, if you could delete automaticaly all added tables & fields.

[Lynne]

Originally Posted by RTMdotORG

i see what it does, but what are the positives?

Could be useful when you are having database problems or coding and need to see if certain things are there. But, if the results don't mean anything to you, then you probably don't need this.

Originally Posted by ragtek

It would be realy cool, if you could delete automaticaly all added tables & fields.

Cool, but could be dangerous in the hands of someone who doesn't know what they are doing.

[ragtek]

Originally Posted by Lynne

Could be useful when you are having database problems or coding and need to see if certain things are there. But, if the results don't mean anything to you, then you probably don't need this.

Cool, but could be dangerous in the hands of someone who doesn't know what they are doing.

Yes sure, maybe with securitycheck(like enable function per fileedit) or something like this.
(thats the way i've coded some developer tools).
I've seen that the 0815 user don't edit the file because he don't know how^^

But its realy a very nice modification! thx

[Jasem]

Good work, thank you!

Installed

[Itworx4me]

Just what I have been looking for...Thanks Calorie

[AzzidReign]

Wow, just what I've been looking for for a while! Been too lazy to do it manually.

[veenuisthebest]

Nice one.

For those who'd like a link in admincp within Maintenance group, upload this file in includes/xml/ folder and refresh your admincp.