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 4 of 5 « First 23 4 5
 
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
  #32  
Old 01-26-2008, 05:37 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
  #33  
Old 01-27-2008, 03:54 PM
Chicago_VLNU_4s Chicago_VLNU_4s is offline
 
Join Date: Mar 2006
Location: Chicago
Posts: 453
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
could be useful, I'll check it out later
Reply With Quote
  #34  
Old 01-27-2008, 06:15 PM
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Location: Germany, Berlin
Posts: 331
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Hi

The progress indicator never ends (tested with 3.7.0ß4). Is that correct?

Regards,

Stoebi
Reply With Quote
  #35  
Old 01-28-2008, 05:12 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yeah - if your DB is unmodifed.
I'll add a message for that case when time permits.
Reply With Quote
  #36  
Old 01-29-2008, 05:42 AM
Stoebi Stoebi is offline
 
Join Date: Apr 2006
Location: Germany, Berlin
Posts: 331
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Sorry Andreas,

my db is modified. Thanks for your answer


Regards,

Stoebi
Attached Images
File Type: jpg db1.jpg (91.4 KB, 0 views)
Reply With Quote
  #37  
Old 02-18-2008, 09:12 AM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I guess a print_dots_stop() wouldn't hurt ...
Reply With Quote
  #38  
Old 05-05-2008, 06:55 PM
red_head red_head is offline
 
Join Date: Aug 2004
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
  #39  
Old 06-14-2009, 02:22 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
The schema (install/mysql-schema.php) is not in place - this file is needed.
Reply With Quote
  #40  
Old 10-26-2009, 01:52 AM
need2fart need2fart is offline
 
Join Date: Aug 2009
Posts: 152
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
  #41  
Old 01-10-2010, 03:33 PM
Reinn Reinn is offline
 
Join Date: Jun 2009
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Will this work in vB 4? I'd really like something like this, thanks!
Reply With Quote
Reply
Page 4 of 5 « First 23 4 5

« 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:33 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.04659 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)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
  • (3)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