Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
Re:phpBB (1 viewing) (1) Guest
Go to bottom Favoured: 8
TOPIC: Re:phpBB
#9814
Re:phpBB 1 Year, 5 Months ago  
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
Luikb (User)
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Monterrey, Mexico Birthdate: 1977-10-20
Logged Logged
 
Last Edit: 2007/06/02 23:38 By Luikb.
 
Greeting
Luis Morales
www.aportacionesfiscales.com
luikb.morales@gmail.com
member of www.joomlamexico.org.mx

PD An apologize for my bad english
 
The administrator has disabled public write access.  
#9820
Re:phpBB 1 Year, 5 Months ago  
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?
hiddink (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#9826
Re:phpBB 1 Year, 5 Months ago  
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.
Luikb (User)
Fresh Boarder
Posts: 14
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Monterrey, Mexico Birthdate: 1977-10-20
Logged Logged
 
Last Edit: 2007/06/03 03:43 By Luikb. Reason: Adition a commentary
 
Greeting
Luis Morales
www.aportacionesfiscales.com
luikb.morales@gmail.com
member of www.joomlamexico.org.mx

PD An apologize for my bad english
 
The administrator has disabled public write access.  
#9828
Re:phpBB 1 Year, 5 Months ago  
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?
hiddink (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#9850
Re:phpBB 1 Year, 5 Months ago  
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.
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/06/03 06:41 By Rapid.
 
The administrator has disabled public write access.  
#9875
Re:phpBB 1 Year, 5 Months ago  
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 (User)
Junior Boarder
Posts: 31
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#9876
Re:phpBB 1 Year, 5 Months ago  
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?
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/06/03 10:26 By Rapid.
 
The administrator has disabled public write access.  
#9877
Re:phpBB 1 Year, 5 Months ago  
wow thanks for the fast response Rapid.. what is the front page component?
tokyo_suicide (User)
Junior Boarder
Posts: 31
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#9905
Re:phpBB 1 Year, 5 Months ago  
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]
tokyo_suicide (User)
Junior Boarder
Posts: 31
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#9949
Re:phpBB 1 Year, 5 Months ago  
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
Rapid (User)
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top