Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vBulletin Merge Tool for v2.2.x Details »»
vBulletin Merge Tool for v2.2.x
Version: 1.00, by JulianD JulianD is offline
Developer Last Online: Sep 2018 Show Printable Version Email this Page

Version: 2.3.x Rating:
Released: 11-17-2002 Last Update: Never Installs: 69
Is in Beta Stage  
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #172  
Old 11-01-2003, 02:48 AM
Quest4DSS Quest4DSS is offline
 
Join Date: Dec 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe I am entering the info in these fields wrong.
Reply With Quote
  #173  
Old 11-01-2003, 03:04 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The other values are the same database username and database password you use on config.php.

And the Database Name is the name of the database you want to merge.
Reply With Quote
  #174  
Old 11-01-2003, 03:19 AM
Quest4DSS Quest4DSS is offline
 
Join Date: Dec 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes I did that exactly like that.
Is there anyway you can look at it?
Reply With Quote
  #175  
Old 11-01-2003, 03:29 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's weird... Send me a PM with the details of your forum admin cp...
Reply With Quote
  #176  
Old 11-01-2003, 03:43 AM
Quest4DSS Quest4DSS is offline
 
Join Date: Dec 2002
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You have a PM.
Reply With Quote
  #177  
Old 11-01-2003, 04:10 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Read my response.
Reply With Quote
  #178  
Old 11-02-2003, 04:59 AM
hockyfan hockyfan is offline
 
Join Date: Mar 2003
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I keep getting this error:
Code:
Database error in vBulletin Merge Tool 2.3.2:

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

mysql error number: 0

Date: Sunday 02nd of November 2003 07:58:20 AM
Script: http://otnforums.snooboo.com/importers/bbimport_vb2.php?&action=start


h
Reply With Quote
  #179  
Old 11-02-2003, 02:12 PM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You're not typing the right values for the database you want to merge, and hence, the script cannot connecto to it.



If you want, send me your details such as admincp login/password and username, password and database name of the database you want to merge and I should be able to tell you what's the problem.
Reply With Quote
  #180  
Old 11-05-2003, 01:46 PM
Rampag33's Avatar
Rampag33 Rampag33 is offline
 
Join Date: Jun 2002
Location: Houston, Texas
Posts: 162
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

excellent hacc, installed

NOTE

combined 232 to 229 all users and post went over fine
attachments were corrupted.
Reply With Quote
  #181  
Old 11-08-2003, 11:10 PM
hockyfan hockyfan is offline
 
Join Date: Mar 2003
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Due to restrictions on my server, I'm not able to create new MySQL databases. This being the case, I only have two dumps of the forums I'd like to combine, but I have no way to load them to real databases. If I sent someone the dump files, would anyone be able to do this for me?

h
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06301 seconds
  • Memory Usage 2,310KB
  • 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)bbcode_code
  • (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