Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases

Reply
 
Thread Tools
vBulletin Merge Tool for v2.2.x Details »»
vBulletin Merge Tool for v2.2.x
Version: 1.00, by JulianD JulianD is offline
Developer Last Online: Sep 2018 Show Printable Version Email this Page

Version: 2.3.x Rating:
Released: 11-17-2002 Last Update: Never Installs: 69
Is in Beta Stage  
No support by the author.

Well, I did this for a friend and I saw some request for this tool before, so here you got.

My code is based on the import scripts that you found on vbulletin.com.

What it does?
- Merge: users, forums, threads, posts, polls, PMs and attachments of two vBulletin databases.
- It allows to associate usernames with current vBulletin users, to prevent duplication

Both databases should be in the same server, and use the same password.

If there's a duplicated name in both databases, the script will postfix the username from the database you're merging with something like: [imported]. So you probably will find users that looks like username[imported] after the merge. To solve this problem of two usernames being one person, there's a tool in the script to merge users individually.

New version
- The database to merge can now have a different host/username/password. *
- Ability to auto merge users with the same username (to avoid 4000 users with the [imported] thing. ) *
- You can now skip the forum merging, and use the tool only to merge users.
- The poll bug seems to be fixed now. Post your feedback.


Installation:

Simply upload the attached file to /forum/importers/ and go to your Admin CP > BB Import Systems and choose vBulletin Merge Tool for v2.2.x.

Note that this script requires vBulletin 2.2.7 (or newer) to work. I have tested it with 2.2.6 but you need to upgrade the file /forum/admin/bbimport.php to the version you found on vBulletin 2.2.7 or newer.



Important Information:
This merger is beta! You should backup everything before starting. Use it under your own risk!


I decided to reopen this thread with a new version of this merger. I hope it fixes all the problems with previous versions.

REMEMBER:

If you're going to merge two database that are located on the same host, you SHOULD use a different hostname for both database.

For example:

If you have 'localhost' configured as your $servername variable on the admin/config.php file, and you want to merge a database stored on the same server, you should use something like '127.0.0.1'. Another example... If you have $servername configured to 'vbulletin.org', and you want to merge a database located on vbulletin.org, use the IP address for that server instead... In this case '205.214.66.221'. Get it?

Sorry, I'm not very good with english and it's very hard to explain this. I hope you've understood this.

Show Your Support

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

Comments
  #32  
Old 11-21-2002, 07:32 PM
Mr L Mr L is offline
 
Join Date: Jan 2002
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have just used this in a live setup. Merging a sister forum to the one that I currently have. The seconary forum only had about 600 users and 8000 posts compared to the current one that had 80000 odd posts.

The results, 100% perfect.

The user merger is a God send with multiple ID's.

I cannot rate this hack high enough 10/10.
Reply With Quote
  #33  
Old 11-22-2002, 02:14 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm glad to hear that.

Right now, the script is in beta, so please, check your forums... Currently, there seems to be a bug with the poll merger.

I have reproduced the problem in my localhost forums, and I'm hunting for the bug right now!
Reply With Quote
  #34  
Old 11-22-2002, 11:52 AM
kmfdm_kid2000's Avatar
kmfdm_kid2000 kmfdm_kid2000 is offline
 
Join Date: Mar 2002
Location: Where Towers Crumble (NYC)
Posts: 89
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Storm
[B]He was my co-admin way back, he recently got upset with me and left the forum to start his own, now he's going to merge my old database with his current one...
Actually, you unfairly De-Admined me, and that's when all of the users saw that and crossed over...Now they can get back all that they worked for...But let's not get into that here, I just wanted to clear the air, since you love to lie...

Quote:
I'm not 100% sure how this hack works, but if it can do this, you can count on trouble...
Hopefully it DOES work...It's our intellectual Property, WE wrote it, your stuff's gonna just get deleted...

Anyway...

