usertopic.php

См. документацию.

<?php
namespace Bitrix\Forum;
 
use Bitrix\Main\Entity\DataManager;
use Bitrix\Main\Type\DateTime;
use Bitrix\Main;

class UserTopicTable extends DataManager
{
    public static function getTableName(): string
    {
        return 'b_forum_user_topic';
    }

    public static function getMap(): array
    {
        return [
            'ID' => [
                'data_type' => 'integer',
                'autocomplete' => true,
            ],
            'TOPIC_ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'required' => true,
            ],
            'USER_ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'required' => true,
            ],
            'FORUM_ID' => [
                'data_type' => 'integer',
                'required' => true,
            ],
            'LAST_VISIT' => [
                'data_type' => 'datetime',
                'required' => true,
                'default_value' => static function() {
                    return new DateTime();
                },
            ],
        ];
    }
 
    public static function deleteBatch(array $filter)
    {
        $tableName = static::getTableName();
        $connection = Main\Application::getConnection();
        $helper = $connection->getSqlHelper();
 
        $where = [];
        foreach ($filter as $key => $value)
        {
            $where[] = $helper->prepareAssignment($tableName, $key, $value);
        }
        $where = implode(' AND ', $where);
 
        if($where)
        {
            $quotedTableName = $helper->quote($tableName);
            $connection->queryExecute("DELETE FROM {$quotedTableName} WHERE {$where}");
        }
    }
}