Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
80.00% covered (warning)
80.00%
4 / 5
CRAP
98.51% covered (success)
98.51%
66 / 67
delete_id
0.00% covered (danger)
0.00%
0 / 1
80.00% covered (warning)
80.00%
4 / 5
16
98.51% covered (success)
98.51%
66 / 67
 __construct
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
100.00%
12 / 12
 configure
100.00% covered (success)
100.00%
1 / 1
1
100.00% covered (success)
100.00%
12 / 12
 execute
0.00% covered (danger)
0.00%
0 / 1
9
96.43% covered (success)
96.43%
27 / 28
 interact
100.00% covered (success)
100.00%
1 / 1
3
100.00% covered (success)
100.00%
9 / 9
 delete_bot_user
100.00% covered (success)
100.00%
1 / 1
2
100.00% covered (success)
100.00%
6 / 6
<?php
/**
 *
 * This file is part of the phpBB Forum Software package.
 *
 * @copyright (c) phpBB Limited <https://www.phpbb.com>
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 * For full copyright and license information, please see
 * the docs/CREDITS.txt file.
 *
 */
namespace phpbb\console\command\user;
use phpbb\console\command\command;
use phpbb\db\driver\driver_interface;
use phpbb\language\language;
use phpbb\log\log_interface;
use phpbb\user;
use phpbb\user_loader;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Question\ConfirmationQuestion;
use Symfony\Component\Console\Style\SymfonyStyle;
class delete_id extends command
{
    /** @var driver_interface */
    protected $db;
    /** @var language */
    protected $language;
    /** @var log_interface */
    protected $log;
    /** @var user_loader */
    protected $user_loader;
    /** @var string Bots table */
    protected $bots_table;
    /** @var string User group table */
    protected $user_group_table;
    /** @var string Users table */
    protected $users_table;
    /** @var string phpBB root path */
    protected $phpbb_root_path;
    /** @var string PHP extension */
    protected $php_ext;
    /**
     * Construct method
     *
     * @param driver_interface $db
     * @param language         $language
     * @param log_interface    $log
     * @param user             $user
     * @param user_loader      $user_loader
     * @param string           $bots_table
     * @param string           $user_group_table
     * @param string           $users_table
     * @param string           $phpbb_root_path
     * @param string           $php_ext
     */
    public function __construct(driver_interface $db, language $language, log_interface $log, user $user, user_loader $user_loader,
                                string $bots_table, string $user_group_table, string $users_table, string $phpbb_root_path, string $php_ext)
    {
        $this->db = $db;
        $this->language = $language;
        $this->log = $log;
        $this->user_loader = $user_loader;
        $this->bots_table = $bots_table;
        $this->user_group_table = $user_group_table;
        $this->users_table = $users_table;
        $this->phpbb_root_path = $phpbb_root_path;
        $this->php_ext = $php_ext;
        $this->language->add_lang('acp/users');
        parent::__construct($user);
    }
    /**
     * Sets the command name and description
     *
     * @return void
     */
    protected function configure(): void
    {
        $this
            ->setName('user:delete_id')
            ->setDescription($this->language->lang('CLI_DESCRIPTION_USER_DELETE_ID'))
            ->addArgument(
                'user_ids',
                InputArgument::REQUIRED | InputArgument::IS_ARRAY,
                $this->language->lang('CLI_DESCRIPTION_USER_DELETE_ID_OPTION_ID')
            )
            ->addOption(
                'delete-posts',
                null,
                InputOption::VALUE_NONE,
                $this->language->lang('CLI_DESCRIPTION_USER_DELETE_OPTION_POSTS')
            )
        ;
    }
    /**
     * Executes the command user:delete_ids
     *
     * Deletes a list of user ids from the database. An option to delete the users' posts
     * is available, by default posts will be retained.
     *
     * @param InputInterface  $input  The input stream used to get the options
     * @param OutputInterface $output The output stream, used to print messages
     *
     * @return int 0 if all is well, 1 if any errors occurred
     */
    protected function execute(InputInterface $input, OutputInterface $output): int
    {
        $user_ids = $input->getArgument('user_ids');
        $mode = ($input->getOption('delete-posts')) ? 'remove' : 'retain';
        $deleted_users = 0;
        $io = new SymfonyStyle($input, $output);
        if (count($user_ids) > 0)
        {
            $this->user_loader->load_users($user_ids);
            $progress = $this->create_progress_bar(count($user_ids), $io, $output);
            $progress->setMessage($this->language->lang('CLI_USER_DELETE_ID_START'));
            $progress->start();
            foreach ($user_ids as $user_id)
            {
                $user_row = $this->user_loader->get_user($user_id);
                // Skip anonymous user
                if ($user_row['user_id'] == ANONYMOUS)
                {
                    $progress->advance();
                    continue;
                }
                else if ($user_row['user_type'] == USER_IGNORE)
                {
                    $this->delete_bot_user($user_row);
                }
                else
                {
                    if (!function_exists('user_delete'))
                    {
                        require($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);
                    }
                    user_delete($mode, $user_row['user_id'], $user_row['username']);
                    $this->log->add('admin', ANONYMOUS, '', 'LOG_USER_DELETED', false, array($user_row['username']));
                }
                $progress->advance();
                $deleted_users++;
            }
            $progress->finish();
            if ($deleted_users > 0)
            {
                $io->success($this->language->lang('CLI_USER_DELETE_ID_SUCCESS'));
            }
        }
        if (!$deleted_users)
        {
            $io->note($this->language->lang('CLI_USER_DELETE_NONE'));
        }
        return 0;
    }
    /**
     * Interacts with the user.
     * Confirm they really want to delete the account...last chance!
     *
     * @param InputInterface  $input  An InputInterface instance
     * @param OutputInterface $output An OutputInterface instance
     */
    protected function interact(InputInterface $input, OutputInterface $output): void
    {
        $helper = $this->getHelper('question');
        $user_ids = $input->getArgument('user_ids');
        if (count($user_ids) > 0)
        {
            $question = new ConfirmationQuestion(
                $this->language->lang('CLI_USER_DELETE_ID_CONFIRM', implode(',', $user_ids)),
                false
            );
            if (!$helper->ask($input, $output, $question))
            {
                $input->setArgument('user_ids', []);
            }
        }
    }
    /**
     * Deletes a bot user
     *
     * @param array $user_row
     * @return void
     */
    protected function delete_bot_user(array $user_row): void
    {
        $delete_tables = [$this->bots_table, $this->user_group_table, $this->users_table];
        foreach ($delete_tables as $table)
        {
            $sql = "DELETE FROM $table
                WHERE user_id = " . (int) $user_row['user_id'];
            $this->db->sql_query($sql);
        }
    }
}