MDR EVENT COUNTER

<?php

function checkEventCount(\PDO $pdo, int $player) : bool
{
    $sql = 'SELECT counter FROM event_counter WHERE player = :player';
    $stmt = $pdo->prepare($sql);
    $stmt->execute(['player' => $player]);
    $count = $stmt->fetchColumn();

    if ($count > 48) {
        return false;
    } return true;
}

function increaseEventCount(\PDO $pdo, int $player) : void
{
    $sql = 'SELECT COUNT(player) AS exists FROM event_counter WHERE player = :player';
    $stmt = $pdo->prepare($sql);
    $stmt->execute(['player' => $player]);
    $exists = $stmt->fetchColumn();

    if ($exists == 0) {
        $sql = 'INSERT INTO event_counter (player, counter) VALUES (:player, 1)';
        $stmt = $pdo->prepare($sql);
        $stmt->execute(['player' => $player]);
    } else {
        $sql = 'UPDARE event_counter SET counter = counter + 1 WHERE player = :player';
        $stmt = $pdo->prepare($sql);
        $stmt->execute(['player' => $player]);
    }
}