Merge pull request #3365 from Hypolite/issue/remove-wrong-profile-link-for-contacts

[friendica.git] / include / post_update.php

diff --git a/include/post_update.php b/include/post_update.php
index 2bdfe1f6fd39ab3f5d621eec3eaf6f4b94a54a7f..f9649961d9ca0d087d6b9a8eeea1dde591ac7305 100644 (file)
--- a/include/post_update.php
+++ b/include/post_update.php
@@ -8,11 +8,18 @@
  */
 function post_update() {
 
-       if (!post_update_1192())
+       if (!post_update_1192()) {
                return;
-
-       if (!post_update_1194())
+       }
+       if (!post_update_1194()) {
+               return;
+       }
+       if (!post_update_1198()) {
+               return;
+       }
+       if (!post_update_1206()) {
                return;
+       }
 }
 
 /**
@@ -138,4 +145,118 @@ function post_update_1194() {
 
        logger("Done", LOGGER_DEBUG);
 }
+
+/**
+ * @brief set the author-id and owner-id in all item entries
+ *
+ * This job has to be started multiple times until all entries are set.
+ * It isn't started in the update function since it would consume too much time and can be done in the background.
+ *
+ * @return bool "true" when the job is done
+ */
+function post_update_1198() {
+
+       // Was the script completed?
+       if (get_config("system", "post_update_version") >= 1198)
+               return true;
+
+       logger("Start", LOGGER_DEBUG);
+
+       // Check if the first step is done (Setting "author-id" and "owner-id" in the item table)
+       $r = q("SELECT `author-link`, `owner-link`, `uid` FROM `item` WHERE `author-id` = 0 AND `owner-id` = 0 LIMIT 100");
+       if (!$r) {
+               // Are there unfinished entries in the thread table?
+               $r = q("SELECT COUNT(*) AS `total` FROM `thread`
+                       INNER JOIN `item` ON `item`.`id` =`thread`.`iid`
+                       WHERE `thread`.`author-id` = 0 AND `thread`.`owner-id` = 0 AND
+                               (`thread`.`uid` IN (SELECT `uid` from `user`) OR `thread`.`uid` = 0)");
+
+               if ($r AND ($r[0]["total"] == 0)) {
+                       set_config("system", "post_update_version", 1198);
+                       logger("Done", LOGGER_DEBUG);
+                       return true;
+               }
+
+               // Update the thread table from the item table
+               $r = q("UPDATE `thread` INNER JOIN `item` ON `item`.`id`=`thread`.`iid`
+                               SET `thread`.`author-id` = `item`.`author-id`,
+                               `thread`.`owner-id` = `item`.`owner-id`
+                       WHERE `thread`.`author-id` = 0 AND `thread`.`owner-id` = 0 AND
+                               (`thread`.`uid` IN (SELECT `uid` from `user`) OR `thread`.`uid` = 0)");
+
+               logger("Updated threads", LOGGER_DEBUG);
+               if (dbm::is_result($r)) {
+                       set_config("system", "post_update_version", 1198);
+                       logger("Done", LOGGER_DEBUG);
+                       return true;
+               }
+               return false;
+       }
+
+       logger("Query done", LOGGER_DEBUG);
+
+       $item_arr = array();
+       foreach ($r AS $item) {
+               $index = $item["author-link"]."-".$item["owner-link"]."-".$item["uid"];
+               $item_arr[$index] = array("author-link" => $item["author-link"],
+                                               "owner-link" => $item["owner-link"],
+                                               "uid" => $item["uid"]);
+       }
+
+       // Set the "gcontact-id" in the item table and add a new gcontact entry if needed
+       foreach($item_arr AS $item) {
+               $author_id = get_contact($item["author-link"], 0);
+               $owner_id = get_contact($item["owner-link"], 0);
+
+               if ($author_id == 0)
+                       $author_id = -1;
+
+               if ($owner_id == 0)
+                       $owner_id = -1;
+
+               q("UPDATE `item` SET `author-id` = %d, `owner-id` = %d
+                       WHERE `uid` = %d AND `author-link` = '%s' AND `owner-link` = '%s'
+                               AND `author-id` = 0 AND `owner-id` = 0",
+                       intval($author_id), intval($owner_id), intval($item["uid"]),
+                       dbesc($item["author-link"]), dbesc($item["owner-link"]));
+       }
+
+       logger("Updated items", LOGGER_DEBUG);
+       return false;
+}
+
+/**
+ * @brief update the "last-item" field in the "self" contact
+ *
+ * This field avoids cost intensive calls in the admin panel and in "nodeinfo"
+ *
+ * @return bool "true" when the job is done
+ */
+function post_update_1206() {
+       // Was the script completed?
+       if (get_config("system", "post_update_version") >= 1206)
+               return true;
+
+       logger("Start", LOGGER_DEBUG);
+       $r = q("SELECT `contact`.`id`, `contact`.`last-item`,
+               (SELECT MAX(`changed`) FROM `item` USE INDEX (`uid_wall_changed`) WHERE `wall` AND `uid` = `user`.`uid`) AS `lastitem_date`
+               FROM `user`
+               INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` AND `contact`.`self`");
+
+       if (!dbm::is_result($r)) {
+               return false;
+       }
+       foreach ($r AS $user) {
+               if (!empty($user["lastitem_date"]) AND ($user["lastitem_date"] > $user["last-item"])) {
+                       q("UPDATE `contact` SET `last-item` = '%s' WHERE `id` = %d",
+                               dbesc($user["lastitem_date"]),
+                               intval($user["id"]));
+               }
+       }
+
+       set_config("system", "post_update_version", 1206);
+       logger("Done", LOGGER_DEBUG);
+       return true;
+}
+
 ?>