+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()