diff options
| author | Jakub Senko <jakubsenko@gmail.com> | 2016-11-20 18:40:40 +0100 |
|---|---|---|
| committer | Jakub Senko <jakubsenko@gmail.com> | 2016-12-13 11:26:45 +0100 |
| commit | df96351244aad129fd8a45047831d69a54072af3 (patch) | |
| tree | ae9140fb8cd5ee05827376b38679bfd67a223419 | |
| parent | dbd9c1f242ae7c7660feddf2677d41aa82bd21b4 (diff) | |
| download | forums-df96351244aad129fd8a45047831d69a54072af3.tar forums-df96351244aad129fd8a45047831d69a54072af3.tar.gz forums-df96351244aad129fd8a45047831d69a54072af3.tar.bz2 forums-df96351244aad129fd8a45047831d69a54072af3.tar.xz forums-df96351244aad129fd8a45047831d69a54072af3.zip | |
[ticket/14239] Add core.ucp_remind_modify_select_sql
PHPBB3-14239
| -rw-r--r-- | phpBB/includes/ucp/ucp_remind.php | 30 |
1 files changed, 25 insertions, 5 deletions
diff --git a/phpBB/includes/ucp/ucp_remind.php b/phpBB/includes/ucp/ucp_remind.php index 415bf0e84d..29d4199528 100644 --- a/phpBB/includes/ucp/ucp_remind.php +++ b/phpBB/includes/ucp/ucp_remind.php @@ -30,7 +30,7 @@ class ucp_remind function main($id, $mode) { global $config, $phpbb_root_path, $phpEx; - global $db, $user, $auth, $template, $phpbb_container; + global $db, $user, $auth, $template, $phpbb_container, $phpbb_dispatcher; if (!$config['allow_password_reset']) { @@ -43,10 +43,30 @@ class ucp_remind if ($submit) { - $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_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "' - AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'"; + $sql_array = array( + 'SELECT' => 'user_id, username, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason', + 'FROM' => array(USERS_TABLE => 'u'), + 'WHERE' => "user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "' + AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" + ); + + /** + * Change SQL query for fetching user data + * + * @event core.ucp_remind_modify_select_sql + * @var string email User's email from the form + * @var string username User's username from the form + * @var array sql_array Fully assembled SQL query with keys SELECT, FROM, WHERE + * @since 3.1.11-RC1 + */ + $vars = array( + 'email', + 'username', + 'sql_array', + ); + extract($phpbb_dispatcher->trigger_event('core.ucp_remind_modify_select_sql', compact($vars))); + + $sql = $db->sql_build_query('SELECT', $sql_array); $result = $db->sql_query($sql); $user_row = $db->sql_fetchrow($result); $db->sql_freeresult($result); |