Exemple #1
0
    public function updateLeague($week)
    {
        // called on updating results
        // get all scores for players
        // write results to Standings table
        $sql = 'SELECT 
						U.id,
						U.username,
						P.pred,
						P.joker,
						M.id,
						M.score,
						M.gotw
						FROM 
						users U
						JOIN predictions P ON U.id = P.user_id
						JOIN matches M ON P.match_id = M.id
						WHERE (U.games & 1) != 0
						AND (M.game & 1) != 0 
						AND M.week_id = ?';
        $db = $this->getDataSource();
        $data = $db->fetchAll($sql, [$week]);
        $table = [];
        $goals = [];
        foreach ($data as $w) {
            $uid = $w['U']['id'];
            $mid = $w['M']['id'];
            @($table[$uid]['goals'] += array_sum(explode('-', $w['P']['pred'])));
            if (!is_null($w['M']['score'])) {
                $score = calc($w['P']['pred'], $w['M']['score'], $w['P']['joker'], $w['M']['gotw']);
                @($table[$uid]['score'] += $score);
                if (empty($goals[$mid])) {
                    $goals[$mid] = array_sum(explode('-', $w['M']['score']));
                }
            } else {
                @($table[$uid]['score'] += 0);
            }
        }
        $goalsum = array_sum($goals);
        if (!empty($table)) {
            foreach ($table as $k => $n) {
                $goal_diff[$k] = abs($goalsum - $n['goals']);
            }
        }
        $closest = getmin($goal_diff);
        foreach ($table as $k => &$n) {
            if (in_array($k, $closest)) {
                $n['score'] += 3;
            }
        }
        ksort($table);
        uasort($table, function ($x, $y) {
            return $x['score'] > $y['score'] ? -1 : 1;
        });
        $this->Standing->deleteAll(['week_id' => $week]);
        $row = 0;
        // which row are we on
        $rank = 0;
        // what is the rank of the player
        $absrank = 0;
        // what is abs score
        $prevrank = 0;
        // rank of row n-1
        foreach ($table as $k => &$n) {
            $absrank = $n['score'];
            if ($absrank == $prevrank) {
                $row++;
            } else {
                $rank = ++$row;
            }
            $prevrank = $absrank;
            $tosave = ['Standing' => ['week_id' => $week, 'user_id' => $k, 'points' => $n['score'], 'position' => $rank]];
            $this->Standing->create();
            if ($this->Standing->save($tosave)) {
                // TODO something
            } else {
                $this->log('Couldn\'t update standings', 'admin');
            }
        }
    }
Exemple #2
0
 $long = $_POST['place_longitude'];
 $nom = $_POST['place_name'];
 if ($userlog == "diagnosol-master") {
     $userlog = "all";
 }
 // Create connection
 $conn = mysqli_connect($servername, $username, $password, $dbname);
 // Check connection
 if (!$conn) {
     die("Connection failed: " . mysqli_connect_error());
 }
 $sql = "SELECT * FROM station";
 $min = array("", 10000000000);
 $reponse = mysqli_query($conn, $sql);
 while ($donnees = mysqli_fetch_array($reponse)) {
     $min = getmin($min, $lat, $long, $donnees['Latitude'], $donnees['Longitude'], $donnees['Nom']);
 }
 $sql3 = "SELECT * FROM site_relation WHERE name = '{$nom}' AND owner = '{$userlog}'";
 $compteur = 0;
 $reponse3 = mysqli_query($conn, $sql3);
 while ($donnees = mysqli_fetch_array($reponse3)) {
     $compteur = $compteur + reccount($nom, $userlog, $compteur);
 }
 if ($compteur != 0) {
     $nom = $nom . " (" . $compteur . ")";
 }
 $sql2 = "INSERT INTO site_relation (`name`, `latitude`, `longitude`, `station`, `owner`) VALUES ('{$nom}','{$lat}','{$long}','{$min['0']}','{$userlog}')";
 //test pour voir si les data sont add comme il faut
 if (mysqli_query($conn, $sql2)) {
     //    echo "New record created successfully";
 } else {