vBulletin Mods

The Official vBulletin Modifications Site

Quick Database Check
by Andreas
24 Nov 2005 23:22

3 Attachment(s)
Quick Database Check

Many Hacks add data (tables, fields) to your database, and not all of them do hav e uninstall functions.
So after some time you may end up with a total mess, as you don't know what is standard and what not.

Then this tool is for you - it shows you which tables are non-standard, which fields have been added to standard tables.

Maybe planned features
  • Exact check of column definition
  • Check indexes
  • Check for non-standard settings, settinggroups, templates, phrase & phrasegroups
Please note: If you currently do have Hacks installed, it will report all their tables/fields as non-standard, as there is no way to determine which belong to installed Hacks.

Just "import" the product XML (import will not complete, so nothing is ever added to your DB or filesystem).

Version History
Initial Version

Added proper support for table prefixes
Changed field detaction a bit

Marco van Herwaarden 24 Nov 2005 23:47

Very nice and clean Kirby. Just a few questions that pop into my mind when i look at the xml:
- Will this not give a false positive if i for example activated full text search?
- Will it also detect missing tables/columns

Andreas 24 Nov 2005 23:55

No, as it currently does not check for missing tables/fields, only for added.
And if you enable FT, two tables will be dropped (postindex, word)

As said, this was just a quick shot as I was annoyed having to cleanup a DB manually ;)

michaelbenson 25 Nov 2005 00:01

Thanks for this hack, i have been getting aggrevated at the current state of my database.

Mike Gaidin 25 Nov 2005 00:10


/me clicks install.

Jenta 25 Nov 2005 01:03

Might want to alert people that they need to have install/mysql-schema.php uploaded. Many delete their install folder.

Andreas 25 Nov 2005 01:08

PHP alert's you if it is not there ;)

Jenta 25 Nov 2005 01:16

True. Just trying to have people not asking you about the error they will get.

Btw, nice. Found a couple of importid's I had missed.

RE: Maybe planned features.
Please do! :)

dieselpowered 25 Nov 2005 05:22

This is great...I do not mean to sound like a total fool, however, once you know what changes have been made, how do you revert them?

Thank you!!

BoYagoob 25 Nov 2005 06:08

I think it is useful

Thanks :)

Marco van Herwaarden 25 Nov 2005 09:08

Could it please be uploaded as a zip-file. XML-files tend to open in the browser, and will lead to many questions on how to save it. ;)

theArchitect 25 Nov 2005 09:33

Sensational work.

My database had ended up in such a mess that some major new hacks could not be installed, even though they worked fine on my unhacked test forum.

Alas, I had to use Impex and rebuild everything to fix it. But still glad you have released this.

Jenta 25 Nov 2005 09:45

Tip: Rename the file to product.xml. Upload it to includes/xml/.
Now you dont need to browse for the file each time. Just click Import in the Import Product page without having to type the filename.


OR import the XML file from your server ./includes/xml/product.xml

gothicuser 25 Nov 2005 09:56

Really nice one, many thanks

sensimilla 25 Nov 2005 10:09

Thanks Andreas it might be very usefull

All times are GMT. The time now is 19:04.

Powered by vBulletin® Version 3.8.13
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.