vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   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=209890)

calorie 03-29-2009 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
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.

RTMdotORG 03-30-2009 06:42 PM
i see what it does, but what are the positives?

maasland 03-30-2009 06:44 PM
After mucking about a simple check to see what's left behind and ought to be removed, how sweet! Thank you...

ragtek 03-30-2009 06:54 PM
It would be realy cool, if you could delete automaticaly all added tables & fields.

Lynne 03-30-2009 07:00 PM
Quote:
Originally Posted by RTMdotORG (Post 1780531)
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 (Post 1780539)
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.

ragtek 03-30-2009 07:17 PM
Quote:
Originally Posted by Lynne (Post 1780547)
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:)

Jasem 03-30-2009 08:10 PM
Good work, thank you!

Installed

Itworx4me 03-31-2009 12:54 AM
Just what I have been looking for...Thanks Calorie

AzzidReign 03-31-2009 03:21 AM
Wow, just what I've been looking for for a while! Been too lazy to do it manually.

veenuisthebest 03-31-2009 03:29 AM
1 Attachment(s)
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.

Hornstar 03-31-2009 09:19 AM
The out-of-the-box vBulletin fields that are not in the vBulletin tables: vb3_holiday - varname and vb3_subscription - varname

Is this bad? what should I do?

gwerzal 03-31-2009 01:29 PM
This is a great mod.

Will be very useful for one of my sites.

Thank you very much

calorie 03-31-2009 01:36 PM
It seems that for upgrades the varname field wasn't added to the vB holiday and subscription tables though it doesn't appear to cause problems. For those getting reports about the missing varname field in the vB holiday and subscription tables in your database, run the following queries to add varname to the tables:
Code:
# replace vb3_ with your vB table prefix you set in the vB config file

ALTER TABLE vb3_holiday ADD varname VARCHAR(100) NOT NULL DEFAULT '';
ALTER TABLE vb3_holiday ADD INDEX varname (varname);
ALTER TABLE vb3_subscription ADD varname VARCHAR(100) NOT NULL DEFAULT '';

Biker_GA 03-31-2009 01:44 PM
Quote:
Originally Posted by ragtek (Post 1780539)
It would be realy cool, if you could delete automaticaly all added tables & fields.
I'll second that one! I've spent hours going through each table trying to find the cause of a recent issue. I ended up blowing off the installation and reinstalling. This would have been a live saver at the time, especially if it would allow me to remove the offending tables/fields.

ahmed-samara 04-01-2009 04:28 PM
great .... thanks

Magnumutz 04-02-2009 07:55 AM
This sure is sweet for checking on your database for foreign tables :)
Another great job by Calorie!

ahmed-samara 04-02-2009 11:20 AM
well well well ..

my questions is if i have database error like if i drop some table from database i can't use yours file compareutility.php to chack or test ... so i prefer to test the file oursite of the logain to admincp

if we can use something like this link .

www.yoursitename.com/vb/compareutility.php

thanks again to support this file

snowlion 05-05-2009 11:15 AM
** never mind, i figured it out

Thomas P 06-19-2009 09:10 PM
Thanks for the Mod and the fix, great work.
Quote:
Originally Posted by calorie (Post 1781067)
It seems that for upgrades the varname field wasn't added to the vB holiday and subscription tables though it doesn't appear to cause problems. For those getting reports about the missing varname field in the vB holiday and subscription tables in your database, run the following queries to add varname to the tables

choccyclaire 09-16-2009 03:15 PM
vBulletin should really detect it's own blog software and not view it as an addon.

Floris 10-15-2009 09:38 AM
Does this support 3.8.4 PL1 (please)

Biker_GA 10-16-2009 11:14 AM
Seems to work OK on my installation. :)

Floris 10-18-2009 08:26 AM
I want the product author to confirm that the changes between this version supporting and the new 3.8.4 PL1 are fine. :) before i change a db field that 3.8.4 requires to be different.

a product simply shouldn't be assumed to be forward compatible, and im not a sql developer.

:)

Floris 10-18-2009 08:53 AM
Btw, I have added it as suggestion in the vb security/audit product :)

project-Buckfas 11-07-2009 07:46 PM
Would like to see this upgraded to 3.8.4 or whatever is the last vb version before 4.0.

It would be nice to remove the crud I've been gathering from all the mods over the years

ragtek 11-08-2009 08:07 AM
Try it!

It should work!

LCN2007 12-01-2009 02:07 AM
Quote:
Originally Posted by ragtek (Post 1780539)
It would be realy cool, if you could delete automaticaly all added tables & fields.

X2 on this,

It would be great it if it auto removed all hacks/mods and associated tables that were not appart of the out of the box vbulletin.

Spinball 12-03-2009 12:29 PM
Quote:
You are not authorized to execute SQL queries. You need to edit your vBulletin config.php file, replacing X with your user ID in the following line: $config['SpecialUsers']['canrunqueries'] = 'X';
Despite it being set to my ID.

Biker_GA 12-03-2009 02:34 PM
Did you use your "numeric" ID?

Spinball 12-03-2009 02:43 PM
Quote:
Originally Posted by Biker_GA (Post 1924739)
Did you use your "numeric" ID?
Yes, which is '1' as you would expect.

0ptima 12-20-2009 02:37 AM
Anyone get a "perfect score" on vb 3.8.4 pl 1? Seems like i am missing 2 fields....

Alien 12-20-2009 07:39 PM
I'd like to see this updated to work with the latest 3.8.4 PL1. I would really like to run this.

ragtek 12-20-2009 07:47 PM
As i understood, it should work with every vB version >3.5;)

0ptima 12-20-2009 11:57 PM
Quote:
Originally Posted by Alien (Post 1934226)
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.?

multiplex 12-22-2009 04:47 AM
works fine on 3.8.4 thanks

0ptima 12-22-2009 07:29 PM
Quote:
Originally Posted by multiplex (Post 1935172)
works fine on 3.8.4 thanks
Did you get a "perfect score" ? Im missing a couple of fields .....

multiplex 12-22-2009 08:56 PM
Quote:
Originally Posted by 0ptima (Post 1935714)
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

0ptima 12-22-2009 10:36 PM
im missing 2 from "The out-of-the-box vBulletin fields that are not in the vBulletin tables"

TheLastSuperman 01-10-2010 03:26 PM
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

MEdwards 01-10-2010 05:00 PM
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,


All times are GMT. The time now is 02:10 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01365 seconds
  • Memory Usage 1,816KB
  • 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_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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