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