public function prepareThreadFetchOptions(array $fetchOptions) { $result = parent::prepareThreadFetchOptions($fetchOptions); extract($result); if (!empty($fetchOptions['BRMS_fetch_user'])) { $selectFields .= ', user.user_group_id , user.display_style_group_id , user.is_banned'; $joinTables .= ' LEFT JOIN xf_user AS user ON (user.user_id = thread.user_id)'; } if (!empty($fetchOptions['BRMS_join_last_post'])) { $selectFields .= ', last_post_user.user_group_id , last_post_user.display_style_group_id , last_post_user.is_banned'; $joinTables .= ' LEFT JOIN xf_user AS last_post_user ON (last_post_user.user_id = thread.last_post_user_id)'; } return compact('selectFields', 'joinTables', 'orderClause'); }
public function prepareThreadFetchOptions(array $fetchOptions) { $result = parent::prepareThreadFetchOptions($fetchOptions); extract($result); if (!empty($fetchOptions['ModernStatistic_join_forum'])) { $selectFields .= ', node.node_id AS forum_id, node.title AS forum_title'; $joinTables .= ' INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id)'; } if (!empty($fetchOptions['ModernStatistic_join_last_post'])) { $selectFields .= ', user.*, IF(user.username IS NULL, thread.username, user.username) AS username'; $joinTables .= ' LEFT JOIN xf_user AS user ON (user.user_id = thread.last_post_user_id)'; } return compact('selectFields', 'joinTables', 'orderClause'); }