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: Mar 2019 I like it Show Printable Version Email this Page

vB Version: 3.5.0 RC 2 Rating: (1 vote - 5.00 average) Installs: 67
Released: 24 Nov 2005 Last Update: 26 Jan 2008 Downloads: 347
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.
  #31  
Old 26 Jan 2008, 18:37
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
Time for an update ^. ^

@bashy
It works just fine with all 3.5.X, 3.6.X and current 3.7 betas as well.
If you don't get any output, no changes were detected.
Reply With Quote
  #32  
Old 27 Jan 2008, 16:54
Chicago_VLNU_4s Chicago_VLNU_4s is offline
 
Join Date: Mar 2006
Location: Chicago
Real name: Moreno 4
could be useful, I'll check it out later
Reply With Quote
  #33  
Old 27 Jan 2008, 19:15
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Real name: Peter
Hi

The progress indicator never ends (tested with 3.7.04). Is that correct?


Regards,

Stoebi
Reply With Quote
  #34  
Old 28 Jan 2008, 18:12
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
Yeah - if your DB is unmodifed.
I'll add a message for that case when time permits.
Reply With Quote
  #35  
Old 29 Jan 2008, 06:42
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Real name: Peter
Sorry Andreas,

my db is modified. Thanks for your answer


Regards,

Stoebi
Attached Images
File Type: jpg db1.jpg (91.4 KB, 90 views)
Reply With Quote
  #36  
Old 18 Feb 2008, 10:12
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
I guess a print_dots_stop() wouldn't hurt ...
Reply With Quote
  #37  
Old 05 May 2008, 19:55
red_head red_head is offline
 
Join Date: Aug 2004
When i import the product i become the follow error:

Warnung: require_once([path]/install/mysql-schema.php) [function.require-once]: failed to open stream: Permission denied in [path]/admincp/plugin.php(1977) : eval()'d code (Zeile 1)

Fatal error: require_once() [function.require]: Failed opening required '/home/arynar/html/install/mysql-schema.php' (include_path='.:/usr/share/php:/usr/share/pear') in /home/arynar/html/admincp/plugin.php(1977) : eval()'d code on line 1

i have controlled the file permissions.
installed vB is 3.7.0
Reply With Quote
  #38  
Old 14 Jun 2009, 15:22
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
The schema (install/mysql-schema.php) is not in place - this file is needed.
Reply With Quote
  #39  
Old 26 Oct 2009, 02:52
need2fart need2fart is offline
 
Join Date: Aug 2009
So like, this will remove unwanted lines inside my DB? And is it safe to use on a vB 3.8.3 forum?

I have uninstalled a few products and stuff off my forum, and I was wondering if this would clean it up a bit. =)

Also nice hack by the read so far.
Reply With Quote
  #40  
Old 10 Jan 2010, 16:33
Reinn Reinn is offline
 
Join Date: Jun 2009
Will this work in vB 4? I'd really like something like this, thanks!
Reply With Quote
  #41  
Old 12 Jan 2010, 07:08
adivor's Avatar
adivor adivor is offline
 
Join Date: Sep 2007
I see this error...


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

Reply With Quote
  #42  
Old 14 Jan 2010, 13:56
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Real name: Sven
Originally Posted by adivor View Post
I see this error...


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Read post #38.
__________________
Please note that there will be no further updates to my addons, especially they will not be upgraded for vB5. I'm leaving vB, since IB choose to go the banana-way yet again.

http://www.roma-antiqua.de
Reply With Quote
  #43  
Old 22 May 2010, 17:06
Mutt's Avatar
Mutt Mutt is offline
 
Join Date: Nov 2001
i'd also like something like this for 4. I'm doing an upgrade to 4 but there's so much custom shit in my old DB. I need to clean that thing up
Reply With Quote
  #44  
Old 22 May 2010, 17:08
Mutt's Avatar
Mutt Mutt is offline
 
Join Date: Nov 2001
found it here for vb4
http://www.vbulletin.org/forum/showt...light=Database
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


New To Site? Need Help?

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

Layout Options | Width: Wide Color: