c5's password encription method

Permalink
I'm in the process of marrying a Wordpress blog and c5's authentication systems through a Wordpress plugin called External DB Authentication (http://wordpress.org/extend/plugins/external-database-authentication/), and it's all working...

except...

I think I haven't selected the correct type of encryption for the passwords. I have SHA1, MD5, and Other as options, where Other requires coding the method. I've tried SHA1 and MD5 to no avail, so I'm turning to the wisdom of the community for further insight.

Thanks again for the help and a great product!

pjhaggerty
 
ScottC replied on at Permalink Reply
ScottC
haven't really messed with it, but it seems pretty straightforward.
pjhaggerty replied on at Permalink Reply
pjhaggerty
Thanks! I appreciate the help.

Plugged in what I thought I should use (i.e. $Password2 = $password_salt), and got an SQL syntax error. Here's the error message (and I quote):

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com FROM Users WHERE uName = 'XXXXXXXXX' AND uPassword = ''' at line 1

(and scene)

Those X's are mine to black out the uName.

So, two steps forward, one step back.