use Friendica\Model\Post;
use Friendica\Model\Profile;
use Friendica\Model\Storage;
+use Friendica\Security\PermissionSet\Depository\PermissionSet;
use Friendica\Worker\Delivery;
// Post-update script of PR 5751
}
// 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 '|'")) {
+ if (!DBA::e("UPDATE `photo` SET `photo`.`backend-class` = SUBSTR(`photo`.`backend-class`, 25) WHERE `photo`.`backend-class` LIKE 'Friendica\\\Model\\\Storage\\\%' ESCAPE '|'") ||
+ !DBA::e("UPDATE `attach` SET `attach`.`backend-class` = SUBSTR(`attach`.`backend-class`, 25) WHERE `attach`.`backend-class` LIKE 'Friendica\\\Model\\\Storage\\\%' ESCAPE '|'")) {
return Update::FAILED;
};
$profiles = DBA::select('profile', [], $condition);
while ($profile = DBA::fetch($profiles)) {
- DI::profileField()->migrateFromLegacyProfile($profile);
+ Profile::migrate($profile);
}
DBA::close($profiles);
return Update::FAILED;
}
- if (!DBA::e("DELETE FROM `profile_check` WHERE NOT `uid` IN (SELECT `uid` FROM `user`)")) {
+ if (DBStructure::existsTable('profile_check') && !DBA::e("DELETE FROM `profile_check` WHERE NOT `uid` IN (SELECT `uid` FROM `user`)")) {
return Update::FAILED;
}
return Update::FAILED;
}
- if (!DBA::e("DELETE FROM `profile_check` WHERE NOT `cid` IN (SELECT `id` FROM `contact`)")) {
+ if (DBStructure::existsTable('profile_check') && !DBA::e("DELETE FROM `profile_check` WHERE NOT `cid` IN (SELECT `id` FROM `contact`)")) {
return Update::FAILED;
}
return Update::SUCCESS;
}
+
+function update_1434()
+{
+ $name = DI::config()->get('storage', 'name');
+
+ // in case of an empty config, set "Database" as default storage backend
+ if (empty($name)) {
+ DI::config()->set('storage', 'name', Storage\Database::getName());
+ }
+
+ // In case of a Using deprecated storage class value, set the right name for it
+ if (stristr($name, 'Friendica\Model\Storage\\')) {
+ DI::config()->set('storage', 'name', substr($name, 24));
+ }
+
+ return Update::SUCCESS;
+}
+
+function update_1435()
+{
+ $contacts = DBA::select('contact', [], ["`uid` != ?", 0]);
+ while ($contact = DBA::fetch($contacts)) {
+ Contact\User::insertForContactArray($contact);
+ }
+}
+
+function update_1438()
+{
+ DBA::update('photo', ['photo-type' => Photo::USER_AVATAR], ['profile' => true]);
+ DBA::update('photo', ['photo-type' => Photo::CONTACT_AVATAR], ["NOT `profile` AND NOT `contact-id` IS NULL AND `contact-id` != ?", 0]);
+ DBA::update('photo', ['photo-type' => Photo::DEFAULT], ["NOT `profile` AND (`contact-id` IS NULL OR `contact-id` = ?) AND `photo-type` IS NULL AND `album` != ?", 0, Photo::CONTACT_PHOTOS]);
+}
+
+function update_1439()
+{
+ $intros = DBA::select('intro', ['id', 'fid'], ["NOT `fid` IS NULL AND `fid` != ?", 0]);
+ while ($intro = DBA::fetch($intros)) {
+ $fcontact = DBA::selectFirst('fcontact', ['url'], ['id' => $intro['fid']]);
+ if (!empty($fcontact['url'])) {
+ $id = Contact::getIdForURL($fcontact['url']);
+ if (!empty($id)) {
+ DBA::update('intro',['suggest-cid' => $id], ['id' => $intro['id']]);
+ }
+ }
+ }
+ DBA::close($intros);
+}
+
+function update_1440()
+{
+ // Fix wrong public permissionset
+ DBA::p("UPDATE `profile_field` SET `psid` = ? WHERE psid IN (SELECT `id` FROM `permissionset` WHERE `id` != ? AND `allow_cid` = '' AND `allow_gid` = '' AND `deny_cid` = '' AND `deny_gid` = '')", PermissionSet::PUBLIC, PermissionSet::PUBLIC);
+ DBA::delete('permissionset', ["`id` != ? AND `allow_cid` = '' AND `allow_gid` = '' AND `deny_cid` = '' AND `deny_gid` = ''", PermissionSet::PUBLIC]);
+
+ return Update::SUCCESS;
+}
+
+function update__1441()
+{
+ $languages = DI::l10n()->getAvailableLanguages();
+
+ $albums = [Photo::PROFILE_PHOTOS];
+ foreach ($languages as $language) {
+ $albums[] = DI::l10n()->withLang($language)->t(Photo::PROFILE_PHOTOS);
+ }
+ $albums = array_unique($albums);
+
+ Photo::update(['photo-type' => Photo::USER_AVATAR], ['album' => $albums]);
+
+ return Update::SUCCESS;
+}