X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=include%2FContact.php;h=8b575bf122bfba5f8c8cc887e01eeeca65600823;hb=9f2196aa1aa0dc112e3fc238832828d4e22fe137;hp=a4b9cb2de5b56d1639ff05ebf760eb3dc3ba44e8;hpb=c6dbbe21b4377081b6c80b53ac8fd795ac37723a;p=friendica.git diff --git a/include/Contact.php b/include/Contact.php index a4b9cb2de5..8b575bf122 100644 --- a/include/Contact.php +++ b/include/Contact.php @@ -607,6 +607,10 @@ function get_contact($url, $uid = 0, $no_update = false) { $data = array_merge($data, $gcontacts); } + if (!$contact_id && ($data["alias"] != '') && ($data["alias"] != $url)) { + $contact_id = get_contact($data["alias"], $uid, true); + } + $url = $data["url"]; if (!$contact_id) { dba::insert('contact', array('uid' => $uid, 'created' => datetime_convert(), 'url' => $data["url"], @@ -658,7 +662,7 @@ function get_contact($url, $uid = 0, $no_update = false) { update_contact_avatar($data["photo"], $uid, $contact_id); - $contact = dba::select('contact', array('addr', 'alias', 'name', 'nick', 'keywords', 'location', 'about', 'avatar-date'), + $contact = dba::select('contact', array('url', 'nurl', 'addr', 'alias', 'name', 'nick', 'keywords', 'location', 'about', 'avatar-date'), array('id' => $contact_id), array('limit' => 1)); // This condition should always be true @@ -668,6 +672,8 @@ function get_contact($url, $uid = 0, $no_update = false) { $updated = array('addr' => $data['addr'], 'alias' => $data['alias'], + 'url' => $data['url'], + 'nurl' => normalise_link($data['url']), 'name' => $data['name'], 'nick' => $data['nick']); @@ -786,22 +792,25 @@ function posts_from_contact_url(App $a, $contact_url) { // There are no posts with "uid = 0" with connector networks // This speeds up the query a lot - $r = q("SELECT `network`, `id` AS `author-id` FROM `contact` + $r = q("SELECT `network`, `id` AS `author-id`, `contact-type` FROM `contact` WHERE `contact`.`nurl` = '%s' AND `contact`.`uid` = 0", dbesc(normalise_link($contact_url))); + + if (!dbm::is_result($r)) { + return ''; + } + if (in_array($r[0]["network"], array(NETWORK_DFRN, NETWORK_DIASPORA, NETWORK_OSTATUS, ""))) { $sql = "(`item`.`uid` = 0 OR (`item`.`uid` = %d AND NOT `item`.`global`))"; } else { $sql = "`item`.`uid` = %d"; } - if (!dbm::is_result($r)) { - return ''; - } - $author_id = intval($r[0]["author-id"]); - $r = q(item_query()." AND `item`.`author-id` = %d AND ".$sql. + $contact = ($r[0]["contact-type"] = ACCOUNT_TYPE_COMMUNITY ? 'owner-id' : 'author-id'); + + $r = q(item_query()." AND `item`.`".$contact."` = %d AND ".$sql. " ORDER BY `item`.`created` DESC LIMIT %d, %d", intval($author_id), intval(local_user()),