<?php
/**
- * @file src/Model/Term
+ * @copyright Copyright (C) 2020, Friendica
+ *
+ * @license GNU AGPL version 3 or any later version
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program. If not, see <https://www.gnu.org/licenses/>.
+ *
*/
+
namespace Friendica\Model;
-use Friendica\Core\System;
+use Friendica\Core\Cache\Duration;
+use Friendica\Core\Logger;
use Friendica\Database\DBA;
+use Friendica\DI;
use Friendica\Util\Strings;
+/**
+ * Class Term
+ *
+ * This Model class handles term table interactions.
+ * This tables stores relevant terms related to posts, photos and searches, like hashtags, mentions and
+ * user-applied categories.
+ */
class Term
{
const UNKNOWN = 0;
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.
+ */
const IMPLICIT_MENTION = 8;
+ /**
+ * An exclusive mention transfers the ownership of the post to the target account, usually a forum.
+ */
const EXCLUSIVE_MENTION = 9;
const TAG_CHARACTER = [
const OBJECT_TYPE_POST = 1;
const OBJECT_TYPE_PHOTO = 2;
+ /**
+ * Returns a list of the most frequent global hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @return array
+ * @throws \Exception
+ */
+ public static function getGlobalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tags = DI::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 `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 ?",
+ Item::PUBLIC,
+ Term::OBJECT_TYPE_POST,
+ Term::HASHTAG,
+ $period,
+ $limit
+ );
+
+ if (DBA::isResult($tagsStmt)) {
+ $tags = DBA::toArray($tagsStmt);
+ DI::cache()->set('global_trending_tags', $tags, Duration::HOUR);
+ }
+ }
+
+ return $tags ?: [];
+ }
+
+ /**
+ * Returns a list of the most frequent local hashtags over the given period
+ *
+ * @param int $period Period in hours to consider posts
+ * @return array
+ * @throws \Exception
+ */
+ public static function getLocalTrendingHashtags(int $period, $limit = 10)
+ {
+ $tags = DI::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`
+ WHERE `thread`.`visible`
+ AND NOT `thread`.`deleted`
+ AND NOT `thread`.`moderated`
+ AND `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 ?",
+ Item::PUBLIC,
+ Term::OBJECT_TYPE_POST,
+ Term::HASHTAG,
+ $period,
+ $limit
+ );
+
+ if (DBA::isResult($tagsStmt)) {
+ $tags = DBA::toArray($tagsStmt);
+ DI::cache()->set('local_trending_tags', $tags, Duration::HOUR);
+ }
+ }
+
+ return $tags ?: [];
+ }
+
/**
* Generates the legacy item.tag field comma-separated BBCode string from an item ID.
* Includes only hashtags, implicit and explicit mentions.
*/
public static function insertFromTagFieldByItemId($item_id, $tag_str)
{
- $profile_base = System::baseUrl();
+ $profile_base = DI::baseUrl();
$profile_data = parse_url($profile_base);
- $profile_path = defaults($profile_data, 'path', '');
+ $profile_path = $profile_data['path'] ?? '';
$profile_base_friendica = $profile_data['host'] . $profile_path . '/profile/';
$profile_base_diaspora = $profile_data['host'] . $profile_path . '/u/';
$type = self::HASHTAG;
$term = $tag;
$link = '';
+
+ Logger::notice('Unknown term type', ['tag' => $tag]);
}
if (DBA::exists('term', ['uid' => $item['uid'], 'otype' => self::OBJECT_TYPE_POST, 'oid' => $item_id, 'term' => $term, 'type' => $type])) {
'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'],
'implicit_mentions' => [],
];
- $searchpath = System::baseUrl() . "/search?tag=";
+ $searchpath = DI::baseUrl() . "/search?tag=";
$taglist = DBA::select(
'term',
$item['body'] = str_replace($orig_tag, $tag['url'], $item['body']);
}
- $return['hashtags'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank">' . $tag['term'] . '</a>';
- $return['tags'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank">' . $tag['term'] . '</a>';
+ $return['hashtags'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank" rel="noopener noreferrer">' . htmlspecialchars($tag['term']) . '</a>';
+ $return['tags'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank" rel="noopener noreferrer">' . htmlspecialchars($tag['term']) . '</a>';
break;
case self::MENTION:
$tag['url'] = Contact::magicLink($tag['url']);
- $return['mentions'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank">' . $tag['term'] . '</a>';
- $return['tags'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank">' . $tag['term'] . '</a>';
+ $return['mentions'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank" rel="noopener noreferrer">' . htmlspecialchars($tag['term']) . '</a>';
+ $return['tags'][] = $prefix . '<a href="' . $tag['url'] . '" target="_blank" rel="noopener noreferrer">' . htmlspecialchars($tag['term']) . '</a>';
break;
case self::IMPLICIT_MENTION:
$return['implicit_mentions'][] = $prefix . $tag['term'];
{
$tag_chars = [];
foreach ($types as $type) {
- if (isset(self::TAG_CHARACTER[$type])) {
+ if (array_key_exists($type, self::TAG_CHARACTER)) {
$tag_chars[] = self::TAG_CHARACTER[$type];
}
}