Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/mets.corals.io/wp-content/plugins/give/src/Log/Migrations/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

declare(strict_types=1);

namespace Give\Log\Migrations;

use Give\Framework\Database\DB;
use Give\Framework\Migrations\Contracts\Migration;
use Give\Log\Log;

/**
 * Removes logs that contain sensitive information.
 *
 * @since 2.20.0
 */
class RemoveSensitiveLogs extends Migration
{
    /**
     * @inheritdoc
     */
    public static function id(): string
    {
        return 'remove_sensitive_logs';
    }

    /**
     * @inheritdoc
     */
    public static function title(): string
    {
        return 'Remove logs wth sensitive information';
    }

    /**
     * @inheritdoc
     */
    public static function timestamp()
    {
        return strtotime('2022-05-04');
    }

    /**
     * @inheritdoc
     */
    public function run()
    {
        $tableName = DB::prefix('give_log');
        $redactions = implode('|', Log::getRedactionList());

        DB::query(" DELETE FROM $tableName WHERE data REGEXP '$redactions' ");
    }
}