From ea873bc7e2ce75847295118d3b9bcf123ffb10d1 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 24 Dec 2000 15:44:29 +0000
Subject: - some improvements and code polishing - added a few extra blocks to
 choose from

---
 modules/story.module | 27 +++++++++++++++++++++++++--
 1 file changed, 25 insertions(+), 2 deletions(-)

(limited to 'modules/story.module')

diff --git a/modules/story.module b/modules/story.module
index 42707168c..27317440e 100644
--- a/modules/story.module
+++ b/modules/story.module
@@ -1,6 +1,29 @@
 <?
 
-$module = array("admin" => "story_admin");
+$module = array("block" => "story_block",
+                "admin" => "story_admin");
+
+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.sid WHERE s.status = 2 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";
+  }
+
+  $blocks[0]["subject"] = "Top 10:<BR>all stories";
+  $blocks[0]["content"] = $content;
+  $blocks[0]["info"] = "Top 10: all stories";
+
+  $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";
+  }
+
+  $blocks[1]["subject"] = "Top 10:<BR>recent stories";
+  $blocks[1]["content"] = $content;
+  $blocks[1]["info"] = "Top 10: recent stories";
+
+  return $blocks;
+}
 
 function story_edit($id) {
   global $categories;
@@ -124,4 +147,4 @@ function story_admin() {
   }
 }
 
-?>
\ No newline at end of file
+?>
-- 
cgit v1.2.3