View difference between Paste ID: 3WSAqDsL and q0HKiSZY
SHOW: | | - or go back to the newest paste.
1
<?php
2
3
function checkEventCount(\PDO $pdo, int $player) : bool
4
{
5
    $sql = 'SELECT counter FROM event_counter WHERE player = :player';
6
	$stmt = $pdo->prepare($sql);
7
	$stmt->execute(['player' => $player]);
8
	$count = $stmt->fetchColumn();
9
	
10-
	if ($count > 48) {
10+
	if ($count === false) {
11-
	    return false;
11+
	    return true;
12-
	} return true;
12+
13
14
	if ($count < 48) {
15
		return true;
16
	}
17
18
	return false;
19
}
20
21
function increaseEventCount(\PDO $pdo, int $player) : void
22
{
23
	$sql = 'SELECT COUNT(player) AS exists FROM event_counter WHERE player = :player';
24
	$stmt = $pdo->prepare($sql);
25
	$stmt->execute(['player' => $player]);
26
	$exists = $stmt->fetchColumn();
27
28
	if ($exists == 0) {
29
		$sql = 'INSERT INTO event_counter (player, counter) VALUES (:player, 1)';
30
		$stmt = $pdo->prepare($sql);
31
	    $stmt->execute(['player' => $player]);
32
	} else {
33
	    $sql = 'UPDARE event_counter SET counter = counter + 1 WHERE player = :player';
34
		$stmt = $pdo->prepare($sql);
35
	    $stmt->execute(['player' => $player]);
36
	}
37
}