1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / betstrength.com / view / handball /
Filename : insights.php
back
<?php
include "../../admin/inc/config.php";
include "../../inc/auth.php";

$pageURL = $mainRoot."handball/insights/clubs";

$hd = $ac = $hcl = $acl = 0;
if(isset($_POST['loadClubs'])){
    $country = (isset($_POST['country'])) ? trim(intval($_POST['country'])) : 0;
    $optLeague = (isset($_POST['optLeague'])) ? trim(intval($_POST['optLeague'])) : 0;
    if($optLeague > 0){ $league = "AND league=$optLeague"; }else{ $league = "AND league<>$optLeague"; }
    $hc = trim(intval($_POST['homeCountry']));
    $ac = trim(intval($_POST['awayCountry']));
    $hcl = trim(intval($_POST['homeClub']));
    $acl = trim(intval($_POST['awayClub']));

    $hcName = getDBVal('countries',$hc);
    $acName = getDBVal('countries',$ac);
    $hclName = getDBVal('handball_clubs',$hcl);
    $aclName = getDBVal('handball_clubs',$acl);

    $hclQ = dbSelect("handball_archive", "AVG(position) AS pos, SUM(hmp) AS htmp, SUM(hw) AS hwins, SUM(hd) AS hdraws, SUM(hl) AS hloss, SUM(hpf) AS hpf, SUM(hpa) AS hpa, SUM(amp) AS atmp, SUM(aw) AS awins, SUM(ad) AS adraws, SUM(al) AS aloss, SUM(apf) AS apf, SUM(apa) AS apa", "club=$hcl $league");

    $aclQ = dbSelect("handball_archive", "AVG(position) AS pos, SUM(hmp) AS htmp, SUM(hw) AS hwins, SUM(hd) AS hdraws, SUM(hl) AS hloss, SUM(hpf) AS hpf, SUM(hpa) AS hpa, SUM(amp) AS atmp, SUM(aw) AS awins, SUM(ad) AS adraws, SUM(al) AS aloss, SUM(apf) AS apf, SUM(apa) AS apa", "club=$acl $league");


    $hclData = mysqli_fetch_assoc($hclQ);

    $aclData = mysqli_fetch_assoc($aclQ);

    # Home Club Stats
    $hclAvgPos = round($hclData['pos']);
    $hclTotalHMatches = $hclData['htmp'];
    $hclTotalHWins = $hclData['hwins'];
    $hclTotalHDraws = $hclData['hdraws'];
    $hclTotalHLoss = $hclData['hloss'];
    $hclTotalHGF = $hclData['hpf'];
    $hclTotalHGA = $hclData['hpa'];
    $hclTotalAMatches = $hclData['atmp'];
    $hclTotalAWins = $hclData['awins'];
    $hclTotalADraws = $hclData['adraws'];
    $hclTotalALoss = $hclData['aloss'];
    $hclTotalAGF = $hclData['apf'];
    $hclTotalAGA = $hclData['apa'];
    $hclTotalWin = $hclTotalHWins + $hclTotalAWins;
    $hclTotalDraw = $hclTotalHDraws + $hclTotalADraws;
    $hclTotalLoss = $hclTotalHLoss + $hclTotalALoss;
    $hclTotalMatches = $hclTotalHMatches + $hclTotalAMatches;
    $hclTotalGF = $hclTotalHGF + $hclTotalAGF;
    $hclTotalGA = $hclTotalHGA + $hclTotalAGA;
    $hclTotalGoals = $hclTotalGF + $hclTotalGA;
    $hclTotalHGoals = $hclTotalHGF + $hclTotalHGA;
    $hHGD = $hclTotalHGF - $hclTotalHGA;
    $hAGD = $hclTotalAGF - $hclTotalAGA;
    $hGD = $hclTotalGF - $hclTotalGA;
    $hclMaxPts = $hclTotalMatches * 3;
    $hclMaxHPts = $hclTotalHMatches * 3;
    $hclMaxAPts = $hclTotalAMatches * 3;
    $hclPts = ($hclTotalWin * 2) + $hclTotalDraw;
    $hclHPts = ($hclTotalHWins * 2) + $hclTotalHDraws;
    $hclAPts = ($hclTotalAWins * 2) + $hclTotalADraws;
    $hclTotalPts = percentageVal(($hclPts), $hclMaxPts);
    $hclTotalHPts = percentageVal(($hclHPts), $hclMaxHPts);
    $hclTotalAPts = percentageVal(($hclAPts), $hclMaxAPts);


    # Away Club Stats
    $aclAvgPos = round($aclData['pos']);
    $aclTotalHMatches = $aclData['htmp'];
    $aclTotalHWins = $aclData['hwins'];
    $aclTotalHDraws = $aclData['hdraws'];
    $aclTotalHLoss = $aclData['hloss'];
    $aclTotalHGF = $aclData['hpf'];
    $aclTotalHGA = $aclData['hpa'];
    $aclTotalAMatches = $aclData['atmp'];
    $aclTotalAWins = $aclData['awins'];
    $aclTotalADraws = $aclData['adraws'];
    $aclTotalALoss = $aclData['aloss'];
    $aclTotalAGF = $aclData['apf'];
    $aclTotalAGA = $aclData['apa'];
    $aclTotalWin = $aclTotalHWins + $aclTotalAWins;
    $aclTotalDraw = $aclTotalHDraws + $aclTotalADraws;
    $aclTotalLoss = $aclTotalHLoss + $aclTotalALoss;
    $aclTotalMatches = $aclTotalHMatches + $aclTotalAMatches;
    $aclTotalGF = $aclTotalHGF + $aclTotalAGF;
    $aclTotalGA = $aclTotalHGA + $aclTotalAGA;
    $aclTotalGoals = $aclTotalGF + $aclTotalGA;
    $aclTotalHGoals = $aclTotalHGF + $aclTotalHGA;
    $aHGD = $aclTotalHGF - $aclTotalHGA;
    $aAGD = $aclTotalAGF - $aclTotalAGA;
    $aGD = $aclTotalGF - $aclTotalGA;
    $aclMaxPts = $aclTotalMatches * 3;
    $aclMaxHPts = $aclTotalHMatches * 3;
    $aclMaxAPts = $aclTotalAMatches * 3;
    $aclPts = ($aclTotalWin * 2) + $aclTotalDraw;
    $aclHPts = ($aclTotalHWins * 2) + $aclTotalHDraws;
    $aclAPts = ($aclTotalAWins * 2) + $aclTotalADraws;
    $aclTotalPts = percentageVal(($aclPts), $aclMaxPts);
    $aclTotalHPts = percentageVal(($aclHPts), $aclMaxHPts);
    $aclTotalAPts = percentageVal(($aclAPts), $aclMaxAPts);

    # Offense Defense
    $hclTotalOffenseNew = percentageVal($hclTotalGF, $hclTotalGoals);
    $hclTotalDefenseNew = 100 - percentageVal($hclTotalGA, $hclTotalGoals);
    $aclTotalOffenseNew = percentageVal($aclTotalGF, $aclTotalGoals);
    $aclTotalDefenseNew = 100 - percentageVal($aclTotalGA, $aclTotalGoals);

    # appearance
    $getC1Pos = dbSelect('handball_archive',"position,season,league", "club=$hcl $league");
    $getC2Pos = dbSelect('handball_archive',"position,season,league", "club=$acl $league");
    $club1LgPos = $club2LgPos = $club1Rank = $club2Rank = [];
    while($c1Row = mysqli_fetch_assoc($getC1Pos)){
        $lgLvl = getDBVal('handball_leagues',$c1Row['league'],'level');
        $lgName = getDBVal('handball_leagues',$c1Row['league']);
        $seasonEY = getDBVal('seasons',$c1Row['season'],'ey');
        $c1ActPos = $lgLvl * $c1Row['position'];
        $club1Rank[] = $c1ActPos;
        $club1LgPos[] = ['league'=>$lgName,'position'=>$c1Row['position'],'season'=>$seasonEY];
    }
    while($c2Row = mysqli_fetch_assoc($getC2Pos)){
        $lgLvl = getDBVal('handball_leagues',$c2Row['league'],'level');
        $lgName = getDBVal('handball_leagues',$c2Row['league']);
        $seasonEY = getDBVal('seasons',$c2Row['season'],'ey');
        $c2ActPos = $lgLvl * $c2Row['position'];
        $club2Rank[] = $c2ActPos;
        $club2LgPos[] = ['league'=>$lgName,'position'=>$c2Row['position'],'season'=>$seasonEY];
    }
    array_multisort(array_column($club1LgPos, 'season'), SORT_ASC, $club1LgPos);
    array_multisort(array_column($club2LgPos, 'season'), SORT_ASC, $club2LgPos);

    # insights
    $hclTotalGD = $hclTotalGF - $hclTotalGA;
    $aclTotalGD = $aclTotalGF - $aclTotalGA;

    $hclWinChance = percentageVal($hclTotalHWins, $hclTotalHMatches);
    $hclDrawChance = percentageVal($hclTotalHDraws, $hclTotalHMatches);
    $hclGR = ($hclTotalHGF > 0 && $hclTotalHMatches > 0 ) ? $hclTotalHGF / $hclTotalHMatches : 0;
    $hclOver40Chance = $hclGR > 40 ? 100 : percentageVal($hclGR, 40);
    $hclOver45Chance = $hclGR > 45 ? 100 : percentageVal($hclGR, 45);
    $hclOver50Chance = $hclGR > 50 ? 100 : percentageVal($hclGR, 50);
    $hclOver55Chance = $hclGR > 55 ? 100 : percentageVal($hclGR, 55);

    $aclWinChance = percentageVal($aclTotalAWins, $aclTotalAMatches);
    $aclDrawChance = percentageVal($aclTotalADraws, $aclTotalAMatches);
    $aclGR = ($aclTotalAGF > 0 && $aclTotalAMatches > 0 ) ? $aclTotalAGF / $aclTotalAMatches : 0;
    $aclOver40Chance = $aclGR > 40 ? 100 : percentageVal($aclGR, 40);
    $aclOver45Chance = $aclGR > 45 ? 100 : percentageVal($aclGR, 45);
    $aclOver50Chance = $aclGR > 50 ? 100 : percentageVal($aclGR, 50);
    $aclOver55Chance = $aclGR > 55 ? 100 : percentageVal($aclGR, 55);
}

