Firefox PHP

Convert phpBB to phorum

Posted by Jens 
Re: Convert phpBB to phorum
December 13, 2004 11:17PM
Yes, lots and lots! For three reasons:
I don't know the Phorum 3 schema;
I'm fixing the things that break;
I'm not very good at PHP but I'm finding this code very readble, except for the sql! ;-)

I've added a
"WHERE forum_id = $forumdata['forum_id']"
and things seem to be progressing better - it's very slow!

phpbb also has a phpbb_topics relation (in fact I think it's in general more relational than Phorum but seeing as MySQL doesn't really do the relational...) but this only has topic titles. I'll have to see what the results are before I decide whether to include this.

Have to see how things progress tomorrow and will keep you posted.

Charlie




Edited 1 time(s). Last edit at 12/13/2004 11:18PM by charlie.clark.
Re: Convert phpBB to phorum
December 14, 2004 01:29AM
charlie.clark Wrote:
-------------------------------------------------------
> phpbb also has a phpbb_topics relation (in fact I
> think it's in general more relational than Phorum
> but seeing as MySQL doesn't really do the
> relational...) but this only has topic titles.

What do you mean? Mysql is as relational as any other DB. There are some other things missing, but not relation...

And doesn't phpbb run on mysql too?

But anyway, your work is still appreciated :)

---
-=[ Panu ]=-
Re: Convert phpBB to phorum
December 14, 2004 11:21AM
phorum5's DB is not as normalized as possible. but thats just for performance. joins aren't as fast as a select from the same table ;).

charlie, I would be very interested in the results.
not sure why it should be that slow though.
I could take a deeper look if I could get a phpbb-database full of data and an explanation of what each data there means.




Thomas Seifert
Phorum Development Team / Mysnip-Solutions.de
Custom Phorum and general software development
worry-free Phorum Hosting
Re: Convert phpBB to phorum
December 15, 2004 11:00AM
ts77 Wrote:
-------------------------------------------------------
> phorum5's DB is not as normalized as possible. but
> thats just for performance. joins aren't as fast
> as a select from the same table ;).

I knew I shouldn't have mentioned this... Joins are unbearably slow with MySQL MyASM tables because they are basically not relational which is why FOREIGN KEYS are only supported syntactically. I don't want to flame about this so for more on this topic see www.dbdebunk.com

> charlie, I would be very interested in the
> results.
> not sure why it should be that slow though.
> I could take a deeper look if I could get a
> phpbb-database full of data and an explanation of
> what each data there means.

It is very slow because of having to iterate through all messages of a specific forum. I left it processing overnight and checked the results and they were little different from what I get with INSERT INTO ... SELECT so I'm rewriting that part of the import to work directly in the database.

I can make the phpbb schema available - it's not well-documented either - and possibly even a database extract later.

Charlie
Re: Convert phpBB to phorum
December 15, 2004 11:10PM
My latest efforts.
Attachments:
open | download - phpbb_in.php (19.3 KB)
open | download - phpbb_to_phorum5_convert.php (7.6 KB)
Re: Convert phpBB to phorum
December 16, 2004 03:20PM
So, the latest version bypasses phorum functions for updating forum stats and post info.

The forums and messages are now imported generating usable information with just a few errors. For some reason date information is being ignored while time information is being preserved.

eg.
"December , 2004 02:13PM"

meta information is being generated manually and is nearly correct. I'd appreciate someone checking the code for this. If I understand things correctly, meta is only required for the first post in a thread.
Attachments:
open | download - phpbb_to_phorum5_convert.php (7.5 KB)
open | download - phpbb_in.php (22.9 KB)
Re: Convert phpBB to phorum
September 16, 2005 09:51PM
who knows, how to do it backwards, from Phorum to phpBB?.. thank you!
Re: Convert phpBB to phorum
September 16, 2005 10:25PM
you should ask this in the phpbb-forums.


Thomas Seifert
Phorum Development Team / Mysnip-Solutions.de
Custom Phorum and general software development
worry-free Phorum Hosting
Re: Convert phpBB to phorum
November 29, 2011 05:05AM
Awesome, thank you very much for posting this!!!

Going to try on Phorum 5.2 and PHP 5.3 from a phpBB 3.0 install

___
Skye Nott
Corvus Digital
Re: Convert phpBB to phorum
October 30, 2012 11:55PM
Quote
Jens
I'd need to convert my bloated phpBB forums to phorum.
I haven't found these on the web, so I thought it could be useful. Especially for me :-)

I did this years ago and posted the manual here, but I can't promise it will work with phorum 5.2. Your easy shortcut would be to install phorum 5.1, follow my instructions, then upgrade to phorum 5.2 taking advantage of its conversion scripts.
Sorry, only registered users may post in this forum.

Click here to login