diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2018-12-29 12:25:52 +0100 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2018-12-29 12:25:52 +0100 |
| commit | 86c773fbf9ecba9074e6fb6c5fa767117ba997ed (patch) | |
| tree | b0f438548b27ca4b0cdf0012759be79a60a346d5 | |
| parent | 3a7d17414dcdf2b4aee2d9d3227ff0b845aad529 (diff) | |
| parent | 8b4c77784e9bd1788244b19966802c61947f18aa (diff) | |
| download | forums-86c773fbf9ecba9074e6fb6c5fa767117ba997ed.tar forums-86c773fbf9ecba9074e6fb6c5fa767117ba997ed.tar.gz forums-86c773fbf9ecba9074e6fb6c5fa767117ba997ed.tar.bz2 forums-86c773fbf9ecba9074e6fb6c5fa767117ba997ed.tar.xz forums-86c773fbf9ecba9074e6fb6c5fa767117ba997ed.zip | |
Merge pull request #5462 from 3D-I/ticket/15890
[ticket/15890] Add core.memberlist_modify_viewprofile_sql
| -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 35472a337f..da60ba1866 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); |