UBB.Developers Forums UBB.threads 7 Development How Do I? How to merge 2 boards?

Hi Scream and JC,

Is there any way to merge 2 boards?

Thanks

Santana,

are you asking about merging two different installs of the forums, or two forums within one installation? Either is possible, I believe, just that the first is a tad more complicated....

Let us know...!

Matt

Hai Matty

I'd like to merge 2 board within the 1 instalation.
For example in this forum (https://www.ubbdev.com/threads/php/ubbthreads.php)
You are combining all posts/threads in:
Official PHP Bug Fixes & The Test Board, into the The Test Board.

So there will be no more Official PHP Bug Fixes' board.

That should be fairly easy. The only thing that designates what forum a post is in is the B_Board field. So let's say the keyword for the board you want to move the posts from is 'oldboard' and the keyword for where you want to move them to is 'newboard'. You would need to go into the admin section and run the following database command:

UPDATE w3t_Posts SET B_Board='newboard' WHERE B_Board='oldboard'

Hello Shreg, I meant Scream... []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

That's it? If we only change the keyword (oldboard to newboard) in B_Board field, then I assume everything will follow the 'newboard' rules, right? such as moderator access, read write permission, etc. And the oldboard will automatically disappear when we use our browser in accessing the forum, right?

Ok, thanks Scream...

=== I did it ===
Well Scream, it appears to work, but the number of posting is still the same, and how do we update the w3t_Boards table which contains the information of numbers of posting, etc. Or should we just manually update the tables?

Note: They are in the same category.

Thanks

Ah, that will require a manual update. You'll need to find out the totals from the old board. If you haven't deleted it yet then you could do:

SELECT Bo_Total,Bo_Threads FROM w3t_Boards WHERE Keyword='oldboard'

This will give you the # of posts and the # of threads. Then you can do this to update the new board:

UDPATE w3t_Boards SET Bo_Total=Bo_Total+totalposts, Bo_Threads=Bo_Threads+totalthreads WHERE Bo_Keyword='newboard'

Hi Scream,

The following would be a very useful feature: to incorporate table merges as part of a board deletion. So if someone deletes a board, prior to really deleting it, you are presented with the option of moving all threads to another board - along with updating the number of posts etc.

In addition (or alternatively) a "mass move" of threads might be useful. From the admin screen, just like you have "close thread" and "expire threads", you could have a "move threads", where you're presented with all the topics along with checkboxes in order to move a bunch of threads to another board.

Max

PS - I'll post this on the official board wishlist as well, with a reference to this thread.