<?php
/**
- * @copyright Copyright (C) 2010-2021, the Friendica project
+ * @copyright Copyright (C) 2010-2022, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
namespace Friendica\Model;
use Friendica\App\BaseURL;
+use Friendica\Contact\Introduction\Exception\IntroductionNotFoundException;
use Friendica\Content\Pager;
use Friendica\Content\Text\HTML;
use Friendica\Core\Hook;
const DEFAULT_AVATAR_THUMB = '/images/person-80.jpg';
const DEFAULT_AVATAR_MICRO = '/images/person-48.jpg';
- /**
- * @deprecated since version 2019.03
- * @see User::PAGE_FLAGS_NORMAL
- */
- const PAGE_NORMAL = User::PAGE_FLAGS_NORMAL;
- /**
- * @deprecated since version 2019.03
- * @see User::PAGE_FLAGS_SOAPBOX
- */
- const PAGE_SOAPBOX = User::PAGE_FLAGS_SOAPBOX;
- /**
- * @deprecated since version 2019.03
- * @see User::PAGE_FLAGS_COMMUNITY
- */
- const PAGE_COMMUNITY = User::PAGE_FLAGS_COMMUNITY;
- /**
- * @deprecated since version 2019.03
- * @see User::PAGE_FLAGS_FREELOVE
- */
- const PAGE_FREELOVE = User::PAGE_FLAGS_FREELOVE;
- /**
- * @deprecated since version 2019.03
- * @see User::PAGE_FLAGS_BLOG
- */
- const PAGE_BLOG = User::PAGE_FLAGS_BLOG;
- /**
- * @deprecated since version 2019.03
- * @see User::PAGE_FLAGS_PRVGROUP
- */
- const PAGE_PRVGROUP = User::PAGE_FLAGS_PRVGROUP;
/**
* @}
*/
return DBA::selectFirst('contact', $fields, ['id' => $id]);
}
+ /**
+ * Fetch the first contact with the provided uri-id.
+ *
+ * @param integer $uri_id uri-id of the contact
+ * @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 getByUriId($uri_id, $fields = [])
+ {
+ return DBA::selectFirst('contact', $fields, ['uri-id' => $uri_id], ['order' => ['uid']]);
+ }
+
/**
* Fetches a contact by a given url
*
{
$fields = ['id', 'name', 'nick', 'location', 'about', 'keywords', 'avatar', 'prvkey', 'pubkey',
'xmpp', 'matrix', 'contact-type', 'forum', 'prv', 'avatar-date', 'url', 'nurl', 'unsearchable',
- 'photo', 'thumb', 'micro', 'addr', 'request', 'notify', 'poll', 'confirm', 'poco', 'network'];
+ 'photo', 'thumb', 'micro', 'header', 'addr', 'request', 'notify', 'poll', 'confirm', 'poco', 'network'];
$self = DBA::selectFirst('contact', $fields, ['uid' => $uid, 'self' => true]);
if (!DBA::isResult($self)) {
return false;
}
$fields['avatar'] = User::getAvatarUrl($user);
+ $fields['header'] = User::getBannerUrl($user);
$fields['forum'] = $user['page-flags'] == User::PAGE_FLAGS_COMMUNITY;
$fields['prv'] = $user['page-flags'] == User::PAGE_FLAGS_PRVGROUP;
$fields['unsearchable'] = !$profile['net-publish'];
self::update(['archive' => true, 'network' => Protocol::PHANTOM, 'deleted' => true], ['id' => $id]);
// Delete it in the background
- Worker::add(PRIORITY_MEDIUM, 'RemoveContact', $id);
+ Worker::add(PRIORITY_MEDIUM, 'Contact\Remove', $id);
}
/**
* @param array $user User unfriending
* @param array $contact Contact (uid != 0) unfriended
* @param boolean $two_way Revoke eventual inbound follow as well
- * @return bool|null true if successful, false if not, null if no action was performed
+ * @return bool|null true if successful, false if not, null if no remote action was performed
* @throws HTTPException\InternalServerErrorException
* @throws \ImagickException
*/
- public static function terminateFriendship(array $user, array $contact): bool
+ public static function terminateFriendship(array $user, array $contact): ?bool
{
$result = Protocol::terminateFriendship($user, $contact);
* @throws HTTPException\InternalServerErrorException
* @throws \ImagickException
*/
- public static function revokeFollow(array $contact): bool
+ public static function revokeFollow(array $contact): ?bool
{
if (empty($contact['network'])) {
throw new \InvalidArgumentException('Empty network in contact array');
];
if (!empty($contact['pending'])) {
- $intro = DBA::selectFirst('intro', ['id'], ['contact-id' => $contact['id']]);
- if (DBA::isResult($intro)) {
- $menu['follow'] = [DI::l10n()->t('Approve'), 'notifications/intros/' . $intro['id'], true];
+ try {
+ $intro = DI::intro()->selectForContact($contact['id']);
+ $menu['follow'] = [DI::l10n()->t('Approve'), 'notifications/intros/' . $intro->id, true];
+ } catch (IntroductionNotFoundException $exception) {
+ DI::logger()->error('Pending contact doesn\'t have an introduction.', ['exception' => $exception]);
}
}
}
Logger::info('Contact will be updated', ['url' => $url, 'uid' => $uid, 'update' => $update, 'cid' => $contact_id]);
}
+ if ($data['network'] == Protocol::DIASPORA) {
+ FContact::updateFromProbeArray($data);
+ }
+
self::updateFromProbeArray($contact_id, $data);
// Don't return a number for a deleted account
*/
public static function checkAvatarCache(int $cid)
{
- $contact = DBA::selectFirst('contact', ['url', 'avatar', 'photo', 'thumb', 'micro'], ['id' => $cid, 'uid' => 0, 'self' => false]);
+ $contact = DBA::selectFirst('contact', ['url', 'network', 'avatar', 'photo', 'thumb', 'micro'], ['id' => $cid, 'uid' => 0, 'self' => false]);
if (!DBA::isResult($contact)) {
return;
}
- if (empty($contact['avatar']) || (!empty($contact['photo']) && !empty($contact['thumb']) && !empty($contact['micro']))) {
+ if (in_array($contact['network'], [Protocol::FEED, Protocol::MAIL]) || DI::config()->get('system', 'cache_contact_avatar')) {
+ if (!empty($contact['avatar']) && (empty($contact['photo']) || empty($contact['thumb']) || empty($contact['micro']))) {
+ Logger::info('Adding avatar cache', ['id' => $cid, 'contact' => $contact]);
+ self::updateAvatar($cid, $contact['avatar'], true);
+ return;
+ }
+ } elseif (!empty($contact['photo']) || !empty($contact['thumb']) || !empty($contact['micro'])) {
+ Logger::info('Removing avatar cache', ['id' => $cid, 'contact' => $contact]);
+ self::updateAvatar($cid, $contact['avatar'], true);
return;
}
-
- Logger::info('Adding avatar cache', ['id' => $cid, 'contact' => $contact]);
-
- self::updateAvatar($cid, $contact['avatar'], true);
}
/**
return $contact;
}
+ /**
+ * Fetch the default header for the given contact
+ *
+ * @param array $contact contact array
+ * @return string avatar URL
+ */
+ public static function getDefaultHeader(array $contact): string
+ {
+ if (!empty($contact['header'])) {
+ return $contact['header'];
+ }
+
+ if (!empty($contact['gsid'])) {
+ // Use default banners for certain platforms
+ $gserver = DBA::selectFirst('gserver', ['platform'], ['id' => $contact['gsid']]);
+ $platform = strtolower($gserver['platform'] ?? '');
+ } else {
+ $platform = '';
+ }
+
+ switch ($platform) {
+ case 'friendica':
+ case 'friendika':
+ /**
+ * Picture credits
+ * @author Lostinlight <https://mastodon.xyz/@lightone>
+ * @license CC0 https://creativecommons.org/share-your-work/public-domain/cc0/
+ * @link https://gitlab.com/lostinlight/per_aspera_ad_astra/-/blob/master/friendica-404/friendica-promo-bubbles.jpg
+ */
+ $header = DI::baseUrl() . '/images/friendica-banner.jpg';
+ break;
+ case 'diaspora':
+ /**
+ * Picture credits
+ * @author John Liu <https://www.flickr.com/photos/8047705@N02/>
+ * @license CC BY 2.0 https://creativecommons.org/licenses/by/2.0/
+ * @link https://www.flickr.com/photos/8047705@N02/5572197407
+ */
+ $header = DI::baseUrl() . '/images/diaspora-banner.jpg';
+ break;
+ default:
+ /**
+ * Use a random picture.
+ * The service provides random pictures from Unsplash.
+ * @license https://unsplash.com/license
+ */
+ $header = 'https://picsum.photos/seed/' . hash('ripemd128', $contact['url']) . '/960/300';
+ break;
+ }
+
+ return $header;
+ }
+
/**
* Fetch the default avatar for the given contact and size
*
* Get avatar link for given contact id
*
* @param integer $cid contact id
- * @param string $size One of the ProxyUtils::SIZE_* constants
+ * @param string $size One of the Proxy::SIZE_* constants
* @param string $updated Contact update date
* @return string avatar link
*/
*
* @param string $url contact url
* @param integer $uid user id
- * @param string $size One of the ProxyUtils::SIZE_* constants
+ * @param string $size One of the Proxy::SIZE_* constants
* @return string avatar link
*/
public static function getAvatarUrlForUrl(string $url, int $uid, string $size = ''):string
* Get header link for given contact id
*
* @param integer $cid contact id
- * @param string $size One of the ProxyUtils::SIZE_* constants
+ * @param string $size One of the Proxy::SIZE_* constants
* @param string $updated Contact update date
* @return string header link
*/
$avatar = self::getDefaultAvatar($contact, Proxy::SIZE_SMALL);
}
- if ($default_avatar && Proxy::isLocalImage($avatar)) {
- $fields = ['avatar' => $avatar, 'avatar-date' => DateTimeFormat::utcNow(),
- 'photo' => $avatar,
- 'thumb' => self::getDefaultAvatar($contact, Proxy::SIZE_THUMB),
- 'micro' => self::getDefaultAvatar($contact, Proxy::SIZE_MICRO)];
- Logger::debug('Use default avatar', ['id' => $cid, 'uid' => $uid]);
+ $cache_avatar = DI::config()->get('system', 'cache_contact_avatar');
+
+ // Local contact avatars don't need to be cached
+ if ($cache_avatar && Network::isLocalLink($contact['url'])) {
+ $cache_avatar = !DBA::exists('contact', ['nurl' => $contact['nurl'], 'self' => true]);
}
- // Use the data from the self account
- if (empty($fields)) {
- $local_uid = User::getIdForURL($contact['url']);
- if (!empty($local_uid)) {
- $fields = self::selectFirst(['avatar', 'avatar-date', 'photo', 'thumb', 'micro'], ['self' => true, 'uid' => $local_uid]);
- Logger::debug('Use owner data', ['id' => $cid, 'uid' => $uid, 'owner-uid' => $local_uid]);
+ if (in_array($contact['network'], [Protocol::FEED, Protocol::MAIL]) || $cache_avatar) {
+ if ($default_avatar && Proxy::isLocalImage($avatar)) {
+ $fields = ['avatar' => $avatar, 'avatar-date' => DateTimeFormat::utcNow(),
+ 'photo' => $avatar,
+ 'thumb' => self::getDefaultAvatar($contact, Proxy::SIZE_THUMB),
+ 'micro' => self::getDefaultAvatar($contact, Proxy::SIZE_MICRO)];
+ Logger::debug('Use default avatar', ['id' => $cid, 'uid' => $uid]);
}
- }
- if (empty($fields)) {
- $update = ($contact['avatar'] != $avatar) || $force;
-
- if (!$update) {
- $data = [
- $contact['photo'] ?? '',
- $contact['thumb'] ?? '',
- $contact['micro'] ?? '',
- ];
-
- foreach ($data as $image_uri) {
- $image_rid = Photo::ridFromURI($image_uri);
- if ($image_rid && !Photo::exists(['resource-id' => $image_rid, 'uid' => $uid])) {
- Logger::debug('Regenerating avatar', ['contact uid' => $uid, 'cid' => $cid, 'missing photo' => $image_rid, 'avatar' => $contact['avatar']]);
- $update = true;
- }
+ // Use the data from the self account
+ if (empty($fields)) {
+ $local_uid = User::getIdForURL($contact['url']);
+ if (!empty($local_uid)) {
+ $fields = self::selectFirst(['avatar', 'avatar-date', 'photo', 'thumb', 'micro'], ['self' => true, 'uid' => $local_uid]);
+ Logger::debug('Use owner data', ['id' => $cid, 'uid' => $uid, 'owner-uid' => $local_uid]);
}
}
- if ($update) {
- $photos = Photo::importProfilePhoto($avatar, $uid, $cid, true);
- if ($photos) {
- $fields = ['avatar' => $avatar, 'photo' => $photos[0], 'thumb' => $photos[1], 'micro' => $photos[2], 'avatar-date' => DateTimeFormat::utcNow()];
- $update = !empty($fields);
- Logger::debug('Created new cached avatars', ['id' => $cid, 'uid' => $uid, 'owner-uid' => $local_uid]);
- } else {
- $update = false;
+ if (empty($fields)) {
+ $update = ($contact['avatar'] != $avatar) || $force;
+
+ if (!$update) {
+ $data = [
+ $contact['photo'] ?? '',
+ $contact['thumb'] ?? '',
+ $contact['micro'] ?? '',
+ ];
+
+ foreach ($data as $image_uri) {
+ $image_rid = Photo::ridFromURI($image_uri);
+ if ($image_rid && !Photo::exists(['resource-id' => $image_rid, 'uid' => $uid])) {
+ Logger::debug('Regenerating avatar', ['contact uid' => $uid, 'cid' => $cid, 'missing photo' => $image_rid, 'avatar' => $contact['avatar']]);
+ $update = true;
+ }
+ }
+ }
+
+ if ($update) {
+ $photos = Photo::importProfilePhoto($avatar, $uid, $cid, true);
+ if ($photos) {
+ $fields = ['avatar' => $avatar, 'photo' => $photos[0], 'thumb' => $photos[1], 'micro' => $photos[2], 'avatar-date' => DateTimeFormat::utcNow()];
+ $update = !empty($fields);
+ Logger::debug('Created new cached avatars', ['id' => $cid, 'uid' => $uid, 'owner-uid' => $local_uid]);
+ } else {
+ $update = false;
+ }
}
+ } else {
+ $update = ($fields['photo'] . $fields['thumb'] . $fields['micro'] != $contact['photo'] . $contact['thumb'] . $contact['micro']) || $force;
}
} else {
- $update = ($fields['photo'] . $fields['thumb'] . $fields['micro'] != $contact['photo'] . $contact['thumb'] . $contact['micro']) || $force;
+ Photo::delete(['uid' => $uid, 'contact-id' => $cid, 'photo-type' => Photo::CONTACT_AVATAR]);
+ $fields = ['avatar' => $avatar, 'avatar-date' => DateTimeFormat::utcNow(),
+ 'photo' => '', 'thumb' => '', 'micro' => ''];
+ $update = ($avatar != $contact['avatar'] . $contact['photo'] . $contact['thumb'] . $contact['micro']) || $force;
}
if (!$update) {
if (!empty($cids)) {
// Delete possibly existing cached user contact avatars
- Photo::delete(['uid' => $uids, 'contact-id' => $cids, 'album' => Photo::CONTACT_PHOTOS]);
+ Photo::delete(['uid' => $uids, 'contact-id' => $cids, 'photo-type' => Photo::CONTACT_AVATAR]);
}
}
}
$ret = Probe::uri($contact['url'], $network, $contact['uid']);
+
+ if ($ret['network'] == Protocol::DIASPORA) {
+ FContact::updateFromProbeArray($ret);
+ }
+
return self::updateFromProbeArray($id, $ret);
}
}
$update = false;
- $guid = $ret['guid'] ?: Item::guidFromUri($ret['url'], parse_url($ret['url'], PHP_URL_HOST));
+ $guid = ($ret['guid'] ?? '') ?: Item::guidFromUri($ret['url'], parse_url($ret['url'], PHP_URL_HOST));
// make sure to not overwrite existing values with blank entries except some technical fields
$keep = ['batch', 'notify', 'poll', 'request', 'confirm', 'poco', 'baseurl'];
self::updateAvatar($id, $ret['photo'], $update);
}
- if (empty($guid)) {
- $uriid = ItemURI::getIdByURI($ret['url']);
- } else {
- $uriid = ItemURI::insert(['uri' => $ret['url'], 'guid' => $guid]);
- }
+ $uriid = ItemURI::insert(['uri' => $ret['url'], 'guid' => $guid]);
if (!$update) {
self::updateContact($id, $uid, $contact['url'], $ret['url'], ['failed' => false, 'last-update' => $updated, 'success_update' => $updated]);
}
if (($network != '') && ($ret['network'] != $network)) {
- Logger::log('Expected network ' . $network . ' does not match actual network ' . $ret['network']);
+ Logger::notice('Expected network ' . $network . ' does not match actual network ' . $ret['network']);
return $result;
}
if (DBA::isResult($contact)) {
// update contact
- $new_relation = (($contact['rel'] == self::FOLLOWER) ? self::FRIEND : self::SHARING);
+ $new_relation = (in_array($contact['rel'], [self::FOLLOWER, self::FRIEND]) ? self::FRIEND : self::SHARING);
$fields = ['rel' => $new_relation, 'subhub' => $subhub, 'readonly' => false];
self::update($fields, ['id' => $contact['id']]);
$contact_id = $contact['id'];
$result['cid'] = $contact_id;
- Group::addMember(User::getDefaultGroup($uid, $contact["network"]), $contact_id);
+ Group::addMember(User::getDefaultGroup($uid), $contact_id);
// Update the avatar
self::updateAvatar($contact_id, $ret['photo']);
Worker::add(PRIORITY_HIGH, 'UpdateContact', $contact_id);
}
- $owner = User::getOwnerDataById($uid);
-
- if (DBA::isResult($owner)) {
- if (in_array($protocol, [Protocol::OSTATUS, Protocol::DFRN])) {
- // create a follow slap
- $item = [];
- $item['verb'] = Activity::FOLLOW;
- $item['gravity'] = GRAVITY_ACTIVITY;
- $item['follow'] = $contact["url"];
- $item['body'] = '';
- $item['title'] = '';
- $item['guid'] = '';
- $item['uri-id'] = 0;
+ $result['success'] = Protocol::follow($uid, $contact, $protocol);
- $slap = OStatus::salmon($item, $owner);
-
- if (!empty($contact['notify'])) {
- Salmon::slapper($owner, $contact['notify'], $slap);
- }
- } elseif ($protocol == Protocol::DIASPORA) {
- $ret = Diaspora::sendShare($owner, $contact);
- Logger::log('share returns: ' . $ret);
- } elseif ($protocol == Protocol::ACTIVITYPUB) {
- $activity_id = ActivityPub\Transmitter::activityIDFromContact($contact_id);
- if (empty($activity_id)) {
- // This really should never happen
- return false;
- }
-
- $ret = ActivityPub\Transmitter::sendActivity('Follow', $contact['url'], $uid, $activity_id);
- Logger::log('Follow returns: ' . $ret);
- }
- }
-
- $result['success'] = true;
return $result;
}
- /**
- * Updated contact's SSL policy
- *
- * @param array $contact Contact array
- * @param string $new_policy New policy, valid: self,full
- *
- * @return array Contact array with updated values
- * @throws \Exception
- */
- public static function updateSslPolicy(array $contact, $new_policy)
- {
- $ssl_changed = false;
- if ((intval($new_policy) == BaseURL::SSL_POLICY_SELFSIGN || $new_policy === 'self') && strstr($contact['url'], 'https:')) {
- $ssl_changed = true;
- $contact['url'] = str_replace('https:', 'http:', $contact['url']);
- $contact['request'] = str_replace('https:', 'http:', $contact['request']);
- $contact['notify'] = str_replace('https:', 'http:', $contact['notify']);
- $contact['poll'] = str_replace('https:', 'http:', $contact['poll']);
- $contact['confirm'] = str_replace('https:', 'http:', $contact['confirm']);
- $contact['poco'] = str_replace('https:', 'http:', $contact['poco']);
- }
-
- if ((intval($new_policy) == BaseURL::SSL_POLICY_FULL || $new_policy === 'full') && strstr($contact['url'], 'http:')) {
- $ssl_changed = true;
- $contact['url'] = str_replace('http:', 'https:', $contact['url']);
- $contact['request'] = str_replace('http:', 'https:', $contact['request']);
- $contact['notify'] = str_replace('http:', 'https:', $contact['notify']);
- $contact['poll'] = str_replace('http:', 'https:', $contact['poll']);
- $contact['confirm'] = str_replace('http:', 'https:', $contact['confirm']);
- $contact['poco'] = str_replace('http:', 'https:', $contact['poco']);
- }
-
- if ($ssl_changed) {
- $fields = ['url' => $contact['url'], 'request' => $contact['request'],
- 'notify' => $contact['notify'], 'poll' => $contact['poll'],
- 'confirm' => $contact['confirm'], 'poco' => $contact['poco']];
- self::update($fields, ['id' => $contact['id']]);
- }
-
- return $contact;
- }
-
- /**
- * Follow a contact
- *
- * @param int $cid Public contact id
- * @param int $uid User ID
- *
- * @return bool "true" if following had been successful
- */
- public static function follow(int $cid, int $uid)
- {
- $contact = self::getById($cid, ['url']);
-
- $result = self::createFromProbeForUser($uid, $contact['url']);
-
- return $result['cid'];
- }
-
/**
* Unfollow a contact
*
} 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);
+ Logger::notice('ignoring duplicated connection request from pending contact ' . $url);
return null;
}
$user = DBA::selectFirst('user', $fields, ['uid' => $importer['uid']]);
if (DBA::isResult($user) && !in_array($user['page-flags'], [User::PAGE_FLAGS_SOAPBOX, User::PAGE_FLAGS_FREELOVE, User::PAGE_FLAGS_COMMUNITY])) {
// create notification
- $hash = Strings::getRandomHex();
-
if (is_array($contact_record)) {
- DBA::insert('intro', ['uid' => $importer['uid'], 'contact-id' => $contact_record['id'],
- 'blocked' => false, 'knowyou' => false, 'note' => $note,
- 'hash' => $hash, 'datetime' => DateTimeFormat::utcNow()]);
+ $intro = DI::introFactory()->createNew(
+ $importer['uid'],
+ $contact_record['id'],
+ $note
+ );
+ DI::intro()->save($intro);
}
- Group::addMember(User::getDefaultGroup($importer['uid'], $contact_record["network"]), $contact_record['id']);
+ Group::addMember(User::getDefaultGroup($importer['uid']), $contact_record['id']);
if (($user['notify-flags'] & Notification\Type::INTRO) &&
in_array($user['page-flags'], [User::PAGE_FLAGS_NORMAL])) {
- notification([
+ DI::notify()->createFromArray([
'type' => Notification\Type::INTRO,
'otype' => Notification\ObjectType::INTRO,
'verb' => ($sharing ? Activity::FRIEND : Activity::FOLLOW),
$contacts = DBA::select('contact', ['id', 'uid', 'name', 'url', 'bd'], $condition);
while ($contact = DBA::fetch($contacts)) {
- Logger::log('update_contact_birthday: ' . $contact['bd']);
+ Logger::notice('update_contact_birthday: ' . $contact['bd']);
$nextbd = DateTimeFormat::utcNow('Y') . substr($contact['bd'], 4);
}
// check supported networks
+ $networks = [Protocol::DFRN, Protocol::ACTIVITYPUB];
if (DI::config()->get('system', 'diaspora_enabled')) {
- $diaspora = Protocol::DIASPORA;
- } else {
- $diaspora = Protocol::DFRN;
+ $networks[] = Protocol::DIASPORA;
}
if (!DI::config()->get('system', 'ostatus_disabled')) {
- $ostatus = Protocol::OSTATUS;
- } else {
- $ostatus = Protocol::DFRN;
+ $networks[] = Protocol::OSTATUS;
+ }
+
+ $condition = ['network' => $networks, 'failed' => false, 'deleted' => false, 'uid' => $uid];
+
+ if ($uid == 0) {
+ $condition['blocked'] = false;
}
// check if we search only communities or every contact
if ($mode === 'community') {
- $extra_sql = sprintf(' AND `contact-type` = %d', self::TYPE_COMMUNITY);
- } else {
- $extra_sql = '';
+ $condition['contact-type'] = self::TYPE_COMMUNITY;
}
$search .= '%';
- $results = DBA::p("SELECT * FROM `contact`
- WHERE (NOT `unsearchable` OR `nurl` IN (SELECT `nurl` FROM `owner-view` where `publish` OR `net-publish`))
- AND `network` IN (?, ?, ?, ?) AND
- NOT `failed` AND `uid` = ? AND
- (`addr` LIKE ? OR `name` LIKE ? OR `nick` LIKE ?) $extra_sql
- ORDER BY `nurl` DESC LIMIT 1000",
- Protocol::DFRN, Protocol::ACTIVITYPUB, $ostatus, $diaspora, $uid, $search, $search, $search
- );
+ $condition = DBA::mergeConditions($condition,
+ ["(NOT `unsearchable` OR `nurl` IN (SELECT `nurl` FROM `owner-view` WHERE `publish` OR `net-publish`))
+ AND (`addr` LIKE ? OR `name` LIKE ? OR `nick` LIKE ?)", $search, $search, $search]);
- $contacts = DBA::toArray($results);
+ $contacts = self::selectToArray([], $condition);
return $contacts;
}
projects / friendica.git / blobdiff