diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2015-10-08 16:53:08 +0200 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2015-10-08 16:53:08 +0200 |
| commit | 6360d748db655e615c0faec1cf939d7cfbe60600 (patch) | |
| tree | 447fcd26223f79aea5eb7602aaeab3c52392338f | |
| parent | 7a60cdd1d324609b95865673d3204598a0078c38 (diff) | |
| parent | e5b895de7b359b3e1a4c15ae23ca3f8f114bbb6f (diff) | |
| download | forums-6360d748db655e615c0faec1cf939d7cfbe60600.tar forums-6360d748db655e615c0faec1cf939d7cfbe60600.tar.gz forums-6360d748db655e615c0faec1cf939d7cfbe60600.tar.bz2 forums-6360d748db655e615c0faec1cf939d7cfbe60600.tar.xz forums-6360d748db655e615c0faec1cf939d7cfbe60600.zip | |
Merge pull request #3844 from rxu/ticket/14113
[ticket/14113] Add core events for customizing members search
| -rw-r--r-- | phpBB/memberlist.php | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index e64dab635b..3e0a9438ea 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -1025,6 +1025,23 @@ switch ($mode) FROM ' . POSTS_TABLE . ' WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips) AND " . $db->sql_in_set('forum_id', $ip_forums); + + /** + * Modify sql query for members search by ip address / hostname + * + * @event core.memberlist_modify_ip_search_sql_query + * @var string ipdomain The host name + * @var string ips IP address list for the given host name + * @var string sql The SQL query for searching members by IP address + * @since 3.1.7-RC1 + */ + $vars = array( + 'ipdomain', + 'ips', + 'sql', + ); + extract($phpbb_dispatcher->trigger_event('core.memberlist_modify_ip_search_sql_query', compact($vars))); + $result = $db->sql_query($sql); if ($row = $db->sql_fetchrow($result)) @@ -1165,6 +1182,32 @@ switch ($mode) $order_by .= ', u.user_posts DESC'; } + /** + * Modify sql query data for members search + * + * @event core.memberlist_modify_sql_query_data + * @var string order_by SQL ORDER BY clause condition + * @var string sort_dir The sorting direction + * @var string sort_key The sorting key + * @var array sort_key_sql Arraty with the sorting conditions data + * @var string sql_from SQL FROM clause condition + * @var string sql_select SQL SELECT fields list + * @var string sql_where SQL WHERE clause condition + * @var string sql_where_data SQL WHERE clause additional conditions data + * @since 3.1.7-RC1 + */ + $vars = array( + 'order_by', + 'sort_dir', + 'sort_key', + 'sort_key_sql', + 'sql_from', + 'sql_select', + 'sql_where', + 'sql_where_data', + ); + extract($phpbb_dispatcher->trigger_event('core.memberlist_modify_sql_query_data', compact($vars))); + // Count the users ... if ($sql_where) { |