Allowing either email address or username, and password for login credentials on v2.53 back end

Hi Jerry,

I can't think of any way to do this without editing the library file as it will get overwritten when you upgrade the cmsb. So if you're going to try the steps below, please make sure that when you upgrade/downgrade your cmsb version, remember to do the same thing again or make a back up copy.

The library file that you need to edit is \cmsAdmin\lib\login_functions.php.

Look for the getCurrentUser() and inside that function, you will find this block of conditional if code:

if ($username && $passwordHash) {
    //$userFound    = mysql_get(accountsTable(), null, array('username' => $username));
    $userFound    = mysql_get(accountsTable(), null, 'username = "'.mysql_escape($username).'" OR email = "'.mysql_escape($username).'"');
    $isValidLogin = $userFound && ($passwordHash == getPasswordDigest($userFound['password']));
    if ($isValidLogin) { $user = $userFound; }
  }

Add a new line of code (blue color in the code above) and comment out the original one (red color in the code above).

Let us know if that works for you.

Cheers,

Thanks Daryl,

I'll give it a try in the morning.

I'm sure it will work just perfectly.

Jerry Kornbluth

Hi Jerry

Another option here is you could modify your signup page so that it only asks for an email address. When a new member signs up, their email address becomes their username as well. This way, they only have one thing to remember.

For the accounts that have already been setup, you can do a quick SQL update to copy the email addresses to the usernames for all accounts.  What do you think?

We can help you with either part via consulting.

Hi, Ross,

That would make it KISS simple.

I guess I could put in some error checking code to insure a validly formed email address was entered, and then insert the same information in the email field in new accounts.

I'll see if the client wants to go for the importing of email addresses into the username field.

Thanks,

Jerry