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... You don't need to edit the file at all. When you start the merger, you will be prompted for the details of the database to merge (you'll be asked for a host, an username, a password and the database name. You should fill those fields according to the database you want to merge.

For example, if you're merging a database located in the same server you're running vb, then the settings should be something like this:

db host: localhost
db user: user
db pass: password
db name: dbname

but if you're trying to merge a database on a different server, you should change the db host to the host name or IP address where the database is located. Note that you will need to configure your server to allow connections from other hosts (most hosting companies doesn't allow connections to the mysql server if you're not on the local server, but you can change this on your control panel, or ask your hosting company about this matter. I'm unable to provide support here).

Tell me how it goes, or contact me (again ) if you can't merge the database.

And remember, DON'T modify the script, you don't need to do it.

[tucklis]

I have uploaded the new version (unmodified) and when I click begin import it gives me the following error:

Database error in vBulletin Merge Tool 2.2.9:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Thursday 20th of March 2003 04:39:44 PM
Script: http://yupz.com/forums/forums/import...p?action=start
Referer: http://yupz.com/forums/admin/bbimport.php?action=

My host says there is no reason why I shouldn't be able to connect

Regs,
Kerry

[tucklis]

I just got this reply from my host:

Dear Kerry,

Thank you for your email.

This error is caused because the script is attempting to connect using sockets which isn't allowed on our system. The way to connect on our system is using the IP address of the database and tcp/ip.



What do I do now ........?


Kerry

[JulianD]

Can you contact me so I can see what's going on with your server configuration? I have msn icq and aim.

I can't reproduce this problem on my server, so I don't have a way to test it out.

Thanks.

[tucklis]

Just got another reply from support, here is what they said:

------------------------------------

Dear Kerry,

Looking quickly at the script you should be able to hard code the remote database in:

var $database = "";

var $link_id = 0;

var $query_id = 0;

var $record = array();

var $errdesc = "";

var $errno = 0;

var $reporterror = 1;

var $server = "localhost";

var $user = "root";

var $password = "";

Where database would be the database name and server would be the IP address of the MySQL server and use the Database Owner details.

Unless its using the hidden fields where you should still be able to hardcode or choose the remote server. You may need to specify port 3306 for the server - simply add ,3306 after the IP address specified i.e. 213.171.111.111,3306 .

I hope this helps.

------------------------------------
Cheers,
Kerry

[JulianD]

OK i think i've fixed the problem. Let me update the file.

[tucklis]

Julian,

The merge has worked fine. Although I think there was a problem with the polls, it didn't seem to convert them (but this isn't such a big problem).

The only thing is most of the forum ids seemed to have changed, is this common? Any idea how to change em back?

Anyway thanks very much for creating a great hack!

Regards,
Kerry

[JulianD]

Ummm I don't know about the polls.... When I have some time, I'll look into this.

About the forums id, yeah, those will change according to the new forums id on the board. Everything changes, just like the threadids, postids, even the userids changes....

[hockyfan]

I just have to comment, the support and assistance I got with this hack was truely unprecedented. I received excellent support, especially considering this was on his own time and without payment etc. This hack did work very well, and I highly recommend it to anyone!

Excellent work julian, and thank you!!


h

[JulianD]

Thanks for the kind words I'm glad you got it working on your forums.