Lowercased login

Cheers. So actually removing the LOWER statement from that string won't cause any problems, if one is wanting to be stringent with regards to username case?

Thanks,

Matt

That, I could live with, if needs be. I'm just unjustifiably pedantic about silly little things like case. On that note about registering, however, another question, if I may? Would replicating the username check in register.php with LOWER as well as UPPER, (running the query twice, as it were), stop that scenario arising? A double lookup there would, I assume, be negligible due to that section not being accessed too frequently?

Thanks again,

Matt

Apologies for keep asking questions, but SQL not being my strongpoint and such. Would that lookup need doing as such, in that case:

$result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE UPPER(username)=UPPER(\''.$db->escape($username).'\') OR UPPER(username)=UPPER(\''.$db->escape(preg_replace('/[^\w]/', '', $username)).'\') OR LOWER(username)=LOWER(\''.$db->escape($username).'\') OR LOWER(username)=LOWER(\''.$db->escape(preg_replace('/[^\w]/', '', $username)).'\')') or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());

or is there a shorthand method, i.e: UPPER/LOWER for that query?

Thanks ever so much once again,

Matt

Cheers. I presume that means I've misinterpreted somewhat exactly what the upper/lower do then?