+
+ /**
+ * 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 = '';
+ $previews = [];
+
+ foreach ($media as $medium) {
+ foreach ($links as $link) {
+ if (Strings::compareLink($link, $medium['url'])) {
+ continue 2;
+ }
+ }
+
+ // Avoid adding separate media entries for previews
+ foreach ($previews as $preview) {
+ if (Strings::compareLink($preview, $medium['url'])) {
+ continue 2;
+ }
+ }
+
+ if (!empty($medium['preview'])) {
+ $previews[] = $medium['preview'];
+ }
+
+ $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
+ * @param string $body
+ * @return string body
+ */
+ public static function addAttachmentsToBody(int $uriid, string $body = '')
+ {
+ if (empty($body)) {
+ $item = Post::selectFirst(['body'], ['uri-id' => $uriid]);
+ if (!DBA::isResult($item)) {
+ return '';
+ }
+ $body = $item['body'];
+ }
+ $original_body = $body;
+
+ $body = preg_replace("/\s*\[attachment .*?\].*?\[\/attachment\]\s*/ism", '', $body);
+
+ foreach (self::getByURIId($uriid, [self::IMAGE, self::AUDIO, self::VIDEO]) as $media) {
+ if (Item::containsLink($body, $media['preview'] ?? $media['url'], $media['type'])) {
+ continue;
+ }
+
+ if ($media['type'] == self::IMAGE) {
+ if (!empty($media['preview'])) {
+ if (!empty($media['description'])) {
+ $body .= "\n[url=" . $media['url'] . "][img=" . $media['preview'] . ']' . $media['description'] .'[/img][/url]';
+ } else {
+ $body .= "\n[url=" . $media['url'] . "][img]" . $media['preview'] .'[/img][/url]';
+ }
+ } else {
+ 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", $original_body, $match)) {
+ $body .= "\n" . $match[1];
+ }
+
+ return $body;
+ }
+
+ /**
+ * Get preview link for given media id
+ *
+ * @param integer $id media id
+ * @param string $size One of the ProxyUtils::SIZE_* constants
+ * @return string preview link
+ */
+ public static function getPreviewUrlForId(int $id, string $size = ''):string
+ {
+ $url = DI::baseUrl() . '/photo/preview/';
+ switch ($size) {
+ case Proxy::SIZE_MICRO:
+ $url .= Proxy::PIXEL_MICRO . '/';
+ break;
+ case Proxy::SIZE_THUMB:
+ $url .= Proxy::PIXEL_THUMB . '/';
+ break;
+ case Proxy::SIZE_SMALL:
+ $url .= Proxy::PIXEL_SMALL . '/';
+ break;
+ case Proxy::SIZE_MEDIUM:
+ $url .= Proxy::PIXEL_MEDIUM . '/';
+ break;
+ case Proxy::SIZE_LARGE:
+ $url .= Proxy::PIXEL_LARGE . '/';
+ break;
+ }
+ return $url . $id;
+ }
+
+ /**
+ * Get media link for given media id
+ *
+ * @param integer $id media id
+ * @param string $size One of the ProxyUtils::SIZE_* constants
+ * @return string media link
+ */
+ public static function getUrlForId(int $id, string $size = ''):string
+ {
+ $url = DI::baseUrl() . '/photo/media/';
+ switch ($size) {
+ case Proxy::SIZE_MICRO:
+ $url .= Proxy::PIXEL_MICRO . '/';
+ break;
+ case Proxy::SIZE_THUMB:
+ $url .= Proxy::PIXEL_THUMB . '/';
+ break;
+ case Proxy::SIZE_SMALL:
+ $url .= Proxy::PIXEL_SMALL . '/';
+ break;
+ case Proxy::SIZE_MEDIUM:
+ $url .= Proxy::PIXEL_MEDIUM . '/';
+ break;
+ case Proxy::SIZE_LARGE:
+ $url .= Proxy::PIXEL_LARGE . '/';
+ break;
+ }
+ return $url . $id;
+ }