Author: cfinck Date: Sat Oct 11 09:28:31 2008 New Revision: 36717
URL: http://svn.reactos.org/svn/reactos?rev=36717&view=rev Log: Remove unneeded LOWER/strtolower calls. The fields are already declared as utf8_unicode_ci, so MySQL automatically compares case-insensitive by default.
Modified: trunk/web/reactos.org/htdocs/roscms/logon/user_register.php
Modified: trunk/web/reactos.org/htdocs/roscms/logon/user_register.php URL: http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/htdocs/roscms/logon... ============================================================================== --- trunk/web/reactos.org/htdocs/roscms/logon/user_register.php [iso-8859-1] (original) +++ trunk/web/reactos.org/htdocs/roscms/logon/user_register.php [iso-8859-1] Sat Oct 11 09:28:31 2008 @@ -61,7 +61,7 @@ // check if another account with the same username already exists $sql_exist_name = "SELECT user_name FROM users - WHERE REPLACE(user_name, '_', ' ') = LOWER(REPLACE('" . mysql_real_escape_string($_POST['username'])."', '_', ' ')) + WHERE REPLACE(user_name, '_', ' ') = REPLACE('" . mysql_real_escape_string($_POST['username'])."', '_', ' ') LIMIT 1;"; $query_exist_name = mysql_query($sql_exist_name); $result_exist_name = mysql_fetch_array($query_exist_name); @@ -73,7 +73,7 @@ // check if the username is equal to a protected name $sql_unsafe_name = "SELECT unsafe_name FROM user_unsafenames - WHERE unsafe_name = '".mysql_real_escape_string(strtolower($_POST['username']))."' + WHERE unsafe_name = '".mysql_real_escape_string($_POST['username'])."' LIMIT 1;"; $query_unsafe_name = mysql_query($sql_unsafe_name); $result_unsafe_name = mysql_fetch_array($query_unsafe_name);