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

diff --git a/src/Model/Term.php b/src/Model/Term.php
index 07dec52134..d950d1d5fb 100644
--- a/src/Model/Term.php
+++ b/src/Model/Term.php
@@ -4,25 +4,135 @@
  */
 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)
 	{
-		$messages = dba::select('item', ['uid', 'deleted', 'file'], ['id' => $itemid], ['limit' => 1]);
-		if (!$messages) {
+		$message = dba::selectFirst('item', ['uid', 'deleted', 'file'], ['id' => $itemid]);
+		if (!DBM::is_result($message)) {
 			return;
 		}
 
-		$message = $messages[0];
-
 		// Clean up all tags
 		q("DELETE FROM `term` WHERE `otype` = %d AND `oid` = %d AND `type` IN (%d, %d)",
 			intval(TERM_OBJ_POST),
@@ -30,34 +140,31 @@ class Term
 			intval(TERM_FILE),
 			intval(TERM_CATEGORY));
 
-		if ($message["deleted"])
+		if ($message["deleted"]) {
 			return;
+		}
 
 		if (preg_match_all("/\[(.*?)\]/ism", $message["file"], $files)) {
 			foreach ($files[1] as $file) {
-				dba::insert('term', ['uid' => $message["uid"], 'oid' => $itemid, 'otype' => TERM_OBJ_POST, 'type' => TERM_FILE, 'term' => $file]);
+				dba::insert('term', [
+					'uid' => $message["uid"],
+					'oid' => $itemid,
+					'otype' => TERM_OBJ_POST,
+					'type' => TERM_FILE,
+					'term' => $file
+				]);
 			}
 		}
 
 		if (preg_match_all("/\<(.*?)\>/ism", $message["file"], $files)) {
 			foreach ($files[1] as $file) {
-				dba::insert('term', ['uid' => $message["uid"], 'oid' => $itemid, 'otype' => TERM_OBJ_POST, 'type' => TERM_CATEGORY, 'term' => $file]);
-			}
-		}
-	}
-
-	/**
-	 * @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"]);
+				dba::insert('term', [
+					'uid' => $message["uid"],
+					'oid' => $itemid,
+					'otype' => TERM_OBJ_POST,
+					'type' => TERM_CATEGORY,
+					'term' => $file
+				]);
 			}
 		}
 	}