function getAllGames()
{
$sql = "select * FROM games";
$regions = getAllRegions();
$teams = getTeamsArray();
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->execute();
$games = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach ($games as $game) {
//Récup infos teams
$game->region = $regions[$game->region]->name;
$game->blue = $teams[$game->blue]->name;
$game->red = $teams[$game->red]->name;
$game->winner = $game->winner == 1 ? $game->blue : $game->red;
//Récup compos
$game->blue_compo = getCompo($game->blue_compo);
$game->red_compo = getCompo($game->red_compo);
//Récup bans
$game->blue_bans = getBans($game->blue_bans);
$game->red_bans = getBans($game->red_bans);
}
return $games;
} catch (PDOException $e) {
return null;
}
}
function getAllTeams()
{
$sql = "select * FROM teams";
$regions = getAllRegions();
try {
$db = getConnection();
$stmt = $db->prepare($sql);
$stmt->execute();
$teams = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach ($teams as $team) {
$team->region = $regions[$team->region]->name;
}
return $teams;
} catch (PDOException $e) {
return null;
}
}
