Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases

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
  #202  
Old 07-06-2004, 06:43 AM
Khashyar Khashyar is offline
 
Join Date: Jan 2003
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This sounds like a great hack, Julian...

(I am wanting to merge two VB 2.3.4 databases, one of them being about one week older than the other).

I wonder if anyone has had luck in trying the merge LOCALLY first, before uploading it on their server?

Also, does the merge overwrite any information in the host database? For example, if you changed the name of a forum in a newer version of the database, will the merge overwrite the newer name?

Another question... If there are two threads that are the same in the two different databases (i.e., one newer version and one older version of the thread), and there were posts that were deleted in the newer version, will the merge reinsert the deleted posts in the thread?

It sounds like a wonderful hack.

Thanks for answering my questions if you can.

Khashyar
Reply With Quote
  #203  
Old 07-06-2004, 06:46 AM
Khashyar Khashyar is offline
 
Join Date: Jan 2003
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi again,

Is there a way to merge the posts and threads of ONE user (from an older database) into a newer database where those posts and threads have been deleted, but just not merge other forum data?

Thanks,

Khashyar
Reply With Quote
  #204  
Old 07-26-2004, 07:39 AM
lewekleonek's Avatar
lewekleonek lewekleonek is offline
 
Join Date: Jul 2004
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Merging failed big time! I am going to restore from the back-up. The forum is a mess - missing posts, threads etc.
Step 5: Merging threads and posts failed and gave the following error:
(of course I've truncated the filedata field for it was a big one - would not fit in the post).

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,vi sible) VALUES (

'',
'541',
'1070546658',
'dildostatic.jpg',
'GIF89a',
'1'
)
mysql error:

mysql error number: 0

Date: Monday 26th of July 2004 04:20:42 AM
Script: http://www.steroidology.com/forum/fo...import_vb2.php
Referer: http://www.steroidology.com/forum/im...import_vb2.php
Reply With Quote
  #205  
Old 08-18-2004, 01:35 PM
kingady kingady is offline
 
Join Date: Jul 2003
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so basically this is , 2 forums on different servers, which are the same ? (same users/posts/threads?) am i correct?
Reply With Quote
  #206  
Old 11-26-2004, 11:28 AM
Gio~Logist's Avatar
Gio~Logist Gio~Logist is offline
 
Join Date: Jun 2004
Location: San Francisco
Posts: 2,575
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so this wont work inporting from one siote to another?
Reply With Quote
  #207  
Old 06-21-2006, 07:28 PM
Sia Bani Sia Bani is offline
 
Join Date: Oct 2002
Posts: 67
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any update on this for vb3.?

Thanks!
Reply With Quote
  #208  
Old 02-21-2007, 05:06 PM
Cebby Cebby is offline
 
Join Date: Aug 2005
Location: Pittsburgh, PA
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Will there be a version of this for 3.6.x at some time soon?
Reply With Quote
  #209  
Old 02-04-2008, 04:23 PM
MadK's Avatar
MadK MadK is offline
 
Join Date: Feb 2008
Location: Canada
Posts: 109
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Cebby View Post
Will there be a version of this for 3.6.x at some time soon?
I would like to know, please.
Reply With Quote
  #210  
Old 02-07-2008, 08:07 AM
WebConnection WebConnection is offline
 
Join Date: Jun 2006
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MadK View Post
I would like to know, please.
Yeah! me too.
Reply With Quote
  #211  
Old 02-14-2008, 08:46 PM
MadK's Avatar
MadK MadK is offline
 
Join Date: Feb 2008
Location: Canada
Posts: 109
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well?

Last Activity: 07 Feb 2008 22:19
Reply With Quote
Reply

Thread Tools

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 10:13 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05129 seconds
  • Memory Usage 2,297KB
  • 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
  • (2)bbcode_quote
  • (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
  • (3)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