summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2007-05-17 14:07:34 +0100
committerAndrew Dolgov <[email protected]>2007-05-17 14:07:34 +0100
commit35a03bddc2b2b0ca18bf549a604788afc8f5422c (patch)
tree51cea419eac28b388d19b71a7a65502c586be6fb
parent10eb9da8572c3729053d0052493d82200e5e1dcf (diff)
tag cloud improvements
-rw-r--r--functions.js2
-rw-r--r--functions.php20
-rw-r--r--modules/popup-dialog.php4
-rw-r--r--tt-rss.js4
4 files changed, 24 insertions, 6 deletions
diff --git a/functions.js b/functions.js
index d14b632d1..b99a53c96 100644
--- a/functions.js
+++ b/functions.js
@@ -1362,7 +1362,7 @@ function displayDlg(id, param) {
return
}
- notify_progress("Loading, please wait...");
+ notify_progress("Loading, please wait...", true);
xmlhttp.open("GET", "backend.php?op=dlg&id=" +
param_escape(id) + "&param=" + param_escape(param), true);
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);
diff --git a/modules/popup-dialog.php b/modules/popup-dialog.php
index 3011f8c1b..4aa498cbf 100644
--- a/modules/popup-dialog.php
+++ b/modules/popup-dialog.php
@@ -416,8 +416,8 @@
print "<div id=\"infoBoxTitle\">".__('Tag Cloud')."</div>";
print "<div class=\"infoBoxContents\">";
- print "Showing top 50 most popular tags (<a
- href='javascript:toggleTags(true)'>show all</a>):<br/>";
+ print "Showing most popular tags for the last month (<a
+ href='javascript:toggleTags(true)'>browse all</a>):<br/>";
print "<div class=\"tagCloudContainer\">";
diff --git a/tt-rss.js b/tt-rss.js
index a4e825a14..ec7e15aac 100644
--- a/tt-rss.js
+++ b/tt-rss.js
@@ -37,12 +37,12 @@ function toggleTags(show_all) {
closeInfoBox();
display_tags = true;
p.innerHTML = __("display feeds");
- notify_progress("Loading, please wait...");
+ notify_progress("Loading, please wait...", true);
updateFeedList();
} else if (display_tags) {
display_tags = false;
p.innerHTML = __("tag cloud");
- notify_progress("Loading, please wait...");
+ notify_progress("Loading, please wait...", true);
updateFeedList();
}
}