// Forum Topics
//
if (isset($items[UH_T]))
{
$sql = 'SELECT t.*, f.forum_alias, f.forum_id, f.forum_name, p.post_id, p.post_username, p.post_time, m.user_id, m.username, m.username_base
FROM _members_unread u, _forums f, _forum_topics t, _forum_posts p, _members m
WHERE u.user_id = ?
AND f.forum_id NOT IN (??)
AND u.element = ?
AND u.item = t.topic_id
AND t.topic_id = p.topic_id
AND t.topic_last_post_id = p.post_id
AND t.forum_id = f.forum_id
AND p.poster_id = m.user_id
ORDER BY t.topic_announce DESC, p.post_time DESC';
$result = sql_rowset(sql_filter($sql, $user->data['user_id'], '22' . forum_for_team_not(), UH_T));
foreach ($result as $i => $row) {
if (!$i) {
_style('items.forums', array(
'ELEMENT' => UH_T)
);
}
$user_profile = $comments->user_profile($row);
_style('items.forums.item', array(
'S_MARK_ID' => $row['topic_id'],
'FOR_MODS' => in_array($row['forum_id'], forum_for_team_array()),
'TOPIC_URL' => s_link('post', $row['post_id']) . '#' . $row['post_id'],
'TOPIC_TITLE' => $row['topic_title'],
private function board() {
global $user, $comments;
$sql = 'SELECT t.*, f.forum_alias, f.forum_id, f.forum_name, p.post_id, p.post_username, p.post_time, m.user_id, m.username, m.username_base
FROM _members_unread u, _forums f, _forum_topics t, _forum_posts p, _members m
WHERE u.user_id = ?
AND f.forum_id NOT IN (??)
AND u.element = ?
AND u.item = t.topic_id
AND t.topic_id = p.topic_id
AND t.topic_last_post_id = p.post_id
AND t.forum_id = f.forum_id
AND p.poster_id = m.user_id
ORDER BY t.topic_announce DESC, p.post_time DESC';
$result = sql_rowset(sql_filter($sql, $user->d('user_id'), '22' . forum_for_team_not(), UH_T));
$response = w();
foreach ($result as $i => $row) {
$user_profile = $comments->user_profile($row);
$response[] = array(
'S_MARK_ID' => $row['topic_id'],
'FOR_MODS' => in_array($row['forum_id'], forum_for_team_array()),
'TOPIC_URL' => s_link('post', $row['post_id']) . '#' . $row['post_id'],
'TOPIC_TITLE' => $row['topic_title'],
'TOPIC_REPLIES' => $row['topic_replies'],
'TOPIC_COLOR' => $row['topic_color'],
'FORUM_URL' => s_link('forum', $row['forum_alias']),
'FORUM_NAME' => $row['forum_name'],
'DATETIME' => $user->format_date($row['post_time']),
'USER_ID' => $row['user_id'],
'USER_PROFILE' => $user_profile['profile'],
'USERNAME' => $user_profile['username']
);
}
return $response;
}
