calcul.php

<?php
session_start();
if (!isset($_SESSION['login']) || $_SESSION['login'] != 'admin') {
    header('Location: index.php');
    exit();
}

include('connect.php');

$req = $bdd->query("SELECT id FROM users WHERE login='admin'");
$id_perso = $req->fetch()['id'];

$grp = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'];

/* Peuplement des 1/8 de finale */
for ($i = 0; $i < 8; $i++) {
    $e1 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp=:groupe;");
    $e2 = $bdd->prepare("SELECT id_e2 FROM paris_0 WHERE id_user=:usr AND grp=:groupe;");

    if ($i < 4) {
        $e1->execute(array('usr' => $id_perso, 'groupe' => $grp[2*$i]));
        $e2->execute(array('usr' => $id_perso, 'groupe' => $grp[2*$i+1]));
    } else {
        $e1->execute(array('usr' => $id_perso, 'groupe' => $grp[2*($i-4)+1]));
        $e2->execute(array('usr' => $id_perso, 'groupe' => $grp[2*($i-4)]));
    }

    $eq1 = $e1->fetch();
    $eq2 = $e2->fetch();

    if ($eq1 && $eq2) {
        $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe=:grp");
        $maj->execute(array('e1' => $eq1['id_e1'], 'e2' => $eq2['id_e2'], 'grp' => 'H' . (string)($i+1)));
    } else {
        $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe=:grp");
        $maj->execute(array('e1' => 0, 'e2' => 0, 'grp' => 'H' . (string)($i+1)));
    }
}

/* Peuplement des 1/4 de finale */
for ($i = 0; $i < 4; $i++) {
    $e1 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp=:groupe;");
    $e2 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp=:groupe;");

    $e1->execute(array('usr' => $id_perso, 'groupe' => 'H' . (string)(2*$i+1)));
    $e2->execute(array('usr' => $id_perso, 'groupe' => 'H' . (string)(2*$i+2)));

    $eq1 = $e1->fetch();
    $eq2 = $e2->fetch();

    if ($eq1 && $eq2) {
        $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe=:grp");
        $maj->execute(array('e1' => $eq1['id_e1'], 'e2' => $eq2['id_e1'], 'grp' => 'Q' . (string)($i+1)));
    } else {
        $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe=:grp");
        $maj->execute(array('e1' => 0, 'e2' => 0, 'grp' => 'Q' . (string)($i+1)));
    }
}

/* Peuplement des 1/2 finales */
for ($i = 0; $i < 2; $i++) {
    $e1 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp=:groupe;");
    $e2 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp=:groupe;");

    $e1->execute(array('usr' => $id_perso, 'groupe' => 'Q' . (string)(2*$i+1)));
    $e2->execute(array('usr' => $id_perso, 'groupe' => 'Q' . (string)(2*$i+2)));

    $eq1 = $e1->fetch();
    $eq2 = $e2->fetch();

    if ($eq1 && $eq2) {
        $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe=:grp");
        $maj->execute(array('e1' => $eq1['id_e1'], 'e2' => $eq2['id_e1'], 'grp' => 'D' . (string)($i+1)));
    } else {
        $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe=:grp");
        $maj->execute(array('e1' => 0, 'e2' => 0, 'grp' => 'D' . (string)($i+1)));
    }
}

/* Peuplement de la finale */
$e1 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp='D1';");
$e2 = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp='D2';");

$e1->execute(array('usr' => $id_perso));
$e2->execute(array('usr' => $id_perso));

$eq1 = $e1->fetch();
$eq2 = $e2->fetch();

if ($eq1 && $eq2) {
    $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe='F0'");
    $maj->execute(array('e1' => $eq1['id_e1'], 'e2' => $eq2['id_e1']));
} else {
    $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe='F0'");
    $maj->execute(array('e1' => 0, 'e2' => 0));
}

/* Peuplement de la petite finale */
$e1 = $bdd->prepare("SELECT id_e2 FROM paris_0 WHERE id_user=:usr AND grp='D1';");
$e2 = $bdd->prepare("SELECT id_e2 FROM paris_0 WHERE id_user=:usr AND grp='D2';");

