X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=src%2FModel%2FContact.php;h=9f6fa6264b3736272b421455aa3346f671643e4a;hb=19247b62aecb69f2854cdbb09e36767a4d580e73;hp=6e7860c8aae96d58541d59cbfc40e763cb9866cb;hpb=d48b100f789aa629578eac5f962726066494366e;p=friendica.git diff --git a/src/Model/Contact.php b/src/Model/Contact.php index 6e7860c8aa..9f6fa6264b 100644 --- a/src/Model/Contact.php +++ b/src/Model/Contact.php @@ -125,13 +125,28 @@ class Contact extends BaseObject } /** - * @param integer $id + * @param array $fields Array of selected fields, empty for all + * @param array $condition Array of fields for condition + * @param array $params Array of several parameters + * @return array + * @throws \Exception + */ + public static function selectFirst(array $fields = [], array $condition = [], array $params = []) + { + $contact = DBA::selectFirst('contact', $fields, $condition, $params); + + return $contact; + } + + /** + * @param integer $id Contact ID + * @param array $fields Array of selected fields, empty for all * @return array|boolean Contact record if it exists, false otherwise * @throws \Exception */ - public static function getById($id) + public static function getById($id, $fields = []) { - return DBA::selectFirst('contact', [], ['id' => $id]); + return DBA::selectFirst('contact', $fields, ['id' => $id]); } /** @@ -161,7 +176,6 @@ class Contact extends BaseObject /** * @brief Get the basepath for a given contact link - * @todo Add functionality to store this value in the contact table * * @param string $url The contact link * @@ -171,13 +185,19 @@ class Contact extends BaseObject */ public static function getBasepath($url) { - $data = Probe::uri($url); - if (!empty($data['baseurl'])) { - return $data['baseurl']; + $contact = DBA::selectFirst('contact', ['baseurl'], ['uid' => 0, 'nurl' => Strings::normaliseLink($url)]); + if (!empty($contact['baseurl'])) { + return $contact['baseurl']; + } + + self::updateFromProbeByURL($url, true); + + $contact = DBA::selectFirst('contact', ['baseurl'], ['uid' => 0, 'nurl' => Strings::normaliseLink($url)]); + if (!empty($contact['baseurl'])) { + return $contact['baseurl']; } - // When we can't probe the server, we use some ugly function that does some pattern matching - return PortableContact::detectServer($url); + return ''; } /** @@ -578,11 +598,13 @@ class Contact extends BaseObject return; } + $file_suffix = 'jpg'; + $fields = ['name' => $profile['name'], 'nick' => $user['nickname'], 'avatar-date' => $self['avatar-date'], 'location' => Profile::formatLocation($profile), 'about' => $profile['about'], 'keywords' => $profile['pub_keywords'], - 'gender' => $profile['gender'], 'avatar' => $profile['photo'], - 'contact-type' => $user['account-type'], 'xmpp' => $profile['xmpp']]; + 'gender' => $profile['gender'], 'contact-type' => $user['account-type'], + 'xmpp' => $profile['xmpp']]; $avatar = Photo::selectFirst(['resource-id', 'type'], ['uid' => $uid, 'profile' => true]); if (DBA::isResult($avatar)) { @@ -594,8 +616,6 @@ class Contact extends BaseObject $types = Image::supportedTypes(); if (isset($types[$avatar['type']])) { $file_suffix = $types[$avatar['type']]; - } else { - $file_suffix = 'jpg'; } // We are adding a timestamp value so that other systems won't use cached content @@ -614,6 +634,7 @@ class Contact extends BaseObject $fields['micro'] = System::baseUrl() . '/images/person-48.jpg'; } + $fields['avatar'] = System::baseUrl() . '/photo/profile/' .$uid . '.' . $file_suffix; $fields['forum'] = $user['page-flags'] == User::PAGE_FLAGS_COMMUNITY; $fields['prv'] = $user['page-flags'] == User::PAGE_FLAGS_PRVGROUP; @@ -646,8 +667,8 @@ class Contact extends BaseObject DBA::update('contact', $fields, ['uid' => 0, 'nurl' => $self['nurl']]); // Update the profile - $fields = ['photo' => System::baseUrl() . '/photo/profile/' .$uid . '.jpg', - 'thumb' => System::baseUrl() . '/photo/avatar/' . $uid .'.jpg']; + $fields = ['photo' => System::baseUrl() . '/photo/profile/' .$uid . '.' . $file_suffix, + 'thumb' => System::baseUrl() . '/photo/avatar/' . $uid .'.' . $file_suffix]; DBA::update('profile', $fields, ['uid' => $uid, 'is-default' => true]); } } @@ -689,9 +710,15 @@ class Contact extends BaseObject if (empty($contact['network'])) { return; } - if (($contact['network'] == Protocol::DFRN) && $dissolve) { + + $protocol = $contact['network']; + if (($protocol == Protocol::DFRN) && !self::isLegacyDFRNContact($contact)) { + $protocol = Protocol::ACTIVITYPUB; + } + + if (($protocol == Protocol::DFRN) && $dissolve) { DFRN::deliver($user, $contact, 'placeholder', true); - } elseif (in_array($contact['network'], [Protocol::OSTATUS, Protocol::DFRN])) { + } elseif (in_array($protocol, [Protocol::OSTATUS, Protocol::DFRN])) { // create an unfollow slap $item = []; $item['verb'] = NAMESPACE_OSTATUS . "/unfollow"; @@ -706,9 +733,9 @@ class Contact extends BaseObject if (!empty($contact['notify'])) { Salmon::slapper($user, $contact['notify'], $slap); } - } elseif ($contact['network'] == Protocol::DIASPORA) { + } elseif ($protocol == Protocol::DIASPORA) { Diaspora::sendUnshare($user, $contact); - } elseif ($contact['network'] == Protocol::ACTIVITYPUB) { + } elseif ($protocol == Protocol::ACTIVITYPUB) { ActivityPub\Transmitter::sendContactUndo($contact['url'], $contact['id'], $user['uid']); if ($dissolve) { @@ -770,6 +797,7 @@ class Contact extends BaseObject */ DBA::update('contact', ['archive' => 1], ['id' => $contact['id']]); DBA::update('contact', ['archive' => 1], ['nurl' => Strings::normaliseLink($contact['url']), 'self' => false]); + GContact::updateFromPublicContactURL($contact['url']); } } } @@ -807,6 +835,7 @@ class Contact extends BaseObject $fields = ['term-date' => DBA::NULL_DATETIME, 'archive' => false]; DBA::update('contact', $fields, ['id' => $contact['id']]); DBA::update('contact', $fields, ['nurl' => Strings::normaliseLink($contact['url'])]); + GContact::updateFromPublicContactURL($contact['url']); if (!empty($contact['batch'])) { $condition = ['batch' => $contact['batch'], 'contact-type' => self::TYPE_RELAY]; @@ -887,7 +916,7 @@ class Contact extends BaseObject // If there is more than one entry we filter out the connector networks if (count($r) > 1) { foreach ($r as $id => $result) { - if ($result["network"] == Protocol::STATUSNET) { + if (!in_array($result["network"], Protocol::NATIVE_SUPPORT)) { unset($r[$id]); } } @@ -941,9 +970,9 @@ class Contact extends BaseObject } if ((empty($profile["addr"]) || empty($profile["name"])) && (defaults($profile, "gid", 0) != 0) - && in_array($profile["network"], [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::DIASPORA, Protocol::OSTATUS]) + && in_array($profile["network"], Protocol::FEDERATED) ) { - Worker::add(PRIORITY_LOW, "UpdateGContact", $profile["gid"]); + Worker::add(PRIORITY_LOW, "UpdateGContact", $url); } // Show contact details of Diaspora contacts only if connected @@ -1071,7 +1100,7 @@ class Contact extends BaseObject $profile_link = $profile_link . '?tab=profile'; } - if (in_array($contact['network'], [Protocol::DFRN, Protocol::DIASPORA]) && !$contact['self']) { + if (self::canReceivePrivateMessages($contact)) { $pm_url = System::baseUrl() . '/message/new/' . $contact['id']; } @@ -1163,12 +1192,12 @@ class Contact extends BaseObject * * @return array Contact array in the "probe" structure */ - private static function getProbeDataFromDatabase($url, $cid) + private static function getProbeDataFromDatabase($url, $cid = null) { // The link could be provided as http although we stored it as https $ssl_url = str_replace('http://', 'https://', $url); - $fields = ['url', 'addr', 'alias', 'notify', 'poll', 'name', 'nick', + $fields = ['id', 'uid', 'url', 'addr', 'alias', 'notify', 'poll', 'name', 'nick', 'photo', 'keywords', 'location', 'about', 'network', 'priority', 'batch', 'request', 'confirm', 'poco']; @@ -1278,11 +1307,13 @@ class Contact extends BaseObject /// @todo Verify if we can't use Contact::getDetailsByUrl instead of the following // We first try the nurl (http://server.tld/nick), most common case - $contact = DBA::selectFirst('contact', ['id', 'avatar', 'updated', 'network'], ['nurl' => Strings::normaliseLink($url), 'uid' => $uid, 'deleted' => false]); + $fields = ['id', 'avatar', 'updated', 'network']; + $options = ['order' => ['id']]; + $contact = DBA::selectFirst('contact', $fields, ['nurl' => Strings::normaliseLink($url), 'uid' => $uid, 'deleted' => false], $options); // Then the addr (nick@server.tld) if (!DBA::isResult($contact)) { - $contact = DBA::selectFirst('contact', ['id', 'avatar', 'updated', 'network'], ['addr' => $url, 'uid' => $uid, 'deleted' => false]); + $contact = DBA::selectFirst('contact', $fields, ['addr' => str_replace('acct:', '', $url), 'uid' => $uid, 'deleted' => false], $options); } // Then the alias (which could be anything) @@ -1290,7 +1321,7 @@ class Contact extends BaseObject // The link could be provided as http although we stored it as https $ssl_url = str_replace('http://', 'https://', $url); $condition = ['`alias` IN (?, ?, ?) AND `uid` = ? AND NOT `deleted`', $url, Strings::normaliseLink($url), $ssl_url, $uid]; - $contact = DBA::selectFirst('contact', ['id', 'avatar', 'updated', 'network'], $condition); + $contact = DBA::selectFirst('contact', $fields, $condition, $options); } if (DBA::isResult($contact)) { @@ -1306,7 +1337,7 @@ class Contact extends BaseObject // Update the contact in the background if needed but it is called by the frontend if ($update_contact && $no_update && in_array($contact['network'], Protocol::NATIVE_SUPPORT)) { - Worker::add(PRIORITY_LOW, "UpdateContact", $contact_id); + Worker::add(PRIORITY_LOW, "UpdateContact", $contact_id, ($uid == 0 ? 'force' : '')); } if (!$update_contact || $no_update) { @@ -1317,10 +1348,14 @@ class Contact extends BaseObject return 0; } - // When we don't want to update, we look if we know this contact in any way if ($no_update && empty($default)) { + // When we don't want to update, we look if we know this contact in any way $data = self::getProbeDataFromDatabase($url, $contact_id); $background_update = true; + } elseif ($no_update && !empty($default)) { + // If there are default values, take these + $data = $default; + $background_update = false; } else { $data = []; $background_update = false; @@ -1335,18 +1370,9 @@ class Contact extends BaseObject } } - // Last try in gcontact for unsupported networks - if (!in_array($data["network"], [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::OSTATUS, Protocol::DIASPORA, Protocol::PUMPIO, Protocol::MAIL, Protocol::FEED])) { - if ($uid != 0) { - return 0; - } - - $contact = array_merge(self::getProbeDataFromDatabase($url, $contact_id), $default); - if (empty($contact)) { - return 0; - } - - $data = array_merge($data, $contact); + // Take the default values when probing failed + if (!empty($default) && !in_array($data["network"], array_merge(Protocol::NATIVE_SUPPORT, [Protocol::PUMPIO]))) { + $data = array_merge($data, $default); } if (empty($data)) { @@ -1381,6 +1407,7 @@ class Contact extends BaseObject 'request' => defaults($data, 'request', ''), 'confirm' => defaults($data, 'confirm', ''), 'poco' => defaults($data, 'poco', ''), + 'baseurl' => defaults($data, 'baseurl', ''), 'name-date' => DateTimeFormat::utcNow(), 'uri-date' => DateTimeFormat::utcNow(), 'avatar-date' => DateTimeFormat::utcNow(), @@ -1391,106 +1418,75 @@ class Contact extends BaseObject $condition = ['nurl' => Strings::normaliseLink($data["url"]), 'uid' => $uid, 'deleted' => false]; - DBA::update('contact', $fields, $condition, true); - - $s = DBA::select('contact', ['id'], $condition, ['order' => ['id'], 'limit' => 2]); - $contacts = DBA::toArray($s); - if (!DBA::isResult($contacts)) { - return 0; - } + // Before inserting we do check if the entry does exist now. + $contact = DBA::selectFirst('contact', ['id'], $condition, ['order' => ['id']]); + if (!DBA::isResult($contact)) { + Logger::info('Create new contact', $fields); - $contact_id = $contacts[0]["id"]; + DBA::insert('contact', $fields); - // Update in the background when we fetched the data solely from the database - if ($background_update) { - Worker::add(PRIORITY_LOW, "UpdateContact", $contact_id); - } - - // Update the newly created contact from data in the gcontact table - $gcontact = DBA::selectFirst('gcontact', ['location', 'about', 'keywords', 'gender'], ['nurl' => Strings::normaliseLink($data["url"])]); - if (DBA::isResult($gcontact)) { - // Only use the information when the probing hadn't fetched these values - if (!empty($data['keywords'])) { - unset($gcontact['keywords']); - } - if (!empty($data['location'])) { - unset($gcontact['location']); + // We intentionally aren't using lastInsertId here. There is a chance for duplicates. + $contact = DBA::selectFirst('contact', ['id'], $condition, ['order' => ['id']]); + if (!DBA::isResult($contact)) { + Logger::info('Contact creation failed', $fields); + // Shouldn't happen + return 0; } - if (!empty($data['about'])) { - unset($gcontact['about']); - } - DBA::update('contact', $gcontact, ['id' => $contact_id]); + } else { + Logger::info('Contact had been created before', ['id' => $contact["id"], 'url' => $url, 'contact' => $fields]); } - if (count($contacts) > 1 && $uid == 0 && $contact_id != 0 && $data["url"] != "") { - $condition = ["`nurl` = ? AND `uid` = ? AND `id` != ? AND NOT `self`", - Strings::normaliseLink($data["url"]), 0, $contact_id]; - Logger::log('Deleting duplicate contact ' . json_encode($condition), Logger::DEBUG); - DBA::delete('contact', $condition); - } + $contact_id = $contact["id"]; } - if (!empty($data['photo'])) { + if (!empty($data['photo']) && ($data['network'] != Protocol::FEED)) { self::updateAvatar($data['photo'], $uid, $contact_id); } - $fields = ['url', 'nurl', 'addr', 'alias', 'name', 'nick', 'keywords', 'location', 'about', 'avatar-date', 'pubkey']; - $contact = DBA::selectFirst('contact', $fields, ['id' => $contact_id]); + if (in_array($data["network"], array_merge(Protocol::NATIVE_SUPPORT, [Protocol::PUMPIO]))) { + if ($background_update) { + // Update in the background when we fetched the data solely from the database + Worker::add(PRIORITY_MEDIUM, "UpdateContact", $contact_id, ($uid == 0 ? 'force' : '')); + } else { + // Else do a direct update + self::updateFromProbe($contact_id, '', false); - // This condition should always be true - if (!DBA::isResult($contact)) { - return $contact_id; - } + // Update the gcontact entry + if ($uid == 0) { + GContact::updateFromPublicContactID($contact_id); + } + } + } else { + $fields = ['url', 'nurl', 'addr', 'alias', 'name', 'nick', 'keywords', 'location', 'about', 'avatar-date', 'baseurl']; + $contact = DBA::selectFirst('contact', $fields, ['id' => $contact_id]); - $updated = ['addr' => $data['addr'], - 'alias' => defaults($data, 'alias', ''), - 'url' => $data['url'], - 'nurl' => Strings::normaliseLink($data['url']), - 'name' => $data['name'], - 'nick' => $data['nick']]; + // This condition should always be true + if (!DBA::isResult($contact)) { + return $contact_id; + } - if (!empty($data['keywords'])) { - $updated['keywords'] = $data['keywords']; - } - if (!empty($data['location'])) { - $updated['location'] = $data['location']; - } + $updated = [ + 'url' => $data['url'], + 'nurl' => Strings::normaliseLink($data['url']), + 'updated' => DateTimeFormat::utcNow() + ]; - // Update the technical stuff as well - if filled - if (!empty($data['notify'])) { - $updated['notify'] = $data['notify']; - } - if (!empty($data['poll'])) { - $updated['poll'] = $data['poll']; - } - if (!empty($data['batch'])) { - $updated['batch'] = $data['batch']; - } - if (!empty($data['request'])) { - $updated['request'] = $data['request']; - } - if (!empty($data['confirm'])) { - $updated['confirm'] = $data['confirm']; - } - if (!empty($data['poco'])) { - $updated['poco'] = $data['poco']; - } + $fields = ['addr', 'alias', 'name', 'nick', 'keywords', 'location', 'about', 'baseurl']; - // Only fill the pubkey if it had been empty before. We have to prevent identity theft. - if (empty($contact['pubkey'])) { - $updated['pubkey'] = $data['pubkey']; - } + foreach ($fields as $field) { + $updated[$field] = defaults($data, $field, $contact[$field]); + } - if (($data['addr'] != $contact['addr']) || (!empty($data['alias']) && ($data['alias'] != $contact['alias']))) { - $updated['uri-date'] = DateTimeFormat::utcNow(); - } - if (($data["name"] != $contact["name"]) || ($data["nick"] != $contact["nick"])) { - $updated['name-date'] = DateTimeFormat::utcNow(); - } + if (($updated['addr'] != $contact['addr']) || (!empty($data['alias']) && ($data['alias'] != $contact['alias']))) { + $updated['uri-date'] = DateTimeFormat::utcNow(); + } - $updated['updated'] = DateTimeFormat::utcNow(); + if (($data['name'] != $contact['name']) || ($data['nick'] != $contact['nick'])) { + $updated['name-date'] = DateTimeFormat::utcNow(); + } - DBA::update('contact', $updated, ['id' => $contact_id], $contact); + DBA::update('contact', $updated, ['id' => $contact_id], $contact); + } return $contact_id; } @@ -1563,7 +1559,7 @@ class Contact extends BaseObject return ''; } - if (in_array($contact["network"], [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::DIASPORA, Protocol::OSTATUS, ""])) { + if (empty($contact["network"]) || in_array($contact["network"], Protocol::FEDERATED)) { $sql = "(`item`.`uid` = 0 OR (`item`.`uid` = ? AND NOT `item`.`global`))"; } else { $sql = "`item`.`uid` = ?"; @@ -1581,7 +1577,7 @@ class Contact extends BaseObject $pager = new Pager($a->query_string); - $params = ['order' => ['created' => true], + $params = ['order' => ['received' => true], 'limit' => [$pager->getStart(), $pager->getItemsPerPage()]]; if ($thread_mode) { @@ -1663,13 +1659,13 @@ class Contact extends BaseObject /** * @brief Blocks a contact * - * @param int $uid + * @param int $cid * @return bool * @throws \Exception */ - public static function block($uid) + public static function block($cid, $reason = null) { - $return = DBA::update('contact', ['blocked' => true], ['id' => $uid]); + $return = DBA::update('contact', ['blocked' => true, 'block_reason' => $reason], ['id' => $cid]); return $return; } @@ -1677,13 +1673,13 @@ class Contact extends BaseObject /** * @brief Unblocks a contact * - * @param int $uid + * @param int $cid * @return bool * @throws \Exception */ - public static function unblock($uid) + public static function unblock($cid) { - $return = DBA::update('contact', ['blocked' => false], ['id' => $uid]); + $return = DBA::update('contact', ['blocked' => false, 'block_reason' => null], ['id' => $cid]); return $return; } @@ -1702,7 +1698,7 @@ class Contact extends BaseObject */ public static function updateAvatar($avatar, $uid, $cid, $force = false) { - $contact = DBA::selectFirst('contact', ['avatar', 'photo', 'thumb', 'micro', 'nurl'], ['id' => $cid]); + $contact = DBA::selectFirst('contact', ['avatar', 'photo', 'thumb', 'micro', 'nurl'], ['id' => $cid, 'self' => false]); if (!DBA::isResult($contact)) { return false; } else { @@ -1713,17 +1709,14 @@ class Contact extends BaseObject $photos = Photo::importProfilePhoto($avatar, $uid, $cid, true); if ($photos) { - DBA::update( - 'contact', - ['avatar' => $avatar, 'photo' => $photos[0], 'thumb' => $photos[1], 'micro' => $photos[2], 'avatar-date' => DateTimeFormat::utcNow()], - ['id' => $cid] - ); + $fields = ['avatar' => $avatar, 'photo' => $photos[0], 'thumb' => $photos[1], 'micro' => $photos[2], 'avatar-date' => DateTimeFormat::utcNow()]; + DBA::update('contact', $fields, ['id' => $cid]); // Update the public contact (contact id = 0) if ($uid != 0) { $pcontact = DBA::selectFirst('contact', ['id'], ['nurl' => $contact['nurl'], 'uid' => 0]); if (DBA::isResult($pcontact)) { - self::updateAvatar($avatar, 0, $pcontact['id'], $force); + DBA::update('contact', $fields, ['id' => $pcontact['id']]); } } @@ -1734,6 +1727,104 @@ class Contact extends BaseObject return $data; } + /** + * @brief Helper function for "updateFromProbe". Updates personal and public contact + * + * @param array $contact The personal contact entry + * @param array $fields The fields that are updated + * @throws \Exception + */ + private static function updateContact($id, $uid, $url, array $fields) + { + DBA::update('contact', $fields, ['id' => $id]); + + // Search for duplicated contacts and get rid of them + if (self::handleDuplicates(Strings::normaliseLink($url), $uid, $id) || ($uid != 0)) { + return; + } + + // Update the corresponding gcontact entry + GContact::updateFromPublicContactID($id); + + // Archive or unarchive the contact. We only need to do this for the public contact. + // The archive/unarchive function will update the personal contacts by themselves. + $contact = DBA::selectFirst('contact', [], ['id' => $id]); + if (!empty($fields['success_update'])) { + self::unmarkForArchival($contact); + } elseif (!empty($fields['failure_update'])) { + self::markForArchival($contact); + } + + $condition = ['self' => false, 'nurl' => Strings::normaliseLink($url), 'network' => Protocol::FEDERATED]; + + // These contacts are sharing with us, we don't poll them. + // This means that we don't set the update fields in "OnePoll.php". + $condition['rel'] = self::SHARING; + DBA::update('contact', $fields, $condition); + + unset($fields['last-update']); + unset($fields['success_update']); + unset($fields['failure_update']); + + if (empty($fields)) { + return; + } + + // We are polling these contacts, so we mustn't set the update fields here. + $condition['rel'] = [self::FOLLOWER, self::FRIEND]; + DBA::update('contact', $fields, $condition); + } + + /** + * @brief Helper function for "updateFromProbe". Remove duplicated contacts + * + * @param string $nurl Normalised contact url + * @param integer $uid User id + * @param integer $id Contact id of a duplicate + * @return boolean + * @throws \Exception + */ + private static function handleDuplicates($nurl, $uid, $id) + { + $condition = ['nurl' => $nurl, 'uid' => $uid, 'deleted' => false]; + $count = DBA::count('contact', $condition); + if ($count <= 1) { + return false; + } + + $first_contact = DBA::selectFirst('contact', ['id'], $condition, ['order' => ['id']]); + if (!DBA::isResult($first_contact)) { + // Shouldn't happen - so we handle it + return false; + } + + $first = $first_contact['id']; + Logger::info('Found duplicates', ['count' => $count, 'id' => $id, 'first' => $first, 'uid' => $uid, 'nurl' => $nurl]); + if ($uid != 0) { + // Don't handle non public duplicates by now + Logger::info('Not handling non public duplicate', ['uid' => $uid, 'nurl' => $nurl]); + return false; + } + + // Find all duplicates + $condition = ["`nurl` = ? AND `uid` = ? AND `id` != ? AND NOT `self` AND NOT `deleted`", $nurl, $uid, $first]; + $duplicates = DBA::select('contact', ['id'], $condition); + while ($duplicate = DBA::fetch($duplicates)) { + $dup_id = $duplicate['id']; + Logger::info('Handling duplicate', ['search' => $dup_id, 'replace' => $first]); + + // Search and replace + DBA::update('item', ['author-id' => $first], ['author-id' => $dup_id]); + DBA::update('item', ['owner-id' => $first], ['owner-id' => $dup_id]); + DBA::update('item', ['contact-id' => $first], ['contact-id' => $dup_id]); + + // Remove the duplicate + DBA::delete('contact', ['id' => $dup_id]); + } + Logger::info('Duplicates handled', ['uid' => $uid, 'nurl' => $nurl]); + return true; + } + /** * @param integer $id contact id * @param string $network Optional network we are probing for @@ -1746,11 +1837,15 @@ class Contact extends BaseObject { /* Warning: Never ever fetch the public key via Probe::uri and write it into the contacts. - This will reliably kill your communication with Friendica contacts. + This will reliably kill your communication with old Friendica contacts. */ - $fields = ['avatar', 'uid', 'name', 'nick', 'url', 'addr', 'batch', 'notify', - 'poll', 'request', 'confirm', 'poco', 'network', 'alias']; + // These fields aren't updated by this routine: + // 'xmpp', 'sensitive' + + $fields = ['uid', 'avatar', 'name', 'nick', 'location', 'keywords', 'about', 'gender', + 'unsearchable', 'url', 'addr', 'batch', 'notify', 'poll', 'request', 'confirm', 'poco', + 'network', 'alias', 'baseurl', 'forum', 'prv', 'contact-type', 'pubkey']; $contact = DBA::selectFirst('contact', $fields, ['id' => $id]); if (!DBA::isResult($contact)) { return false; @@ -1759,51 +1854,153 @@ class Contact extends BaseObject $uid = $contact['uid']; unset($contact['uid']); + $pubkey = $contact['pubkey']; + unset($contact['pubkey']); + $contact['photo'] = $contact['avatar']; unset($contact['avatar']); $ret = Probe::uri($contact['url'], $network, $uid, !$force); + $updated = DateTimeFormat::utcNow(); + + // We must not try to update relay contacts via probe. They are no real contacts. + // We check after the probing to be able to correct falsely detected contact types. + if (($contact['contact-type'] == self::TYPE_RELAY) && + (!Strings::compareLink($ret['url'], $contact['url']) || in_array($ret['network'], [Protocol::FEED, Protocol::PHANTOM]))) { + self::updateContact($id, $uid, $contact['url'], ['last-update' => $updated, 'success_update' => $updated]); + Logger::info('Not updating relais', ['id' => $id, 'url' => $contact['url']]); + return true; + } + // If Probe::uri fails the network code will be different (mostly "feed" or "unkn") - if (in_array($ret['network'], [Protocol::FEED, Protocol::PHANTOM]) && ($ret['network'] != $contact['network'])) { + if (!in_array($ret['network'], Protocol::NATIVE_SUPPORT) || + (in_array($ret['network'], [Protocol::FEED, Protocol::PHANTOM]) && ($ret['network'] != $contact['network']))) { + if ($force && ($uid == 0)) { + self::updateContact($id, $uid, $ret['url'], ['last-update' => $updated, 'failure_update' => $updated]); + } return false; } - if (!in_array($ret['network'], Protocol::NATIVE_SUPPORT)) { - return false; + if (isset($ret['hide']) && is_bool($ret['hide'])) { + $ret['unsearchable'] = $ret['hide']; + } + + if (isset($ret['account-type']) && is_int($ret['account-type'])) { + $ret['forum'] = false; + $ret['prv'] = false; + $ret['contact-type'] = $ret['account-type']; + if ($ret['contact-type'] == User::ACCOUNT_TYPE_COMMUNITY) { + $apcontact = APContact::getByURL($ret['url'], false); + if (isset($apcontact['manually-approve'])) { + $ret['forum'] = (bool)!$apcontact['manually-approve']; + $ret['prv'] = (bool)!$ret['forum']; + } + } } + $new_pubkey = $ret['pubkey']; + $update = false; - // make sure to not overwrite existing values with blank entries + // make sure to not overwrite existing values with blank entries except some technical fields + $keep = ['batch', 'notify', 'poll', 'request', 'confirm', 'poco', 'baseurl']; foreach ($ret as $key => $val) { - if (!isset($contact[$key])) { + if (!array_key_exists($key, $contact)) { unset($ret[$key]); - } elseif (($contact[$key] != '') && ($val == '')) { + } elseif (($contact[$key] != '') && ($val === '') && !is_bool($ret[$key]) && !in_array($key, $keep)) { $ret[$key] = $contact[$key]; } elseif ($ret[$key] != $contact[$key]) { $update = true; } } + if ($ret['network'] != Protocol::FEED) { + self::updateAvatar($ret['photo'], $uid, $id, $update || $force); + } + if (!$update) { + if ($force && ($uid == 0)) { + self::updateContact($id, $uid, $ret['url'], ['last-update' => $updated, 'success_update' => $updated]); + } return true; } $ret['nurl'] = Strings::normaliseLink($ret['url']); - $ret['updated'] = DateTimeFormat::utcNow(); + $ret['updated'] = $updated; + + // Only fill the pubkey if it had been empty before. We have to prevent identity theft. + if (empty($pubkey) && !empty($new_pubkey)) { + $ret['pubkey'] = $new_pubkey; + } + + if (($ret['addr'] != $contact['addr']) || (!empty($ret['alias']) && ($ret['alias'] != $contact['alias']))) { + $ret['uri-date'] = DateTimeFormat::utcNow(); + } - self::updateAvatar($ret['photo'], $uid, $id, true); + if (($ret['name'] != $contact['name']) || ($ret['nick'] != $contact['nick'])) { + $ret['name-date'] = $updated; + } + + if ($force && ($uid == 0)) { + $ret['last-update'] = $updated; + $ret['success_update'] = $updated; + } unset($ret['photo']); - DBA::update('contact', $ret, ['id' => $id]); - // Update the corresponding gcontact entry - PortableContact::lastUpdated($ret["url"]); + self::updateContact($id, $uid, $ret['url'], $ret); return true; } + public static function updateFromProbeByURL($url, $force = false) + { + $id = self::getIdForURL($url); + + if (empty($id)) { + return $id; + } + + self::updateFromProbe($id, '', $force); + + return $id; + } + + /** + * Detects if a given contact array belongs to a legacy DFRN connection + * + * @param array $contact + * @return boolean + */ + public static function isLegacyDFRNContact($contact) + { + // Newer Friendica contacts are connected via AP, then these fields aren't set + return !empty($contact['dfrn-id']) || !empty($contact['issued-id']); + } + + /** + * Detects the communication protocol for a given contact url. + * This is used to detect Friendica contacts that we can communicate via AP. + * + * @param string $url contact url + * @param string $network Network of that contact + * @return string with protocol + */ + public static function getProtocol($url, $network) + { + if ($network != Protocol::DFRN) { + return $network; + } + + $apcontact = APContact::getByURL($url); + if (!empty($apcontact) && !empty($apcontact['generator'])) { + return Protocol::ACTIVITYPUB; + } else { + return $network; + } + } + /** * Takes a $uid and a url/handle and adds a new contact * Currently if the contact is DFRN, interactive needs to be true, to redirect to the @@ -1879,7 +2076,9 @@ class Contact extends BaseObject $contact = DBA::selectFirst('contact', ['id', 'rel'], $condition); } - if (($ret['network'] === Protocol::DFRN) && !DBA::isResult($contact)) { + $protocol = self::getProtocol($url, $ret['network']); + + if (($protocol === Protocol::DFRN) && !DBA::isResult($contact)) { if ($interactive) { if (strlen($a->getURLPath())) { $myaddr = bin2hex(System::baseUrl() . '/profile/' . $a->user['nickname']); @@ -1898,7 +2097,7 @@ class Contact extends BaseObject } // This extra param just confuses things, remove it - if ($ret['network'] === Protocol::DIASPORA) { + if ($protocol === Protocol::DIASPORA) { $ret['url'] = str_replace('?absolute=true', '', $ret['url']); } @@ -1921,7 +2120,7 @@ class Contact extends BaseObject return $result; } - if ($ret['network'] === Protocol::OSTATUS && Config::get('system', 'ostatus_disabled')) { + if ($protocol === Protocol::OSTATUS && Config::get('system', 'ostatus_disabled')) { $result['message'] .= L10n::t('The profile address specified belongs to a network which has been disabled on this site.') . EOL; $ret['notify'] = ''; } @@ -1930,15 +2129,15 @@ class Contact extends BaseObject $result['message'] .= L10n::t('Limited profile. This person will be unable to receive direct/personal notifications from you.') . EOL; } - $writeable = ((($ret['network'] === Protocol::OSTATUS) && ($ret['notify'])) ? 1 : 0); + $writeable = ((($protocol === Protocol::OSTATUS) && ($ret['notify'])) ? 1 : 0); - $subhub = (($ret['network'] === Protocol::OSTATUS) ? true : false); + $subhub = (($protocol === Protocol::OSTATUS) ? true : false); - $hidden = (($ret['network'] === Protocol::MAIL) ? 1 : 0); + $hidden = (($protocol === Protocol::MAIL) ? 1 : 0); - $pending = in_array($ret['network'], [Protocol::ACTIVITYPUB]); + $pending = in_array($protocol, [Protocol::ACTIVITYPUB]); - if (in_array($ret['network'], [Protocol::MAIL, Protocol::DIASPORA, Protocol::ACTIVITYPUB])) { + if (in_array($protocol, [Protocol::MAIL, Protocol::DIASPORA, Protocol::ACTIVITYPUB])) { $writeable = 1; } @@ -1949,7 +2148,7 @@ class Contact extends BaseObject $fields = ['rel' => $new_relation, 'subhub' => $subhub, 'readonly' => false]; DBA::update('contact', $fields, ['id' => $contact['id']]); } else { - $new_relation = (in_array($ret['network'], [Protocol::MAIL]) ? self::FRIEND : self::SHARING); + $new_relation = (in_array($protocol, [Protocol::MAIL]) ? self::FRIEND : self::SHARING); // create contact record DBA::insert('contact', [ @@ -1966,6 +2165,8 @@ class Contact extends BaseObject 'name' => $ret['name'], 'nick' => $ret['nick'], 'network' => $ret['network'], + 'baseurl' => $ret['baseurl'], + 'protocol' => $protocol, 'pubkey' => $ret['pubkey'], 'rel' => $new_relation, 'priority'=> $ret['priority'], @@ -1999,7 +2200,7 @@ class Contact extends BaseObject $owner = User::getOwnerDataById($uid); if (DBA::isResult($owner)) { - if (in_array($contact['network'], [Protocol::OSTATUS, Protocol::DFRN])) { + if (in_array($protocol, [Protocol::OSTATUS, Protocol::DFRN])) { // create a follow slap $item = []; $item['verb'] = ACTIVITY_FOLLOW; @@ -2015,10 +2216,10 @@ class Contact extends BaseObject if (!empty($contact['notify'])) { Salmon::slapper($owner, $contact['notify'], $slap); } - } elseif ($contact['network'] == Protocol::DIASPORA) { + } elseif ($protocol == Protocol::DIASPORA) { $ret = Diaspora::sendShare($a->user, $contact); Logger::log('share returns: ' . $ret); - } elseif ($contact['network'] == Protocol::ACTIVITYPUB) { + } elseif ($protocol == Protocol::ACTIVITYPUB) { $activity_id = ActivityPub\Transmitter::activityIDFromContact($contact_id); if (empty($activity_id)) { // This really should never happen @@ -2076,56 +2277,81 @@ class Contact extends BaseObject return $contact; } - public static function addRelationship($importer, $contact, $datarray, $item = '', $sharing = false) { + /** + * @param array $importer Owner (local user) data + * @param array $contact Existing owner-specific contact data we want to expand the relationship with. Optional. + * @param array $datarray An item-like array with at least the 'author-id' and 'author-url' keys for the contact. Mandatory. + * @param bool $sharing True: Contact is now sharing with Owner; False: Contact is now following Owner (default) + * @param string $note Introduction additional message + * @return bool|null True: follow request is accepted; False: relationship is rejected; Null: relationship is pending + * @throws \Friendica\Network\HTTPException\InternalServerErrorException + * @throws \ImagickException + */ + public static function addRelationship(array $importer, array $contact, array $datarray, $sharing = false, $note = '') + { // Should always be set if (empty($datarray['author-id'])) { - return; + return false; } - $fields = ['url', 'name', 'nick', 'photo', 'network']; + $fields = ['url', 'name', 'nick', 'avatar', 'photo', 'network', 'blocked']; $pub_contact = DBA::selectFirst('contact', $fields, ['id' => $datarray['author-id']]); if (!DBA::isResult($pub_contact)) { // Should never happen - return; + return false; + } + + // Contact is blocked at node-level + if (self::isBlocked($datarray['author-id'])) { + return false; } $url = defaults($datarray, 'author-link', $pub_contact['url']); $name = $pub_contact['name']; - $photo = $pub_contact['photo']; + $photo = defaults($pub_contact, 'avatar', $pub_contact["photo"]); $nick = $pub_contact['nick']; $network = $pub_contact['network']; - if (is_array($contact)) { + if (!empty($contact)) { + // Contact is blocked at user-level + if (!empty($contact['id']) && !empty($importer['id']) && + self::isBlockedByUser($contact['id'], $importer['id'])) { + return false; + } + + // Make sure that the existing contact isn't archived + self::unmarkForArchival($contact); + if (($contact['rel'] == self::SHARING) || ($sharing && $contact['rel'] == self::FOLLOWER)) { - DBA::update('contact', ['rel' => self::FRIEND, 'writable' => true], + DBA::update('contact', ['rel' => self::FRIEND, 'writable' => true, 'pending' => false], ['id' => $contact['id'], 'uid' => $importer['uid']]); } - if ($contact['network'] == Protocol::ACTIVITYPUB) { - ActivityPub\Transmitter::sendContactAccept($contact['url'], $contact['hub-verify'], $importer['uid']); - } - - // send email notification to owner? + return true; } else { + // send email notification to owner? if (DBA::exists('contact', ['nurl' => Strings::normaliseLink($url), 'uid' => $importer['uid'], 'pending' => true])) { Logger::log('ignoring duplicated connection request from pending contact ' . $url); - return; + return null; } + // create contact record - q("INSERT INTO `contact` (`uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`, - `blocked`, `readonly`, `pending`, `writable`) - VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1)", - intval($importer['uid']), - DBA::escape(DateTimeFormat::utcNow()), - DBA::escape($url), - DBA::escape(Strings::normaliseLink($url)), - DBA::escape($name), - DBA::escape($nick), - DBA::escape($photo), - DBA::escape($network), - intval(self::FOLLOWER) - ); + DBA::insert('contact', [ + 'uid' => $importer['uid'], + 'created' => DateTimeFormat::utcNow(), + 'url' => $url, + 'nurl' => Strings::normaliseLink($url), + 'name' => $name, + 'nick' => $nick, + 'photo' => $photo, + 'network' => $network, + 'rel' => self::FOLLOWER, + 'blocked' => 0, + 'readonly' => 0, + 'pending' => 1, + 'writable' => 1, + ]); $contact_record = [ 'id' => DBA::lastInsertId(), @@ -2146,7 +2372,7 @@ class Contact extends BaseObject if (is_array($contact_record)) { DBA::insert('intro', ['uid' => $importer['uid'], 'contact-id' => $contact_record['id'], - 'blocked' => false, 'knowyou' => false, + 'blocked' => false, 'knowyou' => false, 'note' => $note, 'hash' => $hash, 'datetime' => DateTimeFormat::utcNow()]); } @@ -2169,19 +2395,16 @@ class Contact extends BaseObject 'verb' => ($sharing ? ACTIVITY_FRIEND : ACTIVITY_FOLLOW), 'otype' => 'intro' ]); - } } elseif (DBA::isResult($user) && in_array($user['page-flags'], [User::PAGE_FLAGS_SOAPBOX, User::PAGE_FLAGS_FREELOVE, User::PAGE_FLAGS_COMMUNITY])) { $condition = ['uid' => $importer['uid'], 'url' => $url, 'pending' => true]; DBA::update('contact', ['pending' => false], $condition); - $contact = DBA::selectFirst('contact', ['url', 'network', 'hub-verify'], ['id' => $contact_record['id']]); - - if ($contact['network'] == Protocol::ACTIVITYPUB) { - ActivityPub\Transmitter::sendContactAccept($contact['url'], $contact['hub-verify'], $importer['uid']); - } + return true; } } + + return null; } public static function removeFollower($importer, $contact, array $datarray = [], $item = "") @@ -2285,12 +2508,15 @@ class Contact extends BaseObject return $url ?: $contact_url; // Equivalent to: ($url != '') ? $url : $contact_url; } - $cid = self::getIdForURL($contact_url, 0, true); - if (empty($cid)) { + $data = self::getProbeDataFromDatabase($contact_url); + if (empty($data)) { return $url ?: $contact_url; // Equivalent to: ($url != '') ? $url : $contact_url; } - return self::magicLinkbyId($cid, $url); + // Prevents endless loop in case only a non-public contact exists for the contact URL + unset($data['uid']); + + return self::magicLinkByContact($data, $contact_url); } /** @@ -2331,10 +2557,14 @@ class Contact extends BaseObject return $url; } - if ($contact['uid'] != 0) { + if (!empty($contact['uid'])) { return self::magicLink($contact['url'], $url); } + if (empty($contact['id'])) { + return $url ?: $contact['url']; + } + $redirect = 'redir/' . $contact['id']; if ($url != '') { @@ -2375,4 +2605,18 @@ class Contact extends BaseObject // Is it a forum? return ($contact['forum'] || $contact['prv']); } + + /** + * Can the remote contact receive private messages? + * + * @param array $contact + * @return bool + */ + public static function canReceivePrivateMessages(array $contact) + { + $protocol = $contact['network'] ?? $contact['protocol'] ?? Protocol::PHANTOM; + $self = $contact['self'] ?? false; + + return in_array($protocol, [Protocol::DFRN, Protocol::DIASPORA, Protocol::ACTIVITYPUB]) && !$self; + } }