X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=4b719682aafb707252f408ce6d7ce20a33385f13;hb=2a56370cf4dcf891ed737edc2ee01c61d5a813d3;hp=1bdccddeaa77f951fbb3ab93d365824dab2f7cfc;hpb=01dc0c031c8b26cf4f8fdabdeb3052e60167916b;p=friendica.git diff --git a/update.php b/update.php index 1bdccddeaa..4b719682aa 100644 --- a/update.php +++ b/update.php @@ -1,30 +1,31 @@ . + * + * Automatic post-databse structure change updates * - * update.php - automatic system update + * These functions are responsible for doing critical post update changes to the data (not the structure) in the database. * - * This function is responsible for doing post update changes to the data - * (not the structure) in the database. + * Database structure changes are done in static/dbstructure.config.php * - * Database structure changes are done in config/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 process to a structure change, update this file + * 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,39 +34,30 @@ 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()" */ -function update_1178() -{ - require_once 'mod/profiles.php'; - - $profiles = q("SELECT `uid`, `about`, `locality`, `pub_keywords`, `gender` FROM `profile` WHERE `is-default`"); - - foreach ($profiles as $profile) { - if ($profile["about"].$profile["locality"].$profile["pub_keywords"].$profile["gender"] == "") { - continue; - } - - $profile["pub_keywords"] = profile_clean_keywords($profile["pub_keywords"]); - - $r = q("UPDATE `contact` SET `about` = '%s', `location` = '%s', `keywords` = '%s', `gender` = '%s' WHERE `self` AND `uid` = %d", - DBA::escape($profile["about"]), - DBA::escape($profile["locality"]), - DBA::escape($profile["pub_keywords"]), - DBA::escape($profile["gender"]), - intval($profile["uid"]) - ); - } -} +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_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 @@ -78,7 +70,8 @@ function update_1181() { // Fill the new fields in the term table. - Worker::add(PRIORITY_LOW, "TagUpdate"); + // deactivated, the "term" table is deprecated + // Worker::add(PRIORITY_LOW, "TagUpdate"); return Update::SUCCESS; } @@ -86,10 +79,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,26 +90,10 @@ 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_arr = []; - - if ($addons) { - $addons_arr = explode(",", str_replace(" ", "", $addons)); - - $idx = array_search($addon, $addons_arr); - if ($idx !== false) { - unset($addons_arr[$idx]); - //delete forumlist manually from addon and hook table - // 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)); - } - } + Addon::uninstall('forumlist'); } // select old formlist addon entries @@ -133,28 +110,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 +164,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 +187,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 +229,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 +242,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 +255,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 +276,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) { @@ -364,7 +341,7 @@ function update_1309() $deliver_options = ['priority' => PRIORITY_MEDIUM, 'dont_fork' => true]; Worker::add($deliver_options, 'Delivery', Delivery::POST, $item['id'], $entry['cid']); - Logger::info('Added delivery worker', ['command' => $cmd, 'item' => $item['id'], 'contact' => $entry['cid']]); + Logger::info('Added delivery worker', ['item' => $item['id'], 'contact' => $entry['cid']]); DBA::delete('queue', ['id' => $entry['id']]); } return Update::SUCCESS; @@ -384,3 +361,116 @@ function update_1318() Worker::add(PRIORITY_LOW, 'ProfileUpdate'); 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; +} + +function update_1347() +{ + foreach (Item::ACTIVITIES as $index => $activity) { + DBA::insert('verb', ['id' => $index + 1, 'name' => $activity], true); + } + + return Update::SUCCESS; +} + +function pre_update_1348() +{ + if (!DBA::exists('contact', ['id' => 0])) { + DBA::insert('contact', ['nurl' => '']); + $lastid = DBA::lastInsertId(); + if ($lastid != 0) { + DBA::update('contact', ['id' => 0], ['id' => $lastid]); + } + } + + // The tables "permissionset" and "tag" could or could not exist during the update. + // This depends upon the previous version. Depending upon this situation we have to add + // the "0" values before adding the foreign keys - or after would be sufficient. + + update_1348(); + + return Update::SUCCESS; +} + +function update_1348() +{ + // Insert a permissionset with id=0 + // Inserting it without an ID and then changing the value to 0 tricks the auto increment + if (!DBA::exists('permissionset', ['id' => 0])) { + DBA::insert('permissionset', ['allow_cid' => '', 'allow_gid' => '', 'deny_cid' => '', 'deny_gid' => '']); + $lastid = DBA::lastInsertId(); + if ($lastid != 0) { + DBA::update('permissionset', ['id' => 0], ['id' => $lastid]); + } + } + + if (!DBA::exists('tag', ['id' => 0])) { + DBA::insert('tag', ['name' => '']); + $lastid = DBA::lastInsertId(); + if ($lastid != 0) { + DBA::update('tag', ['id' => 0], ['id' => $lastid]); + } + } + + return Update::SUCCESS; +}