3 * @copyright Copyright (C) 2010-2023, the Friendica project
5 * @license GNU AGPL version 3 or any later version
7 * This program is free software: you can redistribute it and/or modify
8 * it under the terms of the GNU Affero General Public License as
9 * published by the Free Software Foundation, either version 3 of the
10 * License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU Affero General Public License for more details.
17 * You should have received a copy of the GNU Affero General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 namespace Friendica\Worker;
24 use Friendica\Core\Logger;
25 use Friendica\Database\DBA;
27 use Friendica\Model\GServer;
28 use Friendica\Util\Network;
30 class UpdateBlockedServers
33 * Updates the server blocked status
35 public static function execute()
37 Logger::info('Update blocked servers - start');
38 $gservers = DBA::select('gserver', ['id', 'url', 'blocked']);
41 while ($gserver = DBA::fetch($gservers)) {
42 $blocked = Network::isUrlBlocked($gserver['url']);
43 if (!is_null($gserver['blocked']) && ($blocked == $gserver['blocked'])) {
49 GServer::setBlockedById($gserver['id']);
51 GServer::setUnblockedById($gserver['id']);
55 DBA::close($gservers);
56 Logger::info('Update blocked servers - done', ['changed' => $changed, 'unchanged' => $unchanged]);
58 if (DI::config()->get('system', 'delete-blocked-servers')) {
59 Logger::info('Delete blocked servers - start');
60 $ret = DBA::delete('gserver', ["`blocked` AND NOT EXISTS(SELECT `gsid` FROM `inbox-status` WHERE `gsid` = `gserver`.`id`) AND NOT EXISTS(SELECT `gsid` FROM `contact` WHERE gsid= `gserver`.`id`) AND NOT EXISTS(SELECT `gsid` FROM `apcontact` WHERE `gsid` = `gserver`.`id`) AND NOT EXISTS(SELECT `gsid` FROM `delivery-queue` WHERE `gsid` = `gserver`.`id`) AND NOT EXISTS(SELECT `gsid` FROM `diaspora-contact` WHERE `gsid` = `gserver`.`id`) AND NOT EXISTS(SELECT `gserver-id` FROM `gserver-tag` WHERE `gserver-id` = `gserver`.`id`)"]);
61 Logger::info('Delete blocked servers - done', ['ret' => $ret, 'rows' => DBA::affectedRows()]);