IPB 2.3.x to phpBB 3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Ideas Centre
Locked
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: IPB 2.3.x to phpBB 3

Post by D¡cky »

Vampire1812,

You will need to use auth_ipb.php for the phpbB3 board. It is supposed to work for those who have logged in to phpbB2 and those who have not.

One of these versions should work,
http://www.phpbb.com/community/viewtopi ... 5#p6566735
http://www.phpbb.com/community/viewtopi ... 5#p6640865
Have you hugged someone today?

Vampire1812
Registered User
Posts: 31
Joined: Fri Sep 12, 2008 1:04 pm

Re: IPB 2.3.x to phpBB 3

Post by Vampire1812 »

Dicky there is no way around doing that? I want to dump the IPB tabels completly. Is there not a way to inject your mod into the phpbb3 script for logging in? Your script for phpbb2 converts users and the PHPbb3 script does not.

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: IPB 2.3.x to phpBB 3

Post by D¡cky »

It is possible to drop the IPB tables. The salt field would have to be added to the phpBB3 and the values copied over from IPB. You should be able to do this manually, you just have to be careful, because some user_ids do get changed. Then the auth_ipb.php can be rewritten to look for the new salt field.
Have you hugged someone today?

Vampire1812
Registered User
Posts: 31
Joined: Fri Sep 12, 2008 1:04 pm

Re: IPB 2.3.x to phpBB 3

Post by Vampire1812 »

Dicky,

Thats over my head :) I am looking through the IPB tables and see no salt table. I guess what I do not understand is why is it not possible to have the auth_db.php script function like the login.php script and just convert the passwords on the fly?

Let me thank you for your replies. I do apperciate that you are taking the time to answer my questions. :)

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: IPB 2.3.x to phpBB 3

Post by D¡cky »

The salt is in the ibf_members_converge table, converge_pass_salt.

The transferring of the salt field could be added to the convertor, but if you have already done the conversion and can't do another one, the salt field will have to be transferred manually.
Have you hugged someone today?

Vampire1812
Registered User
Posts: 31
Joined: Fri Sep 12, 2008 1:04 pm

Re: IPB 2.3.x to phpBB 3

Post by Vampire1812 »

I can reconvert it. I am not going live for probably a month. I am doing this all offile with replicated data.

Would there be a place to put it in the PHPBB2-->PHPBB3 converter?

Vampire1812
Registered User
Posts: 31
Joined: Fri Sep 12, 2008 1:04 pm

Re: IPB 2.3.x to phpBB 3

Post by Vampire1812 »

Dicky,

Can you tell me what I need to add to the conversion scripts to get the salt over?

Let me aks you this insted.

Say I orginally had a IPB board but converted it to PHPBB2 Then did not have the IPB database anymore since everything was working correctly in PHPBB2. I then decided to download and install PHPBB3. I run the conversion script that is supplied in the install but none of my users are able to login because they can not supply a password. How would I convert a PHPBB2 upgrade to PHPBB3 where my users did not have to request a new password?

When I look at the PHPBB2 Database the SALT field is in the phpbb_users. So are you saying that I need to find where in the conversion scripts that the field phpbb_users is not pulling the salt field?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: IPB 2.3.x to phpBB 3

Post by D¡cky »

The easy way is to create the salt table in the phpBB3 database before you convert. Using phpMyAdmin, enter this query into the sql window. If your phpBB3 table prefix is not phpbb_, change to your phpBB3 table prefix.

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_passwd_salt` VARCHAR( 5 ) NULL ;
OPEN convert_phpbb20.php
FIND

Code: Select all

				array('user_password',			'users.user_password',				''),
AFTER, ADD

Code: Select all

				array('user_passwd_salt',		'users.salt',						''),
Make sure the auth_method in the phpB3 config table is set to ipb
Use the attached auth_ipb.php file
Attachments
auth_ipb.zip
This script is for ipb > phpBB2 > phpBB3 conversions.
(1.87 KiB) Downloaded 104 times
Have you hugged someone today?

Vampire1812
Registered User
Posts: 31
Joined: Fri Sep 12, 2008 1:04 pm

Re: IPB 2.3.x to phpBB 3

Post by Vampire1812 »

I just wanted to say Thank you to Dicky. Huge help!

geewhzz
Registered User
Posts: 8
Joined: Sat May 24, 2008 6:17 am

Re: IPB 2.3.x to phpBB 3

Post by geewhzz »

hey dicky, thanks for helping everyone out here.
so i was able to use your script now. it all worked. however, a few things seem odd. i tried to make a list.
  • custom member titles are missing
  • bbcodes other than very basic text formatting tags have turned into some weird html code that the board cannot work.
  • avatars are missing
  • pms appear to be there but they don't show up properly in the ucp
  • polls are missing
  • attachments are missing
could you perhaps confirm if any of the above is normal or if something went wrong during the conversion?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: IPB 2.3.x to phpBB 3

Post by D¡cky »

I can understand that possibly not all the html code in posts got converted to bbcodes, but it looks like the rest should have worked. You will need to look around and see why the rest is not working, particularly ranks, avatars and attachments.
Have you hugged someone today?

furqaan
Registered User
Posts: 10
Joined: Wed May 16, 2007 12:48 pm

Re: IPB 2.3.x to phpBB 3

Post by furqaan »

my attachments forums and passwords are not converted.
members are in phpbb users but 0 in the forum
i dont find any table named auth_method in config value.

please solve this problem
i am using wampserver

User avatar
~Ivy
Registered User
Posts: 28
Joined: Fri Apr 06, 2007 2:07 pm
Location: Croatia, Europe
Contact:

Re: IPB 2.3.x to phpBB 3

Post by ~Ivy »

I just wanted to say I used this convertor, and except the quotes and some problems with signatures, it worked okay! I don't mind passwords being messed up, I warned my members about it. Thanks a lot for this converter!

hey
Registered User
Posts: 34
Joined: Fri Oct 24, 2008 11:59 am

Re: IPB 2.3.x to phpBB 3

Post by hey »

Is it Works With 3.0.2?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: IPB 2.3.x to phpBB 3

Post by D¡cky »

Yes, this convertor will work with phpBB 3.0.2
Have you hugged someone today?

Locked

Return to “[3.0.x] Convertors”