$e1->execute(array('usr' => $id_perso));
$e2->execute(array('usr' => $id_perso));

$eq1 = $e1->fetch();
$eq2 = $e2->fetch();

if ($eq1 && $eq2) {
    $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe='F1'");
    $maj->execute(array('e1' => $eq1['id_e2'], 'e2' => $eq2['id_e2']));
} else {
    $maj = $bdd->prepare("UPDATE matchs SET team1=:e1, team2=:e2 WHERE groupe='F1'");
    $maj->execute(array('e1' => 0, 'e2' => 0));
}

/* Enregistrement du résultat des matchs */
$matchs = $bdd->prepare("SELECT id_match, score1, score2, winner FROM paris_match WHERE id_user=:usr");
$matchs->execute(array('usr' => $id_perso));

while ($match = $matchs->fetch()) {
    $maj = $bdd->prepare("UPDATE matchs SET score1=:s1, score2=:s2, winner=:win, played=1 WHERE id=:id_m");
    $maj->execute(array('s1' => $match['score1'], 's2' => $match['score2'], 'win' => $match['winner'], 'id_m' => $match['id_match']));
}

/* Points des utilisateurs */
$l_ht = [];
$ht = $bdd->query("SELECT id_e1, id_e2 FROM paris_0 JOIN users ON paris_0.id_user = users.id WHERE users.login='admin' AND LENGTH(grp)=1");

while ($eq = $ht->fetch()) {
    $l_ht[] = $eq['id_e1'];
    $l_ht[] = $eq['id_e2'];
}

$l_qr = [];
$qr = $bdd->query("SELECT id_e1 FROM paris_0 JOIN users ON paris_0.id_user = users.id WHERE users.login='admin' AND LENGTH(grp)=2 AND SUBSTR(grp,1,1)='H'");

while ($eq = $qr->fetch()) {
    $l_qr[] = $eq['id_e1'];
}

$l_dm = [];
$dm = $bdd->query("SELECT id_e1 FROM paris_0 JOIN users ON paris_0.id_user = users.id WHERE users.login='admin' AND LENGTH(grp)=2 AND SUBSTR(grp,1,1)='Q'");

while ($eq = $dm->fetch()) {
    $l_dm[] = $eq['id_e1'];
}

$l_fn = [];
$fn = $bdd->query("SELECT id_e1 FROM paris_0 JOIN users ON paris_0.id_user = users.id WHERE users.login='admin' AND LENGTH(grp)=2 AND SUBSTR(grp,1,1)='D'");

while ($eq = $fn->fetch()) {
    $l_fn[] = $eq['id_e1'];
}

$win123 = [];

$win12_q = $bdd->query("SELECT id_e1, id_e2 FROM paris_0 JOIN users ON paris_0.id_user = users.id WHERE users.login='admin' AND grp='F0'");
$win12 = $win12_q->fetch();
if ($win12) {
    $win123['1'] = $win12['id_e1'];
    $win123['2'] = $win12['id_e2'];
}

$win3_q = $bdd->query("SELECT id_e1 FROM paris_0 JOIN users ON paris_0.id_user = users.id WHERE users.login='admin' AND grp='F1'");
$win3 = $win3_q->fetch();
if ($win3) {
    $win123['3'] = $win3['id_e1'];
}

$l_divers = [];
$divers = $bdd->query("SELECT id_obj, val FROM paris_divers JOIN users ON paris_divers.id_user = users.id WHERE users.login='admin'");

while ($p = $divers->fetch()) {
    $l_divers[$p['id_obj']] = $p['val'];
}

$users = $bdd->query("SELECT id FROM users WHERE login != 'admin'");

