Can you help clarify the case sensitivity of DX_Auth 1.0.6?
I have a user in the users table called john. If I try to register a new account with John (capital J) I get the message that the username is already taken.
I have a user in the userstemp table called aaaa. If I try to register a new account with AAAA a new record for AAAA is added to userstemp.
In the first example it appears that the username is case sensitive but in the 2nd case it’s not. Why is there a discrepancy?
Along those same lines I have a user in userstemp called bill with email .(JavaScript must be enabled to view this email address). If I try to register a new account with pete and email .(JavaScript must be enabled to view this email address) (same email, uppercase T) the account is accepted. This wasn’t the result I was expecting since email addresses are case insensitive.
Would these two cases be considered bugs?
Thanks for the work on this library! It’s saved me alot of work!
[Update]
If you open the models/dx_auth/user_temp.php file and search for check_username and check_email methods replace the db->where statements with the following:
check_username:
$this->db->where(‘LOWER(username)=’, strtolower($username));
check_email:
$this->db->where(‘LOWER(email)=’, strtolower($email));
Since this is a change to the lib itself you may lose changes if there’s an upgrade.
[/Update]