const HASHTAG = 1;
const MENTION = 2;
const CATEGORY = 3;
- const PCATEGORY = 4;
const FILE = 5;
- const SAVEDSEARCH = 6;
- const CONVERSATION = 7;
/**
* An implicit mention is a mention in a comment body that is redundant with the threading information.
*/
WHERE `thread`.`visible`
AND NOT `thread`.`deleted`
AND NOT `thread`.`moderated`
- AND NOT `thread`.`private`
+ AND `thread`.`private` = ?
AND t.`uid` = 0
AND t.`otype` = ?
AND t.`type` = ?
GROUP BY `term`
ORDER BY `score` DESC
LIMIT ?",
+ Item::PUBLIC,
Term::OBJECT_TYPE_POST,
Term::HASHTAG,
$period,
FROM `term` t
JOIN `item` i ON i.`id` = t.`oid` AND i.`uid` = t.`uid`
JOIN `thread` ON `thread`.`iid` = i.`id`
- JOIN `user` ON `user`.`uid` = `thread`.`uid` AND NOT `user`.`hidewall`
WHERE `thread`.`visible`
AND NOT `thread`.`deleted`
AND NOT `thread`.`moderated`
- AND NOT `thread`.`private`
+ AND `thread`.`private` = ?
AND `thread`.`wall`
AND `thread`.`origin`
AND t.`otype` = ?
GROUP BY `term`
ORDER BY `score` DESC
LIMIT ?",
+ Item::PUBLIC,
Term::OBJECT_TYPE_POST,
Term::HASHTAG,
$period,
continue;
}
+ if (empty($term)) {
+ continue;
+ }
+
if ($item['uid'] == 0) {
$global = true;
DBA::update('term', ['global' => true], ['otype' => self::OBJECT_TYPE_POST, 'guid' => $item['guid']]);
'oid' => $item_id,
'otype' => self::OBJECT_TYPE_POST,
'type' => $type,
- 'term' => $term,
+ 'term' => substr($term, 0, 255),
'url' => $link,
'guid' => $item['guid'],
'created' => $item['created'],