blob: 17fe2490f159e31f853073351c8ba99280bb1f22 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
<?php
namespace Studip\Cli\Commands\Fix;
use DBManager;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Style\SymfonyStyle;
class Biest8136 extends Command
{
protected static $defaultName = 'fix:biest-8136';
protected function configure(): void
{
$this->setDescription('Fix Biest #8136');
}
protected function execute(InputInterface $input, OutputInterface $output): int
{
$io = new SymfonyStyle($input, $output);
$query = "UPDATE `activities`
SET `actor_type` = 'anonymous',
`actor_id` = ''
WHERE `provider` = :provider
AND `actor_type` != 'anonymous'
AND `object_id` IN (
SELECT `topic_id`
FROM `forum_entries`
WHERE `anonymous` != 0
)";
$statement = DBManager::get()->prepare($query);
$statement->bindValue(':provider', 'Studip\\Activity\\ForumProvider');
$statement->execute();
$io->info(sprintf('%u forum post activities were anonymized', $statement->rowCount()));
return Command::SUCCESS;
}
}
|
