diff options
author | Joas Schilling <nickvergessen@gmx.de> | 2009-08-28 09:26:43 +0000 |
---|---|---|
committer | Joas Schilling <nickvergessen@gmx.de> | 2009-08-28 09:26:43 +0000 |
commit | c52f05b3329c9c79ecbc3184bd65cdbe4644ebcd (patch) | |
tree | 444edeceabcd9527cc5a9946ff11d1d49bf1ecd5 /phpBB/includes/ucp/ucp_remind.php | |
parent | 7cf867419f567e0cf0ab9b4a9fb191ade71df948 (diff) | |
download | forums-c52f05b3329c9c79ecbc3184bd65cdbe4644ebcd.tar forums-c52f05b3329c9c79ecbc3184bd65cdbe4644ebcd.tar.gz forums-c52f05b3329c9c79ecbc3184bd65cdbe4644ebcd.tar.bz2 forums-c52f05b3329c9c79ecbc3184bd65cdbe4644ebcd.tar.xz forums-c52f05b3329c9c79ecbc3184bd65cdbe4644ebcd.zip |
Fix Bug #49195 - Queries on un-indexed column user_email
Added function to generate email-hash.
Authorised by: AcydBurn
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10060 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/ucp/ucp_remind.php')
-rw-r--r-- | phpBB/includes/ucp/ucp_remind.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/includes/ucp/ucp_remind.php b/phpBB/includes/ucp/ucp_remind.php index 6325bf89b6..df6733d038 100644 --- a/phpBB/includes/ucp/ucp_remind.php +++ b/phpBB/includes/ucp/ucp_remind.php @@ -38,7 +38,7 @@ class ucp_remind { $sql = 'SELECT user_id, username, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason FROM ' . USERS_TABLE . " - WHERE user_email = '" . $db->sql_escape($email) . "' + WHERE user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "' AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'"; $result = $db->sql_query($sql); $user_row = $db->sql_fetchrow($result); |