Merge pull request #11959 from annando/notice

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 9126488c49c7ef71ec6034d45c70f1a37f49783b..fab51993c16359026206253c9262e3bbb8486ea1 100644 (file)
--- a/update.php
+++ b/update.php
@@ -42,6 +42,7 @@
 
 use Friendica\Core\Config\ValueObject\Cache;
 use Friendica\Core\Logger;
+use Friendica\Core\Protocol;
 use Friendica\Core\Storage\Capability\ICanReadFromStorage;
 use Friendica\Core\Storage\Type\Database as DatabaseStorage;
 use Friendica\Core\Update;
@@ -1099,11 +1100,24 @@ function update_1451()
 
 function update_1457()
 {
-       $pinned = DBA::select('post-thread-user', ['uri-id'], ['pinned' => true]);
+       $pinned = DBA::select('post-thread-user', ['uri-id', 'author-id'], ['pinned' => true]);
        while ($post = DBA::fetch($pinned)) {
-               Post\Collection::add($post['uri-id'], Post\Collection::FEATURED);
+               Post\Collection::add($post['uri-id'], Post\Collection::FEATURED, $post['author-id']);
        }
        DBA::close($pinned);
 
        return Update::SUCCESS;
 }
+
+function update_1480()
+{
+       DBA::update('contact', ['next-update' => DBA::NULL_DATETIME], ['network' => Protocol::FEDERATED]);
+       DBA::update('post', ['deleted' => false], ["`uri-id` IN (SELECT `uri-id` FROM `post-user` WHERE NOT `deleted`)"]);
+       return Update::SUCCESS;
+}
+
+function update_1481()
+{
+       DBA::e("UPDATE `post-collection` INNER JOIN `post` ON `post`.`uri-id` = `post-collection`.`uri-id` SET `post-collection`.`author-id` = `post`.`author-id` WHERE `post-collection`.`author-id` IS null");
+       return Update::SUCCESS;
+}