games.maxscore,
users.nick
FROM
games
INNER JOIN users ON games.owner = users.id
ORDER BY games.date_start
DESC LIMIT 0,10;';
$columns = array('id', 'title', 'state', 'form', 'type_game', 'date_start', 'date_stop', 'date_restart', 'description', 'logo', 'owner', 'nick', 'organizators', 'maxscore');
$stmt = $conn->prepare($query);
$stmt->execute();
$i = 0;
while ($row = $stmt->fetch()) {
$id = $row['uuid'];
$response['data'][$id] = array();
foreach ($columns as $k) {
$response['data'][$id][$k] = $row[$k];
}
$bAllows = APISecurity::isAdmin();
$bChoose = APISecurity::isAdmin() || APISecurity::isUser();
$response['data'][$id]['permissions']['delete'] = $bAllows;
$response['data'][$id]['permissions']['update'] = $bAllows;
$response['data'][$id]['permissions']['export'] = $bAllows;
$response['data'][$id]['permissions']['choose'] = $bChoose;
}
$response['current_game'] = isset($_SESSION['game']) ? $_SESSION['game']['id'] : 0;
$response['permissions']['insert'] = APISecurity::isAdmin();
$response['result'] = 'ok';
} catch (PDOException $e) {
APIHelpers::showerror(1193, $e->getMessage());
}
APIHelpers::endpage($response);