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]

No, the script will only import known data from the database. If you have another tables/fields in the database, the script will be unable to see those fields or tables..

[Mr L]

Apoligies! I read this as will it work on the import if you had hacked a database and were using a non "out of the box" version of vBulletin.

[hypedave]

any update on the Polls bug?

[JulianD]

Originally posted by hypedave
any update on the Polls bug?

I think I got it....


Test the new version you found in the first post and tell me your comments.

[hypedave]

You wouldnt by any chance have a seperate fix for the polls bug would you??

[JulianD]

You mean, a script to fix a merged database with the poll bug?

No, that´s not possible, i´m afraid.

You should remerge the databases. Sorry for the disadvantage.

[freeshares1]

i am getting the following any thoughts??? I have changed the file to 2.28 as well.

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT COUNT(*) AS count FROM 231102.sql.user
mysql error: You have an error in your SQL syntax near '231102.sql.user' at line 1

mysql error number: 1064

Date: Sunday 24th of November 2002 10:06:31 PM
Script: http://www.jokersrewards.com/forum/f...import_vb2.php
Referer: http://www.jokersrewards.com/forum/i...import_vb2.php

[JulianD]

You must have the vb database as a real database, not as a dump file. Load the dump to mysql and use the database name instead.

[Omar_2002]

Does this script allow us to merge only the users from the second database?

Thanks

- Omar

[JulianD]

Users, forums, threads, posts, polls and attachments.