From 35a03bddc2b2b0ca18bf549a604788afc8f5422c Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 17 May 2007 14:07:34 +0100 Subject: tag cloud improvements --- functions.php | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) (limited to 'functions.php') diff --git a/functions.php b/functions.php index 3cfcef875..2ea1f856c 100644 --- a/functions.php +++ b/functions.php @@ -3864,9 +3864,27 @@ // from here: http://www.roscripts.com/Create_tag_cloud-71.html function printTagCloud($link) { - + + /* get first ref_id to count from */ + + $query = ""; + + if (DB_TYPE == "pgsql") { + $query = "SELECT MIN(id) AS id FROM ttrss_user_entries, ttrss_entries + WHERE int_id = id AND owner_uid = ".$_SESSION["uid"]." + AND date_entered > NOW() - INTERVAL '30 days'"; + } else { + $query = "SELECT MIN(id) AS id FROM ttrss_user_entries, ttrss_entries + WHERE int_id = id AND owner_uid = ".$_SESSION["uid"]." + AND date_entered > DATE_SUB(NOW(), INTERVAL 30 DAY)"; + } + + $result = db_query($link, $query); + $first_id = db_fetch_result($result, 0, "id"); + $query = "SELECT tag_name, COUNT(post_int_id) AS count FROM ttrss_tags WHERE owner_uid = ".$_SESSION["uid"]." + AND post_int_id >= '$first_id' GROUP BY tag_name ORDER BY count DESC LIMIT 50"; $result = db_query($link, $query); -- cgit v1.2.3