X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fpost_update.php;h=af49bb555cd86211df7457e1a622be81aa054768;hb=34815de99c548b61c94b6e6939edd485eca728d6;hp=a2b8497b9b08df3df8c5ca5097fe5bd3ef91e776;hpb=e5c7ce090299102f427bdf427f5347ef6c17d121;p=friendica.git diff --git a/include/post_update.php b/include/post_update.php index a2b8497b9b..af49bb555c 100644 --- a/include/post_update.php +++ b/include/post_update.php @@ -8,17 +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()) + } + if (!post_update_1198()) { return; - - if (!post_update_1206()) + } + if (!post_update_1206()) { return; + } } /** @@ -67,7 +68,7 @@ function post_update_1192() { } // Set the "gcontact-id" in the item table and add a new gcontact entry if needed - foreach($item_arr AS $item) { + foreach ($item_arr AS $item) { $gcontact_id = get_gcontact_id(array("url" => $item['author-link'], "network" => $item['network'], "photo" => $item['author-avatar'], "name" => $item['author-name'])); q("UPDATE `item` SET `gcontact-id` = %d WHERE `uid` = %d AND `author-link` = '%s' AND `gcontact-id` = 0", @@ -203,7 +204,7 @@ function post_update_1198() { } // Set the "gcontact-id" in the item table and add a new gcontact entry if needed - foreach($item_arr AS $item) { + foreach ($item_arr AS $item) { $author_id = get_contact($item["author-link"], 0); $owner_id = get_contact($item["owner-link"], 0); @@ -238,23 +239,22 @@ function post_update_1206() { logger("Start", LOGGER_DEBUG); $r = q("SELECT `contact`.`id`, `contact`.`last-item`, - (SELECT MAX(`changed`) FROM `item` FORCE INDEX (`uid_wall_changed`) WHERE `wall` AND `uid` = `user`.`uid`) AS `lastitem_date` + (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)) + if (!dbm::is_result($r)) { return false; - + } foreach ($r AS $user) { - if (!empty($user["lastitem_date"]) AND ($user["lastitem_date"] > $user["last-item"])) + 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; } - -?>