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
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
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
  #32  
Old 12-20-2009, 02:37 AM
0ptima 0ptima is offline
 
Join Date: Feb 2002
Posts: 346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Anyone get a "perfect score" on vb 3.8.4 pl 1? Seems like i am missing 2 fields....
Reply With Quote
  #33  
Old 12-20-2009, 07:39 PM
Alien's Avatar
Alien Alien is offline
 
Join Date: Oct 2001
Posts: 827
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd like to see this updated to work with the latest 3.8.4 PL1. I would really like to run this.
Reply With Quote
  #34  
Old 12-20-2009, 07:47 PM
ragtek ragtek is offline
 
Join Date: Mar 2006
Location: austria, croatia
Posts: 1,630
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

As i understood, it should work with every vB version >3.5
Reply With Quote
  #35  
Old 12-20-2009, 11:57 PM
0ptima 0ptima is offline
 
Join Date: Feb 2002
Posts: 346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Alien View Post
I'd like to see this updated to work with the latest 3.8.4 PL1. I would really like to run this.
Did you try running this on 3.8.4 PL1.?
Reply With Quote
  #36  
Old 12-22-2009, 04:47 AM
multiplex multiplex is offline
 
Join Date: Jun 2009
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

works fine on 3.8.4 thanks
Reply With Quote
  #37  
Old 12-22-2009, 07:29 PM
0ptima 0ptima is offline
 
Join Date: Feb 2002
Posts: 346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by multiplex View Post
works fine on 3.8.4 thanks
Did you get a "perfect score" ? Im missing a couple of fields .....
Reply With Quote
  #38  
Old 12-22-2009, 08:56 PM
multiplex multiplex is offline
 
Join Date: Jun 2009
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by 0ptima View Post
Did you get a "perfect score" ? Im missing a couple of fields .....
Which section are you referring to?

No differences were detected for the following

The out-of-the-box vBulletin tables that are not in the database

The out-of-the-box vBulletin fields that are not in the vBulletin tables
Reply With Quote
  #39  
Old 12-22-2009, 10:36 PM
0ptima 0ptima is offline
 
Join Date: Feb 2002
Posts: 346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im missing 2 from "The out-of-the-box vBulletin fields that are not in the vBulletin tables"
Reply With Quote
  #40  
Old 01-10-2010, 03:26 PM
TheLastSuperman's Avatar
TheLastSuperman TheLastSuperman is offline
Senior Member
 
Join Date: Sep 2008
Location: North Carolina
Posts: 5,844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We need this: https://vborg.vbsupport.ru/showthrea...08#post1949008

AND THIS MOD all in one IMO

I know Floris told me he was busy (via Twitter) but I would LOVE to see this merged in with his Security Audit Product!

Opinion Calorie?

- Mike
Reply With Quote
  #41  
Old 01-10-2010, 05:00 PM
MEdwards MEdwards is offline
 
Join Date: Mar 2005
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I see that this database checking script is specified for 3.8.1 -- I'm hoping to use it on a 3.8.4_PL-2 database -- Will it work OK? Any known issues with this?

Edit: Oops... Somehow I missed post #35 above -- OK, if this runs on 3.8.4_PL-2, I should be good to go!

Thanks,
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 07:13 PM.


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.09454 seconds
  • Memory Usage 2,325KB
  • 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
  • (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
  • (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
  • (1)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