BlacklistTable::replace

static function replace($siteId, $mailboxId, array $list)
{
	global $DB;

	if ($mailboxId > 0)
	{
		$DB->query(sprintf("DELETE FROM b_mail_blacklist WHERE MAILBOX_ID = %u", $mailboxId));
	}
	else
	{
		$DB->query(sprintf("DELETE FROM b_mail_blacklist WHERE SITE_ID = '%s' AND MAILBOX_ID = 0", $DB->forSql($siteId)));
	}

	if (!empty($list))
	{
		foreach ($list as $item)
		{
			static::add([
				'SITE_ID' => $siteId,
				'MAILBOX_ID' => $mailboxId,
				'ITEM_TYPE' => BlacklistItemType::resolveByValue($item),
				'ITEM_VALUE' => $item,
			]);
		}
	}
}