From 8a78d0d512217a1c15a04508fce2d5bcb61302e7 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Mon, 16 Feb 2004 06:39:29 +0000 Subject: - Bugfix: the forum block was showing posts that are not 'published' yet. --- modules/forum/forum.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/forum/forum.module') diff --git a/modules/forum/forum.module b/modules/forum/forum.module index 6391233e1..7caf894b6 100644 --- a/modules/forum/forum.module +++ b/modules/forum/forum.module @@ -103,7 +103,7 @@ function forum_block($op = 'list', $delta = 0) { if (user_access('access content')) { $content = node_title_list(db_query_range("SELECT n.nid, n.title, GREATEST(n.created, MAX(c.timestamp)) AS sort FROM {node} n LEFT JOIN {comments} c ON n.nid = c.nid WHERE n.type = 'forum' AND n.status = 1 GROUP BY n.nid, n.title, n.created ORDER BY sort DESC", 0, variable_get('forum_block_num', '5')), t('Active forum topics:')); - $content .= node_title_list(db_query_range("SELECT nid, title FROM {node} WHERE type = 'forum' ORDER BY nid DESC", 0, variable_get('forum_block_num', '5')), t('New forum topics:')); + $content .= node_title_list(db_query_range("SELECT nid, title FROM {node} WHERE type = 'forum' AND n.status = 1 ORDER BY nid DESC", 0, variable_get('forum_block_num', '5')), t('New forum topics:')); if ($content) { $content .= "
". l(t('more'), 'forum', array('title' => t('Read the latest forum topics.'))) .'
'; -- cgit v1.2.3