diff options
| author | 3D-I <marktravai@gmail.com> | 2018-12-01 04:35:45 +0100 |
|---|---|---|
| committer | 3D-I <marktravai@gmail.com> | 2018-12-01 04:36:16 +0100 |
| commit | 8b4c77784e9bd1788244b19966802c61947f18aa (patch) | |
| tree | 2e5bc2604f486f38e7259137057273ef2fb755e5 /phpBB | |
| parent | db7f4d4c9523e5dc36c62ec6fe647aaf7708daaa (diff) | |
| download | forums-8b4c77784e9bd1788244b19966802c61947f18aa.tar forums-8b4c77784e9bd1788244b19966802c61947f18aa.tar.gz forums-8b4c77784e9bd1788244b19966802c61947f18aa.tar.bz2 forums-8b4c77784e9bd1788244b19966802c61947f18aa.tar.xz forums-8b4c77784e9bd1788244b19966802c61947f18aa.zip | |
[ticket/15890] Add core.memberlist_modify_viewprofile_sql
PHPBB3-15890
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/memberlist.php | 28 |
1 files changed, 25 insertions, 3 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index 977857da59..13cb3b96d5 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -489,9 +489,31 @@ switch ($mode) } // Get user... - $sql = 'SELECT * - FROM ' . USERS_TABLE . ' - WHERE ' . (($username) ? "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "user_id = $user_id"); + $sql_array = array( + 'SELECT' => 'u.*', + 'FROM' => array( + USERS_TABLE => 'u' + ), + 'WHERE' => (($username) ? "u.username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : "u.user_id = $user_id"), + ); + + /** + * Modify user data SQL before member profile row is created + * + * @event core.memberlist_modify_viewprofile_sql + * @var int user_id The user ID + * @var string username The username + * @var array sql_array Array containing the main query + * @since 3.2.6-RC1 + */ + $vars = array( + 'user_id', + 'username', + 'sql_array', + ); + extract($phpbb_dispatcher->trigger_event('core.memberlist_modify_viewprofile_sql', compact($vars))); + + $sql = $db->sql_build_query('SELECT', $sql_array); $result = $db->sql_query($sql); $member = $db->sql_fetchrow($result); $db->sql_freeresult($result); |