Integration with vBulletin - phpBB3Auth - Migrate phpBB3 user/password to VB4

For all the phpBB3 administrators who want to migrate their phpBB3 to VB4 and hate the idea that the users have to use the "Forgotten your password?" method to logon to the new VB4 board.

The idea heavily borrowed from the ipbAuth mod created by viarun.

The solution I implemented is that I first hash the password the phpBB3 way and check the hashed password against the entry in phpbb3.users table. When the hashes are the same I use the normal VB4 method to store the password in the VB4 database.

Because I don't like to destroy the original phpBB3.users table I added an extra field "PWD_Synced" to the table and use that field to remember that a password was already synced.

We are running this mod on our brand new VB4 forum http://www.astroforum.nl and it work perfect. 330+ phpBB3 users already migrated their password to the new board.

Many thanks to viarun and malcolmx in his LDAP Auth Plugin. THANKS guys!

Installation instructions:

• Add the field "PWD_Synced" in the phpBB3 table phpbb_users. You can use the following statement.
  "ALTER TABLE `phpbb_users` ADD `PWD_Synced` BOOL NOT NULL DEFAULT '0';"
• copy phpBB3Auth directory to your vb forum installation directory
• change the path to controller.php directory in phpBB3-plugin.xml
• copy the hooks_phpBB3.xml to FORUM_ROOT/inclucdes/xml directory
• in login.php do:
  search for:
  

        if ($vbulletin->GPC['vb_login_username'] == '')
           {
            eval(standard_error(fetch_error('badlogin', $vbulletin->options['bburl'], ....
           }

  insert below:
  

        ($hook = vBulletinHook::fetch_hook('phpBB3_login_hook')) ? eval($hook) : false;

• activate plugin system (if not done already) in admincp
• in admin cp import the product file "phpBB3-plugin.xml" at "Download / Upload" Plugins
• re-check if the include for controller.php is right
• in includes/class_bootstrap.php search for:
  

  $show['nopasswordempty']

  change:

  defined('DISABLE_PASSWORD_CLEARING') ? 1 : 0;

  to:

  defined('DISABLE_PASSWORD_CLEARING') ? 0 : 1;

• test the product

Important information

In my documentation I forgot too mention that it is best to install the plug-in after you migrated the data from phpBB3 to VB4. You can leave the phpBB3 database on-line and when you go live the users start to login on VB4 and automagically the password gets migrated to VB4.

Detailed installation instructions and all files needed are in the zip file.

Have fun with it,
MoreLinux

[Lestat_]

this is heaven ! thank you so much mate, you saved me lots and lots of troubles - works excellent, this was the final step I needed to make the transition from phpbb to vbulletin - thank you, you saved my day

[Tracyf]

Ok so I installed this and i cannot get it to work.

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host '<host>' (1) in [path]/phpBB3Auth/controller.php on line 99
Unable to connect to DB: Unknown MySQL server host '' (1)

What does this mean and how do I fix it?

EDIT: Nevermind I got it right after this post

[thetgc]

+1 for being added to impex... this would have helped me when i migrated 2 years ago!

[Alright_Guys!]

Thanks for your code.
I just picked out some lines to help me coding a password updater. Works great!

[CPTA]

it this working?

[Thomasmp]

amazing

[Mr GRiM]

I wish I knew about this mod a couple of months ago, Impex sucks and I have lots so many many members because this wasn't included

[kisanjong]

excellant - thankyou

Originally Posted by Alright_Guys!

I just picked out some lines to help me coding a password updater. Works great!

sounds interesting please explain this more

[VictoriaS]

Hi, sorry if I'm being a bit dim but I don't understand this:

'copy phpBB3Auth directory to your vb forum installation directory
change the path to controller.php directory in phpBB3-plugin.xml'

Is the phpBB3Auth directory the folder called 'auth' that sits within the includes directory on phpbb? If so do I copy across the whole of that folder to my vBulletin installation inside the 'install' folder or somewhere else?

Where then do I need to put:

phpBB3_functions.php
phpBB3config.inc.php
controller.php

I'm fine with the rest of it. Any help anyone can give would be much appreciated!

Thanks,

Victoria

[VictoriaS]

Bump!

Can anyone shed any light on this please?