X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Ftags.php;h=fbb9e6ff776fdbe28850b683076c78555eb68bce;hb=30efb0c1e641b0b9d3aa40a5a79897c6d06ac3ef;hp=c4aba400f3c799e0471b9c077e3d6d127dfa1309;hpb=11d1c1ae8eaf9b91fd2478abc7b089f9c0877845;p=friendica.git diff --git a/include/tags.php b/include/tags.php index c4aba400f3..fbb9e6ff77 100644 --- a/include/tags.php +++ b/include/tags.php @@ -1,20 +1,4 @@ set_baseurl("https://pirati.ca"); -*/ - function create_tags_from_item($itemid) { global $a; @@ -25,7 +9,7 @@ function create_tags_from_item($itemid) { $searchpath = $a->get_baseurl()."/search?tag="; - $messages = q("SELECT `guid`, `uid`, `id`, `edited`, `deleted`, `title`, `body`, `tag` FROM `item` WHERE `id` = %d LIMIT 1", intval($itemid)); + $messages = q("SELECT `guid`, `uid`, `id`, `edited`, `deleted`, `title`, `body`, `tag`, `parent` FROM `item` WHERE `id` = %d LIMIT 1", intval($itemid)); if (!$messages) return; @@ -83,7 +67,7 @@ function create_tags_from_item($itemid) { 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,1))) + 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); @@ -92,7 +76,7 @@ function create_tags_from_item($itemid) { $term = substr($tag, 1); } else { // This shouldn't happen $type = TERM_HASHTAG; - $term = $tag."-oh"; + $term = $tag; } $r = q("INSERT INTO `term` (`uid`, `oid`, `otype`, `type`, `term`, `url`) VALUES (%d, %d, %d, %d, '%s', '%s')", @@ -102,8 +86,11 @@ function create_tags_from_item($itemid) { if ((substr($tag, 0, 1) == '@') AND (strpos($link, $profile_base_friendica) OR 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"]) + if ($user["uid"] == $message["uid"]) { q("UPDATE `item` SET `mention` = 1 WHERE `id` = %d", intval($itemid)); + + q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($message["parent"])); + } } } } @@ -125,11 +112,4 @@ function update_items() { foreach ($messages as $message) create_tags_from_item($message["id"]); } - -//print_r($tags); -//print_r($hashtags); -//print_r($mentions); -//update_items(); -//create_tags_from_item(265194); -//create_tags_from_itemuri("infoagent@diasp.org:cce94abd104c06e8", 2); ?>