return false;
}
if ($GLOBALS['sys_require_unique_email']) {
- if (db_numrows(db_query("SELECT user_id FROM users WHERE email='$email' OR email_new='$email'")) > 0) {
+ if (db_numrows(db_query("SELECT user_id FROM users WHERE email ILIKE '$email' OR email_new LIKE '$email'")) > 0) {
$this->setError(_('User with this email already exists - use people search to recover your login.'));
return false;
}
}
if ($GLOBALS['sys_require_unique_email']) {
- if (db_numrows(db_query("SELECT user_id FROM users WHERE email='$email' OR email_new='$email'")) > 0) {
+ if (db_numrows(db_query("SELECT user_id FROM users WHERE email ILIKE '$email' OR email_new ILIKE '$email'")) > 0) {
$this->setError(_('User with this email already exists.'));
return false;
}