while ($usr = $users->fetch()) {
    $pts = 0;

    /* Points des matchs */
    $p_matchs = $bdd->prepare("SELECT id_match, score1, score2, winner FROM paris_match WHERE id_user=:usr");
    $p_matchs->execute(array('usr' => $usr['id']));

    while ($p = $p_matchs->fetch()) {
        $r_m = $bdd->prepare("SELECT score1, score2, winner, played FROM matchs WHERE id=:id_m");
        $r_m->execute(array('id_m' => $p['id_match']));

        $m = $r_m->fetch();

        if ($m['played'] == 1) {
            if ($p['winner'] == $m['winner'] && $p['score1'] == $m['score1'] && $p['score2'] == $m['score2']) {
                $pts += 5;
            } elseif ($p['winner'] == $m['winner'] && $p['score1'] - $p['score2'] == $m['score1'] - $m['score2']) {
                $pts += 3;
            } elseif ($p['winner'] == $m['winner']) {
                $pts += 1;
            }
        }
    }

    /* Points sur toute la compétition */
    $ht_u = $bdd->prepare("SELECT id_e1, id_e2 FROM paris_0 WHERE id_user=:usr AND LENGTH(grp)=1");
    $ht_u->execute(array('usr' => $usr['id']));

    while ($eq = $ht_u->fetch()) {
        if ($eq['id_e1'] != 0 && in_array($eq['id_e1'], $l_ht)) {
            $pts += 2;
        }

        if ($eq['id_e2'] != 0 && in_array($eq['id_e2'], $l_ht)) {
            $pts += 2;
        }
    }

    $qr_u = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND LENGTH(grp)=2 AND SUBSTR(grp,1,1)='H'");
    $qr_u->execute(array('usr' => $usr['id']));

    while ($eq = $qr_u->fetch()) {
        if ($eq['id_e1'] && in_array($eq['id_e1'], $l_qr)) {
            $pts += 5;
        }
    }

    $dm_u = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND LENGTH(grp)=2 AND SUBSTR(grp,1,1)='Q'");
    $dm_u->execute(array('usr' => $usr['id']));

    while ($eq = $dm_u->fetch()) {
        if ($eq['id_e1'] && in_array($eq['id_e1'], $l_dm)) {
            $pts += 10;
        }
    }

    $fn_u = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND LENGTH(grp)=2 AND SUBSTR(grp,1,1)='D'");
    $fn_u->execute(array('usr' => $usr['id']));

    while ($eq = $fn_u->fetch()) {
        if ($eq['id_e1'] && in_array($eq['id_e1'], $l_fn)) {
            $pts += 15;
        }
    }

    $win123_u = [];

    $win_u = $bdd->prepare("SELECT id_e1, id_e2 FROM paris_0 WHERE id_user=:usr AND grp='F0'");
    $win_u->execute(array('usr' => $usr['id']));

    if ($eq = $win_u->fetch()) {
        $win123_u['1'] = $eq['id_e1'];
        $win123_u['2'] = $eq['id_e2'];
    }

    $win3_u = $bdd->prepare("SELECT id_e1 FROM paris_0 WHERE id_user=:usr AND grp='F1'");
    $win3_u->execute(array('usr' => $usr['id']));

    if ($eq = $win_u->fetch()) {
        $win123_u['3'] = $eq['id_e1'];
    }

    if (array_key_exists('1', $win123) && array_key_exists('1', $win123_u) && $win123_u['1'] == $win123['1']) {
        $pts += 20;
    }

    if (count($win123) == 3 && count($win123_u) == 3 && sort($win123) == sort($win123_u)) {
        $pts += 20;
    }

    if (count($win123) == 3 && count($win123_u) == 3 && $win123 == $win123_u) {
        $pts += 5;
    }

    /* Les paris divers */
    $p_divers = $bdd->prepare("SELECT id_obj, val FROM paris_divers WHERE id_user=:usr");
    $p_divers->execute(array('usr' => $usr['id']));

    while ($p = $p_divers->fetch()) {
        if (!array_key_exists($p['id_obj'], $l_divers)) {
            $delta = 2;
        } else {
            $delta = abs($l_divers[$p['id_obj']] - $p['val']) / $l_divers[$p['id_obj']];
        }

        if ($delta <= 1) {
            $pts += floor(10 * (1 - $delta));
        }
    }

    $maj = $bdd->prepare("UPDATE users SET points=:pts WHERE id=:usr");
    $maj->execute(array('pts' => $pts, 'usr' => $usr['id']));
}

header('Location: index.php');
exit();

?>