+
+ /**
+ * @brief Delete info from table and data from storage
+ *
+ * @param array $conditions Field condition(s)
+ * @param array $options Options array, Optional
+ *
+ * @return boolean
+ *
+ * @throws \Exception
+ * @see \Friendica\Database\DBA::delete
+ */
+ public static function delete(array $conditions, array $options = [])
+ {
+ // get photo to delete data info
+ $photos = self::select(["backend-class","backend-ref"], $conditions);
+
+ foreach($photos as $photo) {
+ /** @var IStorage $backend_class */
+ $backend_class = (string)$photo["backend-class"];
+ if ($backend_class !== "") {
+ $backend_class::delete($photo["backend-ref"]);
+ }
+ }
+
+ return DBA::delete("photo", $conditions, $options);
+ }
+
+ /**
+ * @brief This function is used by the fromgplus addon
+ *
+ * Stores a photo based on image data or an URL
+ *
+ * @param integer $uid user id
+ * @param string $imagedata optional, default empty
+ * @param string $url optional, default empty
+ * @return array
+ * @throws \Friendica\Network\HTTPException\InternalServerErrorException
+ * @throws \ImagickException
+ */
+ public static function storeByData($uid, $imagedata = "", $url = "")
+ {
+ $a = self::getApp();
+ $logger = $a->getLogger();
+ $profiler = $a->getProfiler();
+
+ $r = DBA::p(
+ "SELECT `user`.`nickname`, `user`.`page-flags`, `contact`.`id` FROM `user` INNER JOIN `contact` on `user`.`uid` = `contact`.`uid`
+ WHERE `user`.`uid` = %d AND `user`.`blocked` = 0 AND `contact`.`self` = 1 LIMIT 1",
+ intval($uid)
+ );
+
+ if (!DBA::isResult($r)) {
+ $logger->info("Can't detect user data.", ['uid' => $uid]);
+ return([]);
+ }
+
+ $page_owner_nick = $r[0]['nickname'];
+
+ /// @TODO
+ /// $default_cid = $r[0]['id'];
+ /// $community_page = (($r[0]['page-flags'] == User::PAGE_FLAGS_COMMUNITY) ? true : false);
+
+ if ((strlen($imagedata) == 0) && ($url == "")) {
+ $logger->info("No image data and no url provided");
+ return([]);
+ } elseif (strlen($imagedata) == 0) {
+ $logger->info("Uploading picture,", ['url' => $url]);
+
+ $stamp1 = microtime(true);
+ $imagedata = @file_get_contents($url);
+ $profiler->saveTimestamp($stamp1, "file", System::callstack());
+ }
+
+ $maximagesize = Config::get('system', 'maximagesize');
+
+ if (($maximagesize) && (strlen($imagedata) > $maximagesize)) {
+ $logger->info("Image exceeds size limit.", ['max' => $maximagesize, 'current' => strlen($imagedata)]);
+ return([]);
+ }
+
+ $tempfile = tempnam(get_temppath(), "cache");
+
+ $stamp1 = microtime(true);
+ file_put_contents($tempfile, $imagedata);
+ $profiler->saveTimestamp($stamp1, "file", System::callstack());
+
+ $data = getimagesize($tempfile);
+
+ if (!isset($data["mime"])) {
+ unlink($tempfile);
+ $logger->info("File is no picture");
+ return([]);
+ }
+
+ $Image = new Image($imagedata, $data["mime"]);
+
+ if (!$Image->isValid()) {
+ unlink($tempfile);
+ $logger->info("Picture is no valid picture");
+ return([]);
+ }
+
+ $Image->orient($tempfile);
+ unlink($tempfile);
+
+ $max_length = Config::get('system', 'max_image_length');
+ if (! $max_length) {
+ $max_length = MAX_IMAGE_LENGTH;
+ }
+
+ if ($max_length > 0) {
+ $Image->scaleDown($max_length);
+ }
+
+ $width = $Image->getWidth();
+ $height = $Image->getHeight();
+
+ $hash = Photo::newResource();
+
+ // Pictures are always public by now
+ //$defperm = '<'.$default_cid.'>';
+ $defperm = "";
+ $visitor = 0;
+
+ $r = Photo::store($Image, $uid, $visitor, $hash, $tempfile, L10n::t('Wall Photos'), 0, 0, $defperm);
+
+ if (!$r) {
+ $logger->info("Picture couldn't be stored");
+ return([]);
+ }
+
+ $image = ["page" => System::baseUrl().'/photos/'.$page_owner_nick.'/image/'.$hash,
+ "full" => $a->getBaseURL()."/photo/{$hash}-0.".$Image->getExt()];
+
+ if ($width > 800 || $height > 800) {
+ $image["large"] = System::baseUrl()."/photo/{$hash}-0.".$Image->getExt();
+ }
+
+ if ($width > 640 || $height > 640) {
+ $Image->scaleDown(640);
+ $r = Photo::store($Image, $uid, $visitor, $hash, $tempfile, L10n::t('Wall Photos'), 1, 0, $defperm);
+ if ($r) {
+ $image["medium"] = System::baseUrl()."/photo/{$hash}-1.".$Image->getExt();
+ }
+ }
+
+ if ($width > 320 || $height > 320) {
+ $Image->scaleDown(320);
+ $r = Photo::store($Image, $uid, $visitor, $hash, $tempfile, L10n::t('Wall Photos'), 2, 0, $defperm);
+ if ($r) {
+ $image["small"] = System::baseUrl()."/photo/{$hash}-2.".$Image->getExt();
+ }
+ }
+
+ if ($width > 160 && $height > 160) {
+ $x = 0;
+ $y = 0;
+
+ $min = $Image->getWidth();
+ if ($min > 160) {
+ $x = ($min - 160) / 2;
+ }
+
+ if ($Image->getHeight() < $min) {
+ $min = $Image->getHeight();
+ if ($min > 160) {
+ $y = ($min - 160) / 2;
+ }
+ }
+
+ $min = 160;
+ $Image->crop(160, $x, $y, $min, $min);
+
+ $r = Photo::store($Image, $uid, $visitor, $hash, $tempfile, L10n::t('Wall Photos'), 3, 0, $defperm);
+ if ($r) {
+ $image["thumb"] = $a->getBaseURL() . "/photo/{$hash}-3." . $Image->getExt();
+ }
+ }
+
+ // Set the full image as preview image. This will be overwritten, if the picture is larger than 640.
+ $image["preview"] = $image["full"];
+
+ // Deactivated, since that would result in a cropped preview, if the picture wasn't larger than 320
+ //if (isset($image["thumb"]))
+ // $image["preview"] = $image["thumb"];
+
+ // Unsure, if this should be activated or deactivated
+ //if (isset($image["small"]))
+ // $image["preview"] = $image["small"];
+
+ if (isset($image["medium"])) {
+ $image["preview"] = $image["medium"];
+ }
+
+ return($image);
+ }
+
+ /**
+ * @brief Update a photo
+ *
+ * @param array $fields Contains the fields that are updated
+ * @param array $conditions Condition array with the key values
+ * @param Image $img Image to update. Optional, default null.
+ * @param array|boolean $old_fields Array with the old field values that are about to be replaced (true = update on duplicate)
+ *
+ * @return boolean Was the update successfull?
+ *
+ * @throws \Friendica\Network\HTTPException\InternalServerErrorException
+ * @see \Friendica\Database\DBA::update
+ */
+ public static function update($fields, $conditions, Image $img = null, array $old_fields = [])
+ {
+ if (!is_null($img)) {
+ // get photo to update
+ $photos = self::select(["backend-class","backend-ref"], $conditions);
+
+ foreach($photos as $photo) {
+ /** @var IStorage $backend_class */
+ $backend_class = (string)$photo["backend-class"];
+ if ($backend_class !== "") {
+ $fields["backend-ref"] = $backend_class::put($img->asString(), $photo["backend-ref"]);
+ } else {
+ $fields["data"] = $img->asString();
+ }
+ }
+ $fields['updated'] = DateTimeFormat::utcNow();
+ }
+
+ $fields['edited'] = DateTimeFormat::utcNow();
+
+ return DBA::update("photo", $fields, $conditions, $old_fields);
+ }
+