Page 1 of 8

Junction of Forum's

Posted: Thu Jul 17, 2003 2:09 am
by NitroCar
Hello Friends;
I don't know if here it is the perfect place for that post, more he would like to know if he has as uniting two db of the phpbb (junction of two forum's), thank you !!!

Posted: Thu Jul 17, 2003 2:38 pm
by BartVB
If I understand you correctly you want to merge two separate forums into one?

I'm in the process of creating a script that does exactly that. Currently testing it, seems to be working, it even merges the users tables.

Contact me by mail if you want a copy of it.

Posted: Thu Jul 17, 2003 4:00 pm
by NitroCar
Hello BartVB;
It would be quite so to melt two separate forums in a...
If possible he happens a copy of this:
caio@nitrocar.com.br
icq:122643681
msn:nitrocar_caio@hotmail.com
Thank you very much, I will be in I await him...

Posted: Fri Jul 18, 2003 1:20 pm
by Homies
BartVB: can u send me also a copy of it?
thank you

Posted: Fri Jul 18, 2003 4:24 pm
by BartVB
I received a few other requests for this script so I've put it online:

http://www.typo.nl/misc/merge_phpbb.phps

Have fun..

Please keep in mind that I'll give absolutely _NO_ support. Use of the script is for your own risk. Please make BACKUPS before you use the script!!

Great Script

Posted: Fri Jul 18, 2003 7:05 pm
by doggroups
Great script, I had been looking for something simular forever! I will have to give it a spin this weekend.

Posted: Thu Jul 24, 2003 2:40 am
by Scotticus
I'll look into using this. I only want to merge my posts, posts_text, and topics tables.


Posted: Sun Jul 27, 2003 8:25 pm
by Cerebrosus
When I use this script I get the error message:
Altering dependent table: forum_prune : forum_id (offset = 23)
UPDATE jetera_net.fvuforum_forum_prune SET forum_id = forum_id + + 23 WHERE forum_id > 0


SQL Error : 1064 You have an error in your SQL syntax near '+ 23 WHERE forum_id > 0' at line 1

UPDATE jetera_net.fvuforum_forum_prune SET forum_id = forum_id + + 23 WHERE forum_id > 0

Line : 306
File : /customers/jetera.net/jetera.net/httpd.www/hosted/forum/join.php


What´s wrong?

Posted: Sun Jul 27, 2003 8:30 pm
by Darlof
BartVB wrote: Please keep in mind that I'll give absolutely _NO_ support. Use of the script is for your own risk. Please make BACKUPS before you use the script!!


;)

Posted: Sun Jul 27, 2003 8:37 pm
by Cerebrosus
I know... just wondering if anyone had any idea of the problem....

Posted: Wed Aug 06, 2003 9:25 pm
by ghostrider
Hey all.. I was advised to check this thread out. Is there a way to COMBINE the combined forums?

ie: http://www.phpbb.com/phpBB/viewtopic.php?t=125134 ;)

Posted: Wed Aug 20, 2003 4:35 pm
by Anjay
I have some minor questions about this script:

- I have a member at one board with the name "aaa" and there is a member at the other board also with the name "aaa" - Both people are the SAME person - what will happen?

- I have a catergory at forum1 called "DDD" and the exact same category at forum2 - will all posts in each category be merged?


Thanks for all help. :)

Posted: Sun Aug 24, 2003 9:28 pm
by Manshu
ok, I cant get this script to work! I emailed bart but hes gonna charge me $180 to do it for me. So Im wondering if someone else can do it?

Posted: Sun Aug 24, 2003 10:19 pm
by Manshu
ok, I got it to work, but I get this error:

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 77 WHERE forum_id > 0' at line 1

UPDATE ultimate_dan.phpbb_forum_prune SET forum_id = forum_id + + 77 WHERE forum_id > 0

Line : 306
File : /home/ultimate/public_html/merge_phpbb.php

Posted: Mon Aug 25, 2003 4:07 pm
by BartVB
Ok I lied, I will give support if you deposit $180 (US Dollars) into my paypal account :D 180 euro's also will do ;)

Anyway. I changed the script a bit, maybe the problems that are mentioned here are solved now. Haven't tested my modifications though :D