+ $condition = ['uri-id' => $uri_id];
+
+ if (!empty($types)) {
+ $condition = DBA::mergeConditions($condition, ['type' => $types]);
+ }
+
+ return DBA::selectToArray('post-media', [], $condition);
+ }
+
+ /**
+ * Checks if media attachments are associated with the provided item ID.
+ *
+ * @param int $uri_id
+ * @param array $types
+ * @return array
+ * @throws \Exception
+ */
+ public static function existsByURIId(int $uri_id, array $types = [])
+ {
+ $condition = ['uri-id' => $uri_id];
+
+ if (!empty($types)) {
+ $condition = DBA::mergeConditions($condition, ['type' => $types]);
+ }
+
+ return DBA::exists('post-media', $condition);
+ }
+
+ /**
+ * Split the attachment media in the three segments "visual", "link" and "additional"
+ *
+ * @param int $uri_id
+ * @param string $guid
+ * @param array $links ist of links that shouldn't be added
+ * @return array attachments
+ */
+ public static function splitAttachments(int $uri_id, string $guid = '', array $links = [])
+ {
+ $attachments = ['visual' => [], 'link' => [], 'additional' => []];
+
+ $media = self::getByURIId($uri_id);
+ if (empty($media)) {
+ return $attachments;
+ }
+
+ $height = 0;
+ $selected = '';
+
+ foreach ($media as $medium) {
+ foreach ($links as $link) {
+ if (Strings::compareLink($link, $medium['url'])) {
+ continue 2;
+ }
+ }
+
+ $type = explode('/', current(explode(';', $medium['mimetype'])));
+ if (count($type) < 2) {
+ Logger::info('Unknown MimeType', ['type' => $type, 'media' => $medium]);
+ $filetype = 'unkn';
+ $subtype = 'unkn';
+ } else {
+ $filetype = strtolower($type[0]);
+ $subtype = strtolower($type[1]);
+ }
+
+ $medium['filetype'] = $filetype;
+ $medium['subtype'] = $subtype;
+
+ if ($medium['type'] == self::HTML || (($filetype == 'text') && ($subtype == 'html'))) {
+ $attachments['link'][] = $medium;
+ continue;
+ }
+
+ if (in_array($medium['type'], [self::AUDIO, self::IMAGE]) ||
+ in_array($filetype, ['audio', 'image'])) {
+ $attachments['visual'][] = $medium;
+ } elseif (($medium['type'] == self::VIDEO) || ($filetype == 'video')) {
+ if (strpos($medium['url'], $guid) !== false) {
+ // Peertube videos are delivered in many different resolutions. We pick a moderate one.
+ // By checking against the GUID we also ensure to only work this way on Peertube posts.
+ // This wouldn't be executed when someone for example on Mastodon was sharing multiple videos in a single post.
+ if (empty($height) || ($height > $medium['height']) && ($medium['height'] >= 480)) {
+ $height = $medium['height'];
+ $selected = $medium['url'];
+ }
+ $video[$medium['url']] = $medium;
+ } else {
+ $attachments['visual'][] = $medium;
+ }
+ } else {
+ $attachments['additional'][] = $medium;
+ }
+ }
+ if (!empty($selected)) {
+ $attachments['visual'][] = $video[$selected];
+ unset($video[$selected]);
+ foreach ($video as $element) {
+ $attachments['additional'][] = $element;
+ }
+ }
+ return $attachments;
+ }
+
+ /**
+ * Add media attachments to the body
+ *
+ * @param int $uriid
+ * @return string body
+ */
+ public static function addAttachmentsToBody(int $uriid)
+ {
+ $item = Post::selectFirst(['body'], ['uri-id' => $uriid]);
+ if (!DBA::isResult($item)) {
+ return '';
+ }
+ $body = preg_replace("/\s*\[attachment .*?\].*?\[\/attachment\]\s*/ism", '', $item['body']);
+
+ foreach (self::getByURIId($uriid, [self::IMAGE, self::AUDIO, self::VIDEO]) as $media) {
+ if (Item::containsLink($body, $media['url'])) {
+ continue;
+ }
+
+ if ($media['type'] == self::IMAGE) {
+ if (!empty($media['description'])) {
+ $body .= "\n[img=" . $media['url'] . ']' . $media['description'] .'[/img]';
+ } else {
+ $body .= "\n[img]" . $media['url'] .'[/img]';
+ }
+ } elseif ($media['type'] == self::AUDIO) {
+ $body .= "\n[audio]" . $media['url'] . "[/audio]\n";
+ } elseif ($media['type'] == self::VIDEO) {
+ $body .= "\n[video]" . $media['url'] . "[/video]\n";
+ }
+ }
+
+ if (preg_match("/.*(\[attachment.*?\].*?\[\/attachment\]).*/ism", $item['body'], $match)) {
+ $body .= "\n" . $match[1];
+ }
+
+ return $body;