+ DBA::update('user', ['account-type' => User::ACCOUNT_TYPE_COMMUNITY], ['page-flags' => [User::PAGE_FLAGS_COMMUNITY, User::PAGE_FLAGS_PRVGROUP]]);
+ DBA::update('contact', ['contact-type' => Contact::TYPE_COMMUNITY], ["`forum` OR `prv`"]);
+ DBA::update('contact', ['manually-approve' => true], ['prv' => true]);
+
+ return Update::SUCCESS;
+}
+
+function update_1457()
+{
+ $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['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']);