X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FTerm.php;h=d950d1d5fbff9cd7693b0b0acffc701745336cff;hb=e65bd0325eb35c96138fe3339721a385dae9942a;hp=5f536cae424199feac52039414f6d75f5378cc02;hpb=d23c1c0da7448e4bf2f815f0ed3023521f21ab20;p=friendica.git

diff --git a/src/Model/Term.php b/src/Model/Term.php
index 5f536cae42..d950d1d5fb 100644
--- a/src/Model/Term.php
+++ b/src/Model/Term.php
@@ -4,20 +4,132 @@
  */
 namespace Friendica\Model;
 
+use Friendica\Core\System;
+use Friendica\Database\DBM;
 use dba;
 
-require_once "include/dba.php";
+require_once 'boot.php';
+require_once 'include/dba.php';
 
 class Term
 {
+	public static function insertFromTagFieldByItemId($itemid)
+	{
+		$profile_base = System::baseUrl();
+		$profile_data = parse_url($profile_base);
+		$profile_path = defaults($profile_data, 'path', '');
+		$profile_base_friendica = $profile_data['host'] . $profile_path . '/profile/';
+		$profile_base_diaspora = $profile_data['host'] . $profile_path . '/u/';
+
+		$fields = ['guid', 'uid', 'id', 'edited', 'deleted', 'created', 'received', 'title', 'body', 'tag', 'parent'];
+		$message = dba::selectFirst('item', $fields, ['id' => $itemid]);
+		if (!DBM::is_result($message)) {
+			return;
+		}
+
+		// Clean up all tags
+		dba::e("DELETE FROM `term` WHERE `otype` = ? AND `oid` = ? AND `type` IN (?, ?)",
+			TERM_OBJ_POST, $itemid, TERM_HASHTAG, TERM_MENTION);
+
+		if ($message['deleted']) {
+			return;
+		}
+
+		$taglist = explode(',', $message['tag']);
+
+		$tags_string = '';
+		foreach ($taglist as $tag) {
+			if ((substr(trim($tag), 0, 1) == '#') || (substr(trim($tag), 0, 1) == '@')) {
+				$tags_string .= ' ' . trim($tag);
+			} else {
+				$tags_string .= ' #' . trim($tag);
+			}
+		}
+
+		$data = ' ' . $message['title'] . ' ' . $message['body'] . ' ' . $tags_string . ' ';
+
+		// ignore anything in a code block
+		$data = preg_replace('/\[code\](.*?)\[\/code\]/sm', '', $data);
+
+		$tags = [];
+
+		$pattern = '/\W\#([^\[].*?)[\s\'".,:;\?!\[\]\/]/ism';
+		if (preg_match_all($pattern, $data, $matches)) {
+			foreach ($matches[1] as $match) {
+				$tags['#' . strtolower($match)] = '';
+			}
+		}
+
+		$pattern = '/\W([\#@])\[url\=(.*?)\](.*?)\[\/url\]/ism';
+		if (preg_match_all($pattern, $data, $matches, PREG_SET_ORDER)) {
+			foreach ($matches as $match) {
+				$tags[$match[1] . strtolower(trim($match[3], ',.:;[]/\"?!'))] = $match[2];
+			}
+		}
+
+		foreach ($tags as $tag => $link) {
+			if (substr(trim($tag), 0, 1) == '#') {
+				// try to ignore #039 or #1 or anything like that
+				if (ctype_digit(substr(trim($tag), 1))) {
+					continue;
+				}
+
+				// try to ignore html hex escapes, e.g. #x2317
+				if ((substr(trim($tag), 1, 1) == 'x' || substr(trim($tag), 1, 1) == 'X') && ctype_digit(substr(trim($tag), 2))) {
+					continue;
+				}
+
+				$type = TERM_HASHTAG;
+				$term = substr($tag, 1);
+			} elseif (substr(trim($tag), 0, 1) == '@') {
+				$type = TERM_MENTION;
+				$term = substr($tag, 1);
+			} else { // This shouldn't happen
+				$type = TERM_HASHTAG;
+				$term = $tag;
+			}
+
+			if ($message['uid'] == 0) {
+				$global = true;
+				dba::update('term', ['global' => true], ['otype' => TERM_OBJ_POST, 'guid' => $message['guid']]);
+			} else {
+				$global = dba::exists('term', ['uid' => 0, 'otype' => TERM_OBJ_POST, 'guid' => $message['guid']]);
+			}
+
+			dba::insert('term', [
+				'uid'      => $message['uid'],
+				'oid'      => $itemid,
+				'otype'    => TERM_OBJ_POST,
+				'type'     => $type,
+				'term'     => $term,
+				'url'      => $link,
+				'guid'     => $message['guid'],
+				'created'  => $message['created'],
+				'received' => $message['received'],
+				'global'   => $global
+			]);
+
+			// Search for mentions
+			if ((substr($tag, 0, 1) == '@') && (strpos($link, $profile_base_friendica) || strpos($link, $profile_base_diaspora))) {
+				$users = q("SELECT `uid` FROM `contact` WHERE self AND (`url` = '%s' OR `nurl` = '%s')", $link, $link);
+				foreach ($users AS $user) {
+					if ($user['uid'] == $message['uid']) {
+						dba::update('item', ['mention' => true], ['id' => $itemid]);
+						dba::update('thread', ['mention' => true], ['iid' => $message['parent']]);
+					}
+				}
+			}
+		}
+	}
+
 	/**
 	 * @param integer $itemid item id
 	 * @return void
 	 */
-	public static function createFromItem($itemid)
+	public static function insertFromFileFieldByItemId($itemid)
 	{
 		$message = dba::selectFirst('item', ['uid', 'deleted', 'file'], ['id' => $itemid]);
-		if (!\Friendica\Database\DBM::is_result($message)) {
+		if (!DBM::is_result($message)) {
 			return;
 		}
 
@@ -56,20 +168,4 @@ class Term
 			}
 		}
 	}
-
-	/**
-	 * @param string  $itemuri item uri
-	 * @param integer $uid     uid
-	 * @return void
-	 */
-	public static function createFromItemURI($itemuri, $uid)
-	{
-		$messages = q("SELECT `id` FROM `item` WHERE uri ='%s' AND uid=%d", dbesc($itemuri), intval($uid));
-
-		if (count($messages)) {
-			foreach ($messages as $message) {
-				self::createFromItem($message["id"]);
-			}
-		}
-	}
 }