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');
}
