X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FTerm.php;h=262312532995c1b1b2753fc0c5dcc311e7ef0a20;hb=c083ae047c4259dcfa1c61a3795679bbf1b08d8c;hp=9f0b595014bdaf245ab6c8f4f86cdbad4b3338e9;hpb=daa1177e3a1e42b4c95e0a8759f1610942b952c7;p=friendica.git diff --git a/src/Model/Term.php b/src/Model/Term.php index 9f0b595014..2623125329 100644 --- a/src/Model/Term.php +++ b/src/Model/Term.php @@ -5,8 +5,7 @@ namespace Friendica\Model; use Friendica\Core\System; -use Friendica\Database\dba; -use Friendica\Database\DBM; +use Friendica\Database\DBA; require_once 'boot.php'; require_once 'include/conversation.php'; @@ -18,8 +17,8 @@ class Term { $tag_text = ''; $condition = ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_HASHTAG, TERM_MENTION]]; - $tags = dba::select('term', [], $condition); - while ($tag = dba::fetch($tags)) { + $tags = DBA::select('term', [], $condition); + while ($tag = DBA::fetch($tags)) { if ($tag_text != '') { $tag_text .= ','; } @@ -34,12 +33,23 @@ class Term return $tag_text; } + public static function tagArrayFromItemId($itemid) + { + $condition = ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_HASHTAG, TERM_MENTION]]; + $tags = DBA::select('term', ['type', 'term', 'url'], $condition); + if (!DBA::isResult($tags)) { + return []; + } + + return DBA::toArray($tags); + } + public static function fileTextFromItemId($itemid) { $file_text = ''; $condition = ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_FILE, TERM_CATEGORY]]; - $tags = dba::select('term', [], $condition); - while ($tag = dba::fetch($tags)) { + $tags = DBA::select('term', [], $condition); + while ($tag = DBA::fetch($tags)) { if ($tag['type'] == TERM_CATEGORY) { $file_text .= '<' . $tag['term'] . '>'; } else { @@ -59,14 +69,14 @@ class Term $fields = ['guid', 'uid', 'id', 'edited', 'deleted', 'created', 'received', 'title', 'body', 'parent']; $message = Item::selectFirst($fields, ['id' => $itemid]); - if (!DBM::is_result($message)) { + if (!DBA::isResult($message)) { return; } $message['tag'] = $tags; // Clean up all tags - dba::delete('term', ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_HASHTAG, TERM_MENTION]]); + DBA::delete('term', ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_HASHTAG, TERM_MENTION]]); if ($message['deleted']) { return; @@ -128,12 +138,12 @@ class Term if ($message['uid'] == 0) { $global = true; - dba::update('term', ['global' => true], ['otype' => TERM_OBJ_POST, 'guid' => $message['guid']]); + 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']]); + $global = DBA::exists('term', ['uid' => 0, 'otype' => TERM_OBJ_POST, 'guid' => $message['guid']]); } - dba::insert('term', [ + DBA::insert('term', [ 'uid' => $message['uid'], 'oid' => $itemid, 'otype' => TERM_OBJ_POST, @@ -152,8 +162,8 @@ class Term foreach ($users AS $user) { if ($user['uid'] == $message['uid']) { /// @todo This function is called frim Item::update - so we mustn't call that function here - dba::update('item', ['mention' => true], ['id' => $itemid]); - dba::update('thread', ['mention' => true], ['iid' => $message['parent']]); + DBA::update('item', ['mention' => true], ['id' => $itemid]); + DBA::update('thread', ['mention' => true], ['iid' => $message['parent']]); } } } @@ -167,12 +177,12 @@ class Term public static function insertFromFileFieldByItemId($itemid, $files) { $message = Item::selectFirst(['uid', 'deleted'], ['id' => $itemid]); - if (!DBM::is_result($message)) { + if (!DBA::isResult($message)) { return; } // Clean up all tags - dba::delete('term', ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_FILE, TERM_CATEGORY]]); + DBA::delete('term', ['otype' => TERM_OBJ_POST, 'oid' => $itemid, 'type' => [TERM_FILE, TERM_CATEGORY]]); if ($message["deleted"]) { return; @@ -182,7 +192,7 @@ class Term if (preg_match_all("/\[(.*?)\]/ism", $message["file"], $files)) { foreach ($files[1] as $file) { - dba::insert('term', [ + DBA::insert('term', [ 'uid' => $message["uid"], 'oid' => $itemid, 'otype' => TERM_OBJ_POST, @@ -194,7 +204,7 @@ class Term if (preg_match_all("/\<(.*?)\>/ism", $message["file"], $files)) { foreach ($files[1] as $file) { - dba::insert('term', [ + DBA::insert('term', [ 'uid' => $message["uid"], 'oid' => $itemid, 'otype' => TERM_OBJ_POST, @@ -222,14 +232,14 @@ class Term $searchpath = System::baseUrl() . "/search?tag="; - $taglist = dba::select( + $taglist = DBA::select( 'term', ['type', 'term', 'url'], ["`otype` = ? AND `oid` = ? AND `type` IN (?, ?)", TERM_OBJ_POST, $item['id'], TERM_HASHTAG, TERM_MENTION], ['order' => ['tid']] ); - while ($tag = dba::fetch($taglist)) { + while ($tag = DBA::fetch($taglist)) { if ($tag["url"] == "") { $tag["url"] = $searchpath . $tag["term"]; } @@ -254,7 +264,7 @@ class Term $return['tags'][] = $prefix . "" . $tag["term"] . ""; } - dba::close($taglist); + DBA::close($taglist); return $return; }