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.

[Neo]

It would be nice if you could transfer from one server to another.

[JulianD]

Yeah, i've been thinking about it... Maybe I can do it for the next weekend.

[Neo]

Guess im screwed.. I need it tonight >__<

Anyways do you know a good way to tranfer one db to another that arnt on the same server?

[freeshares1]

I cant make both usernames the same. using the plesk control panel.

Is ideas?

[JulianD]

Originally posted by freeshares1
I cant make both usernames the same. using the plesk control panel.

Is ideas?

I guess you're asking if you can merge two users into one with the hack.... Yes, you can See this post.

[freeshares1]

Originally posted by JulianD


I guess you're asking if you can merge two users into one with the hack.... Yes, you can See this post.

No,

What i have is 2 database

1/ the new one jokersnetwork
2/ the old one i want to merge into the above called old

The problem i have is that according my my host says that both databases cannot have the same username. So database 1 has username "jokers" which is what is in the config.php file and database no.2 has a username in phpadmin of "joker"

My question is how can i make this migration work? because my host says that using pleask (control panel) i cannot have the same database username for 2 different databases.

Below is the error i get

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT COUNT(*) AS count FROM old.user
mysql error: Access denied for user: 'jokers@localhost' to database 'old'

mysql error number: 1044

Date: Sunday 01st of December 2002 01:47:32 PM
Script: http://www.jokersrewards.com/forum/f...import_vb2.php
Referer: http://www.jokersrewards.com/forum/i...import_vb2.php


Any idea's or suggestions?

[Raptor]

could you make a mass user merge for those names that have the [imported] tag

im asking cus I have 3500 members that have [imported] and i'll be sitting here for weeks doing it manually

thanks

[JulianD]

Originally posted by Raptor
could you make a mass user merge for those names that have the [imported] tag

im asking cus I have 3500 members that have [imported] and i'll be sitting here for weeks doing it manually

thanks

Well... That's why you have to associate usernames before starting the users merge. It's a complicated process, but it's required...

Another option is to modify the script to automatically merge two users when they have identical usernames... It's possible, but it's not recommended because it could merge two different users into one.... tell me if this solution could work for you.

[JulianD]

Originally posted by freeshares1


No,

What i have is 2 database

1/ the new one jokersnetwork
2/ the old one i want to merge into the above called old

The problem i have is that according my my host says that both databases cannot have the same username. So database 1 has username "jokers" which is what is in the config.php file and database no.2 has a username in phpadmin of "joker"

My question is how can i make this migration work? because my host says that using pleask (control panel) i cannot have the same database username for 2 different databases.

Below is the error i get

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT COUNT(*) AS count FROM old.user
mysql error: Access denied for user: 'jokers@localhost' to database 'old'

mysql error number: 1044

Date: Sunday 01st of December 2002 01:47:32 PM
Script: http://www.jokersrewards.com/forum/f...import_vb2.php
Referer: http://www.jokersrewards.com/forum/i...import_vb2.php


Any idea's or suggestions?

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.

[Raptor]

Originally posted by JulianD


Well... That's why you have to associate usernames before starting the users merge. It's a complicated process, but it's required...

Another option is to modify the script to automatically merge two users when they have identical usernames... It's possible, but it's not recommended because it could merge two different users into one.... tell me if this solution could work for you.

i've already imported and have just over 3000 *[imported] users

could you right a script so merge all these automatically AFTER all the importing and merging has been done

the *[imported] needs to be source and * needs to be destination