• From: France
  • Registered: 2004-11-06
  • Posts: 695

Topic: How to merge 2 PunBB forums into one ?

Does anyone has an idea on how merge 2 (or more) forums into one ?

I'm not talking about different install of PunBB, but inside one install, if I have several forums that I would like at some point to merge into one (take all the threads and posts of these forums and put them into only one) how would I do that ?

I haven't seen any merge option, or plugin. My guess is that would be a simple UPDATE sql command, but I prefer an expert opinion on the matter smile .

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website

2 Reply by Dexus (edited by Dexus 2005-04-23 07:12)

  • Dexus
  • Senior Member
  • Offline
  • Registered: 2005-03-30
  • Posts: 154

Re: How to merge 2 PunBB forums into one ?

You may write little "function" that will change "forum_id" in 'topics' table.
You may use DB management plugin run sql query like that:

update [prefix]topics set forum_id=3 where forum_id=2

prefix - is prefix of tables, when you were installing punbb database.
but before you have to see viewforum.php?id=N in index.php to find out these ID's to replace one to another.
good luck!

  • From: France
  • Registered: 2004-11-06
  • Posts: 695

Re: How to merge 2 PunBB forums into one ?

Ok so this is the only place where the data is saved ? Good, thanks.

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: How to merge 2 PunBB forums into one ?

I just found a script that does this for PHPBB
http://www.typo.nl/misc/merge_phpbb.phps

Would anyone be interested in me trying to write a similar script for PunBB (except perhaps with an interface you can put the info in, rather then having to edit the script)?

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: How to merge 2 PunBB forums into one ?

does that one query not work then?

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: How to merge 2 PunBB forums into one ?

It would work, but a script that can do it automatically is better IMO smile

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: How to merge 2 PunBB forums into one ?

a plugin maybe? 2 dropdown boxes and your done

FluxBB.
Connorhd.co.uk.

Connorhd's Website

8 Reply by Jérémie (edited by Jérémie 2005-04-28 18:39)

  • From: France
  • Registered: 2004-11-06
  • Posts: 695

Re: How to merge 2 PunBB forums into one ?

Maybe... a SQL query is not that hard, especially with things like Eskuel or PhpMyAdmin and a query as simple as that one. It's a little intimidating for some, but it should, because if something goes wrong you need to repair it yourself.

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: How to merge 2 PunBB forums into one ?

I like a script better, because you'll never need to run the script again anyway smile
A plugin I consider something I would want to use more than once tongue

  • From: France
  • Registered: 2004-11-06
  • Posts: 695

Re: How to merge 2 PunBB forums into one ?

Well, some forums might do this several times. Myself, I want to test several ideas or themes.. so I open a specific forum. If that work, but the trafic is not enough for a single forum ; or if the theme had a time table now over, I can migrate the content into a parent forum.

It's both for temporary forum, and for testing (as in testing a new idea, not technical test). Yes, I guess for some people a plugin would be useful.

But that's certainly not a core feature needed... an automatic mark thread as read is muuuuuch more important big_smile

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website

  • Registered: 2005-03-30
  • Posts: 41

Re: How to merge 2 PunBB forums into one ?

Does anyone know if the info is stored anywhere else besides the forum_id in tables?  I'm working on a plugin for it.

sfackler's Website

  • Registered: 2005-03-30
  • Posts: 41

Re: How to merge 2 PunBB forums into one ?

Ok, I've got the plugin finished.  I've emailed it to Rickard to put on the download page.

http://www.toastedgamers.com/AP_Merge_Forums.zip

sfackler's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: How to merge 2 PunBB forums into one ?

Mmm, so much for that tongue

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: How to merge 2 PunBB forums into one ?

Download page updated. Thanks sfackler.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website