diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2016-12-17 16:20:29 +0100 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2016-12-17 16:20:29 +0100 |
| commit | 3c223b3a5d87a4bf7ecf623879398689842b0227 (patch) | |
| tree | 5fb8dd2eb756c3b05abcca15dbb47ed6421d8db7 /phpBB/includes | |
| parent | daee389e531c78accdb923e86b1577ecb34ee94c (diff) | |
| parent | df96351244aad129fd8a45047831d69a54072af3 (diff) | |
| download | forums-3c223b3a5d87a4bf7ecf623879398689842b0227.tar forums-3c223b3a5d87a4bf7ecf623879398689842b0227.tar.gz forums-3c223b3a5d87a4bf7ecf623879398689842b0227.tar.bz2 forums-3c223b3a5d87a4bf7ecf623879398689842b0227.tar.xz forums-3c223b3a5d87a4bf7ecf623879398689842b0227.zip | |
Merge pull request #4526 from senky/ticket/14239
[ticket/14239] Add core.ucp_remind_modify_select_sql
Diffstat (limited to 'phpBB/includes')
| -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); |