X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=1d4fd38438d203b16592bf126e8f07a80cb9dc6b;hb=e52d5bcca023267d41bcaf755ffcdcbdecdf02d9;hp=b5d17848941bfa18994dc445454c910a72f2c799;hpb=31f0f4821f75be931f0571a6d854448eddd3b86e;p=friendica.git diff --git a/update.php b/update.php index b5d1784894..1d4fd38438 100644 --- a/update.php +++ b/update.php @@ -40,7 +40,6 @@ * If you need to run a script before the database update, name the function "pre_update_4712()" */ -use Friendica\Core\Addon; use Friendica\Core\Logger; use Friendica\Core\Update; use Friendica\Core\Worker; @@ -50,229 +49,12 @@ use Friendica\Database\DBStructure; use Friendica\DI; use Friendica\Model\Contact; use Friendica\Model\Item; -use Friendica\Model\Notify; +use Friendica\Model\Notification; use Friendica\Model\Photo; -use Friendica\Model\User; +use Friendica\Model\Post; use Friendica\Model\Storage; -use Friendica\Util\DateTimeFormat; use Friendica\Worker\Delivery; -function update_1179() -{ - if (DI::config()->get('system', 'no_community_page')) { - DI::config()->set('system', 'community_page_style', CP_NO_COMMUNITY_PAGE); - } - - // Update the central item storage with uid=0 - Worker::add(PRIORITY_LOW, "threadupdate"); - - return Update::SUCCESS; -} - -function update_1181() -{ - - // Fill the new fields in the term table. - // deactivated, the "term" table is deprecated - // Worker::add(PRIORITY_LOW, "TagUpdate"); - - return Update::SUCCESS; -} - -function update_1189() -{ - - if (strlen(DI::config()->get('system', 'directory_submit_url')) && - !strlen(DI::config()->get('system', 'directory'))) { - DI::config()->set('system', 'directory', dirname(DI::config()->get('system', 'directory_submit_url'))); - DI::config()->delete('system', 'directory_submit_url'); - } - - return Update::SUCCESS; -} - -function update_1191() -{ - DI::config()->set('system', 'maintenance', 1); - - if (Addon::isEnabled('forumlist')) { - Addon::uninstall('forumlist'); - } - - // select old formlist addon entries - $r = q("SELECT `uid`, `cat`, `k`, `v` FROM `pconfig` WHERE `cat` = '%s' ", - DBA::escape('forumlist') - ); - - // convert old forumlist addon entries in new config entries - if (DBA::isResult($r)) { - foreach ($r as $rr) { - $uid = $rr['uid']; - $family = $rr['cat']; - $key = $rr['k']; - $value = $rr['v']; - - if ($key === 'randomise') { - DI::pConfig()->delete($uid, $family, $key); - } - - if ($key === 'show_on_profile') { - if ($value) { - DI::pConfig()->set($uid, 'feature', 'forumlist_profile', $value); - } - - DI::pConfig()->delete($uid, $family, $key); - } - - if ($key === 'show_on_network') { - if ($value) { - DI::pConfig()->set($uid, 'feature', 'forumlist_widget', $value); - } - - DI::pConfig()->delete($uid, $family, $key); - } - } - } - - DI::config()->set('system', 'maintenance', 0); - - return Update::SUCCESS; -} - -function update_1203() -{ - $r = q("UPDATE `user` SET `account-type` = %d WHERE `page-flags` IN (%d, %d)", - DBA::escape(User::ACCOUNT_TYPE_COMMUNITY), - DBA::escape(User::PAGE_FLAGS_COMMUNITY), - DBA::escape(User::PAGE_FLAGS_PRVGROUP) - ); -} - -function update_1244() -{ - // Sets legacy_password for all legacy hashes - DBA::update('user', ['legacy_password' => true], ['SUBSTR(password, 1, 4) != "$2y$"']); - - // All legacy hashes are re-hashed using the new secure hashing function - $stmt = DBA::select('user', ['uid', 'password'], ['legacy_password' => true]); - while ($user = DBA::fetch($stmt)) { - DBA::update('user', ['password' => User::hashPassword($user['password'])], ['uid' => $user['uid']]); - } - - // Logged in users are forcibly logged out - DBA::delete('session', ['1 = 1']); - - return Update::SUCCESS; -} - -function update_1245() -{ - $rino = DI::config()->get('system', 'rino_encrypt'); - - if (!$rino) { - return Update::SUCCESS; - } - - DI::config()->set('system', 'rino_encrypt', 1); - - return Update::SUCCESS; -} - -function update_1247() -{ - // Removing hooks with the old name - DBA::e("DELETE FROM `hook` -WHERE `hook` LIKE 'plugin_%'"); - - // Make sure we install the new renamed ones - Addon::reload(); -} - -function update_1260() -{ - DI::config()->set('system', 'maintenance', 1); - DI::config()->set( - 'system', - 'maintenance_reason', - DI::l10n()->t( - '%s: Updating author-id and owner-id in item and thread table. ', - DateTimeFormat::utcNow().' '.date('e') - ) - ); - - $items = DBA::p("SELECT `id`, `owner-link`, `owner-name`, `owner-avatar`, `network` FROM `item` - WHERE `owner-id` = 0 AND `owner-link` != ''"); - while ($item = DBA::fetch($items)) { - $contact = ['url' => $item['owner-link'], 'name' => $item['owner-name'], - 'photo' => $item['owner-avatar'], 'network' => $item['network']]; - $cid = Contact::getIdForURL($item['owner-link'], 0, null, $contact); - if (empty($cid)) { - continue; - } - Item::update(['owner-id' => $cid], ['id' => $item['id']]); - } - DBA::close($items); - - DBA::e("UPDATE `thread` INNER JOIN `item` ON `thread`.`iid` = `item`.`id` - SET `thread`.`owner-id` = `item`.`owner-id` WHERE `thread`.`owner-id` = 0"); - - $items = DBA::p("SELECT `id`, `author-link`, `author-name`, `author-avatar`, `network` FROM `item` - WHERE `author-id` = 0 AND `author-link` != ''"); - while ($item = DBA::fetch($items)) { - $contact = ['url' => $item['author-link'], 'name' => $item['author-name'], - 'photo' => $item['author-avatar'], 'network' => $item['network']]; - $cid = Contact::getIdForURL($item['author-link'], 0, null, $contact); - if (empty($cid)) { - continue; - } - Item::update(['author-id' => $cid], ['id' => $item['id']]); - } - DBA::close($items); - - DBA::e("UPDATE `thread` INNER JOIN `item` ON `thread`.`iid` = `item`.`id` - SET `thread`.`author-id` = `item`.`author-id` WHERE `thread`.`author-id` = 0"); - - DI::config()->set('system', 'maintenance', 0); - return Update::SUCCESS; -} - -function update_1261() -{ - // This fixes the results of an issue in the develop branch of 2018-05. - DBA::update('contact', ['blocked' => false, 'pending' => false], ['uid' => 0, 'blocked' => true, 'pending' => true]); - return Update::SUCCESS; -} - -function update_1278() -{ - DI::config()->set('system', 'maintenance', 1); - DI::config()->set( - 'system', - 'maintenance_reason', - DI::l10n()->t( - '%s: Updating post-type.', - DateTimeFormat::utcNow().' '.date('e') - ) - ); - - Item::update(['post-type' => Item::PT_PAGE], ['bookmark' => true]); - Item::update(['post-type' => Item::PT_PERSONAL_NOTE], ['type' => 'note']); - - DI::config()->set('system', 'maintenance', 0); - - return Update::SUCCESS; -} - -function update_1288() -{ - // Updates missing `uri-id` values - - DBA::e("UPDATE `item-activity` INNER JOIN `item` ON `item`.`iaid` = `item-activity`.`id` SET `item-activity`.`uri-id` = `item`.`uri-id` WHERE `item-activity`.`uri-id` IS NULL OR `item-activity`.`uri-id` = 0"); - DBA::e("UPDATE `item-content` INNER JOIN `item` ON `item`.`icid` = `item-content`.`id` SET `item-content`.`uri-id` = `item`.`uri-id` WHERE `item-content`.`uri-id` IS NULL OR `item-content`.`uri-id` = 0"); - - return Update::SUCCESS; -} - // Post-update script of PR 5751 function update_1298() { @@ -336,7 +118,7 @@ function update_1309() continue; } - $item = Item::selectFirst(['id', 'gravity'], ['uid' => $contact['uid'], 'guid' => $entry['guid']]); + $item = Post::selectFirst(['id', 'gravity'], ['uid' => $contact['uid'], 'guid' => $entry['guid']]); if (!DBA::isResult($item)) { continue; } @@ -872,12 +654,12 @@ function pre_update_1377() function update_1380() { if (!DBA::e("UPDATE `notify` INNER JOIN `item` ON `item`.`id` = `notify`.`iid` SET `notify`.`uri-id` = `item`.`uri-id` WHERE `notify`.`uri-id` IS NULL AND `notify`.`otype` IN (?, ?)", - Notify\ObjectType::ITEM, Notify\ObjectType::PERSON)) { + Notification\ObjectType::ITEM, Notification\ObjectType::PERSON)) { return Update::FAILED; } if (!DBA::e("UPDATE `notify` INNER JOIN `item` ON `item`.`id` = `notify`.`parent` SET `notify`.`parent-uri-id` = `item`.`uri-id` WHERE `notify`.`parent-uri-id` IS NULL AND `notify`.`otype` IN (?, ?)", - Notify\ObjectType::ITEM, Notify\ObjectType::PERSON)) { + Notification\ObjectType::ITEM, Notification\ObjectType::PERSON)) { return Update::FAILED; }