Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 04-19-2010, 09:33 PM
osayidan osayidan is offline
 
Join Date: Sep 2006
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Merge two VB forums

First the simple question: is there a way to merge 2 vbulletin forums who already have established databases? Where one would "receive" the important things such as user accounts, threads, posts and any other data required by those 3 things. The receiver would otherwise remain intact, forum structure, layout, plugins/mods/hacks and so forth, while the other would then be discarded after having given the data.

And now onto the gory details.

One of the forums is currently running on SMF. I'm quite sure the first step would involve converting the SMF into VB with impex on a clean temporary forum.

It's what comes after that which I'm not sure of and would need assistance with.
The main problem I can imagine is that the IDs for each object in the relevant tables I need to merge would conflict with each other.

My solution to this would be to script something in PHP to read the entries of these tables from the "donor" forum and append them into the corresponding tables of the "receiver" forum, making use of the auto increment for the ID fields.

The next issue would be what forum sections threads would end up in. I think this can be solved by another php script which would change forum IDs for each thread of the donor forum to the forum IDs of the receiver forum that I want them to go in. For example if "Category 5" on the donor is forum ID 87, and I want them to go in "Category 17" on the reciever which is ID 29, would have php cycle through every thread and change 87's into 29's.

If I'm on the right track for those two things then all I'm worried about after that point is conflicting user names. Wouldn't be too sure how to handle those other than renaming them, and if they turn out to be the same physical person, manually merge them upon request, and at some future date discard unclaimed duplicates.

So am I on the right track with this? Any input from someone who knows the back end of VB fairly well would be much appreciated.
Reply With Quote
  #2  
Old 04-21-2010, 05:53 PM
osayidan osayidan is offline
 
Join Date: Sep 2006
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No comments on this?

I've been studying the DB structure and it seems entirely possible, there's just a lot of things to take into consideration. So I'll be doing some tests with this soon.

Any feedback would still be appreciated though.

--------------- Added [DATE]1271889357[/DATE] at [TIME]1271889357[/TIME] ---------------

Update:

I've been told by a couple of non-official VB sources that impex -can- merge VB forums together.

However from many other non-official sources, everyone says that all impex will do is convert the database into a clean VB, destroying any data that was already there. The documentation I can find doesn't mention any merging however.

What's the real answer on impex and merging then?

Thanks.
Reply With Quote
Reply

Thread Tools
Display Modes

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:55 AM.


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.02999 seconds
  • Memory Usage 2,156KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete