4 * @file src/Worker/UpdateGcontact.php
7 namespace Friendica\Worker;
9 use Friendica\Core\Logger;
10 use Friendica\Core\Protocol;
11 use Friendica\Database\DBA;
12 use Friendica\Network\Probe;
13 use Friendica\Protocol\PortableContact;
14 use Friendica\Util\DateTimeFormat;
18 public static function execute($contact_id)
20 Logger::log('update_gcontact: start');
22 if (empty($contact_id)) {
23 Logger::log('update_gcontact: no contact');
27 $r = q("SELECT * FROM `gcontact` WHERE `id` = %d", intval($contact_id));
29 if (!DBA::isResult($r)) {
33 if (!in_array($r[0]["network"], [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::DIASPORA, Protocol::OSTATUS])) {
37 $data = Probe::uri($r[0]["url"]);
39 if (!in_array($data["network"], [Protocol::ACTIVITYPUB, Protocol::DFRN, Protocol::DIASPORA, Protocol::OSTATUS])) {
40 if ($r[0]["server_url"] != "") {
41 PortableContact::checkServer($r[0]["server_url"], $r[0]["network"]);
44 q("UPDATE `gcontact` SET `last_failure` = '%s' WHERE `id` = %d",
45 DBA::escape(DateTimeFormat::utcNow()), intval($contact_id));
49 if (($data["name"] == "") && ($r[0]['name'] != "")) {
50 $data["name"] = $r[0]['name'];
53 if (($data["nick"] == "") && ($r[0]['nick'] != "")) {
54 $data["nick"] = $r[0]['nick'];
57 if (($data["addr"] == "") && ($r[0]['addr'] != "")) {
58 $data["addr"] = $r[0]['addr'];
61 if (($data["photo"] == "") && ($r[0]['photo'] != "")) {
62 $data["photo"] = $r[0]['photo'];
66 q("UPDATE `gcontact` SET `name` = '%s', `nick` = '%s', `addr` = '%s', `photo` = '%s'
68 DBA::escape($data["name"]),
69 DBA::escape($data["nick"]),
70 DBA::escape($data["addr"]),
71 DBA::escape($data["photo"]),
75 q("UPDATE `contact` SET `name` = '%s', `nick` = '%s', `addr` = '%s', `photo` = '%s'
76 WHERE `uid` = 0 AND `addr` = '' AND `nurl` = '%s'",
77 DBA::escape($data["name"]),
78 DBA::escape($data["nick"]),
79 DBA::escape($data["addr"]),
80 DBA::escape($data["photo"]),
81 DBA::escape(normalise_link($data["url"]))
84 q("UPDATE `contact` SET `addr` = '%s'
85 WHERE `uid` != 0 AND `addr` = '' AND `nurl` = '%s'",
86 DBA::escape($data["addr"]),
87 DBA::escape(normalise_link($data["url"]))