The Arcive of Official vBulletin Modifications Site.

vBulletin Merge Tool for v2.2.x · **Released**: 11-17-2002

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.

Smellycat · #**152** 07-02-2003, 03:23 PM

Have you made sure both databases are of the same version? i,e 2.3.0

Mikal · #**153** 07-02-2003, 05:23 PM

They should be

Mikal · #**154** 07-03-2003, 02:19 PM

But it doesnt even let me run the script, in admin cp, I choose the script and try to run it, and get the error.

so any ideas?

marcel-ea · #**155** 07-15-2003, 02:35 PM

Also i offer everybody 100$ cash who help me to fix the script
and merge two big forums. PM me

JulianD · #**156** 07-15-2003, 04:48 PM

I am sorry for all the problems you're having with this script.. It was something I wrote a long time ago and I don't have the time to fix all the numerous bugs that have been appearing with the new PHP and MySQL releases.

I'm sure some of the problems (like the duplicated threads) are caused by new versions of PHP and/or MySQL.... The first releases of this script didn't have such problems... I took a look to the code a few days ago but I can't find the problem... It requires some more testing and some more time, and that's something I don't have right now

I'd be very happy if some of you guys can improve this script until Jelsoft officially releases something like this for vB2 and vB3.

Right now I can't take care of this script, even though I would love to fix it and post it here for the benefit of you.

!!!cyr0n_k0r · #**157** 07-27-2003, 04:33 AM

hey, ++++ this guy

I just contacted him on AIM to ask him a question about this script and he blocked me.

I then asked him why he blocked me on ICQ and he blocked me again.

This guys an +++++++.

JulianD · #**158** 07-28-2003, 03:27 AM

I didn't blocked you. I disconnected from the Internet. Anyway, I am not giving support for this hack, so if you were looking for support, I can't help you. Sorry.

!!!cyr0n_k0r · #**159** 08-04-2003, 06:41 AM

bull++++ you disconnected. You were online with ICQ after you blocked me from aim.. and only disconnected AFTER I asked you why you blocked me in the first place.

Dont lie to my face +++++++.

JulianD · #**160** 08-04-2003, 07:56 AM

OK Thread closed. Sorry.

JulianD · #**161** 10-14-2003, 03:43 PM

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 databases.

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.

Go to the first post... There's the attachment.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04549 seconds Memory Usage 2,307KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!