From 983a893e8652c444646b511c817e9c0dd8a08945 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Mon, 24 Nov 2008 08:57:04 +0000 Subject: Show a link to the item with the most tags. --- core/controllers/welcome.php | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'core/controllers') diff --git a/core/controllers/welcome.php b/core/controllers/welcome.php index 4f4f7535..a3e46214 100644 --- a/core/controllers/welcome.php +++ b/core/controllers/welcome.php @@ -47,8 +47,17 @@ class Welcome_Controller extends Template_Controller { try { $this->template->tag_count = ORM::factory("tag")->count_all(); + $this->template->most_tagged = Database::instance() + ->select("item_id AS id", "COUNT(tag_id) AS count") + ->from("items_tags") + ->groupby("item_id") + ->orderby("count", "DESC") + ->limit(1) + ->get() + ->current(); } catch (Exception $e) { $this->template->tag_count = 0; + $this->template->most_tagged = 0; } set_error_handler($old_handler); -- cgit v1.2.3