X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=4b719682aafb707252f408ce6d7ce20a33385f13;hb=2a56370cf4dcf891ed737edc2ee01c61d5a813d3;hp=4d12730fab6e5cbf05b486bdef307e3238864f5d;hpb=04d620fc2f567d32b50f5d5b0974acafeb072177;p=friendica.git diff --git a/update.php b/update.php index 4d12730fab..4b719682aa 100644 --- a/update.php +++ b/update.php @@ -1,29 +1,31 @@ . + * + * Automatic post-databse structure change updates + * + * These functions are responsible for doing critical post update changes to the data (not the structure) in the database. * * Database structure changes are done in static/dbstructure.config.php * - * If there is a need for a post process to a structure change, update this file + * 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 @@ -38,28 +40,19 @@ use Friendica\Worker\Delivery; * 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() { @@ -77,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; } @@ -99,23 +93,7 @@ function update_1191() DI::config()->set('system', 'maintenance', 1); if (Addon::isEnabled('forumlist')) { - $addon = 'forumlist'; - $addons = DI::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' "); - DI::config()->set('system', 'addon', implode(", ", $addons_arr)); - } - } + Addon::uninstall('forumlist'); } // select old formlist addon entries @@ -137,7 +115,7 @@ function update_1191() if ($key === 'show_on_profile') { if ($value) { - DI::pConfig()->set($uid, feature, forumlist_profile, $value); + DI::pConfig()->set($uid, 'feature', 'forumlist_profile', $value); } DI::pConfig()->delete($uid, $family, $key); @@ -145,7 +123,7 @@ function update_1191() if ($key === 'show_on_network') { if ($value) { - DI::pConfig()->set($uid, feature, forumlist_widget, $value); + DI::pConfig()->set($uid, 'feature', 'forumlist_widget', $value); } DI::pConfig()->delete($uid, $family, $key); @@ -363,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; @@ -430,3 +408,69 @@ function update_1330() 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; +}