Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Quick Database Check Details »»
Quick Database Check
Mod Version: 1.1.0, by Andreas (Coder) Andreas is offline
Developer Last Online: Apr 2016 I like it Show Printable Version Email this Page

vB Version: 3.5.0 RC 2 Rating: (1 vote - 5.00 average) Installs: 66
Released: 24 Nov 2005 Last Update: 26 Jan 2008 Downloads: 329
Not Supported Is in Beta Stage  

Quick Database Check

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

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

Version History
1.0.0
Initial Version

1.1.0
Added proper support for table prefixes
Changed field detaction a bit

Download Now

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

Screenshots

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 24 Nov 2005, 22:47
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 24 Nov 2005, 22:55
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
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
Reply With Quote
  #4  
Old 24 Nov 2005, 23:01
michaelbenson's Avatar
michaelbenson michaelbenson is offline
 
Join Date: Feb 2005
Real name: Michael Benson
Thanks for this hack, i have been getting aggrevated at the current state of my database.
Reply With Quote
  #5  
Old 24 Nov 2005, 23:10
Mike Gaidin's Avatar
Mike Gaidin Mike Gaidin is offline
 
Join Date: Oct 2001
Real name: Mike
THANK YOU!!!!

/me clicks install.
Reply With Quote
  #6  
Old 25 Nov 2005, 00:03
Jenta Jenta is offline
 
Join Date: Dec 2004
Might want to alert people that they need to have install/mysql-schema.php uploaded. Many delete their install folder.
Reply With Quote
  #7  
Old 25 Nov 2005, 00:08
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
PHP alert's you if it is not there
Reply With Quote
  #8  
Old 25 Nov 2005, 00:16
Jenta Jenta is offline
 
Join Date: Dec 2004
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!
Reply With Quote
  #9  
Old 25 Nov 2005, 04:22
dieselpowered's Avatar
dieselpowered dieselpowered is offline
 
Join Date: Aug 2004
Location: Arizona
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!!
__________________
CommanderTalk.com --> www.commandertalk.com
Reply With Quote
  #10  
Old 25 Nov 2005, 05:08
BoYagoob BoYagoob is offline
 
Join Date: Feb 2005
I think it is useful

Thanks
Reply With Quote
  #11  
Old 25 Nov 2005, 08:08
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #12  
Old 25 Nov 2005, 08:33
theArchitect's Avatar
theArchitect theArchitect is offline
 
Join Date: Sep 2004
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.
Reply With Quote
  #13  
Old 25 Nov 2005, 08:45
Jenta Jenta is offline
 
Join Date: Dec 2004
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

Last edited by Jenta; 25 Nov 2005 at 08:48.
Reply With Quote
  #14  
Old 25 Nov 2005, 08:56
gothicuser's Avatar
gothicuser gothicuser is offline
 
Join Date: Apr 2004
Real name: Tony
Really nice one, many thanks
__________________
Grumpy and bad tempered. I'm a pensioner, so don't care any more
Reply With Quote
  #15  
Old 25 Nov 2005, 09:09
sensimilla sensimilla is offline
 
Join Date: Dec 2004
Real name: Eric Estrada
Thanks Andreas it might be very usefull
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 09:22.

Layout Options | Width: Wide Color: