summaryrefslogtreecommitdiff
path: root/modules/forum.module
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2004-02-16 06:39:29 +0000
committerDries Buytaert <dries@buytaert.net>2004-02-16 06:39:29 +0000
commit8a78d0d512217a1c15a04508fce2d5bcb61302e7 (patch)
treebe53106a78e494eca5c7940fbdd76b623f03fda8 /modules/forum.module
parentbf459265e607e4c5a5082ef0276a88dd90dd727f (diff)
downloadbrdo-8a78d0d512217a1c15a04508fce2d5bcb61302e7.tar.gz
brdo-8a78d0d512217a1c15a04508fce2d5bcb61302e7.tar.bz2
- Bugfix: the forum block was showing posts that are not 'published' yet.
Diffstat (limited to 'modules/forum.module')
-rw-r--r--modules/forum.module2
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/forum.module b/modules/forum.module
index 6391233e1..7caf894b6 100644
--- a/modules/forum.module
+++ b/modules/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 .= "<div class=\"more-link\">". l(t('more'), 'forum', array('title' => t('Read the latest forum topics.'))) .'</div>';