diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-01-03 09:24:00 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-01-03 09:24:00 +0000 |
| commit | c85a0ee005d67a3104954ad7b637b7d22f9109b4 (patch) | |
| tree | 55c9e87d6b165d49cae4c54da0ca778f5f5c51f2 /modules/story.module | |
| parent | ca2d5d6fb2bf8ee5365799c42097f035aeb2bde8 (diff) | |
| download | brdo-c85a0ee005d67a3104954ad7b637b7d22f9109b4.tar.gz brdo-c85a0ee005d67a3104954ad7b637b7d22f9109b4.tar.bz2 | |
- bugfix in "Top 10: most recent stories"
Diffstat (limited to 'modules/story.module')
| -rw-r--r-- | modules/story.module | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/modules/story.module b/modules/story.module index 0b57634de..5a18671a1 100644 --- a/modules/story.module +++ b/modules/story.module @@ -13,6 +13,8 @@ function story_block() { $blocks[0]["content"] = $content; $blocks[0]["info"] = "Top 10: all stories"; + unset($content); + $result = db_query("select s.id, COUNT(s.id) as comments, s.subject from stories s left join comments c on s.id = c.sid WHERE s.status = 2 AND ". time() ." - s.timestamp < 2419200 GROUP BY s.id ORDER BY comments DESC LIMIT 10"); while ($story = db_fetch_object($result)) { $content .= "<LI><A HREF=\"discussion.php?id=$story->id\">$story->subject</A><BR><SMALL>(". format_plural($story->comments, "comment", "comments") .")</SMALL></LI>\n"; |