Hi,
I have a bulletin board running - yabbSE that works with mySQL and php.

I want to enable my site users to only register once instead of signing up with my site then registering on the board. The passwords as saved in a binary field in mySQL.

If i can find out how to save the password in the binary format and get it back out, i can update both my member table and the boards table so they only have to register once.

Any ideas?

Will Tim's latest authentication suite solve this issue?

No my Authentication extras suite won't resolve this issue.

This took a little bit of digging to actually work out how the passwords were encrypted.

However, I found the actual algorithm in the yabbSE source code. The way they do it is like this:-

$cryptedPassword = crypt($password,substr($password,0,2));

Where $password contains the actual password that was entered. You should remember though, that this algorithm will need to be used both for insertion and validation.

I hope this helps.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Thanks Tim. I'll play around with it and see what happens.