Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Convert phpBB3 passwords to vBulletin 3.8 Details »
Convert phpBB3 passwords to vBulletin 3.8
Mod Version: 1.00, by peterska2 (Member) peterska2 is offline
Developer Last Online: Nov 2013 I like it Show Printable Version Email this Page

vB Version: 3.8.7 Rating: (1 vote - 4.00 average) Installs: 5
Released: 26 Oct 2012 Last Update: Never Downloads: 30
Not Supported Code Changes Additional Files  

Please note: This requires file edits. It is not possible to do this without file edits, so if you are not comfortable doing this, please don't use this and instead follow the standard ImpEx passwords procedure of telling your users to reset their passwords.

Now that I have warned you about that, time to tell you what this actually does (sorry if I ramble a bit, just realized its literally years since I last released any code - which has shocked me slightly).

Here's the situation:

You have a phpBB3 forum.
You want to import the data to vBulletin 3.8
You are reluctant to do so due to requiring all imported users to reset their passwords before logging in and have heard many reports of huge user loss because of this.

Worry no more! With this converter, your users retain their phpBB3 passwords. When they first log into your newly converted vBulletin site, their password is checked against the phpBB3 database. If it matches, then the password is updated in the vBulletin database so that it remains the same password and they are logged in. If they enter an incorrect password, then they receive the standard password incorrect error and are prompted to try again or reset their password.

Please be aware that this does not update any users without them logging in successfully using phpBB3 authentication and removal of this modification will then prevent any users who have not had their passwords converted from retaining their phpBB3 password without going through the standard password resetting procedure.

In the ZIP file there are 3 files, instructions.txt phpBB3Auth/controller.php and phpBB3Auth/phpbb3_functions.php

It is fairly simple. Open instructions.txt and this tells you exactly what to do. Then, upload the files as indicated in the instructions.

There are file edits required to login.php and includes/config.php

If your phpBB3 database has a table prefix other than phpbb_ then you will also need to edit phpBB3Auth/controller.php

The main other requirement is that the phpBB3 users table is in the same database as your vBulletin tables. This does not mean that you need to have the entire phpBB3 database in the same one as vBulletin, but purely just the users table. This is for two reasons:
1. It is easier to code when it is all in the same database
2. It is better for management as depending on the size or activity of your site it may take a while for most members to visit and successfully log in and so you are less likely to accidently delete the table if it is in the same database as your vBulletin forum.

Any problems, let me know and I will try to help. This works successfully for a conversion I am in the process of doing, and if it helps anyone else then that is a bonus.

I will not be updating this for vB4 or later.
It is not tested for use on vB3.7 or earlier.
This is tested on vB3.8.3 and 3.8.7 and so should work on all versions current and future in the 3.8.x series.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 08 Jun 2013, 09:31
Gizmo99 Gizmo99 is offline
 
Join Date: Feb 2002
Works like a charm

BUT

Instructions wrong and missing a step

In Instructions for login.php edits

Find
if ($getimporteduserid['PWD_Synced'] == '0')

Replace with
if ($checkforimportedpw['PWD_Synced'] == '0')

Now we need to add a new column to your phpbb users table
ALTER TABLE phpbb_users MODIFY PWD_Synced varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '0'

Remember it won't work for Admin accounts just change them to none admin get them to loggin THEN make them admin !

Sorted !!

Giz
Reply With Quote
  #3  
Old 26 Oct 2013, 22:13
deverill2010 deverill2010 is offline
 
Join Date: Jan 2011
Originally Posted by Gizmo99 View Post
Works like a charm

BUT

Instructions wrong and missing a step

In Instructions for login.php edits

Find
if ($getimporteduserid['PWD_Synced'] == '0')

Replace with
if ($checkforimportedpw['PWD_Synced'] == '0')

Now we need to add a new column to your phpbb users table
ALTER TABLE phpbb_users MODIFY PWD_Synced varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '0'

Remember it won't work for Admin accounts just change them to none admin get them to loggin THEN make them admin !

Sorted !!

Giz

I've done as the instructions in the zip have said, and also made your change.

Yet I still can't log in (non admin account). Not sure what else to do?
Reply With Quote
  #4  
Old 29 Oct 2013, 22:16
deverill2010 deverill2010 is offline
 
Join Date: Jan 2011
Anyone able to go through this with me?
Reply With Quote
  #5  
Old 04 Oct 2014, 19:20
superj707 superj707 is offline
 
Join Date: Sep 2014
would you be able to make one for SMF to VB4?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 11:41.

Layout Options | Width: Wide Color: