<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

class MiBD extends SQLite3
{
    function __construct()
    {
        $this->open('../bd/jailgames.db');
    }
}

$bd = new MiBD();

$game = "";
if (isset($_GET['game'])) $game = $_GET['game'];

$query = "SELECT user, points FROM scores WHERE game LIKE '".$game."' ORDER BY points DESC";
$resultado = $bd->query($query);

$res = "";
$fila = $resultado->fetchArray(SQLITE3_ASSOC);
while ($fila) {
    $res = $res.$fila['user'].",".$fila['points']."\n";
    $fila = $resultado->fetchArray(SQLITE3_ASSOC);
}
echo($res);
?>