����JFIF���������
1#@!#!123s
D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
nc6d095
/
betstrength.com
/
view
/
basketball
/
Filename :
insights.php
back
Copy
<?php include "../../admin/inc/config.php"; include "../../inc/auth.php"; $pageURL = $mainRoot."basketball/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('basket_clubs',$hcl); $aclName = getDBVal('basket_clubs',$acl); $hclQ = dbSelect("basket_archive", "AVG(position) AS pos, SUM(hmp) AS htmp, SUM(hw) AS hwins, SUM(hl) AS hloss, SUM(hpf) AS hpf, SUM(hpa) AS hpa, SUM(amp) AS atmp, SUM(aw) AS awins, SUM(al) AS aloss, SUM(apf) AS apf, SUM(apa) AS apa", "club=$hcl $league"); $aclQ = dbSelect("basket_archive", "AVG(position) AS pos, SUM(hmp) AS htmp, SUM(hw) AS hwins, SUM(hl) AS hloss, SUM(hpf) AS hpf, SUM(hpa) AS hpa, SUM(amp) AS atmp, SUM(aw) AS awins, 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']; $hclTotalHLoss = $hclData['hloss']; $hclTotalHGF = $hclData['hpf']; $hclTotalHGA = $hclData['hpa']; $hclTotalAMatches = $hclData['atmp']; $hclTotalAWins = $hclData['awins']; $hclTotalALoss = $hclData['aloss']; $hclTotalAGF = $hclData['apf']; $hclTotalAGA = $hclData['apa']; $hclTotalWin = $hclTotalHWins + $hclTotalAWins; $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 * 2; $hclMaxHPts = $hclTotalHMatches * 2; $hclMaxAPts = $hclTotalAMatches * 2; $hclPts = $hclTotalWin * 2; $hclHPts = $hclTotalHWins * 2; $hclAPts = $hclTotalAWins * 2; $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']; $aclTotalHLoss = $aclData['hloss']; $aclTotalHGF = $aclData['hpf']; $aclTotalHGA = $aclData['hpa']; $aclTotalAMatches = $aclData['atmp']; $aclTotalAWins = $aclData['awins']; $aclTotalALoss = $aclData['aloss']; $aclTotalAGF = $aclData['apf']; $aclTotalAGA = $aclData['apa']; $aclTotalWin = $aclTotalHWins + $aclTotalAWins; $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 * 2; $aclMaxHPts = $aclTotalHMatches * 2; $aclMaxAPts = $aclTotalAMatches * 2; $aclPts = $aclTotalWin * 2; $aclHPts = $aclTotalHWins * 2; $aclAPts = $aclTotalAWins * 2; $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('basket_archive',"position,season,league", "club=$hcl $league"); $getC2Pos = dbSelect('basket_archive',"position,season,league", "club=$acl $league"); $club1LgPos = $club2LgPos = $club1Rank = $club2Rank = []; while($c1Row = mysqli_fetch_assoc($getC1Pos)){ $lgLvl = getDBVal('basket_leagues',$c1Row['league'],'level'); $lgName = getDBVal('basket_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('basket_leagues',$c2Row['league'],'level'); $lgName = getDBVal('basket_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); $hclGR = ($hclTotalHGF > 0 && $hclTotalHMatches > 0 ) ? $hclTotalHGF / $hclTotalHMatches : 0; $hclOver50Chance = $hclGR > 50 ? 100 : percentageVal($hclGR, 50); $hclOver100Chance = $hclGR > 100 ? 100 : percentageVal($hclGR, 100); $hclOver150Chance = $hclGR > 150 ? 100 : percentageVal($hclGR, 150); $hclOver200Chance = $hclGR > 200 ? 100 : percentageVal($hclGR, 200); $aclWinChance = percentageVal($aclTotalAWins, $aclTotalAMatches); $aclGR = ($aclTotalAGF > 0 && $aclTotalAMatches > 0 ) ? $aclTotalAGF / $aclTotalAMatches : 0; $aclOver50Chance = $aclGR > 50 ? 100 : percentageVal($aclGR, 50); $aclOver100Chance = $aclGR > 100 ? 100 : percentageVal($aclGR, 100); $aclOver150Chance = $aclGR > 150 ? 100 : percentageVal($aclGR, 150); $aclOver200Chance = $aclGR > 200 ? 100 : percentageVal($aclGR, 200); } define("TITLE", "$hclName vs $aclName | Bet Insights: Basketball Clubs"); const HEADER = "Basketball 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">50</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-5 rounded-pill">100</span></td> <td class="text-end"> <div class="fs-mobile"><?= getProbability($hclOver100Chance,'square') ?></div> </td> <td class="text-start"> <div class="fs-mobile"><?= getProbability($aclOver100Chance,'square') ?></div> </td> </tr> <tr> <td class="text-center"><span class="badge badge-xs gradient-8 rounded-pill">150</span></td> <td class="text-end"> <div class="fs-mobile"><?= getProbability($hclOver150Chance,'square') ?></div> </td> <td class="text-start"> <div class="fs-mobile"><?= getProbability($aclOver150Chance,'square') ?></div> </td> </tr> <tr> <td class="text-center"><span class="badge badge-xs gradient-8 rounded-pill">200</span></td> <td class="text-end"> <div class="fs-mobile"><?= getProbability($hclOver200Chance,'square') ?></div> </td> <td class="text-start"> <div class="fs-mobile"><?= getProbability($aclOver200Chance,'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">Basketball 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,'basket_leagues');"> <option value="">--select--</option> <?php $q = dbSelect("countries", "*", "status='active'", "name"); while($row = mysqli_fetch_assoc($q)){ if(!in_array($row['id'], $basketCountries)){ 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("basket_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,'basket_clubs');"> <option value="">--select--</option> <?php $q = dbSelect("countries", "*", "status='active'", "name"); while($row = mysqli_fetch_assoc($q)){ if(!in_array($row['id'], $basketCountries)){ 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("basket_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,'basket_clubs');"> <option value="">--select--</option> <?php $q = dbSelect("countries", "*", "status='active'", "name"); while($row = mysqli_fetch_assoc($q)){ if(!in_array($row['id'], $basketCountries)){ 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("basket_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">50</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">100</span> Over 100 </li> <li class="list-group-item d-flex align-items-center justify-content-between"> <span class="badge bg-primary rounded-pill me-3">150</span> Over 150 </li> <li class="list-group-item d-flex align-items-center justify-content-between"> <span class="badge bg-primary rounded-pill me-3">200</span> Over 200 </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"; ?>