diff options
| author | Andrew Dolgov <[email protected]> | 2007-08-10 05:12:29 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2007-08-10 05:12:29 +0100 |
| commit | ef1ac7c73aeaf34129f26d0bda39bea3fc55eeb3 (patch) | |
| tree | fca22c7ad572c6fe3b1c983a31bc86607eb6a699 | |
| parent | 2bc2147f2e726b8db29f93e2a14da91b641ced7d (diff) | |
limit tag browsing mode to top50 most popular
| -rw-r--r-- | functions.php | 6 | ||||
| -rw-r--r-- | modules/popup-dialog.php | 2 |
2 files changed, 5 insertions, 3 deletions
diff --git a/functions.php b/functions.php index 5fc20841a..336a6d4b9 100644 --- a/functions.php +++ b/functions.php @@ -1913,7 +1913,8 @@ $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id) FROM ttrss_user_entries WHERE int_id = post_int_id AND unread = true)) AS count FROM ttrss_tags - WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name ORDER BY tag_name"); + WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name + ORDER BY count DESC LIMIT 55"); $tags = array(); @@ -3474,7 +3475,8 @@ $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id) FROM ttrss_user_entries WHERE int_id = post_int_id AND unread = true)) AS count FROM ttrss_tags - WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name ORDER BY tag_name"); + WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name + ORDER BY count DESC LIMIT 50"); $tags = array(); diff --git a/modules/popup-dialog.php b/modules/popup-dialog.php index 562093d9d..6590159d2 100644 --- a/modules/popup-dialog.php +++ b/modules/popup-dialog.php @@ -424,7 +424,7 @@ print "<div class=\"infoBoxContents\">"; print __("Showing most popular tags ")." (<a - href='javascript:toggleTags(true)'>".__('browse all')."</a>):<br/>"; + href='javascript:toggleTags(true)'>".__('browse more')."</a>):<br/>"; print "<div class=\"tagCloudContainer\">"; |