FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Suggestions » merge boards
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
merge boards [message #5660] Wed, 11 September 2002 20:21 Go to next message
heidiott is currently offline  heidiott   United States
Messages: 34
Registered: May 2002
Karma: 0
Member
Is it possible to merge two boards? If it is can you tell me how to do it?
Thanks,
Heidi
Re: merge boards [message #5661 is a reply to message #5660] Wed, 11 September 2002 20:34 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
If you are referring to two seperate FUDforum installations, then yes it is possible, however it would require a quite bit of work on your part.
Since the id cannot be maintained you will need to write a script that would convert the ids. Meaning that if you had a user in the source forum with id of 55, you need to insert that data into the destination forum and then equate the new user id to 55, so everywhere user id 55 is uses you will need to insert the new user id and so on.


FUDforum Core Developer
Re: merge boards [message #5663 is a reply to message #5660] Wed, 11 September 2002 21:00 Go to previous messageGo to next message
heidiott is currently offline  heidiott   United States
Messages: 34
Registered: May 2002
Karma: 0
Member
Actually, I was refering to two forums within the same board. Would this be possible?

Thanks,
Heidi
Re: merge boards [message #5664 is a reply to message #5663] Wed, 11 September 2002 21:35 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Yeah, you can move messages from 1 forum to another pretty easy by using the move link...

FUDforum Core Developer
Re: merge boards [message #6241 is a reply to message #5664] Sun, 06 October 2002 22:00 Go to previous message
valiant is currently offline  valiant   Switzerland
Messages: 80
Registered: September 2002
Location: Zurich
Karma: 0
Member
I guess she wants not only to move 1 or 2 messages from one forum to another. She used the word "merge" what would mean:
1. take all the topics from one forum and move them to the other.
2. delete the empty forum and rename the other.

that's pretty easy to do if FUDForum doesn't supply a feature like that.
if you have a webinterface to your database as "phpMyAdmin" you can do one single sql query to move all the topics from one thread into another.
I've tested it on my setup but it failed. Don't know why, but it should have worked. Probably protoss could help...

UPDATE `fud23_thread` 
set forum_id = new
WHERE forum_id = old;


whereas
- 'fud23_thread' is the your thread table (I'm using the prefix fud23_)
- "old" is the old forum id: look in your forum table (i.e. fud23_forum) and examine what "id" the forum has which will be emptied and what id the forum has which will be filled (the "new" one).



cheers - andy
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Deleting Messages
Next Topic: NNTP as backend
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 15:11:12 GMT 2024

Total time taken to generate the page: 0.03194 seconds