Finally I can convert phpbb > Fireboard, change the code

Here is my final converter if someone is interested on it.

Luikb wrote:
Finally I can convert phpbb > Fireboard, change the code

Here is my final converter if someone is interested on it.

File Attachment:
File Name: phpbb2fb-40e5251d386a24103e0a2bcf571714c1.zip
File Size: 4019

What's the difference with the one earlier posted in this thread?

Basically my users was taken from the joomla users, because I had not php users

This was the original (changing user_id for id)


// Read all users from phpBB2
$query="SELECT u.*, b.ban_userid FROM {$phpbb_dbprefix}users AS u LEFT OUTER JOIN {$phpbb_dbprefix}banlist AS b ON u.id = b.ban_userid WHERE id > 0 ORDER BY u.id";
$result = mysql_query($query) or die("Invalid query:$query" . mysql_error());

This is mine


// Read all users from phpBB2
$query="SELECT u.*, b.ban_userid FROM {$mosConfig_dbprefix}users AS u LEFT OUTER JOIN {$phpbb_dbprefix}banlist AS b ON u.id = b.ban_userid WHERE id > 0 ORDER BY u.id";
$result = mysql_query($query) or die("Invalid query:$query" . mysql_error());

And thats all, some in the fisrt answers suggest change only u.user_id to u.id but in my case it did not work, because the reason I explained before

Aditionally I can say its works fantastic, I have sorrund 2,800 users and 9000 posts.

tried your script before your reply, I get the same error as before. Now that I read this I'm aware I cannot use this script since for me the phpbb users are important.
By the way I saw login information in your script, I hope dat it is not the actual login information you use for your mySQL database?

OK for anyone who's had dramas (loss of posters names, linking to messages etc. - see my previous posts) converting to FB from PHPBB here's how I solved it - albeit the "obvious" long way round...

Install SMF
Convert PHPBB to SMF
Run converter SMF to FB - DONE!
The only problem I had was the "Views" all returned to zero. Small price to pay as far as I'm concerned. I'm sure someone could figure it out here.

At last no more dodgy Bridges!!!

Cheers.

HEY ! nice idea rapid... but what smf>phpbb convertor did you use? can you please post it here. I really could care less about the views if it really works!

oh yea I had a few more questions:
1) I noticed the log in box is on the Joomla page and this forum page... Is that "sync'd" automatically when I install fireboard or is there some script that will do it?
2) what if I don't want a Joomla hompage... I just want the users to go straight to the forums...

Thanks guys~

tokyo_suicide wrote:
HEY ! nice idea rapid... but what smf>phpbb convertor did you use? can you please post it here. I really could care less about the views if it really works!

Download SMF HERE

PHPBB2 to SMF converter is HERE
SMF Convert Instructions:
"To use these converters simply upload the contents of the archive to your SMF directory and execute convert.php."

SMF to FB HERE
Copy your new SMF database to Joomla. Open mysql.php in the Zip and add your details and upload to a folder e.g. (www.yoursite/convert). Then run the index file (www.yoursite/convert/index.php)
That should do it - took me about 20-30 mins with searching and downloading. So for you 15mins!


1) I noticed the log in box is on the Joomla page and this forum page... Is that "sync'd" automatically when I install fireboard or is there some script that will do it?
It's sync'd.

2) what if I don't want a Joomla hompage... I just want the users to go straight to the forums...
I think this is locked to the Front Page Component?

wow thanks for the fast response Rapid.. what is the front page component?

hey any please help quickly- my forum is down...

i tried going from phpbb>smf and got this error:

[code:1]Converting topics... Unsuccessful!
This query:
INSERT INTO `tokyo_suicide`.smf_topics
(ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
VALUES ('3', '0', '3', '4171', '4', '818', '3', '', '0', '1', '163'),
('4', '0', '4', '4', '4', '4', '35', '', '0', '0', '14'),
('6', '0', '7', '7', '2', '2', '35', '', '0', '0', '8'),
('7', '0', '8', '8', '2', '2', '35', '', '0', '0', '11'),
('8', '0', '9', '9', '2', '2', '35', '', '0', '0', '6'),
('9', '0', '10', '10', '2', '2', '35', '', '0', '0', '6'),
[i]*The string of numbers continues really long...*[/i]

Caused the error:

Duplicate entry '3' for key 1[/code:1]

Best place for support with this issue is on SMF.
Here's a thread that should help -> www.simplemachines.org/community/index.php?topic=85064.0