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

[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

Installation

FTP the compareutility.php file into your /admincp directory in ASCII mode.
Go to the following page with your browser: http://www.YOUR-DOMAIN.com/YOUR-FORUM-DIR/YOUR-ADMINCP-DIR/compareutility.php

UN-installation

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 (https://vborg.vbsupport.ru/showthread.php?t=235476)

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]

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

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.

[Hornstar]

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?

[gwerzal]

This is a great mod.

Will be very useful for one of my sites.

Thank you very much

[calorie]

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:

# replace vb3_ with your vB table prefix you set in the vB config file

ALTER TABLE vb3_holiday ADD varname VARCHAR(100) NOT NULL DEFAULT '';
ALTER TABLE vb3_holiday ADD INDEX varname (varname);
ALTER TABLE vb3_subscription ADD varname VARCHAR(100) NOT NULL DEFAULT '';

[Biker_GA]

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.

[ahmed-samara]

great .... thanks

[Magnumutz]

This sure is sweet for checking on your database for foreign tables :)
Another great job by Calorie!

[ahmed-samara]

well well well ..

my questions is if i have database error like if i drop some table from database i can't use yours file compareutility.php to chack or test ... so i prefer to test the file oursite of the logain to admincp

if we can use something like this link .

www.yoursitename.com/vb/compareutility.php

thanks again to support this file

[snowlion]

** never mind, i figured it out

[Thomas P]

Thanks for the Mod and the fix, great work.
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

[choccyclaire]

vBulletin should really detect it's own blog software and not view it as an addon.

[Floris]

Does this support 3.8.4 PL1 (please)

[Biker_GA]

Seems to work OK on my installation. :)

[Floris]

I want the product author to confirm that the changes between this version supporting and the new 3.8.4 PL1 are fine. :) before i change a db field that 3.8.4 requires to be different.

a product simply shouldn't be assumed to be forward compatible, and im not a sql developer.

:)

[Floris]

Btw, I have added it as suggestion in the vb security/audit product :)

[project-Buckfas]

Would like to see this upgraded to 3.8.4 or whatever is the last vb version before 4.0.

It would be nice to remove the crud I've been gathering from all the mods over the years

[ragtek]

Try it!

It should work!

[LCN2007]

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


X2 on this,

It would be great it if it auto removed all hacks/mods and associated tables that were not appart of the out of the box vbulletin.

[Spinball]

You are not authorized to execute SQL queries. You need to edit your vBulletin config.php file, replacing X with your user ID in the following line: $config['SpecialUsers']['canrunqueries'] = 'X';Despite it being set to my ID.

[Biker_GA]

Did you use your "numeric" ID?

[Spinball]

Did you use your "numeric" ID?

Yes, which is '1' as you would expect.

[0ptima]

Anyone get a "perfect score" on vb 3.8.4 pl 1? Seems like i am missing 2 fields....

[Alien]

I'd like to see this updated to work with the latest 3.8.4 PL1. I would really like to run this.

[ragtek]

As i understood, it should work with every vB version >3.5;)

[0ptima]

I'd like to see this updated to work with the latest 3.8.4 PL1. I would really like to run this.

Did you try running this on 3.8.4 PL1.?

[multiplex]

works fine on 3.8.4 thanks

[0ptima]

works fine on 3.8.4 thanks

Did you get a "perfect score" ? Im missing a couple of fields .....

[multiplex]

Did you get a "perfect score" ? Im missing a couple of fields .....

Which section are you referring to?

No differences were detected for the following

The out-of-the-box vBulletin tables that are not in the database

The out-of-the-box vBulletin fields that are not in the vBulletin tables

[0ptima]

im missing 2 from "The out-of-the-box vBulletin fields that are not in the vBulletin tables"

[TheLastSuperman]

We need this: https://vborg.vbsupport.ru/showthread.php?p=1949008#post1949008

AND THIS MOD all in one IMO ;)

I know Floris told me he was busy (via Twitter) but I would LOVE to see this merged in with his Security Audit Product!

Opinion Calorie?

- Mike

[MEdwards]

I see that this database checking script is specified for 3.8.1 -- I'm hoping to use it on a 3.8.4_PL-2 database -- Will it work OK? Any known issues with this?

Edit: Oops... Somehow I missed post #35 above -- OK, if this runs on 3.8.4_PL-2, I should be good to go!

Thanks,

[Floris]

We need this: https://vborg.vbsupport.ru/showthread.php?p=1949008#post1949008

AND THIS MOD all in one IMO ;)

I know Floris told me he was busy (via Twitter) but I would LOVE to see this merged in with his Security Audit Product!

Opinion Calorie?

- Mike

I would love to at least put this mod in the recommendation list.
Calorie and I could work together at merging our mod, if she wants.

[Doctor Death]

Any idea if this works with 4.0.1? Sounds like something very valuable for my instance.

[carpefile]

Just wanted to say thank you for such a very functional tool. Saved me untold amounts of time digging thru my incredibly mucked up db stripping out the chaff built up over the years from so many hacks uninstalled ages ago. Really a life saver. :)

[CvP]

really cool.
will it be updated for vB4?

[samiro]

i dont undesrstand
this will delete all the addons and plugins tables ?

[edward hamilton]

For what it's worth, I just ran this on vB 4.0.1 and detected a few tables I've added to the db and a few from old mods like googlemapme. I wish uninstalls would actually uninstall.

[edward hamilton]

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.

I get an Invalid File Specified error in vB 4.0.1 but I'm going to take the time to figure this out, it is very useful.

[AzzidReign]

This is what I get, can someone tell me what I need to do?

The out-of-the-box vBulletin fields that are not in the vBulletin tables
holiday:
varname

subscription:
varname

[Alfa1]

Works great. Thank you!

Now if only it where possible to track which addons table and fields come from.

[viper357]

Thanks for this, but.....Question

Now that I have identified tables and fields from old uninstalled hacks, how do I delete them, do I just go into phpmyadmin and delete from there?

[Alfa1]

How did you go about finding which hacks tables belong to?

Too bad that this modification does not identify vbulletin blog and project tools tables, as default tables.

[yotsume]

Can be useful at times. Thanks!

[viper357]

How did you go about finding which hacks tables belong to?
Pure luck mostly, some of them were obvious as they had decent names which identified them to the hack that they belonged to, some of them I had to google and search for on vb.org, but yeah, most of them I haven't got a clue about, I just did the obvious ones.

[viper357]

It would be nice if each coder listed the tables and fields that his/her hack creates when it is installed.

[Alfa1]

It would be nice if each coder listed the tables and fields that his/her hack creates when it is installed.
Yes, i think that should be mandatory on vb.org. I have tables that have such generic names, that its difficult to find out anything.