X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=06287516fa5250f30172e5c23d9c02f819f48543;hb=8087d88472a8cf5fc143948dfc529796028a824b;hp=523232ef3e972d3ce419518f80eef2bf3d3caac6;hpb=8e2d1fad17a525565d4734b7458ddb61642152d7;p=friendica.git diff --git a/update.php b/update.php index 523232ef3e..06287516fa 100644 --- a/update.php +++ b/update.php @@ -1,30 +1,31 @@ . * - * This function is responsible for doing post update changes to the data - * (not the structure) in the database. + * Automatic post-databse structure change updates * - * Database structure changes are done in config/dbstructure.config.php + * These functions are responsible for doing critical post update changes to the data (not the structure) in the database. * - * If there is a need for a post process to a structure change, update this file + * Database structure changes are done in static/dbstructure.config.php + * + * For non-critical database migrations, please add a method in the Database\PostUpdate class + * + * If there is a need for a post update to a structure change, update this file * by adding a new function at the end with the number of the new DB_UPDATE_VERSION. * * The numbered script in this file has to be exactly like the DB_UPDATE_VERSION @@ -33,12 +34,26 @@ use Friendica\Worker\Delivery; * You are currently on version 4711 and you are preparing changes that demand an update script. * * 1. Create a function "update_4712()" here in the update.php - * 2. Apply the needed structural changes in config/dbStructure.php - * 3. Set DB_UPDATE_VERSION in config/dbstructure.config.php to 4712. + * 2. Apply the needed structural changes in static/dbStructure.php + * 3. Set DB_UPDATE_VERSION in static/dbstructure.config.php to 4712. * * 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; +use Friendica\Database\DBA; +use Friendica\DI; +use Friendica\Model\Contact; +use Friendica\Model\GContact; +use Friendica\Model\Item; +use Friendica\Model\User; +use Friendica\Model\Storage; +use Friendica\Util\DateTimeFormat; +use Friendica\Worker\Delivery; + function update_1178() { require_once 'mod/profiles.php'; @@ -64,8 +79,8 @@ function update_1178() function update_1179() { - if (Config::get('system', 'no_community_page')) { - Config::set('system', 'community_page_style', CP_NO_COMMUNITY_PAGE); + 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 @@ -86,10 +101,10 @@ function update_1181() function update_1189() { - if (strlen(Config::get('system', 'directory_submit_url')) && - !strlen(Config::get('system', 'directory'))) { - Config::set('system', 'directory', dirname(Config::get('system', 'directory_submit_url'))); - Config::delete('system', 'directory_submit_url'); + 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; @@ -97,11 +112,11 @@ function update_1189() function update_1191() { - Config::set('system', 'maintenance', 1); + DI::config()->set('system', 'maintenance', 1); if (Addon::isEnabled('forumlist')) { $addon = 'forumlist'; - $addons = Config::get('system', 'addon'); + $addons = DI::config()->get('system', 'addon'); $addons_arr = []; if ($addons) { @@ -114,7 +129,7 @@ function update_1191() // since Addon::uninstall() don't work here q("DELETE FROM `addon` WHERE `name` = 'forumlist' "); q("DELETE FROM `hook` WHERE `file` = 'addon/forumlist/forumlist.php' "); - Config::set('system', 'addon', implode(", ", $addons_arr)); + DI::config()->set('system', 'addon', implode(", ", $addons_arr)); } } } @@ -133,28 +148,28 @@ function update_1191() $value = $rr['v']; if ($key === 'randomise') { - PConfig::delete($uid, $family, $key); + DI::pConfig()->delete($uid, $family, $key); } if ($key === 'show_on_profile') { if ($value) { - PConfig::set($uid, feature, forumlist_profile, $value); + DI::pConfig()->set($uid, feature, forumlist_profile, $value); } - PConfig::delete($uid, $family, $key); + DI::pConfig()->delete($uid, $family, $key); } if ($key === 'show_on_network') { if ($value) { - PConfig::set($uid, feature, forumlist_widget, $value); + DI::pConfig()->set($uid, feature, forumlist_widget, $value); } - PConfig::delete($uid, $family, $key); + DI::pConfig()->delete($uid, $family, $key); } } } - Config::set('system', 'maintenance', 0); + DI::config()->set('system', 'maintenance', 0); return Update::SUCCESS; } @@ -187,13 +202,13 @@ function update_1244() function update_1245() { - $rino = Config::get('system', 'rino_encrypt'); + $rino = DI::config()->get('system', 'rino_encrypt'); if (!$rino) { return Update::SUCCESS; } - Config::set('system', 'rino_encrypt', 1); + DI::config()->set('system', 'rino_encrypt', 1); return Update::SUCCESS; } @@ -210,11 +225,11 @@ WHERE `hook` LIKE 'plugin_%'"); function update_1260() { - Config::set('system', 'maintenance', 1); - Config::set( + DI::config()->set('system', 'maintenance', 1); + DI::config()->set( 'system', 'maintenance_reason', - L10n::t( + DI::l10n()->t( '%s: Updating author-id and owner-id in item and thread table. ', DateTimeFormat::utcNow().' '.date('e') ) @@ -252,7 +267,7 @@ function update_1260() DBA::e("UPDATE `thread` INNER JOIN `item` ON `thread`.`iid` = `item`.`id` SET `thread`.`author-id` = `item`.`author-id` WHERE `thread`.`author-id` = 0"); - Config::set('system', 'maintenance', 0); + DI::config()->set('system', 'maintenance', 0); return Update::SUCCESS; } @@ -265,11 +280,11 @@ function update_1261() function update_1278() { - Config::set('system', 'maintenance', 1); - Config::set( + DI::config()->set('system', 'maintenance', 1); + DI::config()->set( 'system', 'maintenance_reason', - L10n::t( + DI::l10n()->t( '%s: Updating post-type.', DateTimeFormat::utcNow().' '.date('e') ) @@ -278,7 +293,7 @@ function update_1278() Item::update(['post-type' => Item::PT_PAGE], ['bookmark' => true]); Item::update(['post-type' => Item::PT_PERSONAL_NOTE], ['type' => 'note']); - Config::set('system', 'maintenance', 0); + DI::config()->set('system', 'maintenance', 0); return Update::SUCCESS; } @@ -299,7 +314,7 @@ function update_1298() $keys = ['gender', 'marital', 'sexual']; foreach ($keys as $translateKey) { $allData = DBA::select('profile', ['id', $translateKey]); - $allLangs = L10n::getAvailableLanguages(); + $allLangs = DI::l10n()->getAvailableLanguages(); $success = 0; $fail = 0; foreach ($allData as $key => $data) { @@ -373,7 +388,7 @@ function update_1309() function update_1315() { DBA::delete('item-delivery-data', ['postopts' => '', 'inform' => '', 'queue_count' => 0, 'queue_done' => 0]); - return Update::Success; + return Update::SUCCESS; } function update_1318() @@ -382,5 +397,67 @@ function update_1318() DBA::update('profile', ['marital' => "Single"], ['marital' => "Available"]); Worker::add(PRIORITY_LOW, 'ProfileUpdate'); - return Update::Success; + return Update::SUCCESS; +} + +function update_1323() +{ + $users = DBA::select('user', ['uid']); + while ($user = DBA::fetch($users)) { + Contact::updateSelfFromUserID($user['uid']); + } + DBA::close($users); + + return Update::SUCCESS; +} + +function update_1327() +{ + $contacts = DBA::select('contact', ['uid', 'id', 'blocked', 'readonly'], ["`uid` != ? AND (`blocked` OR `readonly`) AND NOT `pending`", 0]); + while ($contact = DBA::fetch($contacts)) { + Contact::setBlockedForUser($contact['id'], $contact['uid'], $contact['blocked']); + Contact::setIgnoredForUser($contact['id'], $contact['uid'], $contact['readonly']); + } + DBA::close($contacts); + + return Update::SUCCESS; +} + +function update_1330() +{ + $currStorage = DI::config()->get('storage', 'class', ''); + + // set the name of the storage instead of the classpath as config + if (!empty($currStorage)) { + /** @var Storage\IStorage $currStorage */ + if (!DI::config()->set('storage', 'name', $currStorage::getName())) { + return Update::FAILED; + } + + // try to delete the class since it isn't needed. This won't work with config files + DI::config()->delete('storage', 'class'); + } + + // Update attachments and photos + if (!DBA::p("UPDATE `photo` SET `photo`.`backend-class` = SUBSTR(`photo`.`backend-class`, 25) WHERE `photo`.`backend-class` LIKE 'Friendica\\\Model\\\Storage\\\%' ESCAPE '|'") || + !DBA::p("UPDATE `attach` SET `attach`.`backend-class` = SUBSTR(`attach`.`backend-class`, 25) WHERE `attach`.`backend-class` LIKE 'Friendica\\\Model\\\Storage\\\%' ESCAPE '|'")) { + return Update::FAILED; + }; + + return Update::SUCCESS; +} + +function update_1332() +{ + $condition = ["`is-default` IS NOT NULL"]; + $profiles = DBA::select('profile', [], $condition); + + while ($profile = DBA::fetch($profiles)) { + DI::profileField()->migrateFromLegacyProfile($profile); + } + DBA::close($profiles); + + DBA::update('contact', ['profile-id' => null], ['`profile-id` IS NOT NULL']); + + return Update::SUCCESS; }