vBulletin Merge Tool for v2.2.x

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.

[-=dm=-]

hey Thanx man

Now I got a clean install of 2.2.9 and imported everything from 2.2.4 in no time

this is one of the best hack!!!!!

[drives fast]

yea....I am looking at the same situation....I have over 35,000 members and I want to merge another database that has say 26,000 and I know there are duplicates. I cannot do 355 pages of setting user ID's....can you make this auto associate by username and case matters?

I have no need for posts, threads and stuff like that.....just members.

also...what happens if there are members in special usergroups? on the two forums there are the same usergroups but they are different usergroup ID's

I know....can it import and auto associate by usergroup alone? because I really only need the people from one specific usergroup to merge into the other database.

[JulianD]

OK I have some free time today... I'll do the modification right now to the script, to allow you to merge users with the same username.

Now, if there are users in special usergroups, they will be set to the Registered usergroup. But it's easy to modify the script to add special usergroups I'll teach you how, if you wish.

[drives fast]

you are most kind...I would appreciate you teaching me how.

[94supratt]

Originally posted by JulianD


Ohhh sorry.... Now I understand you...

Unfortunately at this time it's not possible to merge two database without the same user and password. I'll try to release a new version with this ability for you guys.

I have 2 databases. One for my forum and one from a forum I am importing. I know the user names match for some users but I DO NOT know if the passwords do. Will this be a problem?

[JulianD]

If the passwords for both databases are different, yes... there will be a problem... Sorry, I don't have time right now to enhance this script i've been very busy with my site right now.

[94supratt]

Originally posted by JulianD
If the passwords for both databases are different, yes... there will be a problem... Sorry, I don't have time right now to enhance this script i've been very busy with my site right now.

When you say problem what exactly will happen if I try to merge and have users with different passwords?

[JulianD]

The problem is that the script will be unable to connect to your second database.... and will display an error screen.

[94supratt]

Originally posted by JulianD
The problem is that the script will be unable to connect to your second database.... and will display an error screen.

I think you may have misunderstood my question. The DATABASE PASSWORDS and USER are the SAME. Its my individual FORUM users that MAY have different passwords. Would that be an issue? Sorry for not being clear. If user passwords are not an issue then I am ready to merge

[JulianD]

Oh.. .Well.. for example if you have two users with the same username, and you associate them before merging, then the posts and PMs will be merged to the user in the actual forum.

If you don't associate the users, then for every duplicated user the script will rename the merged users to something like: username[imported].