From e25c50b994ced3822bafd84d2358eddbdecf852f Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 20 Jan 2001 12:53:54 +0000
Subject: - 3 small bugfixes

---
 modules/story/story.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/story')

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";
   }
-- 
cgit v1.2.3