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.

[zajako]

it seems the database i told it in the merdge script got my current db cloned to it.. It totaly confused me. I might have to look at the code to see whats up, but correct me if im wrong. The database name i specify in the merdge script is the database i want to copy to that current forums.

also i don't have access to my php ini file to disable magic quotes. is there a way to de-activate it via php coding?

[Marshalus]

Does having MySQL 4 have anything to do with this script not working? It's worked for me in the past on a MySQL 3 server.

[Manik]

I think the beta has a big bug.. use the non-beta.

[Marshalus]

Kiind of a serious bug don't you think :S

[Dan]

I used it and it worked great except this TINY problem we have now.

Everyone is a guest(even know they are in a usergroup)

Check what happens when they post in the attachement

Any help WILL be greatly appriciated

[Dan]

If anyone knows the answer to above problem please tell me my forum is down because of this and I got cranky members.

/me won't be able to see any answers till sunday night

[gmtalk]

Just a silly question. did you have backups of both systems? If so then i suggest restoring it back to normal.

personally i would have tested it out on a test site prior to a live site. but that is just me. I am still trying to iron out bugs and issues that it is creating on the test site of mine.

[Dan]

/grumbles

I guess I'll try to restore the backup

[J.C.]

is this hack will work for future vB3?

thanks.

[Skyguide]

Last night i tried to run the script to import a board with 120'000 postings. The result was an overload of mysql (to many open connections, >200).

Also i was wondering that i didn't get any status back just klicked on start import and then wait to restart mysql....

Any idea ?

regards Skyguide