X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fpost_update.php;h=6918bf0fa433d64fac2c719b0a74758bd4511f31;hb=497fd34026fbaa83b11a64d3a0a6e20f1360e5d6;hp=2bdfe1f6fd39ab3f5d621eec3eaf6f4b94a54a7f;hpb=b9d9ffbd015c213f2248860b3fd902fc8c5ff135;p=friendica.git

diff --git a/include/post_update.php b/include/post_update.php
index 2bdfe1f6fd..6918bf0fa4 100644
--- a/include/post_update.php
+++ b/include/post_update.php
@@ -13,6 +13,9 @@ function post_update() {
 
 	if (!post_update_1194())
 		return;
+
+	if (!post_update_1198())
+		return;
 }
 
 /**
@@ -138,4 +141,78 @@ 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 1000");
+	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
+		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);
+		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;
+}
 ?>