Junction of Forum's

The 2.0.x discussion forum has been locked; this will remain read-only. The 3.0.x discussion forum has been renamed phpBB Discussion.
Locked
NitroCar
Registered User
Posts: 8
Joined: Thu Jul 17, 2003 1:11 am

Junction of Forum's

Post 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 !!!
BartVB
Consultant
Consultant
Posts: 1288
Joined: Thu Aug 02, 2001 1:32 pm
Location: The Netherlands
Contact:

Post 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.
I Hate oversized sigs and Love Penguins :D
NitroCar
Registered User
Posts: 8
Joined: Thu Jul 17, 2003 1:11 am

Post 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...
Homies
Registered User
Posts: 26
Joined: Thu Jul 10, 2003 12:33 pm

Post by Homies »

BartVB: can u send me also a copy of it?
thank you
Last edited by Homies on Tue May 27, 2008 2:56 pm, edited 1 time in total.
BartVB
Consultant
Consultant
Posts: 1288
Joined: Thu Aug 02, 2001 1:32 pm
Location: The Netherlands
Contact:

Post 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!!
I Hate oversized sigs and Love Penguins :D
doggroups
Registered User
Posts: 48
Joined: Tue Apr 15, 2003 4:32 pm
Contact:

Great Script

Post by doggroups »

Great script, I had been looking for something simular forever! I will have to give it a spin this weekend.
Scotticus
Registered User
Posts: 248
Joined: Thu Jul 10, 2003 6:25 am
Location: Tacoma, WA
Contact:

Post by Scotticus »

I'll look into using this. I only want to merge my posts, posts_text, and topics tables.

Cerebrosus
Registered User
Posts: 10
Joined: Thu Jul 24, 2003 3:57 pm
Contact:

Post 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?
User avatar
Darlof
Former Team Member
Posts: 7111
Joined: Wed Jul 10, 2002 7:53 pm
Location: AR, USA
Name: Darrell
Contact:

Post 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!!


;)
Cerebrosus
Registered User
Posts: 10
Joined: Thu Jul 24, 2003 3:57 pm
Contact:

Post by Cerebrosus »

I know... just wondering if anyone had any idea of the problem....
ghostrider
Registered User
Posts: 6
Joined: Sat Feb 01, 2003 5:50 pm
Contact:

Post 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 ;)
User avatar
Anjay
Registered User
Posts: 66
Joined: Sat Dec 29, 2001 8:58 pm
Location: France
Contact:

Post 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. :)
"Be careful, when you play with fire you will always get burned, when you play with ice you will always get iced, when you play with nothing; then you are safe from all elements except your mind" ~ A Wise Old Man
User avatar
Manshu
Registered User
Posts: 127
Joined: Sun Dec 15, 2002 3:37 pm

Post 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?
User avatar
Manshu
Registered User
Posts: 127
Joined: Sun Dec 15, 2002 3:37 pm

Post 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
BartVB
Consultant
Consultant
Posts: 1288
Joined: Thu Aug 02, 2001 1:32 pm
Location: The Netherlands
Contact:

Post 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
I Hate oversized sigs and Love Penguins :D
Locked

Return to “2.0.x Discussion”