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.

[Intercept]

hey can you make the script so the database username doesnt have to be the same, i got plesk control pannel. and it wont let me put the same user name

[Molok]

i have 2 board version 2.2.9
now i want to merge and i received the following error

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO userfield
(userid,field1,field2,field3,field4,importuserid,i snew)
VALUES
('2475',
'',
'',
'',
'',
'8',1
)
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

[Darkwolf]

It is possible like when the two database merge if the user using same email then they merge if not use as username[imported] ?

[Lanigironu]

This is exactly what I needed. I was going to write a script of my own, but this seems like it will do everything.

I just hope it works.

[JulianD]

Originally posted by Molok
i have 2 board version 2.2.9
now i want to merge and i received the following error

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO userfield
(userid,field1,field2,field3,field4,importuserid,i snew)
VALUES
('2475',
'',
'',
'',
'',
'8',1
)
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

Uhmm Looks like it doesn't work if you've deleted the user fields that comes with vbulletin. You can however replace this:

PHP Code:

  if ($userid) {
      $DB_site->query("INSERT INTO userfield
      (userid,field1,field2,field3,field4,importuserid,isnew)
      VALUES
      ('$userid',
      '".addslashes(htmlspecialchars($user[biography]))."',
      '".addslashes(htmlspecialchars($user[location]))."',
      '".addslashes(htmlspecialchars($user[interests]))."',
      '".addslashes(htmlspecialchars($user[occupation]))."',
      '$user[importuserid]',1
      )");
  } 


with this:

PHP Code:

  if ($userid) {
      $DB_site->query("INSERT INTO userfield
      (userid,importuserid,isnew)
      VALUES
      ('$userid',
      '$user[importuserid]',1
      )");
  } 


and hopefully it will work, however, you will lose the userfields data when you merge the databases.

[JulianD]

ok I need some help here.

I've enhaced the script a little bit. Now you can choose if you want to auto merge users with the same username, and you can choose a database to merge with a different password and a different hostname.

Please tell me if you encounter any problems, so I can update the first post.

[KarateKid]

Great.

Maybe I'll try this hack with 2 forums each many thousands posts, user and threads

Regards.

[Iezugod]

When I go to start the import, I get:

Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /usr/local/psa/home/vhosts/nintendonet.com/httpdocs/forums/admin/db_mysql.php on line 32

[JulianD]

Are you sure you typed the login information for the second database?

[Iezugod]

No, it wouldn't let me. As soon as I selected the vB Merge tool from the list, and clicked submit, it gave me an error..