|
Joined: Jul 2001
Posts: 442
Enthusiast
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
Just like the title, I simply want to get rid of a forum but not the content, simply want to move the content of one forum into another forum.
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
Near Impossible without some very complex scripts.
How would the script react when importing a member that already exists. How is it to handle post numbers if they already exist. There are so many variables.
|
|
|
|
Joined: Jul 2001
Posts: 442
Enthusiast
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
I'm lost, not sure what post count has to do with anything, as an admin I can move one thread at a time to another forum, if that can happem I would think you could move an entire forum of threads to another forum, or am I missing something?
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
The Mass Move is what you need. Not sure if it's been tested on 6.4 yet - so backup your database before you play.
|
|
|
|
Joined: May 2001
Posts: 550
Code Monkey
|
Code Monkey
Joined: May 2001
Posts: 550 |
>Near Impossible without some very complex scripts.
I think you ment merging 2 boards...
He is talking about merging 2 forums, I think.
Basicaly, all you have to do is a MSQL query, something like this(just to give an idea, sql syntax not correct)
UPDATE w3t_Posts SET B_Board = newforum WHERE B_Board = oldforum
This will move all posts from oldforum to newforum.
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
Yeah Me was tired LOL I read it as merging two board databases not a forums posts
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Care will need to be taken to update totals in the Boards table as well as the last posters in the forum. take a look at the scripts I posted for the queries that need to be done.
|
|
|
|
Joined: Jul 2001
Posts: 442
Enthusiast
|
Enthusiast
Joined: Jul 2001
Posts: 442 |
Josh, as far as I can tell this script worked perfect in 6.4.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Thanks - just updated the post to note that it works for 6.4.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|