@@ -75,34+83,8 @@ class TagCloudSection extends Section
return ($cnt > TAGS_PER_SECTION);
}
- function getTags($lst, $usr)
+ function getTags()
{
- $profile_tag = new Profile_tag;
- $profile_tag->selectAdd();
- $profile_tag->selectAdd('tag');
- $profile_tag->selectAdd('count(tag) as weight');
- $profile_tag->groupBy('tag');
- $profile_tag->orderBy('weight DESC');
- $cnt = $profile_tag->find();
-
- $profile_tag->query("
-SELECT tag, count(tag) as weight from profile_tag, (SELECT subscriber, subscribed from subscription where subscriber=$usr and subscribed != subscriber) as t where tagger=subscriber and tagged=subscribed group by tag order by weight dest");