vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin (https://vborg.vbsupport.ru/showthread.php?t=235476)

calorie 02-09-2010 10:00 PM

Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin
 
1 Attachment(s)
What is it?

This utility makes a comparison between the tables and fields in your database and the out-of-the-box vBulletin tables and fields.

It reports the following differences:
  • The out-of-the-box vBulletin tables that are not in the database
  • The database tables that are not a part of out-of-the-box vBulletin
  • The out-of-the-box vBulletin fields that are not in the vBulletin tables
  • The fields that are in the vBulletin tables but not a part of out-of-the-box vBulletin
New Features
  • Ability to delete extraneous tables and fields from the compareutility.php file
    • Don't screw up your vBulletin database!
Installation
  1. FTP the compareutility.php file into your /admincp directory in ASCII mode.
  2. Go to the following page with your browser: http://www.YOUR-DOMAIN.com/YOUR-FORUM-DIR/YOUR-ADMINCP-DIR/compareutility.php
  3. You need to set the following to yes to access the compareutility.php file:
    • ACP -> Usergroups -> Administrator Permissions -> Edit Permissions -> Can Run Maintenance Tools
  4. To add a link to compareutility.php under the ACP -> Maintenance sidebar see this post.
UN-installation
  1. Delete the compareutility.php file from your server.
  2. Delete the cpnav_compare_db.xml from your server (from this post).
vBulletin version?
  • Only tested on vBulletin 4.0.0 PL1 and 4.0.1
  • May not work correctly on vBulletin 4.0.2
  • May work on vBulletin 3.5 and up
  • Won't work on less than vBulletin 3.5
  • The vB3 version is located here
Screenshot
  • None, run the script to see the report.

Hornstar 02-10-2010 09:29 AM

one of these days I should run this to help me clean up my database. I'm just a little worried that I will screw something major up or remove a field that is required by a hack.

Leo Brazil 02-10-2010 01:52 PM

Great Idea. Sometimes you remove a hack and always leave behide something on database. It's good to keep it clean.

Thank you

Edit: This should be default on vB just like the check files on maitenance menu.

Bouncer222 02-10-2010 02:49 PM

Isn't this part of the diagnostics feature? That feature does pretty much everything you posted here.

Wayne Luke 02-10-2010 04:56 PM

Quote:

Originally Posted by Bouncer222 (Post 1979161)
Isn't this part of the diagnostics feature? That feature does pretty much everything you posted here.

Actually, no. This isn't part of the default diagnostics in vBulletin. Personally, I wish it was as it would make my job easier but until then this works well enough.

AzzidReign 02-10-2010 05:15 PM

I'm going to be using this when I upgrade to 4.x. I never used your 3.8.x one but I'll be using this one! Thanks.

Zaiaku 02-11-2010 03:23 PM

Nice work. Tagging for future use for now then then into install.

Bram H 02-15-2010 09:56 AM

Would love to use this hack, as we have installed so many mods the last years. And i am sure it needs some cleaning.
But like Hornstar i am too frightened to mess something up badly :)

fly 02-15-2010 03:41 PM

It looks like there a genius coder that used a ' in his table names. it doesn't appear that your script likes those.

yaghoub 02-16-2010 12:51 PM

i install it but ant things not show in admincp for reviwe this hack going to ..adress


All times are GMT. The time now is 11:17 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.01031 seconds
  • Memory Usage 1,734KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete