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 5 of 6 « First 34 5 6
 
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
  #42  
Old 01-11-2010, 09:38 AM
Floris Floris is offline
 
Join Date: Jan 2002
Posts: 1,898
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by TheLastSuperman View Post
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
I would love to at least put this mod in the recommendation list.
Calorie and I could work together at merging our mod, if she wants.
Reply With Quote
  #43  
Old 01-13-2010, 03:31 PM
Doctor Death Doctor Death is offline
 
Join Date: Dec 2005
Posts: 449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Any idea if this works with 4.0.1? Sounds like something very valuable for my instance.
Reply With Quote
  #44  
Old 01-17-2010, 01:50 PM
carpefile carpefile is offline
 
Join Date: Jul 2004
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Just wanted to say thank you for such a very functional tool. Saved me untold amounts of time digging thru my incredibly mucked up db stripping out the chaff built up over the years from so many hacks uninstalled ages ago. Really a life saver.
Reply With Quote
  #45  
Old 01-17-2010, 04:38 PM
CvP's Avatar
CvP CvP is offline
 
Join Date: Aug 2006
Posts: 263
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
really cool.
will it be updated for vB4?
Reply With Quote
  #46  
Old 01-27-2010, 06:38 AM
samiro's Avatar
samiro samiro is offline
 
Join Date: Jan 2007
Posts: 136
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i dont undesrstand
this will delete all the addons and plugins tables ?
Reply With Quote
  #47  
Old 02-09-2010, 06:20 PM
edward hamilton edward hamilton is offline
 
Join Date: Mar 2007
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
For what it's worth, I just ran this on vB 4.0.1 and detected a few tables I've added to the db and a few from old mods like googlemapme. I wish uninstalls would actually uninstall.
Reply With Quote
  #48  
Old 02-09-2010, 06:50 PM
edward hamilton edward hamilton is offline
 
Join Date: Mar 2007
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by veenuisthebest View Post
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.
I get an Invalid File Specified error in vB 4.0.1 but I'm going to take the time to figure this out, it is very useful.
Reply With Quote
  #49  
Old 02-18-2010, 10:49 PM
AzzidReign's Avatar
AzzidReign AzzidReign is offline
 
Join Date: Apr 2006
Posts: 497
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This is what I get, can someone tell me what I need to do?

The out-of-the-box vBulletin fields that are not in the vBulletin tables
holiday:
varname

subscription:
varname
Reply With Quote
  #50  
Old 05-23-2010, 10:23 PM
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Location: Netherlands
Posts: 3,537
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Works great. Thank you!

Now if only it where possible to track which addons table and fields come from.
Reply With Quote
  #51  
Old 12-19-2010, 06:38 PM
viper357's Avatar
viper357 viper357 is offline
 
Join Date: Dec 2006
Location: Worthing, UK
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks for this, but.....Question

Now that I have identified tables and fields from old uninstalled hacks, how do I delete them, do I just go into phpmyadmin and delete from there?
Reply With Quote
Reply
Page 5 of 6 « First 34 5 6

« 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 07:46 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.10779 seconds
  • Memory Usage 2,329KB
  • 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
  • (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
  • (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