Invision Power Services > Getting the passwords working from a MD5-only DB

Full Version: Getting the passwords working from a MD5-only DB

Invision Power Services > Community Forums > Community General Chat

Domen Lombergar

Mar 8 2005, 10:41 PM

Hi there.

Me and my friends are doing a custom conversion from LDU to IPB copying all members and forums. We managed to copy all the users and their information successfully and all the forums to some extent (we are working on the forums), but now we have encountered a MAJOR setback.

The passwords.

LDU uses a regular MD5 encrypted password, but IPB uses one heck of a weird sense for storing these.

Now my question would be the following:

Which of the conversion tools can take a normal MD5 password and generate a IPB-compatible one?

Thanks so much for the reply.

Chroder

Mar 9 2005, 04:22 AM

So they are already MD5'd once? From looking into class_converge.php, the passwords for IPB are:

CODE

md5( md5( salt ) . md5( password ) )

So, for each user you have to generate their random salt and md5 it with their already MD5'd password.

CODE

$ipb_pass = md5( md5($salt) . $hashed_password );

Or if you have everything in the database already, a simple query could do it.

SQL

UPDATE members_converge SET converge_pass_hash = MD5( CONCAT( MD5(converge_pass_salt), "<<original password>>" ) )

Domen Lombergar

Mar 10 2005, 03:11 PM

Thank you, works like a charm.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.