Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
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
  #22  
Old 11-25-2005, 12:28 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is there like an "install but it really doesn't install" button I should click?
Reply With Quote
  #23  
Old 11-25-2005, 02:07 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Boofo
Is there like an "install but it really doesn't install" button I should click?
It is in the bottom of his post.
Reply With Quote
  #24  
Old 11-25-2005, 02:09 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

LOL
Reply With Quote
  #25  
Old 11-25-2005, 07:44 PM
Man1c M0g's Avatar
Man1c M0g Man1c M0g is offline
 
Join Date: Jan 2004
Location: Portsmouth, UK.
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Extremely useful! Many thanks for this hack!
Reply With Quote
  #26  
Old 11-25-2005, 07:56 PM
Ben5150 Ben5150 is offline
 
Join Date: Jan 2005
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

great item but when does this stop working the ] keeps moving lol
Reply With Quote
  #27  
Old 11-25-2005, 08:12 PM
Jenta Jenta is offline
 
Join Date: Dec 2004
Posts: 377
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

never, it doesnt really install
Quote:
Usage
Just "import" the product XML (import will not complete, so nothing is ever added to your DB or filesystem).
Reply With Quote
  #28  
Old 11-26-2005, 01:05 AM
Moparx Moparx is offline
 
Join Date: Jul 2004
Posts: 120
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great work as always Andreas
It will be even greater when you get around to including the additional planned features
Reply With Quote
  #29  
Old 11-26-2005, 01:10 AM
bigmonay2k bigmonay2k is offline
 
Join Date: May 2004
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

damn, it sound good
Reply With Quote
  #30  
Old 02-14-2006, 10:55 AM
David_R David_R is offline
 
Join Date: Mar 2005
Location: Los Angeles
Posts: 212
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get following results:

The following tables seem to be non-standard
All the tables of my forum

The following tables seem to be modified
O_customavatar
avatardata
O_customprofilepic
profilepicdata
O_post
isusenetpost
msgid
ref
editlevel

vBulletin v3.5.3, Copyright ?2000-2006
Reply With Quote
  #31  
Old 03-11-2007, 04:28 PM
bashy bashy is offline
 
Join Date: Nov 2005
Posts: 2,544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

a long shot but, any chance this could be made to work on 3.6 please?
When i try to install it just says please wait and hangs there
Reply With Quote
Reply


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:51 AM.


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.09112 seconds
  • Memory Usage 2,326KB
  • 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
  • (2)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
  • (4)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