- $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");
-
- $tags = array();
- while ($profile_tag->fetch()) {
-// var_dump($profile_tag);
- $tags[$profile_tag->tag] = $profile_tag->weight;
- }
- $profile_tag->free();
- if (0) {
- echo 'tags: <pre>';
- var_dump($tags);
- echo '</pre>';
- }
- return $tags;
- }
-
- function getAllTags() {