<?php
/**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2021, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
use Friendica\DI;
use Friendica\Model\Contact;
use Friendica\Model\Item;
+use Friendica\Model\ItemURI;
use Friendica\Model\Notification;
use Friendica\Model\Photo;
use Friendica\Model\Post;
function pre_update_1395()
{
- if (DBStructure::existsTable('post-user') && !DBA::e("DROP TABLE `post-user`")) {
+ if (DBStructure::existsTable('post-user') && !DBStructure::existsColumn('post-user', ['id']) && !DBA::e("DROP TABLE `post-user`")) {
return Update::FAILED;
}
return Update::SUCCESS;
continue 2;
}
DBA::update('workerqueue', ['parameter' => json_encode($parameters)], ['id' => $task['id']]);
+
+ return Update::SUCCESS;
}
}
if (!DBA::e("UPDATE `post-thread-user` SET `causer-id` = NULL WHERE `causer-id` = 0")) {
return Update::FAILED;
}
+
+ return Update::SUCCESS;
+}
+
+function update_1413()
+{
+ if (!DBA::e("UPDATE `post-user` SET `post-reason` = `post-type` WHERE `post-type` >= 64 and `post-type` <= 75")) {
+ return Update::FAILED;
+ }
+}
+
+function update_1419()
+{
+ $mails = DBA::select('mail', ['id', 'from-url', 'uri', 'parent-uri', 'guid'], [], ['order' => ['id']]);
+ while ($mail = DBA::fetch($mails)) {
+ $fields = [];
+ $fields['author-id'] = Contact::getIdForURL($mail['from-url'], 0, false);
+ if (empty($fields['author-id'])) {
+ continue;
+ }
+
+ $fields['uri-id'] = ItemURI::insert(['uri' => $mail['uri'], 'guid' => $mail['guid']]);
+ $fields['parent-uri-id'] = ItemURI::getIdByURI($mail['parent-uri']);
+
+ $reply = DBA::selectFirst('mail', ['uri', 'uri-id', 'guid'], ['parent-uri' => $mail['parent-uri'], 'reply' => false]);
+ if (!empty($reply)) {
+ $fields['thr-parent'] = $reply['uri'];
+ if (!empty($reply['uri-id'])) {
+ $fields['thr-parent-id'] = $reply['uri-id'];
+ } else {
+ $fields['thr-parent-id'] = ItemURI::insert(['uri' => $reply['uri'], 'guid' => $reply['guid']]);
+ }
+ }
+
+ DBA::update('mail', $fields, ['id' => $mail['id']]);
+ }
+ return Update::SUCCESS;
}