function maxRound()
{
$maxRound = 1;
$currentSaison = currentSaison();
$result = runQuery('SELECT round FROM result WHERE saison = "' . $currentSaison . '" ORDER BY round DESC LIMIT 1');
foreach ($result as $row) {
$maxRound = $row['round'];
}
return $maxRound;
}
function getRankingL1($type)
{
$roundLimit = 0;
if ($type == 'realTime') {
$roundLimit = currentRound();
} else {
if ($type == 'delayed') {
$roundLimit = currentRound() - 1;
}
}
$rankingL1 = array();
$currentSaison = currentSaison();
$result = runQuery('
SELECT * FROM result WHERE scoreDomicile >= 0 && round <= ' . $roundLimit . ' && saison = "' . $currentSaison . '"
');
foreach ($result as $row) {
$round = intval($row['round']);
$teamDomicile = $row['teamDomicile'];
$teamExterieur = $row['teamExterieur'];
$scoreDomicile = intval($row['scoreDomicile']);
$scoreExterieur = intval($row['scoreExterieur']);
if (!isset($rankingL1[$teamDomicile])) {
$rankingL1[$teamDomicile] = ['name' => $row['teamDomicile'], 'round' => 0, 'win' => 0, 'equality' => 0, 'loose' => 0, 'bp' => 0, 'bc' => 0, 'difference' => 0, 'points' => 0];
}
if (!isset($rankingL1[$teamExterieur])) {
$rankingL1[$teamExterieur] = ['name' => $row['teamExterieur'], 'round' => 0, 'win' => 0, 'equality' => 0, 'loose' => 0, 'bp' => 0, 'bc' => 0, 'difference' => 0, 'points' => 0];
}
$rankingL1[$teamDomicile]['round']++;
$rankingL1[$teamExterieur]['round']++;
if ($scoreDomicile > $scoreExterieur) {
$rankingL1[$teamDomicile]['win']++;
$rankingL1[$teamDomicile]['points'] = $rankingL1[$teamDomicile]['points'] + 3;
$rankingL1[$teamExterieur]['loose']++;
} else {
if ($scoreDomicile < $scoreExterieur) {
$rankingL1[$teamExterieur]['win']++;
$rankingL1[$teamExterieur]['points'] = $rankingL1[$teamExterieur]['points'] + 3;
$rankingL1[$teamDomicile]['loose']++;
} else {
$rankingL1[$teamDomicile]['equality']++;
$rankingL1[$teamDomicile]['points']++;
$rankingL1[$teamExterieur]['equality']++;
$rankingL1[$teamExterieur]['points']++;
}
}
$rankingL1[$teamDomicile]['bp'] = $rankingL1[$teamDomicile]['bp'] + $scoreDomicile;
$rankingL1[$teamDomicile]['bc'] = $rankingL1[$teamDomicile]['bc'] + $scoreExterieur;
$rankingL1[$teamExterieur]['bp'] = $rankingL1[$teamExterieur]['bp'] + $scoreExterieur;
$rankingL1[$teamExterieur]['bc'] = $rankingL1[$teamExterieur]['bc'] + $scoreDomicile;
}
$ranking = array();
foreach ($rankingL1 as $team => $row) {
$rankingL1[$team]['difference'] = $row['bp'] - $row['bc'];
$ranking[] = $rankingL1[$team];
}
usort($ranking, 'compareTeam');
$index = 0;
foreach ($ranking as $index => $row) {
$ranking[$index]['rank'] = $index + 1;
}
return $rankingL1 = array('rankingL1' => $ranking);
}
<?php
require_once '../api/requireConnected.php';
header('Content-Type: application/json');
require_once '../php/sql.php';
require_once '../lib/general.php';
require_once '../api/lag.php';
$round = $_GET['round'];
$saison = currentSaison();
if (isset($_GET['saison'])) {
$saison = $_GET['saison'];
}
$userId = 0;
$userBets = array();
$matchs = array();
$userId = intval($_GET['user']);
$matchsRoundQuery = 'SELECT * FROM result WHERE round = ' . $round . ' AND saison = "' . $saison . '" ORDER BY date';
$result = runQuery($matchsRoundQuery);
foreach ($result as $row) {
$match = ['matchId' => $row['id'], 'teamDomicile' => $row['teamDomicile'], 'teamExterieur' => $row['teamExterieur'], 'scoreDomicile' => $row['scoreDomicile'], 'scoreExterieur' => $row['scoreExterieur'], 'date' => $row['date']];
$matchs[] = $match;
}
$result = runQuery('SELECT * FROM bet WHERE userId = ' . $userId);
foreach ($result as $row) {
$userBets[$row['matchId']] = ['scoreDomicile' => $row['scoreDomicile'], 'scoreExterieur' => $row['scoreExterieur'], 'coteResult' => $row['coteResult'], 'coteScore' => $row['coteScore']];
}
echo json_encode(array('userBets' => $userBets, 'matchs' => $matchs));
