diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2015-05-08 11:16:40 +0200 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2015-05-08 11:16:40 +0200 |
| commit | 7f5f5c216bc54eab3259bd0b7560a0b324d01841 (patch) | |
| tree | 578064fb1ceba18eb3b48f9be9f156f1a6e5e9c4 | |
| parent | d741ab57a82f52cca00cc105096d9e8887d4065d (diff) | |
| parent | b0f5ef0b1a39a587cf00c4f4e4cba66c81202351 (diff) | |
| download | forums-7f5f5c216bc54eab3259bd0b7560a0b324d01841.tar forums-7f5f5c216bc54eab3259bd0b7560a0b324d01841.tar.gz forums-7f5f5c216bc54eab3259bd0b7560a0b324d01841.tar.bz2 forums-7f5f5c216bc54eab3259bd0b7560a0b324d01841.tar.xz forums-7f5f5c216bc54eab3259bd0b7560a0b324d01841.zip | |
Merge pull request #3529 from rxu/ticket/13752
[ticket/13752] Add viewonline.php core event to allow modifying forum data SQL
| -rw-r--r-- | phpBB/viewonline.php | 24 |
1 files changed, 20 insertions, 4 deletions
diff --git a/phpBB/viewonline.php b/phpBB/viewonline.php index 9589fb54e2..583e297682 100644 --- a/phpBB/viewonline.php +++ b/phpBB/viewonline.php @@ -86,10 +86,26 @@ if ($mode == 'whois' && $auth->acl_get('a_') && $session_id) } // Forum info -$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id - FROM ' . FORUMS_TABLE . ' - ORDER BY left_id ASC'; -$result = $db->sql_query($sql, 600); +$sql_ary = array( + 'SELECT' => 'f.forum_id, f.forum_name, f.parent_id, f.forum_type, f.left_id, f.right_id', + 'FROM' => array( + FORUMS_TABLE => 'f', + ), + 'ORDER_BY' => 'f.left_id ASC', +); + +/** +* Modify the forum data SQL query for getting additional fields if needed +* +* @event core.viewonline_modify_forum_data_sql +* @var array sql_ary The SQL array +* @since 3.1.5-RC1 +*/ +$vars = array('sql_ary'); +extract($phpbb_dispatcher->trigger_event('core.viewonline_modify_forum_data_sql', compact($vars))); + +$result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary), 600); +unset($sql_ary); $forum_data = array(); while ($row = $db->sql_fetchrow($result)) |