Password Encrypt/Decrypt

[WoWCFXML]

Im working on the login and followed http://tutorial8.easycfm.com/. It works for me, however when I try to login and put my password, it will not take. It only recognize the characted in the database which are encrypted.

For example:
My login:
User_name: admin
user_pass: normalpassword

In the database:
User_name: admin
user_pass Hz345Yu89765abc

My login only will take the password in the database and not recognize my normal password when i enter.

Here is the same code I have in my site which I took from http://tutorial8.easycfm.com/:

[Daverms]

Hi,

Can you confirm that your "tblAdmins" table's fields are of the same datatypes that has been given in that tutorial?.

[WoWCFXML]

yes, infact. I can login using the encrypted password from the table.

So I did little research and found out that the password was in MD5 and utf8_to_cp1252. So how can I convert my regular password to MD5, so it will equal to my plain text password.

[WoWCFXML]

yes, infact. I can login using the encrypted password from the table.

So I did little research and found out that the password was in MD5 and utf8_to_cp1252. So how can I convert my regular password to MD5, so it will equal to my plain text password.

[Daverms]

You can do it using this UDF,

http://cflib.org/udf/MD5