here... a phpBB 1.4x to YaBB 1.4.1 converter...

[aitrus]

After reading through 4 pages of "I want I want I want..." I decided to just write this converter myself.

http://uhacc.org/code/phpBBtoYaBB.php.gz
http://uhacc.org/code/phpBBtoYaBB.php.bzip2
http://uhacc.org/code/phpBBtoYaBB.php.zip

Right click on that link and download the code.  Quick instructions are in the file itself.
It will convert most information for categories, boards, posts (including dates and times), instant messages, and users.  The converter also removes some of the BBCode from the posts.  Check out the code for more information.
This script will blow away everything in YaBB before it runs to prevent duplicates.  So don't try and use this to import into an existing forum.
The output is ugly, and if your browser or webserver chokes on it, then go through and comment out all of the "echo" statements before you run it.
Once ran, users can go to the login screen and click "forgot password" to have a new password created and sent to them.

[Chris Cromer]

You have to zip it up, or else we can't download it(all we get is the html and not the source code itself. )

Even when you right click it only saves the html of the file.

[aitrus]

Err... yeah... I don't know where my brain was...  

I modified the original post with the new files...

[groundup]

VERY COOL!

[David]

BOO FRIGGIN YA GRANDMA!!  

[A.M.A.]

nice  

[vegatopia]

No workie form me unfortunately. It starts with converting members and when it reaches member nr. 49 it stops with a syntax error:

Executing: INSERT INTO yabbse_members ( ID_MEMBER, memberName, realName, passwd, emailAddress, dateRegistered, personalText, websiteTitle, websiteUrl, location, ICQ, AIM, YIM, hideEmail, signature, posts, MSN ) VALUES ( 48, 'Mieke', 'Mieke', '2e11ad88e8b40630c6ece8e0cef0e32a', '[email protected]', 990655200, '0', '', '', 'A'dam', '', '', '', 1, '', 2, '' )
DB Error: syntax error

Anyone any idea?

[Compuart]

It seems the A'dam is giving the troubles and has to be escaped first. Try replacing:

Code Select Expand

 $sql .= "'" . $objRow->websiteUrl . "', '" . $objRow->location . "', ";

by:

Code Select Expand

 $sql .= "'" . $objRow->websiteUrl . "', '" . mysql_escape_string($objRow->location) . "', ";


[aitrus]

Looks like your error is on member #48, not #49.  See the 'A'dam'?  Try changing line 646 of the code from this:

  $sql .= "'" . $objRow->websiteUrl . "', '" . $objRow->location . "', ";

to this:

  $sql .= "'" . $objRow->websiteUrl . "', '" . addcslashes( $objRow->location ) . "', ";

j

[aitrus]

Heh... Looks like we were posting at the same time.  =)

Thanks for looking into it as well.  I probably should escape all of the strings, but ugh... what a lot of typing...

j

[vegatopia]

Thanks to you both. I'll give it a try later on today and let you know if it worked.  

[vegatopia]

Unfortunately neither of the adjustements to the original script did the tric. Aitrus's new line produced errors from line one on (forgot to write them down, I'll look into that later), Compuart's solution worked longer, but it stopped when trying to convert member 728 and said: DB Error: syntax error

This is what it tried to do with member 728:
Executing: INSERT INTO yabbse_members ( ID_MEMBER, memberName, realName, passwd, emailAddress, dateRegistered, personalText, websiteTitle, websiteUrl, location, ICQ, AIM, YIM, hideEmail, signature, posts, MSN ) VALUES ( 728, 'Dark O'Neills', 'Dark O'Neills', 'f45eba65fefe6616cd8cbf0c34526c0c', '[email protected]', 1027116000, '0', 'http://www.student.kun.nl/r.niels', 'http://www.student.kun.nl/r.niels', 'Nijmegen', '', '', '', 0, '', 0, '' )

Any of you see anything unusual? Is it the 'Dark O'Neills' thingie?

[Compuart]

yep, that's it

replace:

Code Select Expand

 $sql .= $objRow->ID_MEMBER . ", '" . $objRow->memberName . "', ";
  $sql .= "'" . $objRow->realName . "', ";

by:

Code Select Expand

 $sql .= $objRow->ID_MEMBER . ", '" . mysql_escape_string($objRow->memberName) . "', ";
  $sql .= "'" . mysql_escape_string($objRow->realName) . "', ";

(who knows it might happen again, same procedure, just put it into a mysql_escape_string(bla) function)

[vegatopia]

Thanks for the tip, it worked fine for inserting memebers, topics and posts. But then it stopped when it wanted to gather post texts:

Code Select Expand

Executing: INSERT INTO yabbse_messages ( ID_MSG, ID_TOPIC, ID_MEMBER, posterTime, posterIP ) VALUES ( 56189, 2426, 1, 1029867240, '24.132.154.56' )
Gathering post text info from phpBB...
Sorry to bother you guys again  

[vegatopia]

Other thingie I'm wondering about: can i run the script from a completely fresh yabbse install? What I mean is: I don't have to set up categories and forums first, but it will import categories and forums from the old phpbb-install right?