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.

[Boofo]

Glad to here you got it fixed.

[Bram H]

Is this mod still fully updated to the latest vb specs?

[Bram H]

A bump as nothing has ever been posted since my last question

[avsunforum]

great mod thank you