Board3

portal/block/recent.php
Find

$sql_where .= ' AND forum_id <> ' . trim($id);

Replace With

$sql_where .= ' AND t.forum_id <> ' . trim($id);

The Find specified by the MOD could not be found


Find
//
// Recent announcements
//
$sql = 'SELECT topic_title, forum_id, topic_id
FROM ' . TOPICS_TABLE . '
WHERE topic_status <> ' . FORUM_LINK . '
AND topic_approved = 1
AND ( topic_type = ' . POST_ANNOUNCE . ' OR topic_type = ' . POST_GLOBAL . ' )
AND topic_moved_id = 0
' . $sql_where . '
ORDER BY topic_time DESC';

Replace With

//
// Recent announcements
//
$sql = 'SELECT t.topic_title, t.forum_id, t.topic_id, pt.post_text
FROM ' . TOPICS_TABLE . ' t
LEFT JOIN ' . POSTS_TABLE . ' pt
ON pt.post_id = t.topic_first_post_id
WHERE t.topic_status <> ' . FORUM_LINK . '
AND t.topic_approved = 1
AND ( t.topic_type = ' . POST_ANNOUNCE . ' OR t.topic_type = ' . POST_GLOBAL . ' )
AND t.topic_moved_id = 0
' . $sql_where . '
ORDER BY t.topic_time DESC';

The Find specified by the MOD could not be found