1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / sports.nisan.space / inc /
Filename : ajax.php
back
<?php
include('../admin/inc/config.php');

# get clubs
if(!empty($_POST["cId"]))
{
    $id=trim($_POST['cId']);
    $q = getRows('clubs',"*","country=$id", "name");
    echo '<option value="">Pick Football Club</option>';
    while($row=mysqli_fetch_array($q))
    {
        $club = $row['id'];
        echo '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
//        if(cntRows("archive","club=$club") > 0) {
//        }
    }
}

# get leagues
if(!empty($_POST["coId"]))
{
    $id=trim($_POST['coId']);
    $q = getRows('leagues',"*","country=$id", "name");
    echo '<option value="">Pick Football League</option>';
    while($row=mysqli_fetch_array($q))
    {
        echo '<option value="'.$row['id'].'">'.$row['name'].'</option>';
    }
}

#get archive
if(!empty($_POST['clId'])) {
    $id = intval($_POST['clId']);

    $q2 = dbSelect("archive", "AVG(position) AS pos, SUM(mp_home) AS tmp_home, SUM(w_home) AS home_wins, SUM(d_home) AS home_draws, SUM(l_home) AS home_loss, SUM(gf_home) AS gf_home, SUM(ga_home) AS ga_home, SUM(mp_away) AS tmp_away, SUM(w_away) AS away_wins, SUM(d_away) AS away_draws, SUM(l_away) AS away_loss, SUM(gf_away) AS gf_away, SUM(ga_away) AS ga_away", "club=$id", null, 5);
    if(mysqli_num_rows($q2) > 0) {
        $clubInfo = mysqli_fetch_assoc($q2);
        $hTM = $clubInfo['tmp_home'];
        $aTM = $clubInfo['tmp_away'];
        $hW = $clubInfo['home_wins'];
        $aW = $clubInfo['away_wins'];
        $hD = $clubInfo['home_draws'];
        $aD = $clubInfo['away_draws'];
        $hL = $clubInfo['home_loss'];
        $aL = $clubInfo['away_loss'];
        $hGF = $clubInfo['gf_home'];
        $aGF = $clubInfo['gf_away'];
        $hGA = $clubInfo['ga_home'];
        $aGA = $clubInfo['ga_away'];

        $clubPos = $clubRank = $clubLgPos = [];
        $getCPos = dbSelect('archive', "position,league", "club=$id");
        while ($cRow = mysqli_fetch_assoc($getCPos)) {
            $lgLvl = getDBVal('leagues', $cRow['league'], 'level');
            $cActPos = $lgLvl * $cRow['position'];
            $clubRank[] = $cActPos;
        }

        $getCLPos = dbSelect('archive', "position", "club=$id");
        while ($cLRow = mysqli_fetch_assoc($getCLPos)) {
            $clubLgPos[] = $cLRow['position'];
        }
        $totalMatches = $hTM + $aTM;
        $totalWins = $hW + $aW;
        $totalDraws = $hD + $aD;
        $totalLoss = $hL + $aL;
        $maxHomePoints = $hTM * 3;
        $maxAwayPoints = $aTM * 3;
        $maxPoints = $totalMatches * 3;
        $hGD = $hGF - $hGA;
        $aGD = $aGF - $aGA;
        $oGF = $hGF + $aGF;
        $oGA = $hGA + $aGA;
        $oGD = $oGF - $oGA;
        $homeWPts = $hW * 3;
        $homeDPts = $hD;
        $awayWPts = $aW * 3;
        $awayDPts = $aD;
        $hWinChance = percentageVal($hW, $hTM);
        $aWinChance = percentageVal($aW, $aTM);
        $oWinChance = percentageVal($hW + $aW, $totalMatches);
        $hXChance = percentageVal($hW + $hD, $hTM);
        $aXChance = percentageVal($aW + $aD, $aTM);
        $oXChance = percentageVal($totalWins + $totalDraws, $totalMatches);
        $hLChance = percentageVal($hL, $hTM);
        $aLChance = percentageVal($aL, $aTM);
        $oLChance = percentageVal($totalLoss, $totalMatches);
        $hPts = $homeWPts + $homeDPts;
        $aPts = $awayWPts + $awayDPts;
        $oPts = $hPts + $aPts;
        $cRank = round(getClubRank($clubRank));

        $oGDColor = ($oGD > 0) ? 'green' : 'red';
        $hGDColor = ($hGD > 0) ? 'green' : 'red';
        $aGDColor = ($aGD > 0) ? 'green' : 'red';
        echo "
        <tr class='fs-12'>
            <th class='fw-bolder'>Rank</th>
            <th class='bg-primary text-white fw-bolder'>OS</th>
            <th class='fw-bolder'>TM</th>
            <th class='fw-bolder'>OW</th>
            <th class='fw-bolder'>OX</th>
            <th class='fw-bolder'>OL</th>
            <th>GD</th>
            <th class='bg-primary text-white fw-bolder'>HS</th>
            <th class='bg-soft-green fw-bolder'>HM</th>
            <th class='bg-soft-green fw-bolder'>HW</th>
            <th class='bg-soft-green fw-bolder'>HX</th>
            <th class='bg-soft-green fw-bolder'>HL</th>
            <th>GD</th>
            <th class='bg-primary text-white fw-bolder'>AS</th>
            <th class='bg-soft-red fw-bolder'>AM</th>
            <th class='bg-soft-red fw-bolder'>AW</th>
            <th class='bg-soft-red fw-bolder'>AX</th>
            <th class='bg-soft-red fw-bolder'>HL</th>
            <th>GD</th>
        </tr>
        <tr class='fs-12'>
            <td class='fw-bolder'>$cRank</td>
            <td class='bg-primary text-white fw-bolder'>".getPercentage($oPts, $maxPoints)."</td>
            <td class='fw-bolder'>$totalMatches</td>
            <td class='fw-bolder'>$oWinChance%</td>
            <td class='fw-bolder'>$oXChance%</td>
            <td class='fw-bolder'>$oLChance%</td>
            <td class='text-$oGDColor fw-bolder'>$oGD</td>
            <td class='bg-primary text-white fw-bolder'>".getPercentage($hPts, $maxHomePoints)."</td>
            <td class='bg-soft-green fw-bolder'>$hTM</td>
            <td class='bg-soft-green fw-bolder'>$hWinChance%</td>
            <td class='bg-soft-green fw-bolder'>$hXChance%</td>
            <td class='bg-soft-green fw-bolder'>$hLChance%</td>
            <td class='text-$hGDColor fw-bolder'>$hGD</td>
            <td class='bg-primary text-white fw-bolder'>".getPercentage($aPts, $maxAwayPoints)."</td>
            <td class='bg-soft-red fw-bolder'>$aTM</td>
            <td class='bg-soft-red fw-bolder'>$aWinChance%</td>
            <td class='bg-soft-red fw-bolder'>$aXChance%</td>
            <td class='bg-soft-red fw-bolder'>$aLChance%</td>
            <td class='text-$aGDColor fw-bolder'>$aGD</td>
        </tr>
";
    }
}