CounterCalculation::updateContactEmailRegister

static function updateContactEmailRegister()
{
	$query = null;
	$connection = \Bitrix\Main\Application::getConnection();
	switch(mb_strtoupper($connection->getType()))
	{
		case 'MSSQL':
			$query = "SELECT ID FROM b_sender_contact WHERE TYPE_ID=1 AND CODE LIKE '%[A-Z]%' COLLATE Latin1_General_BIN";
			break;
		case 'MYSQL':
			$query = "SELECT ID FROM b_sender_contact WHERE TYPE_ID=1 AND CODE REGEXP BINARY '[A-Z]'";
			break;
		case 'ORACLE':
			$query = "SELECT ID FROM b_sender_contact WHERE TYPE_ID=1 AND REGEXP_LIKE(CODE, '[A-Z]')";
			break;
	}

	if($query)
	{
		$senderContactDb = $connection->query($query);
		while($senderContact = $senderContactDb->fetch())
		{
			if(self::isTimeUp())
			{
				return true;
			}

			$connection->Query("UPDATE b_sender_contact SET CODE = LOWER(CODE) WHERE TYPE_ID=1 AND ID = " . intval($senderContact['ID']));
		}
	}

	return false;
}