keii.dev
1<?php
2
3session_start();
4
5require_once 'priv/errorhandler.php';
6require_once 'priv/pdo.php';
7require_once 'priv/twig.php';
8
9$sql = '
10SELECT *
11FROM qr_events
12WHERE display_date > CURRENT_DATE LIMIT 1
13';
14$event = DB::prepare($sql)->texecute()->fetch();
15$model['event'] = $event;
16
17if($event)
18{
19 $sql = '
20 SELECT
21 SUM(1) AS score,
22 qr_users.name,
23 qr_players.alive,
24 qr_users.class
25 FROM qr_players
26 JOIN qr_kills ON qr_kills.killer = qr_players.qr_users_id
27 JOIN qr_users ON qr_players.qr_users_id = qr_users.id
28 WHERE qr_players.qr_events_id = ?
29 GROUP BY qr_kills.killer
30 ORDER BY score DESC, alive DESC
31 LIMIT 10
32 ';
33 $users = DB::prepare($sql)->texecute([$event['id']])->fetchAll();
34 $model['users'] = $users;
35}
36
37if(isset($_GET['screen']))
38{
39 echo $twig->render('scoreboard.screen.html', $model);
40 die();
41}
42echo $twig->render('scoreboard.html', $model);