define("TITLE", "$hclName vs $aclName | Bet Insights: Handball Clubs");
const HEADER = "Handball Bet Insights";


include "../../inc/head.php";

?>

    <div class="content-wrapper">
        <?php include "../../inc/header.php"; ?>
        <!-- /header -->

        <?php include "../../inc/page-header.php"; ?>
        <!-- /section -->
        <section class="wrapper bg-light">
            <div class="container pb-14 pb-md-16">
                <div class="row">
                    <div class="col mt-n19">
                        <div class="card shadow-lg">
                            <div class="card-body px-2 px-md-10">
                                <p class="lead mb-6 text-center">Make the forecasting count: Know the actual strength before staking</p>
                                <div class="row g-3">
                                    <div class="col-md-12">
                                        <div class="card shadow mb-10">
                                            <div class="card-header bg-gradient-red">
                                                <h4 class="card-title">Strength Overview</h4>
                                            </div>
                                            <div class="card-body p-1">
                                                <div class="row">
                                                    <div class="col-12">
                                                        <table class="table table-striped table-hover insight-table">
                                                            <thead>
                                                            <tr>
                                                                <th class="text-end" style="width: 48%;"><?= $hclName ?></th>
                                                                <th style="width: 4%;" class="text-center"><span class="badge badge-lg gradient-8 rounded-pill">vs</span></th>
                                                                <th class="text-start" style="width: 48%;"><?= $aclName ?></th>
                                                            </tr>
                                                            </thead>
                                                            <tbody class="fs-25">
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div><span class="badge badge-lg gradient-6 rounded-pill"><?= $hclTotalMatches ?></span></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">TM</span></td>
                                                                <td class="text-start">
                                                                    <div><span class="badge badge-lg gradient-7 rounded-pill"><?= $aclTotalMatches ?></span></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div><span class="badge badge-lg bg-<?= ($hGD > 0) ? "success" : "danger" ?> rounded-pill"><?= ($hGD > 0) ? "$hGD" : abs($hGD) ?></span></span></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">PD</span></td>
                                                                <td class="text-start">
                                                                    <div><span class="badge badge-lg bg-<?= ($aGD > 0) ? "success" : "danger" ?> rounded-pill"><?= ($aGD > 0) ? "$aGD" : abs($aGD) ?></span></span></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div><span class="badge badge-lg gradient-6 rounded-pill"><?= round(getClubRank($club1Rank)) ?></span></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">R</span></td>
                                                                <td class="text-start">
                                                                    <div><span class="badge badge-lg gradient-7 rounded-pill"><?= round(getClubRank($club2Rank)) ?></span></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div class="fs-mobile"><?= getProbability($hclTotalPts,'square') ?></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">O</span></td>
                                                                <td class="text-start">
                                                                    <div class="fs-mobile"><?= getProbability($aclTotalPts,'square') ?></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div class="fs-mobile"><?= getProbability($hclTotalHPts,'square') ?></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">H</span></td>
                                                                <td class="text-start">
                                                                    <div class="fs-mobile"><?= getProbability($aclTotalHPts,'square') ?></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div class="fs-mobile"><?= getProbability($hclTotalAPts,'square') ?></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">A</span></td>
                                                                <td class="text-start">
                                                                    <div class="fs-mobile"><?= getProbability($aclTotalAPts,'square') ?></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div class="fs-mobile"><?= getProbability($hclTotalOffenseNew,'square') ?></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">AS</span></td>
                                                                <td class="text-start">
                                                                    <div class="fs-mobile"><?= getProbability($aclTotalOffenseNew,'square') ?></div>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td class="text-end">
                                                                    <div class="fs-mobile"><?= getProbability($hclTotalDefenseNew,'square') ?></div>
                                                                </td>
                                                                <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">DS</span></td>
                                                                <td class="text-start">
                                                                    <div class="fs-mobile"><?= getProbability($aclTotalDefenseNew,'square') ?></div>
                                                                </td>
                                                            </tr>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                    <div class="col-12">
                                                        <div class="mt-5">
                                                            <div id="overallChart" style="min-height: 400px;" class="echart"></div>

                                                            <script>
                                                                document.addEventListener("DOMContentLoaded", () => {
                                                                    echarts.init(document.querySelector("#overallChart")).setOption({
                                                                        tooltip: {
                                                                            trigger: 'axis',
                                                                            axisPointer: {
                                                                                type: 'shadow'
                                                                            }
                                                                        },
                                                                        legend: {
                                                                            data: ['<?= $hclName ?>', '<?= $aclName ?>']
                                                                        },
                                                                        radar: {
                                                                            // shape: 'circle',
                                                                            indicator: [
                                                                                {
                                                                                    name: 'Overall',
                                                                                    max: 100
                                                                                },
                                                                                {
                                                                                    name: 'Hm',
                                                                                    max: 100
                                                                                },
                                                                                {
                                                                                    name: 'Atk',
                                                                                    max: 100
                                                                                },
                                                                                {
                                                                                    name: 'Def',
                                                                                    max: 100
                                                                                },
                                                                                {
                                                                                    name: 'Aw',
                                                                                    max: 100
                                                                                }

                                                                            ]
                                                                        },
                                                                        series: [{
                                                                            name: 'Club Strength',
                                                                            type: 'radar',
                                                                            data: [{
                                                                                value: [<?= $hclTotalPts ?>, <?= $hclTotalHPts ?>, <?= $hclTotalOffenseNew ?>, <?= $hclTotalDefenseNew ?>, <?= $hclTotalAPts ?>],
                                                                                name: '<?= $hclName ?>'
                                                                            },
                                                                                {
                                                                                    value: [<?= $aclTotalPts ?>, <?= $aclTotalHPts ?>, <?= $aclTotalOffenseNew ?>, <?= $aclTotalDefenseNew ?>, <?= $aclTotalAPts ?>],
                                                                                    name: '<?= $aclName ?>'
                                                                                }
                                                                            ]
                                                                        }]
                                                                    });
                                                                });
                                                            </script>
                                                            <!-- End Radar Chart -->
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

                                <div class="card shadow mb-10">
                                    <div class="card-header bg-gradient-red">
                                        <h4 class="card-title">Bet Insights</h4>
                                    </div>
                                    <div class="card-body px-1">
                                        <div class="row gy-3">
                                            <div class="col-md-12">
                                                <div class="table-responsive">
                                                    <table class="table table-striped table-hover insight-table">
                                                        <thead>
                                                        <tr>
                                                            <th style="width: 4%;"></th>
                                                            <th class="text-end" style="width: 48%;"><span class="badge badge-xs gradient-6 rounded-pill">home</span><br> <?= $hclName ?></th>
                                                            <th class="text-start" style="width: 48%;"><span class="badge badge-xs gradient-7 rounded-pill">away</span><br> <?= $aclName ?></th>
                                                        </tr>
                                                        </thead>
                                                        <tbody class="fs-25">
                                                        <tr>
                                                            <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">1/2</span></td>
                                                            <td class="text-end">
                                                                <div class="fs-mobile"><?= getProbability($hclWinChance,'square') ?></div>
                                                            </td>
                                                            <td class="text-start">
                                                                <div class="fs-mobile"><?= getProbability($aclWinChance,'square') ?></div>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">O40</span></td>
                                                            <td class="text-end">
                                                                <div class="fs-mobile"><?= getProbability($hclOver40Chance,'square') ?></div>
                                                            </td>
                                                            <td class="text-start">
                                                                <div class="fs-mobile"><?= getProbability($aclOver40Chance,'square') ?></div>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td class="text-center"><span class="badge badge-xs gradient-5 rounded-pill">O45</span></td>
                                                            <td class="text-end">
                                                                <div class="fs-mobile"><?= getProbability($hclOver45Chance,'square') ?></div>
                                                            </td>
                                                            <td class="text-start">
                                                                <div class="fs-mobile"><?= getProbability($aclOver45Chance,'square') ?></div>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td class="text-center"><span class="badge badge-xs gradient-8 rounded-pill">O50</span></td>
                                                            <td class="text-end">
                                                                <div class="fs-mobile"><?= getProbability($hclOver50Chance,'square') ?></div>
                                                            </td>
                                                            <td class="text-start">
                                                                <div class="fs-mobile"><?= getProbability($aclOver50Chance,'square') ?></div>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td class="text-center"><span class="badge badge-xs gradient-8 rounded-pill">O55</span></td>
                                                            <td class="text-end">
                                                                <div class="fs-mobile"><?= getProbability($hclOver55Chance,'square') ?></div>
                                                            </td>
                                                            <td class="text-start">
                                                                <div class="fs-mobile"><?= getProbability($aclOver55Chance,'square') ?></div>
                                                            </td>
                                                        </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>



                                <div class="row gx-0 text-center justify-content-center">
                                    <div class="col-lg-12">
                                        <form action="" method="post">
                                            <div class="card mb-3">
                                                <div class="card-body p-2">
                                                    <div class="row gy-3 gx-1">
                                                        <h5 class="card-title fs-13">Handball League (optional)</h5>
                                                        <div class="col-md-6">
                                                            <div class="form-floating">
                                                                <select class="form-select select-adv" id="optCountry" name="country" onChange="getLeagues(this.value,'handball_leagues');">
                                                                    <option value="">--select--</option>
                                                                    <?php
                                                                    $q = dbSelect("countries", "*", "status='active'", "name");
                                                                    while($row = mysqli_fetch_assoc($q)){
                                                                        if(!in_array($row['id'], $handballCountries)){
                                                                            continue;
                                                                        }
                                                                        ?>
                                                                        <option <?php if($country > 0 && $country == $row['id']){ echo 'selected'; }  ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                    <?php } ?>
                                                                </select>
                                                                <label for="optCountry" class="form-label">Country</label>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <div class="form-floating">
                                                                <select class="form-select select-adv" id="leagueBox" name="optLeague">
                                                                    <?php if($optLeague > 0):
                                                                        $q = dbSelect("handball_leagues","*", "country=$country");
                                                                        while($row = mysqli_fetch_assoc($q)){
                                                                            ?>
                                                                            <option <?php if($optLeague == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                        <?php } endif ?>
                                                                </select>
                                                                <label for="leagueBox" class="form-label">League</label>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="row gy-5 gx-1 gx-md-5">
                                                <div class="col-6">
                                                    <h5 class="card-title fs-13">Home Team</h5>
                                                    <div class="col-md-12">
                                                        <div class="form-floating">
                                                            <select class="form-select select-adv" id="homeCountry" name="homeCountry" onChange="getHomeClubs(this.value,'handball_clubs');">
                                                                <option value="">--select--</option>
                                                                <?php
                                                                $q = dbSelect("countries", "*", "status='active'", "name");
                                                                while($row = mysqli_fetch_assoc($q)){
                                                                    if(!in_array($row['id'], $handballCountries)){
                                                                        continue;
                                                                    }
                                                                    ?>
                                                                    <option <?php if($hc > 0 && $hc == $row['id']){ echo 'selected'; }  ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                <?php } ?>
                                                            </select>
                                                            <label for="homeCountry" class="form-label">Country</label>
                                                        </div>
                                                        <span class="text-danger"><?php if(isset($homeCountryErr)){ echo $homeCountryErr; } ?></span>
                                                    </div>
                                                    <div class="col-md-12">
                                                        <div class="form-floating">
                                                            <select class="form-select select-adv" id="homeClub" name="homeClub">
                                                                <?php if($hcl > 0):
                                                                    $q = dbSelect("handball_clubs","*", "country=$hc");
                                                                    while($row = mysqli_fetch_assoc($q)){
                                                                        ?>
                                                                        <option <?php if($hcl == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                    <?php } endif ?>
                                                            </select>
                                                            <label for="homeClub" class="form-label">Club</label>
                                                        </div>
                                                        <span class="text-danger"><?php if(isset($homeClubErr)){ echo $homeClubErr; } ?></span>
                                                    </div>
                                                </div>
                                                <div class="col-6">
                                                    <h5 class="card-title fs-13 text-end text-md-start">Away Team</h5>
                                                    <div class="col-md-12">
                                                        <div class="form-floating">
                                                            <select class="form-select select-adv" id="awayCountry" name="awayCountry" onChange="getAwayClubs(this.value,'handball_clubs');">
                                                                <option value="">--select--</option>
                                                                <?php
                                                                $q = dbSelect("countries", "*", "status='active'", "name");
                                                                while($row = mysqli_fetch_assoc($q)){
                                                                    if(!in_array($row['id'], $handballCountries)){
                                                                        continue;
                                                                    }
                                                                    ?>
                                                                    <option <?php if($ac > 0 && $ac == $row['id']){ echo 'selected'; }  ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                <?php } ?>
                                                            </select>
                                                            <label for="awayCountry" class="form-label">Country</label>
                                                        </div>
                                                        <span class="text-danger"><?php if(isset($awayCountryErr)){ echo $awayCountryErr; } ?></span>
                                                    </div>
                                                    <div class="col-md-12">
                                                        <div class="form-floating">
                                                            <select class="form-select select-adv" id="awayClub" name="awayClub">
                                                                <?php if($acl > 0):
                                                                    $q = dbSelect("handball_clubs","*", "country=$ac");
                                                                    while($row = mysqli_fetch_assoc($q)){
                                                                        ?>
                                                                        <option <?php if($acl == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                                    <?php } endif ?>
                                                            </select>
                                                            <label for="awayClub" class="form-label">Club</label>
                                                        </div>
                                                        <span class="text-danger"><?php if(isset($awayClubErr)){ echo $awayClubErr; } ?></span>
                                                    </div>
                                                </div>
                                                <div class="col-md-12">
                                                    <button type="submit" class="btn btn-outline-primary btn-icon btn-icon-start w-100 text-uppercase fs-20 searchBtn submitButton" name="loadClubs"><i class="uil uil-chart-growth-alt"></i>Show Abilities</button>
                                                </div>
                                            </div>
                                        </form>
                                    </div>
                                    <!--/column -->
                                </div>
                                <!--/.row -->
                            </div>
                        </div>
                        <!-- /.card -->
                        <div class="card shadow my-3">
                            <div class="card-header bg-gradient-red">
                                <h4 class="card-title">Legend</h4>
                            </div>
                            <div class="card-body px-1">
                                <div class="col-md-12">
                                    <ul class="list-group list-group-flush">
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">TM</span>
                                            Total Matches
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">PD</span>
                                            Points Difference
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">R</span>
                                            National Rank
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">O</span>
                                            Overall Strength
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">H</span>
                                            Home
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">A</span>
                                            Away
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">AS</span>
                                            Attack Strength
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge gradient-5 rounded-pill me-3">DS</span>
                                            Defence Strength
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">1/2</span>
                                            Straight Win
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">Off</span>
                                            Attack
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">Def</span>
                                            Defence
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">O40</span>
                                            Over 40
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">O45</span>
                                            Over 45
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">O50</span>
                                            Over 50
                                        </li>
                                        <li class="list-group-item d-flex align-items-center justify-content-between">
                                            <span class="badge bg-primary rounded-pill me-3">O55</span>
                                            Over 55
                                        </li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- /column -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container -->
        </section>
        <!-- /section -->
    </div>
    <!-- /.content-wrapper -->

<?php
include "../../inc/footer.php";
include "../../inc/foot.php";
?>