Authentication

Hi,

I am not sure if this is the best place to post this or not, but since this area is devoted to external database authentication, I figured it was worth a try. I am working on an authentication option where Moodle looks to an external MS SQL database table to retrieve user name and password information.

Unfortunately, the password is encrypted in this table and not with one of the usual standard hashes. There is a stored procedure in my MS SQL database called sp_web_login which is used to authenticate the password entered by the user against the password in the table. What I think needs to happen is I need to tell the Moodle auth.php file to call that same script to match the user entered password with the hashed password in the table.

The only problem is I have very little idea how to do this in the php file. I've added a call to the stored procedure, but I doubt it is in the right place. Can someone take a look and point me in the right direction?

Any suggestions would be great. I am attaching the auth.php file below.

Thanks in advance,
Janet