Merge pull request #12606 from nupplaphil/bug/file_put

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 2c5e2f5c1c99fcc1448a375fc0c6dcadf1ccba30..1dbf78e06f915647cf6300c4886623fe4ca8fdaa 100644 (file)
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * @copyright Copyright (C) 2010-2022, the Friendica project
+ * @copyright Copyright (C) 2010-2023, the Friendica project
  *
  * @license GNU AGPL version 3 or any later version
  *
@@ -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;
@@ -58,8 +59,8 @@ use Friendica\Model\Photo;
 use Friendica\Model\Post;
 use Friendica\Model\Profile;
 use Friendica\Model\User;
+use Friendica\Protocol\Delivery;
 use Friendica\Security\PermissionSet\Repository\PermissionSet;
-use Friendica\Worker\Delivery;
 
 // Post-update script of PR 5751
 function update_1298()
@@ -78,11 +79,11 @@ function update_1298()
                                        $a->strings = [];
 
                                        // First we get the the localizations
-                                       if (file_exists("view/lang/$lang/strings.php")) {
-                                               include "view/lang/$lang/strings.php";
+                                       if (file_exists('view/lang/$lang/strings.php')) {
+                                               include 'view/lang/$lang/strings.php';
                                        }
-                                       if (file_exists("addon/morechoice/lang/$lang/strings.php")) {
-                                               include "addon/morechoice/lang/$lang/strings.php";
+                                       if (file_exists('addon/morechoice/lang/$lang/strings.php')) {
+                                               include 'addon/morechoice/lang/$lang/strings.php';
                                        }
 
                                        $localizedStrings = $a->strings;
@@ -111,7 +112,7 @@ function update_1298()
                        }
                }
 
-               Logger::notice($translateKey . " fix completed", ['action' => 'update', 'translateKey' => $translateKey, 'Success' => $success, 'Fail' => $fail ]);
+               Logger::notice($translateKey . ' fix completed', ['action' => 'update', 'translateKey' => $translateKey, 'Success' => $success, 'Fail' => $fail ]);
        }
        return Update::SUCCESS;
 }
@@ -130,7 +131,7 @@ function update_1309()
                        continue;
                }
 
-               $deliver_options = ['priority' => PRIORITY_MEDIUM, 'dont_fork' => true];
+               $deliver_options = ['priority' => Worker::PRIORITY_MEDIUM, 'dont_fork' => true];
                Worker::add($deliver_options, 'Delivery', Delivery::POST, $item['id'], $entry['cid']);
                Logger::info('Added delivery worker', ['item' => $item['id'], 'contact' => $entry['cid']]);
                DBA::delete('queue', ['id' => $entry['id']]);
@@ -148,10 +149,10 @@ function update_1315()
 
 function update_1318()
 {
-       DBA::update('profile', ['marital' => "In a relation"], ['marital' => "Unavailable"]);
-       DBA::update('profile', ['marital' => "Single"], ['marital' => "Available"]);
+       DBA::update('profile', ['marital' => 'In a relation'], ['marital' => 'Unavailable']);
+       DBA::update('profile', ['marital' => 'Single'], ['marital' => 'Available']);
 
-       Worker::add(PRIORITY_LOW, 'ProfileUpdate');
+       Worker::add(Worker::PRIORITY_LOW, 'ProfileUpdate');
        return Update::SUCCESS;
 }
 
@@ -298,7 +299,7 @@ function update_1349()
        }
 
        if (!DBA::e("UPDATE `item` INNER JOIN `item-activity` ON `item`.`uri-id` = `item-activity`.`uri-id`
-               SET `vid` = `item-activity`.`activity` + 1 WHERE `gravity` = ? AND (`vid` IS NULL OR `vid` = 0)", GRAVITY_ACTIVITY)) {
+               SET `vid` = `item-activity`.`activity` + 1 WHERE `gravity` = ? AND (`vid` IS NULL OR `vid` = 0)", Item::GRAVITY_ACTIVITY)) {
                return Update::FAILED;
        }
 
@@ -973,7 +974,7 @@ function update_1429()
                return Update::FAILED;
        }
 
