Darren Kemp wrote:
Unfortunately the original system was setup
using mysql password encryption. (password=password('password')) Since
there is no way (that i have found) to decrypt a mysql password in php
or encrypt a password in php using mysql encryption I have been having
some struggles getting this to work. (as is we are comparing a
cleartext password to an encrypted password in the code).
I don't know MySQL Select statements in gory detail, but doesn't it
support something like
SELECT password('cleartextPsw') as encUserPsw
Then just compare the encrypted versions for a match.
Mike