X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fpost_update.php;h=8dcf070526e4eaf3d042bc18e834911324f0715c;hb=390e34d587ef5bd09759ce63e7e64518398b2018;hp=a2b8497b9b08df3df8c5ca5097fe5bd3ef91e776;hpb=e5c7ce090299102f427bdf427f5347ef6c17d121;p=friendica.git diff --git a/include/post_update.php b/include/post_update.php index a2b8497b9b..8dcf070526 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; + } } /** @@ -44,7 +45,7 @@ function post_update_1192() { WHERE `thread`.`gcontact-id` = 0 AND (`thread`.`uid` IN (SELECT `uid` from `user`) OR `thread`.`uid` = 0)"); - if ($r AND ($r[0]["total"] == 0)) { + if ($r && ($r[0]["total"] == 0)) { set_config("system", "post_update_version", 1192); return true; } @@ -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", @@ -170,7 +171,7 @@ function post_update_1198() { 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)) { + if ($r && ($r[0]["total"] == 0)) { set_config("system", "post_update_version", 1198); logger("Done", LOGGER_DEBUG); return true; @@ -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"]) && ($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; } - -?>