diff options
Diffstat (limited to 'modules/story/story.module')
| -rw-r--r-- | modules/story/story.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/story/story.module b/modules/story/story.module index 2e0ea5b23..dbf7cc7f9 100644 --- a/modules/story/story.module +++ b/modules/story/story.module @@ -22,7 +22,7 @@ function story_help() { } function story_block() { - $result = db_query("SELECT s.id, COUNT(s.id) AS comments, s.subject FROM stories s LEFT JOIN comments c ON s.id = c.lid WHERE s.status = 2 AND c.link = 'link' GROUP BY s.id ORDER BY comments DESC LIMIT 10"); + $result = db_query("SELECT s.id, COUNT(s.id) AS comments, s.subject FROM stories s LEFT JOIN comments c ON s.id = c.lid WHERE s.status = 2 AND c.link = 'story' GROUP BY s.id ORDER BY comments DESC LIMIT 10"); while ($story = db_fetch_object($result)) { $content .= "<LI><A HREF=\"story.php?id=$story->id\">$story->subject</A><BR><SMALL>(". format_plural($story->comments, "comment", "comments") .")</SMALL></LI>\n"; } |