[imp] case sensitivity with login

Josh Trutwin josh at trutwins.homeip.net
Fri Jul 9 20:10:01 PDT 2004


On Fri, 9 Jul 2004 18:31:18 -0700 (PDT)
Kris Efland <kris_efland at yahoo.com> wrote:

<snip>

> my question is, is there a way to modify the sql.php so that the
> select statements are using a tolower command or similar so that all
> queries coming into sql are lowercase?

Find the MySQL query and use something like:

SELECT whatever FROM auth_table
WHERE LOWER('$username_from_login_page') = LOWER(mysql_username_field);

This is a complete random guess at the actual SELECT query, but it should do the job if you can locate it.

Josh


More information about the imp mailing list