+
+ /**
+ * @brief Add new birthday event for this person
+ *
+ * @param array $contact Contact record
+ * @param string $birthday Birthday of the contact
+ * @todo Add array type-hint for $contact
+ */
+ private static function birthday_event($contact, $birthday) {
+
+ // Check for duplicates
+ $r = q("SELECT `id` FROM `event` WHERE `uid` = %d AND `cid` = %d AND `start` = '%s' AND `type` = '%s' LIMIT 1",
+ intval($contact["uid"]),
+ intval($contact["id"]),
+ dbesc(datetime_convert("UTC","UTC", $birthday)),
+ dbesc("birthday"));
+
+ if (dbm::is_result($r)) {
+ return;
+ }
+
+ logger("updating birthday: ".$birthday." for contact ".$contact["id"]);
+
+ $bdtext = sprintf(t("%s\'s birthday"), $contact["name"]);
+ $bdtext2 = sprintf(t("Happy Birthday %s"), " [url=".$contact["url"]."]".$contact["name"]."[/url]") ;
+
+ $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
+ VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s') ",
+ intval($contact["uid"]),
+ intval($contact["id"]),
+ dbesc(datetime_convert()),
+ dbesc(datetime_convert()),
+ dbesc(datetime_convert("UTC","UTC", $birthday)),
+ dbesc(datetime_convert("UTC","UTC", $birthday." + 1 day ")),
+ dbesc($bdtext),
+ dbesc($bdtext2),
+ dbesc("birthday")
+ );
+ }
+
+ /**
+ * @brief Fetch the author data from head or entry items
+ *
+ * @param object $xpath XPath object
+ * @param object $context In which context should the data be searched
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @param string $element Element name from which the data is fetched
+ * @param bool $onlyfetch Should the data only be fetched or should it update the contact record as well
+ *
+ * @return Returns an array with relevant data of the author
+ * @todo Find good type-hints for all parameter
+ */
+ private static function fetchauthor($xpath, $context, $importer, $element, $onlyfetch, $xml = "") {
+
+ $author = array();
+ $author["name"] = $xpath->evaluate($element."/atom:name/text()", $context)->item(0)->nodeValue;
+ $author["link"] = $xpath->evaluate($element."/atom:uri/text()", $context)->item(0)->nodeValue;
+
+ $r = q("SELECT `id`, `uid`, `url`, `network`, `avatar-date`, `name-date`, `uri-date`, `addr`,
+ `name`, `nick`, `about`, `location`, `keywords`, `xmpp`, `bdyear`, `bd`, `hidden`, `contact-type`
+ FROM `contact` WHERE `uid` = %d AND `nurl` = '%s' AND `network` != '%s'",
+ intval($importer["uid"]), dbesc(normalise_link($author["link"])), dbesc(NETWORK_STATUSNET));
+
+ if (dbm::is_result($r)) {
+ $contact = $r[0];
+ $author["contact-id"] = $r[0]["id"];
+ $author["network"] = $r[0]["network"];
+ } else {
+ if (!$onlyfetch) {
+ logger("Contact ".$author["link"]." wasn't found for user ".$importer["uid"]." XML: ".$xml, LOGGER_DEBUG);
+ }
+
+ $author["contact-id"] = $importer["id"];
+ $author["network"] = $importer["network"];
+ $onlyfetch = true;
+ }
+
+ // Until now we aren't serving different sizes - but maybe later
+ $avatarlist = array();
+ /// @todo check if "avatar" or "photo" would be the best field in the specification
+ $avatars = $xpath->query($element."/atom:link[@rel='avatar']", $context);
+ foreach ($avatars AS $avatar) {
+ $href = "";
+ $width = 0;
+ foreach ($avatar->attributes AS $attributes) {
+ /// @TODO Rewrite these similar if() to one switch
+ if ($attributes->name == "href") {
+ $href = $attributes->textContent;
+ }
+ if ($attributes->name == "width") {
+ $width = $attributes->textContent;
+ }
+ if ($attributes->name == "updated") {
+ $contact["avatar-date"] = $attributes->textContent;
+ }
+ }
+ if (($width > 0) AND ($href != "")) {
+ $avatarlist[$width] = $href;
+ }
+ }
+ if (count($avatarlist) > 0) {
+ krsort($avatarlist);
+ $author["avatar"] = current($avatarlist);
+ }
+
+ if (dbm::is_result($r) AND !$onlyfetch) {
+ logger("Check if contact details for contact ".$r[0]["id"]." (".$r[0]["nick"].") have to be updated.", LOGGER_DEBUG);
+
+ $poco = array("url" => $contact["url"]);
+
+ // When was the last change to name or uri?
+ $name_element = $xpath->query($element."/atom:name", $context)->item(0);
+ foreach ($name_element->attributes AS $attributes) {
+ if ($attributes->name == "updated") {
+ $poco["name-date"] = $attributes->textContent;
+ }
+ }
+
+ $link_element = $xpath->query($element."/atom:link", $context)->item(0);
+ foreach ($link_element->attributes AS $attributes) {
+ if ($attributes->name == "updated") {
+ $poco["uri-date"] = $attributes->textContent;
+ }
+ }
+
+ // Update contact data
+ $value = $xpath->evaluate($element."/dfrn:handle/text()", $context)->item(0)->nodeValue;
+ if ($value != "") {
+ $poco["addr"] = $value;
+ }
+
+ $value = $xpath->evaluate($element."/poco:displayName/text()", $context)->item(0)->nodeValue;
+ if ($value != "") {
+ $poco["name"] = $value;
+ }
+
+ $value = $xpath->evaluate($element."/poco:preferredUsername/text()", $context)->item(0)->nodeValue;
+ if ($value != "") {
+ $poco["nick"] = $value;
+ }
+
+ $value = $xpath->evaluate($element."/poco:note/text()", $context)->item(0)->nodeValue;
+ if ($value != "") {
+ $poco["about"] = $value;
+ }
+
+ $value = $xpath->evaluate($element."/poco:address/poco:formatted/text()", $context)->item(0)->nodeValue;
+ if ($value != "") {
+ $poco["location"] = $value;
+ }
+
+ /// @todo Only search for elements with "poco:type" = "xmpp"
+ $value = $xpath->evaluate($element."/poco:ims/poco:value/text()", $context)->item(0)->nodeValue;
+ if ($value != "") {
+ $poco["xmpp"] = $value;
+ }
+
+ /// @todo Add support for the following fields that we don't support by now in the contact table:
+ /// - poco:utcOffset
+ /// - poco:urls
+ /// - poco:locality
+ /// - poco:region
+ /// - poco:country
+
+ // If the "hide" element is present then the profile isn't searchable.
+ $hide = intval($xpath->evaluate($element."/dfrn:hide/text()", $context)->item(0)->nodeValue == "true");
+
+ logger("Hidden status for contact ".$contact["url"].": ".$hide, LOGGER_DEBUG);
+
+ // If the contact isn't searchable then set the contact to "hidden".
+ // Problem: This can be manually overridden by the user.
+ if ($hide) {
+ $contact["hidden"] = true;
+ }
+
+ // Save the keywords into the contact table
+ $tags = array();
+ $tagelements = $xpath->evaluate($element."/poco:tags/text()", $context);
+ foreach ($tagelements AS $tag) {
+ $tags[$tag->nodeValue] = $tag->nodeValue;
+ }
+
+ if (count($tags)) {
+ $poco["keywords"] = implode(", ", $tags);
+ }
+
+ // "dfrn:birthday" contains the birthday converted to UTC
+ $old_bdyear = $contact["bdyear"];
+
+ $birthday = $xpath->evaluate($element."/dfrn:birthday/text()", $context)->item(0)->nodeValue;
+
+ if (strtotime($birthday) > time()) {
+ $bd_timestamp = strtotime($birthday);
+
+ $poco["bdyear"] = date("Y", $bd_timestamp);
+ }
+
+ // "poco:birthday" is the birthday in the format "yyyy-mm-dd"
+ $value = $xpath->evaluate($element."/poco:birthday/text()", $context)->item(0)->nodeValue;
+
+ if (!in_array($value, array("", "0000-00-00"))) {
+ $bdyear = date("Y");
+ $value = str_replace("0000", $bdyear, $value);
+
+ if (strtotime($value) < time()) {
+ $value = str_replace($bdyear, $bdyear + 1, $value);
+ $bdyear = $bdyear + 1;
+ }
+
+ $poco["bd"] = $value;
+ }
+
+ $contact = array_merge($contact, $poco);
+
+ if ($old_bdyear != $contact["bdyear"]) {
+ self::birthday_event($contact, $birthday);
+ }
+
+ // Get all field names
+ $fields = array();
+ foreach ($r[0] AS $field => $data) {
+ $fields[$field] = $data;
+ }
+
+ unset($fields["id"]);
+ unset($fields["uid"]);
+ unset($fields["url"]);
+ unset($fields["avatar-date"]);
+ unset($fields["name-date"]);
+ unset($fields["uri-date"]);
+
+ // Update check for this field has to be done differently
+ $datefields = array("name-date", "uri-date");
+ foreach ($datefields AS $field) {
+ if (strtotime($contact[$field]) > strtotime($r[0][$field])) {
+ logger("Difference for contact ".$contact["id"]." in field '".$field."'. New value: '".$contact[$field]."', old value '".$r[0][$field]."'", LOGGER_DEBUG);
+ $update = true;
+ }
+ }
+
+ foreach ($fields AS $field => $data) {
+ if ($contact[$field] != $r[0][$field]) {
+ logger("Difference for contact ".$contact["id"]." in field '".$field."'. New value: '".$contact[$field]."', old value '".$r[0][$field]."'", LOGGER_DEBUG);
+ $update = true;
+ }
+ }
+
+ if ($update) {
+ logger("Update contact data for contact ".$contact["id"]." (".$contact["nick"].")", LOGGER_DEBUG);
+
+ q("UPDATE `contact` SET `name` = '%s', `nick` = '%s', `about` = '%s', `location` = '%s',
+ `addr` = '%s', `keywords` = '%s', `bdyear` = '%s', `bd` = '%s', `hidden` = %d,
+ `xmpp` = '%s', `name-date` = '%s', `uri-date` = '%s'
+ WHERE `id` = %d AND `network` = '%s'",
+ dbesc($contact["name"]), dbesc($contact["nick"]), dbesc($contact["about"]), dbesc($contact["location"]),
+ dbesc($contact["addr"]), dbesc($contact["keywords"]), dbesc($contact["bdyear"]),
+ dbesc($contact["bd"]), intval($contact["hidden"]), dbesc($contact["xmpp"]),
+ dbesc($contact["name-date"]), dbesc($contact["uri-date"]),
+ intval($contact["id"]), dbesc($contact["network"]));
+ }
+
+ update_contact_avatar($author["avatar"], $importer["uid"], $contact["id"],
+ (strtotime($contact["avatar-date"]) > strtotime($r[0]["avatar-date"])));
+
+ // The generation is a sign for the reliability of the provided data.
+ // It is used in the socgraph.php to prevent that old contact data
+ // that was relayed over several servers can overwrite contact
+ // data that we received directly.
+
+ $poco["generation"] = 2;
+ $poco["photo"] = $author["avatar"];
+ $poco["hide"] = $hide;
+ $poco["contact-type"] = $contact["contact-type"];
+ update_gcontact($poco);
+ }
+
+ return($author);
+ }
+
+ /**
+ * @brief Transforms activity objects into an XML string
+ *
+ * @param object $xpath XPath object
+ * @param object $activity Activity object
+ * @param text $element element name
+ *
+ * @return string XML string
+ * @todo Find good type-hints for all parameter
+ */
+ private static function transform_activity($xpath, $activity, $element) {
+ if (!is_object($activity)) {
+ return "";
+ }
+
+ $obj_doc = new DOMDocument("1.0", "utf-8");
+ $obj_doc->formatOutput = true;
+
+ $obj_element = $obj_doc->createElementNS(NAMESPACE_ATOM1, $element);
+
+ $activity_type = $xpath->query("activity:object-type/text()", $activity)->item(0)->nodeValue;
+ xml::add_element($obj_doc, $obj_element, "type", $activity_type);
+
+ $id = $xpath->query("atom:id", $activity)->item(0);
+ if (is_object($id)) {
+ $obj_element->appendChild($obj_doc->importNode($id, true));
+ }
+
+ $title = $xpath->query("atom:title", $activity)->item(0);
+ if (is_object($title)) {
+ $obj_element->appendChild($obj_doc->importNode($title, true));
+ }
+
+ $links = $xpath->query("atom:link", $activity);
+ if (is_object($links)) {
+ foreach ($links AS $link) {
+ $obj_element->appendChild($obj_doc->importNode($link, true));
+ }
+ }
+
+ $content = $xpath->query("atom:content", $activity)->item(0);
+ if (is_object($content)) {
+ $obj_element->appendChild($obj_doc->importNode($content, true));
+ }
+
+ $obj_doc->appendChild($obj_element);
+
+ $objxml = $obj_doc->saveXML($obj_element);
+
+ /// @todo This isn't totally clean. We should find a way to transform the namespaces
+ $objxml = str_replace("<".$element.' xmlns="http://www.w3.org/2005/Atom">', "<".$element.">", $objxml);
+ return($objxml);
+ }
+
+ /**
+ * @brief Processes the mail elements
+ *
+ * @param object $xpath XPath object
+ * @param object $mail mail elements
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @todo Find good type-hints for all parameter
+ */
+ private static function process_mail($xpath, $mail, $importer) {
+
+ logger("Processing mails");
+
+ /// @TODO Rewrite this to one statement
+ $msg = array();
+ $msg["uid"] = $importer["importer_uid"];
+ $msg["from-name"] = $xpath->query("dfrn:sender/dfrn:name/text()", $mail)->item(0)->nodeValue;
+ $msg["from-url"] = $xpath->query("dfrn:sender/dfrn:uri/text()", $mail)->item(0)->nodeValue;
+ $msg["from-photo"] = $xpath->query("dfrn:sender/dfrn:avatar/text()", $mail)->item(0)->nodeValue;
+ $msg["contact-id"] = $importer["id"];
+ $msg["uri"] = $xpath->query("dfrn:id/text()", $mail)->item(0)->nodeValue;
+ $msg["parent-uri"] = $xpath->query("dfrn:in-reply-to/text()", $mail)->item(0)->nodeValue;
+ $msg["created"] = $xpath->query("dfrn:sentdate/text()", $mail)->item(0)->nodeValue;
+ $msg["title"] = $xpath->query("dfrn:subject/text()", $mail)->item(0)->nodeValue;
+ $msg["body"] = $xpath->query("dfrn:content/text()", $mail)->item(0)->nodeValue;
+ $msg["seen"] = 0;
+ $msg["replied"] = 0;
+
+ dbm::esc_array($msg, true);
+
+ $r = dbq("INSERT INTO `mail` (`".implode("`, `", array_keys($msg))."`) VALUES (".implode(", ", array_values($msg)).")");
+
+ // send notifications.
+ /// @TODO Arange this mess
+ $notif_params = array(
+ "type" => NOTIFY_MAIL,
+ "notify_flags" => $importer["notify-flags"],
+ "language" => $importer["language"],
+ "to_name" => $importer["username"],
+ "to_email" => $importer["email"],
+ "uid" => $importer["importer_uid"],
+ "item" => $msg,
+ "source_name" => $msg["from-name"],
+ "source_link" => $importer["url"],
+ "source_photo" => $importer["thumb"],
+ "verb" => ACTIVITY_POST,
+ "otype" => "mail"
+ );
+
+ notification($notif_params);
+
+ logger("Mail is processed, notification was sent.");
+ }
+
+ /**
+ * @brief Processes the suggestion elements
+ *
+ * @param object $xpath XPath object
+ * @param object $suggestion suggestion elements
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @todo Find good type-hints for all parameter
+ */
+ private static function process_suggestion($xpath, $suggestion, $importer) {
+ $a = get_app();
+
+ logger("Processing suggestions");
+
+ /// @TODO Rewrite this to one statement
+ $suggest = array();
+ $suggest["uid"] = $importer["importer_uid"];
+ $suggest["cid"] = $importer["id"];
+ $suggest["url"] = $xpath->query("dfrn:url/text()", $suggestion)->item(0)->nodeValue;
+ $suggest["name"] = $xpath->query("dfrn:name/text()", $suggestion)->item(0)->nodeValue;
+ $suggest["photo"] = $xpath->query("dfrn:photo/text()", $suggestion)->item(0)->nodeValue;
+ $suggest["request"] = $xpath->query("dfrn:request/text()", $suggestion)->item(0)->nodeValue;
+ $suggest["body"] = $xpath->query("dfrn:note/text()", $suggestion)->item(0)->nodeValue;
+
+ // Does our member already have a friend matching this description?
+
+ $r = q("SELECT `id` FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
+ dbesc($suggest["name"]),
+ dbesc(normalise_link($suggest["url"])),
+ intval($suggest["uid"])
+ );
+ /// @TODO Really abort on valid result??? Maybe missed ! here?
+ if (dbm::is_result($r)) {
+ return false;
+ }
+
+ // Do we already have an fcontact record for this person?
+
+ $fid = 0;
+ $r = q("SELECT `id` FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
+ dbesc($suggest["url"]),
+ dbesc($suggest["name"]),
+ dbesc($suggest["request"])
+ );
+ if (dbm::is_result($r)) {
+ $fid = $r[0]["id"];
+
+ // OK, we do. Do we already have an introduction for this person ?
+ $r = q("SELECT `id` FROM `intro` WHERE `uid` = %d AND `fid` = %d LIMIT 1",
+ intval($suggest["uid"]),
+ intval($fid)
+ );
+ /// @TODO Really abort on valid result??? Maybe missed ! here?
+ if (dbm::is_result($r)) {
+ return false;
+ }
+ }
+ if (!$fid)
+ $r = q("INSERT INTO `fcontact` (`name`,`url`,`photo`,`request`) VALUES ('%s', '%s', '%s', '%s')",
+ dbesc($suggest["name"]),
+ dbesc($suggest["url"]),
+ dbesc($suggest["photo"]),
+ dbesc($suggest["request"])
+ );
+ $r = q("SELECT `id` FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
+ dbesc($suggest["url"]),
+ dbesc($suggest["name"]),
+ dbesc($suggest["request"])
+ );
+ if (dbm::is_result($r)) {
+ $fid = $r[0]["id"];
+ } else {
+ // database record did not get created. Quietly give up.
+ killme();
+ }
+
+
+ $hash = random_string();
+
+ $r = q("INSERT INTO `intro` (`uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked`)
+ VALUES(%d, %d, %d, '%s', '%s', '%s', %d)",
+ intval($suggest["uid"]),
+ intval($fid),
+ intval($suggest["cid"]),
+ dbesc($suggest["body"]),
+ dbesc($hash),
+ dbesc(datetime_convert()),
+ intval(0)
+ );
+
+ notification(array(
+ "type" => NOTIFY_SUGGEST,
+ "notify_flags" => $importer["notify-flags"],
+ "language" => $importer["language"],
+ "to_name" => $importer["username"],
+ "to_email" => $importer["email"],
+ "uid" => $importer["importer_uid"],
+ "item" => $suggest,
+ "link" => App::get_baseurl()."/notifications/intros",
+ "source_name" => $importer["name"],
+ "source_link" => $importer["url"],
+ "source_photo" => $importer["photo"],
+ "verb" => ACTIVITY_REQ_FRIEND,
+ "otype" => "intro"
+ ));
+
+ return true;
+
+ }
+
+ /**
+ * @brief Processes the relocation elements
+ *
+ * @param object $xpath XPath object
+ * @param object $relocation relocation elements
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @todo Find good type-hints for all parameter
+ */
+ private static function process_relocation($xpath, $relocation, $importer) {
+
+ logger("Processing relocations");
+
+ /// @TODO Rewrite this to one statement
+ $relocate = array();
+ $relocate["uid"] = $importer["importer_uid"];
+ $relocate["cid"] = $importer["id"];
+ $relocate["url"] = $xpath->query("dfrn:url/text()", $relocation)->item(0)->nodeValue;
+ $relocate["addr"] = $xpath->query("dfrn:addr/text()", $relocation)->item(0)->nodeValue;
+ $relocate["name"] = $xpath->query("dfrn:name/text()", $relocation)->item(0)->nodeValue;
+ $relocate["avatar"] = $xpath->query("dfrn:avatar/text()", $relocation)->item(0)->nodeValue;
+ $relocate["photo"] = $xpath->query("dfrn:photo/text()", $relocation)->item(0)->nodeValue;
+ $relocate["thumb"] = $xpath->query("dfrn:thumb/text()", $relocation)->item(0)->nodeValue;
+ $relocate["micro"] = $xpath->query("dfrn:micro/text()", $relocation)->item(0)->nodeValue;
+ $relocate["request"] = $xpath->query("dfrn:request/text()", $relocation)->item(0)->nodeValue;
+ $relocate["confirm"] = $xpath->query("dfrn:confirm/text()", $relocation)->item(0)->nodeValue;
+ $relocate["notify"] = $xpath->query("dfrn:notify/text()", $relocation)->item(0)->nodeValue;
+ $relocate["poll"] = $xpath->query("dfrn:poll/text()", $relocation)->item(0)->nodeValue;
+ $relocate["sitepubkey"] = $xpath->query("dfrn:sitepubkey/text()", $relocation)->item(0)->nodeValue;
+
+ if (($relocate["avatar"] == "") AND ($relocate["photo"] != "")) {
+ $relocate["avatar"] = $relocate["photo"];
+ }
+
+ if ($relocate["addr"] == "") {
+ $relocate["addr"] = preg_replace("=(https?://)(.*)/profile/(.*)=ism", "$3@$2", $relocate["url"]);
+ }
+
+ // update contact
+ $r = q("SELECT `photo`, `url` FROM `contact` WHERE `id` = %d AND `uid` = %d;",
+ intval($importer["id"]),
+ intval($importer["importer_uid"]));
+
+ if (!dbm::is_result($r)) {
+ killme();
+ }
+
+ $old = $r[0];
+
+ // Update the gcontact entry
+ $relocate["server_url"] = preg_replace("=(https?://)(.*)/profile/(.*)=ism", "$1$2", $relocate["url"]);
+
+ $x = q("UPDATE `gcontact` SET
+ `name` = '%s',
+ `photo` = '%s',
+ `url` = '%s',
+ `nurl` = '%s',
+ `addr` = '%s',
+ `connect` = '%s',
+ `notify` = '%s',
+ `server_url` = '%s'
+ WHERE `nurl` = '%s';",
+ dbesc($relocate["name"]),
+ dbesc($relocate["avatar"]),
+ dbesc($relocate["url"]),
+ dbesc(normalise_link($relocate["url"])),
+ dbesc($relocate["addr"]),
+ dbesc($relocate["addr"]),
+ dbesc($relocate["notify"]),
+ dbesc($relocate["server_url"]),
+ dbesc(normalise_link($old["url"])));
+
+ // Update the contact table. We try to find every entry.
+ $x = q("UPDATE `contact` SET
+ `name` = '%s',
+ `avatar` = '%s',
+ `url` = '%s',
+ `nurl` = '%s',
+ `addr` = '%s',
+ `request` = '%s',
+ `confirm` = '%s',
+ `notify` = '%s',
+ `poll` = '%s',
+ `site-pubkey` = '%s'
+ WHERE (`id` = %d AND `uid` = %d) OR (`nurl` = '%s');",
+ dbesc($relocate["name"]),
+ dbesc($relocate["avatar"]),
+ dbesc($relocate["url"]),
+ dbesc(normalise_link($relocate["url"])),
+ dbesc($relocate["addr"]),
+ dbesc($relocate["request"]),
+ dbesc($relocate["confirm"]),
+ dbesc($relocate["notify"]),
+ dbesc($relocate["poll"]),
+ dbesc($relocate["sitepubkey"]),
+ intval($importer["id"]),
+ intval($importer["importer_uid"]),
+ dbesc(normalise_link($old["url"])));
+
+ update_contact_avatar($relocate["avatar"], $importer["importer_uid"], $importer["id"], true);
+
+ if ($x === false) {
+ return false;
+ }
+
+ // update items
+ /// @todo This is an extreme performance killer
+ $fields = array(
+ 'owner-link' => array($old["url"], $relocate["url"]),
+ 'author-link' => array($old["url"], $relocate["url"]),
+ //'owner-avatar' => array($old["photo"], $relocate["photo"]),
+ //'author-avatar' => array($old["photo"], $relocate["photo"]),
+ );
+ foreach ($fields as $n=>$f) {
+ $r = q("SELECT `id` FROM `item` WHERE `%s` = '%s' AND `uid` = %d LIMIT 1",
+ $n, dbesc($f[0]),
+ intval($importer["importer_uid"]));
+
+ if (dbm::is_result($r)) {
+ $x = q("UPDATE `item` SET `%s` = '%s' WHERE `%s` = '%s' AND `uid` = %d",
+ $n, dbesc($f[1]),
+ $n, dbesc($f[0]),
+ intval($importer["importer_uid"]));
+ if ($x === false)
+ return false;
+ }
+ }
+
+ /// @TODO
+ /// merge with current record, current contents have priority
+ /// update record, set url-updated
+ /// update profile photos
+ /// schedule a scan?
+ return true;
+ }
+
+ /**
+ * @brief Updates an item
+ *
+ * @param array $current the current item record
+ * @param array $item the new item record
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @param int $entrytype Is it a toplevel entry, a comment or a relayed comment?
+ */
+ private static function update_content($current, $item, $importer, $entrytype) {
+ $changed = false;
+
+ if (edited_timestamp_is_newer($current, $item)) {
+
+ // do not accept (ignore) an earlier edit than one we currently have.
+ if(datetime_convert("UTC","UTC",$item["edited"]) < $current["edited"])
+ return(false);
+
+ $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
+ dbesc($item["title"]),
+ dbesc($item["body"]),
+ dbesc($item["tag"]),
+ dbesc(datetime_convert("UTC","UTC",$item["edited"])),
+ dbesc(datetime_convert()),
+ dbesc($item["uri"]),
+ intval($importer["importer_uid"])
+ );
+ create_tags_from_itemuri($item["uri"], $importer["importer_uid"]);
+ update_thread_uri($item["uri"], $importer["importer_uid"]);
+
+ $changed = true;
+
+ if ($entrytype == DFRN_REPLY_RC) {
+ proc_run(PRIORITY_HIGH, "include/notifier.php","comment-import", $current["id"]);
+ }
+ }
+
+ // update last-child if it changes
+ if ($item["last-child"] AND ($item["last-child"] != $current["last-child"])) {
+ $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
+ dbesc(datetime_convert()),
+ dbesc($item["parent-uri"]),
+ intval($importer["importer_uid"])
+ );
+ $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
+ intval($item["last-child"]),
+ dbesc(datetime_convert()),
+ dbesc($item["uri"]),
+ intval($importer["importer_uid"])
+ );
+ }
+ return $changed;
+ }
+
+ /**
+ * @brief Detects the entry type of the item
+ *
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @param array $item the new item record
+ *
+ * @return int Is it a toplevel entry, a comment or a relayed comment?
+ */
+ private static function get_entry_type($importer, $item) {
+ if ($item["parent-uri"] != $item["uri"]) {
+ $community = false;
+
+ if($importer["page-flags"] == PAGE_COMMUNITY || $importer["page-flags"] == PAGE_PRVGROUP) {
+ $sql_extra = "";
+ $community = true;
+ logger("possible community action");
+ } else {
+ $sql_extra = " AND `contact`.`self` AND `item`.`wall` ";
+ }
+
+ // was the top-level post for this action written by somebody on this site?
+ // Specifically, the recipient?
+
+ $is_a_remote_action = false;
+
+ $r = q("SELECT `item`.`parent-uri` FROM `item`
+ WHERE `item`.`uri` = '%s'
+ LIMIT 1",
+ dbesc($item["parent-uri"])
+ );
+ if (dbm::is_result($r)) {
+ $r = q("SELECT `item`.`forum_mode`, `item`.`wall` FROM `item`
+ INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
+ WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' OR `item`.`thr-parent` = '%s')
+ AND `item`.`uid` = %d
+ $sql_extra
+ LIMIT 1",
+ dbesc($r[0]["parent-uri"]),
+ dbesc($r[0]["parent-uri"]),
+ dbesc($r[0]["parent-uri"]),
+ intval($importer["importer_uid"])
+ );
+ if (dbm::is_result($r)) {
+ $is_a_remote_action = true;
+ }
+ }
+
+ // Does this have the characteristics of a community or private group action?
+ // If it's an action to a wall post on a community/prvgroup page it's a
+ // valid community action. Also forum_mode makes it valid for sure.
+ // If neither, it's not.
+
+ if ($is_a_remote_action && $community) {
+ if ((!$r[0]["forum_mode"]) && (!$r[0]["wall"])) {
+ $is_a_remote_action = false;
+ logger("not a community action");
+ }
+ }
+
+ if ($is_a_remote_action) {
+ return DFRN_REPLY_RC;
+ } else {
+ return DFRN_REPLY;
+ }
+
+ } else {
+ return DFRN_TOP_LEVEL;
+ }
+
+ }
+
+ /**
+ * @brief Send a "poke"
+ *
+ * @param array $item the new item record
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @param int $posted_id The record number of item record that was just posted
+ */
+ private static function do_poke($item, $importer, $posted_id) {
+ $verb = urldecode(substr($item["verb"],strpos($item["verb"], "#")+1));
+ if (!$verb) {
+ return;
+ }
+ $xo = parse_xml_string($item["object"],false);
+
+ if (($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
+
+ // somebody was poked/prodded. Was it me?
+ foreach ($xo->link as $l) {
+ $atts = $l->attributes();
+ switch($atts["rel"]) {
+ case "alternate":
+ $Blink = $atts["href"];
+ break;
+ default:
+ break;
+ }
+ }
+
+ if($Blink && link_compare($Blink,App::get_baseurl()."/profile/".$importer["nickname"])) {
+
+ // send a notification
+ notification(array(
+ "type" => NOTIFY_POKE,
+ "notify_flags" => $importer["notify-flags"],
+ "language" => $importer["language"],
+ "to_name" => $importer["username"],
+ "to_email" => $importer["email"],
+ "uid" => $importer["importer_uid"],
+ "item" => $item,
+ "link" => App::get_baseurl()."/display/".urlencode(get_item_guid($posted_id)),
+ "source_name" => stripslashes($item["author-name"]),
+ "source_link" => $item["author-link"],
+ "source_photo" => ((link_compare($item["author-link"],$importer["url"]))
+ ? $importer["thumb"] : $item["author-avatar"]),
+ "verb" => $item["verb"],
+ "otype" => "person",
+ "activity" => $verb,
+ "parent" => $item["parent"]
+ ));
+ }
+ }
+ }
+
+ /**
+ * @brief Processes several actions, depending on the verb
+ *
+ * @param int $entrytype Is it a toplevel entry, a comment or a relayed comment?
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @param array $item the new item record
+ * @param bool $is_like Is the verb a "like"?
+ *
+ * @return bool Should the processing of the entries be continued?
+ */
+ private static function process_verbs($entrytype, $importer, &$item, &$is_like) {
+
+ logger("Process verb ".$item["verb"]." and object-type ".$item["object-type"]." for entrytype ".$entrytype, LOGGER_DEBUG);
+
+ if (($entrytype == DFRN_TOP_LEVEL)) {
+ // The filling of the the "contact" variable is done for legcy reasons
+ // The functions below are partly used by ostatus.php as well - where we have this variable
+ $r = q("SELECT * FROM `contact` WHERE `id` = %d", intval($importer["id"]));
+ $contact = $r[0];
+ $nickname = $contact["nick"];
+
+ // Big question: Do we need these functions? They were part of the "consume_feed" function.
+ // This function once was responsible for DFRN and OStatus.
+ if (activity_match($item["verb"],ACTIVITY_FOLLOW)) {
+ logger("New follower");
+ new_follower($importer, $contact, $item, $nickname);
+ return false;
+ }
+ if (activity_match($item["verb"],ACTIVITY_UNFOLLOW)) {
+ logger("Lost follower");
+ lose_follower($importer, $contact, $item);
+ return false;
+ }
+ if (activity_match($item["verb"],ACTIVITY_REQ_FRIEND)) {
+ logger("New friend request");
+ new_follower($importer, $contact, $item, $nickname, true);
+ return false;
+ }
+ if (activity_match($item["verb"],ACTIVITY_UNFRIEND)) {
+ logger("Lost sharer");
+ lose_sharer($importer, $contact, $item);
+ return false;
+ }
+ } else {
+ if(($item["verb"] == ACTIVITY_LIKE)
+ || ($item["verb"] == ACTIVITY_DISLIKE)
+ || ($item["verb"] == ACTIVITY_ATTEND)
+ || ($item["verb"] == ACTIVITY_ATTENDNO)
+ || ($item["verb"] == ACTIVITY_ATTENDMAYBE)) {
+ $is_like = true;
+ $item["type"] = "activity";
+ $item["gravity"] = GRAVITY_LIKE;
+ // only one like or dislike per person
+ // splitted into two queries for performance issues
+ $r = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `author-link` = '%s' AND `verb` = '%s' AND `parent-uri` = '%s' AND NOT `deleted` LIMIT 1",
+ intval($item["uid"]),
+ dbesc($item["author-link"]),
+ dbesc($item["verb"]),
+ dbesc($item["parent-uri"])
+ );
+ if (dbm::is_result($r)) {
+ return false;
+ }
+
+ $r = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `author-link` = '%s' AND `verb` = '%s' AND `thr-parent` = '%s' AND NOT `deleted` LIMIT 1",
+ intval($item["uid"]),
+ dbesc($item["author-link"]),
+ dbesc($item["verb"]),
+ dbesc($item["parent-uri"])
+ );
+ if (dbm::is_result($r)) {
+ return false;
+ }
+ } else {
+ $is_like = false;
+ }
+
+ if (($item["verb"] == ACTIVITY_TAG) && ($item["object-type"] == ACTIVITY_OBJ_TAGTERM)) {
+
+ $xo = parse_xml_string($item["object"],false);
+ $xt = parse_xml_string($item["target"],false);
+
+ if ($xt->type == ACTIVITY_OBJ_NOTE) {
+ $r = q("SELECT `id`, `tag` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
+ dbesc($xt->id),
+ intval($importer["importer_uid"])
+ );
+
+ if (!dbm::is_result($r)) {
+ killme();
+ }
+
+ // extract tag, if not duplicate, add to parent item
+ if ($xo->content) {
+ if (!(stristr($r[0]["tag"],trim($xo->content)))) {
+ q("UPDATE `item` SET `tag` = '%s' WHERE `id` = %d",
+ dbesc($r[0]["tag"] . (strlen($r[0]["tag"]) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
+ intval($r[0]["id"])
+ );
+ create_tags_from_item($r[0]["id"]);
+ }
+ }
+ }
+ }
+ }
+ return true;
+ }
+
+ /**
+ * @brief Processes the link elements
+ *
+ * @param object $links link elements
+ * @param array $item the item record
+ * @todo Add type-hints
+ */
+ private static function parse_links($links, &$item) {
+ $rel = "";
+ $href = "";
+ $type = "";
+ $length = "0";
+ $title = "";
+ foreach ($links AS $link) {
+ foreach ($link->attributes AS $attributes) {
+ /// @TODO Rewrite these repeated (same) if() statements to a switch()
+ if ($attributes->name == "href") {
+ $href = $attributes->textContent;
+ }
+ if ($attributes->name == "rel") {
+ $rel = $attributes->textContent;
+ }
+ if ($attributes->name == "type") {
+ $type = $attributes->textContent;
+ }
+ if ($attributes->name == "length") {
+ $length = $attributes->textContent;
+ }
+ if ($attributes->name == "title") {
+ $title = $attributes->textContent;
+ }
+ }
+ if (($rel != "") AND ($href != ""))
+ switch($rel) {
+ case "alternate":
+ $item["plink"] = $href;
+ break;
+ case "enclosure":
+ $enclosure = $href;
+ if (strlen($item["attach"])) {
+ $item["attach"] .= ",";
+ }
+
+ $item["attach"] .= '[attach]href="'.$href.'" length="'.$length.'" type="'.$type.'" title="'.$title.'"[/attach]';
+ break;
+ }
+ }
+ }
+
+ /**
+ * @brief Processes the entry elements which contain the items and comments
+ *
+ * @param array $header Array of the header elements that always stay the same
+ * @param object $xpath XPath object
+ * @param object $entry entry elements
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @todo Add type-hints
+ */
+ private static function process_entry($header, $xpath, $entry, $importer) {
+
+ logger("Processing entries");
+
+ $item = $header;
+
+ // Get the uri
+ $item["uri"] = $xpath->query("atom:id/text()", $entry)->item(0)->nodeValue;
+
+ $item["edited"] = $xpath->query("atom:updated/text()", $entry)->item(0)->nodeValue;
+
+ $current = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
+ dbesc($item["uri"]),
+ intval($importer["importer_uid"])
+ );
+
+ // Is there an existing item?
+ if (dbm::is_result($current) AND edited_timestamp_is_newer($current[0], $item) AND
+ (datetime_convert("UTC","UTC",$item["edited"]) < $current[0]["edited"])) {
+ logger("Item ".$item["uri"]." already existed.", LOGGER_DEBUG);
+ return;
+ }
+
+ // Fetch the owner
+ $owner = self::fetchauthor($xpath, $entry, $importer, "dfrn:owner", true);
+
+ $item["owner-name"] = $owner["name"];
+ $item["owner-link"] = $owner["link"];
+ $item["owner-avatar"] = $owner["avatar"];
+
+ // fetch the author
+ $author = self::fetchauthor($xpath, $entry, $importer, "atom:author", true);
+
+ $item["author-name"] = $author["name"];
+ $item["author-link"] = $author["link"];
+ $item["author-avatar"] = $author["avatar"];
+
+ $item["title"] = $xpath->query("atom:title/text()", $entry)->item(0)->nodeValue;
+
+ $item["created"] = $xpath->query("atom:published/text()", $entry)->item(0)->nodeValue;
+
+ $item["body"] = $xpath->query("dfrn:env/text()", $entry)->item(0)->nodeValue;
+ $item["body"] = str_replace(array(' ',"\t","\r","\n"), array('','','',''),$item["body"]);
+ // make sure nobody is trying to sneak some html tags by us
+ $item["body"] = notags(base64url_decode($item["body"]));
+
+ $item["body"] = limit_body_size($item["body"]);
+
+ /// @todo Do we really need this check for HTML elements? (It was copied from the old function)
+ if ((strpos($item['body'],'<') !== false) && (strpos($item['body'],'>') !== false)) {
+
+ $item['body'] = reltoabs($item['body'],$base_url);
+
+ $item['body'] = html2bb_video($item['body']);
+
+ $item['body'] = oembed_html2bbcode($item['body']);
+
+ $config = HTMLPurifier_Config::createDefault();
+ $config->set('Cache.DefinitionImpl', null);
+
+ // we shouldn't need a whitelist, because the bbcode converter
+ // will strip out any unsupported tags.
+
+ $purifier = new HTMLPurifier($config);
+ $item['body'] = $purifier->purify($item['body']);
+
+ $item['body'] = @html2bbcode($item['body']);
+ }
+
+ /// @todo We should check for a repeated post and if we know the repeated author.
+
+ // We don't need the content element since "dfrn:env" is always present
+ //$item["body"] = $xpath->query("atom:content/text()", $entry)->item(0)->nodeValue;
+
+ $item["last-child"] = $xpath->query("dfrn:comment-allow/text()", $entry)->item(0)->nodeValue;
+ $item["location"] = $xpath->query("dfrn:location/text()", $entry)->item(0)->nodeValue;
+
+ $georsspoint = $xpath->query("georss:point", $entry);
+ if ($georsspoint) {
+ $item["coord"] = $georsspoint->item(0)->nodeValue;
+ }
+
+ $item["private"] = $xpath->query("dfrn:private/text()", $entry)->item(0)->nodeValue;
+
+ $item["extid"] = $xpath->query("dfrn:extid/text()", $entry)->item(0)->nodeValue;
+
+ if ($xpath->query("dfrn:bookmark/text()", $entry)->item(0)->nodeValue == "true") {
+ $item["bookmark"] = true;
+ }
+
+ $notice_info = $xpath->query("statusnet:notice_info", $entry);
+ if ($notice_info AND ($notice_info->length > 0)) {
+ foreach ($notice_info->item(0)->attributes AS $attributes) {
+ if ($attributes->name == "source") {
+ $item["app"] = strip_tags($attributes->textContent);
+ }
+ }
+ }
+
+ $item["guid"] = $xpath->query("dfrn:diaspora_guid/text()", $entry)->item(0)->nodeValue;
+
+ // We store the data from "dfrn:diaspora_signature" in a different table, this is done in "item_store"
+ $dsprsig = unxmlify($xpath->query("dfrn:diaspora_signature/text()", $entry)->item(0)->nodeValue);
+ if ($dsprsig != "") {
+ $item["dsprsig"] = $dsprsig;
+ }
+
+ $item["verb"] = $xpath->query("activity:verb/text()", $entry)->item(0)->nodeValue;
+
+ if ($xpath->query("activity:object-type/text()", $entry)->item(0)->nodeValue != "") {
+ $item["object-type"] = $xpath->query("activity:object-type/text()", $entry)->item(0)->nodeValue;
+ }
+
+ $object = $xpath->query("activity:object", $entry)->item(0);
+ $item["object"] = self::transform_activity($xpath, $object, "object");
+
+ if (trim($item["object"]) != "") {
+ $r = parse_xml_string($item["object"], false);
+ if (isset($r->type)) {
+ $item["object-type"] = $r->type;
+ }
+ }
+
+ $target = $xpath->query("activity:target", $entry)->item(0);
+ $item["target"] = self::transform_activity($xpath, $target, "target");
+
+ $categories = $xpath->query("atom:category", $entry);
+ if ($categories) {
+ foreach ($categories AS $category) {
+ $term = "";
+ $scheme = "";
+ foreach ($category->attributes AS $attributes) {
+ if ($attributes->name == "term") {
+ $term = $attributes->textContent;
+ }
+
+ if ($attributes->name == "scheme") {
+ $scheme = $attributes->textContent;
+ }
+ }
+
+ if (($term != "") AND ($scheme != "")) {
+ $parts = explode(":", $scheme);
+ if ((count($parts) >= 4) AND (array_shift($parts) == "X-DFRN")) {
+ $termhash = array_shift($parts);
+ $termurl = implode(":", $parts);
+
+ if (strlen($item["tag"])) {
+ $item["tag"] .= ",";
+ }
+
+ $item["tag"] .= $termhash."[url=".$termurl."]".$term."[/url]";
+ }
+ }
+ }
+ }
+
+ $enclosure = "";
+
+ $links = $xpath->query("atom:link", $entry);
+ if ($links) {
+ self::parse_links($links, $item);
+ }
+
+ // Is it a reply or a top level posting?
+ $item["parent-uri"] = $item["uri"];
+
+ $inreplyto = $xpath->query("thr:in-reply-to", $entry);
+ if (is_object($inreplyto->item(0))) {
+ foreach ($inreplyto->item(0)->attributes AS $attributes) {
+ if ($attributes->name == "ref") {
+ $item["parent-uri"] = $attributes->textContent;
+ }
+ }
+ }
+
+ // Get the type of the item (Top level post, reply or remote reply)
+ $entrytype = self::get_entry_type($importer, $item);
+
+ // Now assign the rest of the values that depend on the type of the message
+ if (in_array($entrytype, array(DFRN_REPLY, DFRN_REPLY_RC))) {
+ if (!isset($item["object-type"])) {
+ $item["object-type"] = ACTIVITY_OBJ_COMMENT;
+ }
+
+ if ($item["contact-id"] != $owner["contact-id"]) {
+ $item["contact-id"] = $owner["contact-id"];
+ }
+
+ if (($item["network"] != $owner["network"]) AND ($owner["network"] != "")) {
+ $item["network"] = $owner["network"];
+ }
+
+ if ($item["contact-id"] != $author["contact-id"]) {
+ $item["contact-id"] = $author["contact-id"];
+ }
+
+ if (($item["network"] != $author["network"]) AND ($author["network"] != "")) {
+ $item["network"] = $author["network"];
+ }
+
+ // This code was taken from the old DFRN code
+ // When activated, forums don't work.
+ // And: Why should we disallow commenting by followers?
+ // the behaviour is now similar to the Diaspora part.
+ //if($importer["rel"] == CONTACT_IS_FOLLOWER) {
+ // logger("Contact ".$importer["id"]." is only follower. Quitting", LOGGER_DEBUG);
+ // return;
+ //}
+ }
+
+ if ($entrytype == DFRN_REPLY_RC) {
+ $item["type"] = "remote-comment";
+ $item["wall"] = 1;
+ } elseif ($entrytype == DFRN_TOP_LEVEL) {
+ if (!isset($item["object-type"])) {
+ $item["object-type"] = ACTIVITY_OBJ_NOTE;
+ }
+
+ // Is it an event?
+ if ($item["object-type"] == ACTIVITY_OBJ_EVENT) {
+ logger("Item ".$item["uri"]." seems to contain an event.", LOGGER_DEBUG);
+ $ev = bbtoevent($item["body"]);
+ if ((x($ev, "desc") || x($ev, "summary")) && x($ev, "start")) {
+ logger("Event in item ".$item["uri"]." was found.", LOGGER_DEBUG);
+ $ev["cid"] = $importer["id"];
+ $ev["uid"] = $importer["uid"];
+ $ev["uri"] = $item["uri"];
+ $ev["edited"] = $item["edited"];
+ $ev['private'] = $item['private'];
+ $ev["guid"] = $item["guid"];
+
+ $r = q("SELECT `id` FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
+ dbesc($item["uri"]),
+ intval($importer["uid"])
+ );
+ if (dbm::is_result($r)) {
+ $ev["id"] = $r[0]["id"];
+ }
+
+ $event_id = event_store($ev);
+ logger("Event ".$event_id." was stored", LOGGER_DEBUG);
+ return;
+ }
+ }
+ }
+
+ if (!self::process_verbs($entrytype, $importer, $item, $is_like)) {
+ logger("Exiting because 'process_verbs' told us so", LOGGER_DEBUG);
+ return;
+ }
+
+ // Update content if 'updated' changes
+ if (dbm::is_result($current)) {
+ if (self::update_content($r[0], $item, $importer, $entrytype)) {
+ logger("Item ".$item["uri"]." was updated.", LOGGER_DEBUG);
+ } else {
+ logger("Item ".$item["uri"]." already existed.", LOGGER_DEBUG);
+ }
+ return;
+ }
+
+ if (in_array($entrytype, array(DFRN_REPLY, DFRN_REPLY_RC))) {
+ $posted_id = item_store($item);
+ $parent = 0;
+
+ if ($posted_id) {
+
+ logger("Reply from contact ".$item["contact-id"]." was stored with id ".$posted_id, LOGGER_DEBUG);
+
+ $item["id"] = $posted_id;
+
+ $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
+ intval($posted_id),
+ intval($importer["importer_uid"])
+ );
+ if (dbm::is_result($r)) {
+ $parent = $r[0]["parent"];
+ $parent_uri = $r[0]["parent-uri"];
+ }
+
+ if (!$is_like) {
+ $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
+ dbesc(datetime_convert()),
+ intval($importer["importer_uid"]),
+ intval($r[0]["parent"])
+ );
+
+ $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
+ dbesc(datetime_convert()),
+ intval($importer["importer_uid"]),
+ intval($posted_id)
+ );
+ }
+
+ if ($posted_id AND $parent AND ($entrytype == DFRN_REPLY_RC)) {
+ logger("Notifying followers about comment ".$posted_id, LOGGER_DEBUG);
+ proc_run(PRIORITY_HIGH, "include/notifier.php", "comment-import", $posted_id);
+ }
+
+ return true;
+ }
+ } else { // $entrytype == DFRN_TOP_LEVEL
+ if (!link_compare($item["owner-link"],$importer["url"])) {
+ // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
+ // but otherwise there's a possible data mixup on the sender's system.
+ // the tgroup delivery code called from item_store will correct it if it's a forum,
+ // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
+ logger('Correcting item owner.', LOGGER_DEBUG);
+ $item["owner-name"] = $importer["senderName"];
+ $item["owner-link"] = $importer["url"];
+ $item["owner-avatar"] = $importer["thumb"];
+ }
+
+ if (($importer["rel"] == CONTACT_IS_FOLLOWER) && (!tgroup_check($importer["importer_uid"], $item))) {
+ logger("Contact ".$importer["id"]." is only follower and tgroup check was negative.", LOGGER_DEBUG);
+ return;
+ }
+
+ // This is my contact on another system, but it's really me.
+ // Turn this into a wall post.
+ $notify = item_is_remote_self($importer, $item);
+
+ $posted_id = item_store($item, false, $notify);
+
+ logger("Item was stored with id ".$posted_id, LOGGER_DEBUG);
+
+ if(stristr($item["verb"],ACTIVITY_POKE))
+ self::do_poke($item, $importer, $posted_id);
+ }
+ }
+
+ /**
+ * @brief Deletes items
+ *
+ * @param object $xpath XPath object
+ * @param object $deletion deletion elements
+ * @param array $importer Record of the importer user mixed with contact of the content
+ */
+ private static function process_deletion($xpath, $deletion, $importer) {
+
+ logger("Processing deletions");
+
+ foreach ($deletion->attributes AS $attributes) {
+ if ($attributes->name == "ref") {
+ $uri = $attributes->textContent;
+ }
+ if ($attributes->name == "when") {
+ $when = $attributes->textContent;
+ }
+ }
+ if ($when) {
+ $when = datetime_convert("UTC", "UTC", $when, "Y-m-d H:i:s");
+ } else {
+ $when = datetime_convert("UTC", "UTC", "now", "Y-m-d H:i:s");
+ }
+
+ if (!$uri OR !$importer["id"]) {
+ return false;
+ }
+
+ /// @todo Only select the used fields
+ $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
+ WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
+ dbesc($uri),
+ intval($importer["uid"]),
+ intval($importer["id"])
+ );
+ if (!dbm::is_result($r)) {
+ logger("Item with uri ".$uri." from contact ".$importer["id"]." for user ".$importer["uid"]." wasn't found.", LOGGER_DEBUG);
+ return;
+ } else {
+
+ $item = $r[0];
+
+ $entrytype = self::get_entry_type($importer, $item);
+
+ if (!$item["deleted"]) {
+ logger('deleting item '.$item["id"].' uri='.$uri, LOGGER_DEBUG);
+ } else {
+ return;
+ }
+
+ if ($item["object-type"] == ACTIVITY_OBJ_EVENT) {
+ logger("Deleting event ".$item["event-id"], LOGGER_DEBUG);
+ event_delete($item["event-id"]);
+ }
+
+ if (($item["verb"] == ACTIVITY_TAG) && ($item["object-type"] == ACTIVITY_OBJ_TAGTERM)) {
+
+ $xo = parse_xml_string($item["object"],false);
+ $xt = parse_xml_string($item["target"],false);
+
+ if ($xt->type == ACTIVITY_OBJ_NOTE) {
+ $i = q("SELECT `id`, `contact-id`, `tag` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
+ dbesc($xt->id),
+ intval($importer["importer_uid"])
+ );
+ if (dbm::is_result($i)) {
+
+ // For tags, the owner cannot remove the tag on the author's copy of the post.
+
+ $owner_remove = (($item["contact-id"] == $i[0]["contact-id"]) ? true: false);
+ $author_remove = (($item["origin"] && $item["self"]) ? true : false);
+ $author_copy = (($item["origin"]) ? true : false);
+
+ if ($owner_remove && $author_copy) {
+ return;
+ }
+ if ($author_remove || $owner_remove) {
+ $tags = explode(',',$i[0]["tag"]);
+ $newtags = array();
+ if (count($tags)) {
+ foreach ($tags as $tag) {
+ if (trim($tag) !== trim($xo->body)) {
+ $newtags[] = trim($tag);
+ }
+ }
+ }
+ q("UPDATE `item` SET `tag` = '%s' WHERE `id` = %d",
+ dbesc(implode(',',$newtags)),
+ intval($i[0]["id"])
+ );
+ create_tags_from_item($i[0]["id"]);
+ }
+ }
+ }
+ }
+
+ if($entrytype == DFRN_TOP_LEVEL) {
+ $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
+ `body` = '', `title` = ''
+ WHERE `parent-uri` = '%s' AND `uid` = %d",
+ dbesc($when),
+ dbesc(datetime_convert()),
+ dbesc($uri),
+ intval($importer["uid"])
+ );
+ create_tags_from_itemuri($uri, $importer["uid"]);
+ create_files_from_itemuri($uri, $importer["uid"]);
+ update_thread_uri($uri, $importer["uid"]);
+ } else {
+ $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
+ `body` = '', `title` = ''
+ WHERE `uri` = '%s' AND `uid` = %d",
+ dbesc($when),
+ dbesc(datetime_convert()),
+ dbesc($uri),
+ intval($importer["uid"])
+ );
+ create_tags_from_itemuri($uri, $importer["uid"]);
+ create_files_from_itemuri($uri, $importer["uid"]);
+ update_thread_uri($uri, $importer["importer_uid"]);
+ if($item["last-child"]) {
+ // ensure that last-child is set in case the comment that had it just got wiped.
+ q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
+ dbesc(datetime_convert()),
+ dbesc($item["parent-uri"]),
+ intval($item["uid"])
+ );
+ // who is the last child now?
+ $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
+ ORDER BY `created` DESC LIMIT 1",
+ dbesc($item["parent-uri"]),
+ intval($importer["uid"])
+ );
+ if (dbm::is_result($r)) {
+ q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
+ intval($r[0]["id"])
+ );
+ }
+ }
+ // if this is a relayed delete, propagate it to other recipients
+
+ if($entrytype == DFRN_REPLY_RC) {
+ logger("Notifying followers about deletion of post ".$item["id"], LOGGER_DEBUG);
+ proc_run(PRIORITY_HIGH, "include/notifier.php","drop", $item["id"]);
+ }
+ }
+ }
+ }
+
+ /**
+ * @brief Imports a DFRN message
+ *
+ * @param text $xml The DFRN message
+ * @param array $importer Record of the importer user mixed with contact of the content
+ * @param bool $sort_by_date Is used when feeds are polled
+ */
+ public static function import($xml,$importer, $sort_by_date = false) {
+
+ if ($xml == "")
+ return;
+
+ if($importer["readonly"]) {
+ // We aren't receiving stuff from this person. But we will quietly ignore them
+ // rather than a blatant "go away" message.
+ logger('ignoring contact '.$importer["id"]);
+ return;
+ }
+
+ $doc = new DOMDocument();
+ @$doc->loadXML($xml);
+
+ $xpath = new DomXPath($doc);
+ $xpath->registerNamespace("atom", NAMESPACE_ATOM1);
+ $xpath->registerNamespace("thr", NAMESPACE_THREAD);
+ $xpath->registerNamespace("at", NAMESPACE_TOMB);
+ $xpath->registerNamespace("media", NAMESPACE_MEDIA);
+ $xpath->registerNamespace("dfrn", NAMESPACE_DFRN);
+ $xpath->registerNamespace("activity", NAMESPACE_ACTIVITY);
+ $xpath->registerNamespace("georss", NAMESPACE_GEORSS);
+ $xpath->registerNamespace("poco", NAMESPACE_POCO);
+ $xpath->registerNamespace("ostatus", NAMESPACE_OSTATUS);
+ $xpath->registerNamespace("statusnet", NAMESPACE_STATUSNET);
+
+ $header = array();
+ $header["uid"] = $importer["uid"];
+ $header["network"] = NETWORK_DFRN;
+ $header["type"] = "remote";
+ $header["wall"] = 0;
+ $header["origin"] = 0;
+ $header["contact-id"] = $importer["id"];
+
+ // Update the contact table if the data has changed
+
+ // The "atom:author" is only present in feeds
+ if ($xpath->query("/atom:feed/atom:author")->length > 0)
+ self::fetchauthor($xpath, $doc->firstChild, $importer, "atom:author", false, $xml);
+
+ // Only the "dfrn:owner" in the head section contains all data
+ if ($xpath->query("/atom:feed/dfrn:owner")->length > 0)
+ self::fetchauthor($xpath, $doc->firstChild, $importer, "dfrn:owner", false, $xml);
+
+ logger("Import DFRN message for user ".$importer["uid"]." from contact ".$importer["id"], LOGGER_DEBUG);
+
+ // The account type is new since 3.5.1
+ if ($xpath->query("/atom:feed/dfrn:account_type")->length > 0) {
+ $accounttype = intval($xpath->evaluate("/atom:feed/dfrn:account_type/text()", $context)->item(0)->nodeValue);
+
+ if ($accounttype != $importer["contact-type"])
+ q("UPDATE `contact` SET `contact-type` = %d WHERE `id` = %d",
+ intval($accounttype),
+ intval($importer["id"])
+ );
+ }
+
+ // is it a public forum? Private forums aren't supported with this method
+ // This is deprecated since 3.5.1
+ $forum = intval($xpath->evaluate("/atom:feed/dfrn:community/text()", $context)->item(0)->nodeValue);
+
+ if ($forum != $importer["forum"])
+ q("UPDATE `contact` SET `forum` = %d WHERE `forum` != %d AND `id` = %d",
+ intval($forum), intval($forum),
+ intval($importer["id"])
+ );
+
+ $mails = $xpath->query("/atom:feed/dfrn:mail");
+ foreach ($mails AS $mail) {
+ self::process_mail($xpath, $mail, $importer);
+ }
+
+ $suggestions = $xpath->query("/atom:feed/dfrn:suggest");
+ foreach ($suggestions AS $suggestion) {
+ self::process_suggestion($xpath, $suggestion, $importer);
+ }
+
+ $relocations = $xpath->query("/atom:feed/dfrn:relocate");
+ foreach ($relocations AS $relocation) {
+ self::process_relocation($xpath, $relocation, $importer);
+ }
+
+ $deletions = $xpath->query("/atom:feed/at:deleted-entry");
+ foreach ($deletions AS $deletion) {
+ self::process_deletion($xpath, $deletion, $importer);
+ }
+
+ if (!$sort_by_date) {
+ $entries = $xpath->query("/atom:feed/atom:entry");
+ foreach ($entries AS $entry) {
+ self::process_entry($header, $xpath, $entry, $importer);
+ }
+ } else {
+ $newentries = array();
+ $entries = $xpath->query("/atom:feed/atom:entry");
+ foreach ($entries AS $entry) {
+ $created = $xpath->query("atom:published/text()", $entry)->item(0)->nodeValue;
+ $newentries[strtotime($created)] = $entry;
+ }
+
+ // Now sort after the publishing date
+ ksort($newentries);
+
+ foreach ($newentries AS $entry) {
+ self::process_entry($header, $xpath, $entry, $importer);
+ }
+ }
+ logger("Import done for user ".$importer["uid"]." from contact ".$importer["id"], LOGGER_DEBUG);
+ }