From 7960953fde4a5bb58ccbe6d0b6492c8c137ba24f Mon Sep 17 00:00:00 2001 From: moodler <moodler> Date: Mon, 25 Feb 2008 03:21:49 +0000 Subject: [PATCH] Merged blog_tags fixlet MDL-13632 from 1.9 --- blocks/blog_tags/block_blog_tags.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/blocks/blog_tags/block_blog_tags.php b/blocks/blog_tags/block_blog_tags.php index 693b4efc5d..0cce47af1b 100644 --- a/blocks/blog_tags/block_blog_tags.php +++ b/blocks/blog_tags/block_blog_tags.php @@ -74,7 +74,7 @@ class block_blog_tags extends block_base { $timewithin = time() - $this->config->timewithin * 24 * 60 * 60; /// convert to seconds - $sql = 'SELECT t.id, t.tagtype, t.rawname AS name, COUNT(DISTINCT ti.id) AS ct '; + $sql = 'SELECT t.id, t.tagtype, t.rawname, t.name, COUNT(DISTINCT ti.id) AS ct '; $sql .= "FROM {$CFG->prefix}tag t, {$CFG->prefix}tag_instance ti, {$CFG->prefix}post p "; $sql .= 'WHERE t.id = ti.tagid '; $sql .= 'AND p.id = ti.itemid '; -- 2.39.5