Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
Reload this Page Administrative and Maintenance Tools - Quick Database Check
FAQ Community Calendar Today's Posts Search

Reply
Page 2 of 5 1 2 34 Last »
 
Thread Tools
Quick Database Check Details »»
Quick Database Check
Version: 1.1.0, by Andreas Andreas is offline
Developer Last Online: Jan 2023 Show Printable Version Email this Page
Category: Administrative and Maintenance Tools - Version: 3.5.0 RC 2 Rating:
Released: 11-23-2005 Last Update: 01-25-2008 Installs: 70
Is in Beta Stage  
No support by the author.

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

File Type: zip dbcheck.zip (949 Bytes, 294 views)
File Type: zip dbcheck_1-1-0.zip (1,006 Bytes, 298 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 11-25-2005, 07:08 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #13  
Old 11-25-2005, 07:33 AM
theArchitect's Avatar
theArchitect theArchitect is offline
 
Join Date: Sep 2004
Location: Sydney
Posts: 417
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
  #14  
Old 11-25-2005, 07:45 AM
Jenta Jenta is offline
 
Join Date: Dec 2004
Posts: 377
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.

Quote:
OR import the XML file from your server ./includes/xml/product.xml
Reply With Quote
  #15  
Old 11-25-2005, 07:56 AM
gothicuser's Avatar
gothicuser gothicuser is offline
 
Join Date: Apr 2004
Location: Kernow, Nr. UK
Posts: 468
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Really nice one, many thanks
Reply With Quote
  #16  
Old 11-25-2005, 08:09 AM
sensimilla sensimilla is offline
 
Join Date: Dec 2004
Location: Poland
Posts: 555
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks Andreas it might be very usefull
Reply With Quote
  #17  
Old 11-25-2005, 08:13 AM
reteep reteep is offline
 
Join Date: Mar 2004
Location: Germany
Posts: 164
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Very nice!
Reply With Quote
  #18  
Old 11-25-2005, 09:07 AM
uae's Avatar
uae uae is offline
 
Join Date: Jul 2002
Location: Irvine, California
Posts: 312
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks for sharing Andreas.
Reply With Quote
  #19  
Old 11-25-2005, 10:46 AM
Flow Fusion Flow Fusion is offline
 
Join Date: Jul 2003
Location: Georgia
Posts: 512
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
thanks.
Reply With Quote
  #20  
Old 11-25-2005, 11:49 AM
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Posts: 3,832
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thank you!
Reply With Quote
  #21  
Old 11-25-2005, 11:50 AM
MThornback MThornback is offline
 
Join Date: Apr 2005
Location: Canada
Posts: 388
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This is absolutly fantastic I has so many tables carry over from my upgrade that I can finally sort through easily! Thanks so much!

*Clicks Install
Reply With Quote
Reply
Page 2 of 5 1 2 34 Last »

« Previous Thread | Next Thread »

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


All times are GMT. The time now is 11:39 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05348 seconds
  • Memory Usage 2,322KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (2)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete