vBulletin LTS

Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin
Mod Version: 1.0.0, by calorie

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

   Spoiler (click to open)

   
   

   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.

   Attached Files

   cpnav_compare_db.xml (325 Bytes, 137 views)

   
   

   Close
   post.

UN-installation

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

   Spoiler (click to open)

   
   

   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.

   Attached Files

   cpnav_compare_db.xml (325 Bytes, 137 views)

   
   

   Close
   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.