-       if (!DBA::e("UPDATE `fcontact` SET `uri-id` = null WHERE NOT `uri-id` IS NULL")) {
+       if (DBStructure::existsTable('fcontact') && !DBA::e("UPDATE `fcontact` SET `uri-id` = null WHERE NOT `uri-id` IS NULL")) {
                return Update::FAILED;
        }
 
@@ -981,7 +982,7 @@ function update_1429()
                return Update::FAILED;
        }
 
-       DI::config()->set("system", "post_update_version", 1423);
+       DI::keyValue()->set('post_update_version', 1423);
 
        return Update::SUCCESS;
 }
@@ -1012,6 +1013,10 @@ function update_1438()
 
 function update_1439()
 {
+       if (!DBStructure::existsTable('fcontact')) {
+               return Update::SUCCESS;
+       }
+
        $intros = DBA::select('intro', ['id', 'fid'], ["NOT `fid` IS NULL AND `fid` != ?", 0]);
        while ($intro = DBA::fetch($intros)) {
                $fcontact = DBA::selectFirst('fcontact', ['url'], ['id' => $intro['fid']]);
@@ -1023,6 +1028,8 @@ function update_1439()
                }
        }
        DBA::close($intros);
+
+       return Update::SUCCESS;
 }
 
 function update_1440()
@@ -1099,11 +1106,91 @@ 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;
+}
+
+function update_1491()
+{
+       DBA::update('contact', ['remote_self' => Contact::MIRROR_OWN_POST], ['remote_self' => Contact::MIRROR_FORWARDED]);
+       return Update::SUCCESS;
+}
+
+function update_1497()
+{
+       DBA::e("UPDATE `user` SET `last-activity` = DATE(`login_date`) WHERE `last-activity` IS NULL");
+       return Update::SUCCESS;
+}
+
+function update_1502()
+{
+       DBA::e("UPDATE `pconfig` SET `cat` = 'calendar' WHERE `k` = 'first_day_of_week'");
+       return Update::SUCCESS;
+}
+
+function update_1505()
+{
+       if (!DBStructure::existsTable('config')) {
+               return Update::SUCCESS;
+       }
+
+       $conditions = [
+               "((`cat`  = ?) AND ((`k` LIKE ?) OR (`k` = ?) OR (`k` LIKE ?) OR (`k` = ?))) OR " .
+               "((`cat` != ?) AND  (`k` LIKE ?)) OR " .
+               "((`cat`  = ?) AND  (`k` LIKE ?))",
+               "system",
+               "post_update_%",
+               "worker_last_cleaned",
+               "last%",
+               "worker_daemon_mode",
+               "system",
+               "last_%",
+               "database",
+               "update_%",
+       ];
+
+       $postUpdateEntries = DBA::selectToArray('config', ['cat', 'k', 'v'], $conditions);
+
+       foreach ($postUpdateEntries as $postUpdateEntry) {
+               if ($postUpdateEntry['cat'] === 'system') {
+                       DI::keyValue()->set($postUpdateEntry['k'], $postUpdateEntry['v']);
+               } else {
+                       DI::keyValue()->set(sprintf('%s_%s', $postUpdateEntry['cat'], $postUpdateEntry['k']), $postUpdateEntry['v']);
+               }
+       }
+
+       return DBA::delete('config', $conditions) ? Update::SUCCESS : Update::FAILED;
+}
+
+function update_1508()
+{
+       $config = DBA::selectToArray('config');
+
+       $newConfig = DI::config()->beginTransaction();
+
+       foreach ($config as $entry) {
+               $newConfig->set($entry['cat'], $entry['k'], $entry['v']);
+       }
+
+       $newConfig->commit();
+
+       DBA::e("TRUNCATE TABLE `config`");
+}