Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin Details »»
Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin
Mod Version: 1.0.1, by calorie (Coder/Designer) calorie is offline
Developer Last Online: Jun 2013 I like it Show Printable Version Email this Page

vB Version: 3.8.1 Rating: (5 votes - 5.00 average) Installs: 91
Released: 30 Mar 2009 Last Update: 30 Mar 2009 Downloads: 745
Not Supported Additional Files  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools Utility to update pmtotal and pmunread in user table Quarterbore vBulletin 3.6 Add-ons 24 27 Feb 2007 01:06

Comments
  #2  
Old 30 Mar 2009, 19:42
RTMdotORG RTMdotORG is offline
 
Join Date: Dec 2008
i see what it does, but what are the positives?
Reply With Quote
  #3  
Old 30 Mar 2009, 19:44
maasland's Avatar
maasland maasland is offline
 
Join Date: Apr 2008
After mucking about a simple check to see what's left behind and ought to be removed, how sweet! Thank you...
Reply With Quote
  #4  
Old 30 Mar 2009, 19:54
ragtek's Avatar
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
It would be realy cool, if you could delete automaticaly all added tables & fields.
__________________
my addons: http://ragtek.github.com
Reply With Quote
  #5  
Old 30 Mar 2009, 20:00
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by RTMdotORG View Post
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 View Post
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.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 30 Mar 2009, 20:17
ragtek's Avatar
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
Originally Posted by Lynne View Post
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
__________________
my addons: http://ragtek.github.com
Reply With Quote
  #7  
Old 30 Mar 2009, 21:10
Jasem's Avatar
Jasem Jasem is offline
 
Join Date: Feb 2006
Location: www.menokia.com
Good work, thank you!

Installed
__________________
games
Forum Nokia
Reply With Quote
  #8  
Old 31 Mar 2009, 01:54
Itworx4me's Avatar
Itworx4me Itworx4me is offline
 
Join Date: Feb 2002
Just what I have been looking for...Thanks Calorie
Reply With Quote
  #9  
Old 31 Mar 2009, 04:21
AzzidReign's Avatar
AzzidReign AzzidReign is offline
 
Join Date: Apr 2006
Wow, just what I've been looking for for a while! Been too lazy to do it manually.
__________________
Xbox 360 Mods
Reply With Quote
  #10  
Old 31 Mar 2009, 04:29
veenuisthebest's Avatar
veenuisthebest veenuisthebest is offline
 
Join Date: Mar 2008
Real name: Vinayak
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
File Type: xml cpnav_compare_db.xml (325 Bytes, 129 views)
Reply With Quote
  #11  
Old 31 Mar 2009, 10:19
Hornstar's Avatar
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Real name: Matt
The out-of-the-box vBulletin fields that are not in the vBulletin tables: vb3_holiday - varname and vb3_subscription - varname

Is this bad? what should I do?
Reply With Quote
  #12  
Old 31 Mar 2009, 14:29
gwerzal's Avatar
gwerzal gwerzal is offline
 
Join Date: Oct 2007
This is a great mod.

Will be very useful for one of my sites.

Thank you very much
Reply With Quote
  #13  
Old 31 Mar 2009, 14:36
calorie calorie is offline
 
Join Date: May 2003
It seems that for upgrades the varname field wasn't added to the vB holiday and subscription tables though it doesn't appear to cause problems. For those getting reports about the missing varname field in the vB holiday and subscription tables in your database, run the following queries to add varname to the tables:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #14  
Old 31 Mar 2009, 14:44
Biker_GA Biker_GA is offline
 
Join Date: Oct 2004
Originally Posted by ragtek View Post
It would be realy cool, if you could delete automaticaly all added tables & fields.
I'll second that one! I've spent hours going through each table trying to find the cause of a recent issue. I ended up blowing off the installation and reinstalling. This would have been a live saver at the time, especially if it would allow me to remove the offending tables/fields.
Reply With Quote
  #15  
Old 01 Apr 2009, 17:28
ahmed-samara's Avatar
ahmed-samara ahmed-samara is offline
 
Join Date: Dec 2004
Real name: Ahmed Mohamed
great .... thanks
__________________
Please don't PM me , Send request or enquiry to the Forum

support vBulletin Arabic, vBulletin Manual , vBulletin API

Last edited by ahmed-samara; 01 Apr 2009 at 21:01.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 11:22.

Layout Options | Width: Wide Color: