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 | } |