-
- /**
- * Returns a list of the most frequent global tags over the given period
- *
- * @param int $period Period in hours to consider posts
- * @return array
- * @throws \Exception
- */
- private static function getGlobalTrendingTags(int $period)
- {
- $tags = Cache::get('global_trending_tags');
-
- if (!$tags) {
- $tagsStmt = DBA::p("SELECT t.`term`, COUNT(*) AS `score`
-FROM `term` t
- JOIN `item` i ON i.`id` = t.`oid` AND i.`uid` = t.`uid`
- JOIN `thread` ON `thread`.`iid` = i.`id`
-WHERE `thread`.`visible`
- AND NOT `thread`.`deleted`
- AND NOT `thread`.`moderated`
- AND NOT `thread`.`private`
- AND t.`uid` = 0
- AND t.`otype` = ?
- AND t.`type` = ?
- AND t.`term` != ''
- AND i.`received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
-GROUP BY `term`
-ORDER BY `score` DESC
-LIMIT 20", Term::OBJECT_TYPE_POST, Term::HASHTAG, $period);
-
- if (DBA::isResult($tags)) {
- $tags = DBA::toArray($tagsStmt);
- Cache::set('global_trending_tags', $tags, Cache::HOUR);
- }
- }
-
- return $tags ?: [];
- }
-
- /**
- * Returns a list of the most frequent local tags over the given period
- *
- * @param int $period Period in hours to consider posts
- * @return array
- * @throws \Exception
- */
- private static function getLocalTrendingTags(int $period)
- {
- $tags = Cache::get('local_trending_tags');
-
- if (!$tags) {
- $tagsStmt = DBA::p("SELECT t.`term`, COUNT(*) AS `score`
-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`.`wall`
- AND `thread`.`origin`
- AND t.`otype` = ?
- AND t.`type` = ?
- AND t.`term` != ''
- AND i.`received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
-GROUP BY `term`
-ORDER BY `score` DESC
-LIMIT 20", Term::OBJECT_TYPE_POST, Term::HASHTAG, $period);
-
- if (DBA::isResult($tags)) {
- $tags = DBA::toArray($tagsStmt);
- Cache::set('local_trending_tags', $tags, Cache::HOUR);
- }
- }
-
- return $tags ?: [];
- }