X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FPhoto.php;h=555df80e63df689fea8f056f22586783857f0574;hb=c4ea3bfb3e8a603aacd386438b23fe5a59068114;hp=cf31849c8d23c1e2a7971c4cd3d2ffc9104a724c;hpb=9b37f5c0855c8071075fa3ce49b7e9c38f2c6a2e;p=friendica.git diff --git a/src/Model/Photo.php b/src/Model/Photo.php index cf31849c8d..555df80e63 100644 --- a/src/Model/Photo.php +++ b/src/Model/Photo.php @@ -10,11 +10,10 @@ use Friendica\Core\Cache; use Friendica\Core\Config; use Friendica\Core\L10n; use Friendica\Core\System; -use Friendica\Database\DBM; +use Friendica\Database\DBA; use Friendica\Object\Image; use Friendica\Util\DateTimeFormat; use Friendica\Util\Network; -use dba; require_once 'include/dba.php'; @@ -41,14 +40,14 @@ class Photo */ public static function store(Image $Image, $uid, $cid, $rid, $filename, $album, $scale, $profile = 0, $allow_cid = '', $allow_gid = '', $deny_cid = '', $deny_gid = '', $desc = '') { - $photo = dba::selectFirst('photo', ['guid'], ["`resource-id` = ? AND `guid` != ?", $rid, '']); - if (DBM::is_result($photo)) { + $photo = DBA::selectFirst('photo', ['guid'], ["`resource-id` = ? AND `guid` != ?", $rid, '']); + if (DBA::isResult($photo)) { $guid = $photo['guid']; } else { - $guid = get_guid(); + $guid = System::createGUID(); } - $existing_photo = dba::selectFirst('photo', ['id'], ['resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale]); + $existing_photo = DBA::selectFirst('photo', ['id'], ['resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale]); $fields = [ 'uid' => $uid, @@ -73,10 +72,10 @@ class Photo 'desc' => $desc ]; - if (DBM::is_result($existing_photo)) { - $r = dba::update('photo', $fields, ['id' => $existing_photo['id']]); + if (DBA::isResult($existing_photo)) { + $r = DBA::update('photo', $fields, ['id' => $existing_photo['id']]); } else { - $r = dba::insert('photo', $fields); + $r = DBA::insert('photo', $fields); } return $r; @@ -91,13 +90,16 @@ class Photo */ public static function importProfilePhoto($image_url, $uid, $cid, $quit_on_error = false) { - $photo = dba::selectFirst( + $thumb = ''; + $micro = ''; + + $photo = DBA::selectFirst( 'photo', ['resource-id'], ['uid' => $uid, 'contact-id' => $cid, 'scale' => 4, 'album' => 'Contact Photos'] ); if (x($photo['resource-id'])) { $hash = $photo['resource-id']; } else { - $hash = photo_new_resource(); + $hash = self::newResource(); } $photo_failure = false; @@ -237,8 +239,8 @@ class Photo WHERE `uid` = %d AND `album` != '%s' AND `album` != '%s' $sql_extra GROUP BY `album` ORDER BY `created` DESC", intval($uid), - dbesc('Contact Photos'), - dbesc(L10n::t('Contact Photos')) + DBA::escape('Contact Photos'), + DBA::escape(L10n::t('Contact Photos')) ); } else { // This query doesn't do the count and is much faster @@ -246,8 +248,8 @@ class Photo FROM `photo` USE INDEX (`uid_album_scale_created`) WHERE `uid` = %d AND `album` != '%s' AND `album` != '%s' $sql_extra", intval($uid), - dbesc('Contact Photos'), - dbesc(L10n::t('Contact Photos')) + DBA::escape('Contact Photos'), + DBA::escape(L10n::t('Contact Photos')) ); } Cache::set($key, $albums, CACHE_DAY); @@ -264,4 +266,14 @@ class Photo $key = "photo_albums:".$uid.":".local_user().":".remote_user(); Cache::set($key, null, CACHE_DAY); } + + /** + * Generate a unique photo ID. + * + * @return string + */ + public static function newResource() + { + return system::createGUID(32, false); + } }