* @param integer $uid
* @param integer $start
* @param integer $limit
+ * @param integer $last_uriid
* @return array with URI-ID
*/
- public static function getURIIdListByTag(string $search, int $uid = 0, int $start = 0, int $limit = 100)
+ public static function getURIIdListByTag(string $search, int $uid = 0, int $start = 0, int $limit = 100, int $last_uriid = 0)
{
$condition = ["`name` = ? AND (NOT `private` OR (`private` AND `uid` = ?))", $search, $uid];
+
+ if (!empty($last_uriid)) {
+ $condition = DBA::mergeConditions($condition, ["`uri-id` < ?", $last_uriid]);
+ }
+
$params = [
'order' => ['uri-id' => true],
'group_by' => ['uri-id'],
* Returns a list of the most frequent global hashtags over the given period
*
* @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
* @return array
* @throws \Exception
*/
public static function getGlobalTrendingHashtags(int $period, $limit = 10)
{
- $tags = DI::cache()->get('global_trending_tags');
-
- if (empty($tags)) {
- $tagsStmt = DBA::p("SELECT `name` AS `term`, COUNT(*) AS `score`
- FROM `tag-search-view`
- WHERE `private` = ? AND `received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
- GROUP BY `term` ORDER BY `score` DESC LIMIT ?",
- Item::PUBLIC, $period, $limit);
-
- if (DBA::isResult($tagsStmt)) {
- $tags = DBA::toArray($tagsStmt);
- DI::cache()->set('global_trending_tags', $tags, Duration::HOUR);
- }
+ $tags = DI::cache()->get('global_trending_tags-' . $period . '-' . $limit);
+ if (!empty($tags)) {
+ return $tags;
+ } else {
+ return self::setGlobalTrendingHashtags($period, $limit);
+ }
+ }
+
+ /**
+ * Creates a list of the most frequent global hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
+ * @return array
+ * @throws \Exception
+ */
+ public static function setGlobalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tagsStmt = DBA::p("SELECT `name` AS `term`, COUNT(*) AS `score`
+ FROM `tag-search-view`
+ WHERE `private` = ? AND `uid` = ? AND `received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
+ GROUP BY `term` ORDER BY `score` DESC LIMIT ?",
+ Item::PUBLIC, 0, $period, $limit);
+
+ if (DBA::isResult($tagsStmt)) {
+ $tags = DBA::toArray($tagsStmt);
+ DI::cache()->set('global_trending_tags-' . $period . '-' . $limit, $tags, Duration::DAY);
+ return $tags;
}
- return $tags ?: [];
+ return [];
}
/**
* Returns a list of the most frequent local hashtags over the given period
*
* @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
* @return array
* @throws \Exception
*/
public static function getLocalTrendingHashtags(int $period, $limit = 10)
{
- $tags = DI::cache()->get('local_trending_tags');
-
- if (empty($tags)) {
- $tagsStmt = DBA::p("SELECT `name` AS `term`, COUNT(*) AS `score`
- FROM `tag-search-view`
- WHERE `private` = ? AND `wall` AND `origin` AND `received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
- GROUP BY `term` ORDER BY `score` DESC LIMIT ?",
- Item::PUBLIC, $period, $limit);
-
- if (DBA::isResult($tagsStmt)) {
- $tags = DBA::toArray($tagsStmt);
- DI::cache()->set('local_trending_tags', $tags, Duration::HOUR);
- }
+ $tags = DI::cache()->get('local_trending_tags-' . $period . '-' . $limit);
+ if (!empty($tags)) {
+ return $tags;
+ } else {
+ return self::setLocalTrendingHashtags($period, $limit);
+ }
+ }
+
+ /**
+ * Returns a list of the most frequent local hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @param int $limit Number of returned tags
+ * @return array
+ * @throws \Exception
+ */
+ public static function setLocalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tagsStmt = DBA::p("SELECT `name` AS `term`, COUNT(*) AS `score`
+ FROM `tag-search-view`
+ WHERE `private` = ? AND `wall` AND `origin` AND `received` > DATE_SUB(NOW(), INTERVAL ? HOUR)
+ GROUP BY `term` ORDER BY `score` DESC LIMIT ?",
+ Item::PUBLIC, $period, $limit);
+
+ if (DBA::isResult($tagsStmt)) {
+ $tags = DBA::toArray($tagsStmt);
+ DI::cache()->set('local_trending_tags-' . $period . '-' . $limit, $tags, Duration::DAY);
+ return $tags;
}
- return $tags ?: [];
+ return [];
}
/**