Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
Reload this Page Administrative and Maintenance Tools - Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 6 1 23 Last »
 
Thread Tools
Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin Details »»
Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin
MOD Information
The Developer
 
Version: 1.0.1, by calorie calorie is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page
Category: Administrative and Maintenance Tools - Version: 3.8.1 Rating:
Released: 03-29-2009 Last Update: 03-29-2009 Installs: 96
Additional Files  
No support by the author.

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
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
UN-installation
  1. Delete the compareutility.php file from your server.
vBulletin version?
  • Only tested on vBulletin 3.8.1
  • May work on vBulletin 3.5 and up
  • Won't work on less than vBulletin 3.5
  • The vB4 version is located here
Screenshot
  • None, run the script to see the report.

Download Now

File Type: zip compareutility.zip (3.7 KB, 696 views)

Show Your Support

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

Comments
  #2  
Old 03-30-2009, 06:42 PM
RTMdotORG RTMdotORG is offline
 
Join Date: Dec 2008
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i see what it does, but what are the positives?
Reply With Quote
  #3  
Old 03-30-2009, 06:44 PM
maasland's Avatar
maasland maasland is offline
 
Join Date: Apr 2008
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
After mucking about a simple check to see what's left behind and ought to be removed, how sweet! Thank you...
Reply With Quote
  #4  
Old 03-30-2009, 06:54 PM
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
Posts: 1,630
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It would be realy cool, if you could delete automaticaly all added tables & fields.
Reply With Quote
  #5  
Old 03-30-2009, 07:00 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by RTMdotORG View Post
i see what it does, but what are the positives?
Could be useful when you are having database problems or coding and need to see if certain things are there. But, if the results don't mean anything to you, then you probably don't need this.
Quote:
Originally Posted by ragtek View Post
It would be realy cool, if you could delete automaticaly all added tables & fields.
Cool, but could be dangerous in the hands of someone who doesn't know what they are doing.
Reply With Quote
  #6  
Old 03-30-2009, 07:17 PM
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
Posts: 1,630
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Lynne View Post
Could be useful when you are having database problems or coding and need to see if certain things are there. But, if the results don't mean anything to you, then you probably don't need this.

Cool, but could be dangerous in the hands of someone who doesn't know what they are doing.
Yes sure, maybe with securitycheck(like enable function per fileedit) or something like this.
(thats the way i've coded some developer tools).
I've seen that the 0815 user don't edit the file because he don't know how^^

But its realy a very nice modification! thx
Reply With Quote
  #7  
Old 03-30-2009, 08:10 PM
Jasem's Avatar
Jasem Jasem is offline
 
Join Date: Feb 2006
Location: www.menokia.com
Posts: 594
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Good work, thank you!

Installed
Reply With Quote
  #8  
Old 03-31-2009, 12:54 AM
Itworx4me's Avatar
Itworx4me Itworx4me is offline
 
Join Date: Feb 2002
Posts: 210
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Just what I have been looking for...Thanks Calorie
Reply With Quote
  #9  
Old 03-31-2009, 03:21 AM
AzzidReign's Avatar
AzzidReign AzzidReign is offline
 
Join Date: Apr 2006
Posts: 497
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Wow, just what I've been looking for for a while! Been too lazy to do it manually.
Reply With Quote
  #10  
Old 03-31-2009, 03:29 AM
veenuisthebest's Avatar
veenuisthebest veenuisthebest is offline
 
Join Date: Mar 2008
Location: India
Posts: 1,416
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice one.

For those who'd like a link in admincp within Maintenance group, upload this file in includes/xml/ folder and refresh your admincp.
Attached Files
File Type: xml cpnav_compare_db.xml (325 Bytes, 136 views)
Reply With Quote
Reply
Page 1 of 6 1 23 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 01:31 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05188 seconds
  • Memory Usage 2,322KB
  • Queries Executed 24 (?)
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
  • (3)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
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (2)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)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