1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- <?php
- defined('GNUSOCIAL') || die();
- class GroupTagCloudSection extends TagCloudSection
- {
- public $group = null;
- public function __construct($out = null, $group = null)
- {
- parent::__construct($out);
- $this->group = $group;
- }
- public function title()
- {
-
-
- return _('Tags');
- }
- public function getTags()
- {
- $weightexpr = common_sql_weight('notice_tag.created', common_config('tag', 'dropoff'));
-
- $names = $this->group->getAliases();
- $names = array_merge(array($this->group->nickname), $names);
-
- $quoted = array();
- foreach ($names as $name) {
- $quoted[] = "'$name'";
- }
- $namestring = implode(',', $quoted);
- $limit = TAGS_PER_SECTION;
- $qry = 'SELECT notice_tag.tag, ' . $weightexpr . ' AS weight ' .
- 'FROM notice_tag INNER JOIN notice ' .
- 'ON notice_tag.notice_id = notice.id ' .
- 'INNER JOIN group_inbox ON group_inbox.notice_id = notice.id ' .
- 'WHERE group_inbox.group_id = %d ' .
- 'AND notice_tag.tag NOT IN (%s) '.
- 'GROUP BY notice_tag.tag ' .
- 'ORDER BY weight DESC LIMIT ' . $limit;
- $tag = Memcached_DataObject::cachedQuery(
- 'Notice_tag',
- sprintf($qry, $this->group->id, $namestring),
- 3600
- );
- return $tag;
- }
- }
|