I applaud you for this hack...You've done us a great service in gaining back our lost history...I thank you, and my community thanks you...We worked hard for those posts, only to have that guy take it all away from us in the end...He's upset because we started a new site, and abandoned his...I will be implimenting this hack soon, and I'll let you know how it goes...Considering I paid for part of the old license, and none of his intellectual property will be carried over, I think whatever transpires will be nothing illegal...

He didn't post that stuff, WE did...Nothing in the License agreement states anything against any of this, and most of the old stuff is just going into archives anyway...

Ahhh, to relive the good ol' days once again
Reply With Quote
  #35  
Old 11-22-2002, 12:44 PM
ModshackUK ModshackUK is offline
 
Join Date: Jun 2002
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actualy the posts remain the property of the site and its owner so if you do decide to merge his database into yours then you are breaking the copyright laws, and I would recomend he takes it to a court to sort out.

I had this a while back and was advised I had grounds to take legal action against the person(s) who did it. the site in question was imediately removed from the server it was hosted on.

The domain name owner provides the site on the understanding that all the content of the site is the property of him regardless of who posted it.

You were just an admin and not holding the position of owning the domain and so if you do this then he can simply contact your domain host and have your site removed for theft of content.

Its the same as me importing my posts from here into my own bulletin board, it just aint going to happen.

BTW you also import his members who may not want to go to your site, this also includes all thier PRIVATE MESSAGES as well as other personal info that they may not wish YOU to have access to. Each of them can activly prosecute you for theft of their intelectual property as the importer imports all the threads and members and does not distinguish them, this means that you have already done the dead before you delete them so the crime has already been commited.

By holding a copy of his database he has grounds enough there to prosecute you for unlawfull theft of his property.

So dont break out the champagne out yet m8

HM
Reply With Quote
  #36  
Old 11-22-2002, 03:58 PM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I had this situation about a year ago. About 1000 members on my site were from a UBB, before I converted to vBulletin. An admin of my site [who paid for neither the UBB, vB, hosting or domains] left the site in protest over banner ads, and when he later decided to return found he wasn't an admin, started threatening to start his own site with the UBB backup. He had no legal basis to stand on, not that I'm saying law and morality are always the same thing.
Reply With Quote
  #37  
Old 11-22-2002, 04:35 PM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Whoa installed this just now, excellent for merging users accounts. Thanks!
Reply With Quote
  #38  
Old 11-23-2002, 02:05 AM
FASherman's Avatar
FASherman FASherman is offline
 
Join Date: Aug 2002
Posts: 289
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do the two database schemas have to be identical?

For instance, a highly hacked production forum with extra fields in tables and a plain, unhacked out-of-the-box test forum. How does this util handle that situation, if it does at all?
Reply With Quote
  #39  
Old 11-23-2002, 02:17 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I haven't tested it with hacked databases, but it should work fine.

Let me know if you have any problem running the script with hacked databases.
Reply With Quote
  #40  
Old 11-23-2002, 08:48 AM
Mr L Mr L is offline
 
Join Date: Jan 2002
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by FASherman
Do the two database schemas have to be identical?

For instance, a highly hacked production forum with extra fields in tables and a plain, unhacked out-of-the-box test forum. How does this util handle that situation, if it does at all?
I can answer this one...

The database I merged with a hacked one, but with different hacks then the destinaton database. It was also a couple of revisions of vBulletin earlier.

I merged it into a hacked database as well. As an example, not active as I have removed the PHP, the database they were merged into had stuff like the Quiz and the Store installed. They also have the Awards installed and the user accounts that were merged worked fine with the active destination accounts that were award enabled.

Harvey.
Reply With Quote
  #41  
Old 11-23-2002, 10:33 AM
FASherman's Avatar
FASherman FASherman is offline
 
Join Date: Aug 2002
Posts: 289
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your answer would seem to indicate it works, but how? Does it drop the extra fields when populating the target database? And if the target has extra fields itself, does it populate them based on the field default values?
Reply With Quote
Reply

Thread Tools

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 09:33 AM.


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.06379 seconds
  • Memory Usage 2,305KB
  • Queries Executed 25 (?)
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
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete