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.

[JulianD]

Nice to hear that

[ManagerJosh]

This is superb! I think this will be made into an official import script sometime soon

[JohnWoo]

great work... I w8 this hack a long time.... Thanks one more...

[Marshalus]

OH SWEET MOTHER OF EVERYTHING HOLY!

Exactly what I've been needing for a long time.

[Marshalus]

Worked like a charm, the whole thing went off without a hitch.

Edit: The poll import is messed up, it doesn't apply to the right thread. Not a horrible thing, but kind of annoying.

[JulianD]

Originally posted by Marshalus
Worked like a charm, the whole thing went off without a hitch.

Edit: The poll import is messed up, it doesn't apply to the right thread. Not a horrible thing, but kind of annoying.

I'll take a look

[Dean C]

Looks awesome..

Excellent idea and its great at last that this has been done

Much credit to you sir

Touché

- miSt

[FleaBag]

Any luck on the polls front?

[JulianD]

I'll work on the polls tonight.... I only have two databases, one of 16MB and another of 60MB..... I'll try to play with both databases and see how the polls are merged.....

[hypedave]

I cant believe this was to easy to run. I have been trying to write something like this for almost a year now, only thing I came close to was user to user merge. Great job you have done man,