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 » Thu Jul 17, 2003 2:09 am

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 » Thu Jul 17, 2003 2:38 pm

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 » Thu Jul 17, 2003 4:00 pm

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 » Fri Jul 18, 2003 1:20 pm

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 » Fri Jul 18, 2003 4:24 pm

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 » Fri Jul 18, 2003 7:05 pm

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 » Thu Jul 24, 2003 2:40 am

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 » Sun Jul 27, 2003 8:25 pm

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 » Sun Jul 27, 2003 8:30 pm

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 » Sun Jul 27, 2003 8:37 pm

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 » Wed Aug 06, 2003 9:25 pm

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 » Wed Aug 20, 2003 4:35 pm

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 » Sun Aug 24, 2003 9:28 pm

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 » Sun Aug 24, 2003 10:19 pm

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 » Mon Aug 25, 2003 4:07 pm

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”