1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / betstrength.com / admin / view /
Filename : archive.php
back
<?php
global $now, $adminRoot;
include('../inc/config.php');
include('../inc/auth.php');

$tinyEditor = "bare";
$country = 0;
$leagueIds = [];
const TITLE = 'Manage Football Archive';
const HEADER = 'Football Archive';
const BREADCRUMB = 'archive';

#logics
#show clubs
if(isset($_GET['ct']) && isset($_GET['cr'])){
    if(!$_GET['cr'] > 0){
        $emsg = "you must select a country to see the clubs";
    }
    else{
        $country = trim(intval($_GET['cr']));
        $continent = trim(intval($_GET['ct']));
        $q = dbSelect('leagues',"id","country=$country");
        while($row = mysqli_fetch_assoc($q)){
            $leagueIds[] = $row['id'];
        }
    }
}

$url = $adminRoot."archive";
if(isset($_GET['ct'])){ $url.= "?ct=".$_GET['ct']; }
if(isset($_GET['cr'])){ $url.= "&cr=".$_GET['cr']; }


#save club
if(isset($_POST['saveArchive'])){
    #data cleaning & scrutinization
    $seasonFrm = intval($_POST['season']);
    $leagueFrm = intval($_POST['league']);
    $clubFrm = intval($_POST['club']);
    $positionFrm = intval($_POST['position']);
    $clubHMFrm = intval($_POST['clubHM']);
    $clubHWFrm = intval($_POST['clubHW']);
    $clubHDFrm = intval($_POST['clubHD']);
    $clubHLFrm = intval($_POST['clubHL']);
    $clubHGFFrm = intval($_POST['clubHGF']);
    $clubHGAFrm = intval($_POST['clubHGA']);
    $clubAMFrm = intval($_POST['clubAM']);
    $clubAWFrm = intval($_POST['clubAW']);
    $clubADFrm = intval($_POST['clubAD']);
    $clubALFrm = intval($_POST['clubAL']);
    $clubAGFFrm = intval($_POST['clubAGF']);
    $clubAGAFrm = intval($_POST['clubAGA']);

    if($clubHMFrm != ($clubHWFrm + $clubHLFrm + $clubHDFrm)){
        $errs[] = $clubMErr = ""; $emsg = "home matches not consistent";
    }
    if($clubAMFrm != ($clubAWFrm + $clubALFrm + $clubADFrm)){
        $errs[] = $clubHMErr = ""; $emsg = "away matches not consistent";
    }
    if($clubFrm < 1){ $errs[] = $clubErr = "required"; $emsg = "please fill all inputs"; }
    elseif($positionFrm < 1){ $errs[] = $positionErr = ""; $emsg = "position must be greater than zero"; }
    else{
        $rowCnt = checkDuplicates('archive', "club=$clubFrm AND league=$leagueFrm AND season=$seasonFrm");
        if($rowCnt > 0){
            $errs[] = $archiveExistErr = "";
            $emsg = "Record already exists";
        }
    }
    if(count($errs) == 0){
        $q = dbInsert("archive", ['user'=>$currUserId, 'club' => $clubFrm, 'league'=>$leagueFrm, 'season' => $seasonFrm, 'position' => $positionFrm, 'mp_home' => $clubHMFrm, 'w_home' => $clubHWFrm,  'd_home' => $clubHDFrm, 'l_home' => $clubHLFrm, 'gf_home' => $clubHGFFrm, 'ga_home' => $clubHGAFrm, 'mp_away' => $clubAMFrm, 'w_away' => $clubAWFrm, 'd_away' => $clubADFrm, 'l_away' => $clubALFrm, 'gf_away' => $clubAGFFrm, 'ga_away' => $clubAGAFrm, 'dc' => $now]);
        if($q){
            $smsg = "record added successfully";
            $preventResubmission = true;
        }
        else{
           $emsg = "Action not successful. Try again later";
        }
    }
}


if(isset($_POST['updateArchive'])) {
    $id = intval(trim($_POST['updateArchive']));
    $user = getDBVal('archive', $id, 'user');
    if ($currUserId == $user) {
        if (isset($_POST['position'])) {
            updateArchive('archive',$_POST['position'], $id, 'position', 'Position');
            $preventResubmission = true;
        }
        if (isset($_POST['hmp'])) {
            updateArchive('archive',$_POST['hmp'], $id, 'mp_home', 'Home Total Matches');
            $preventResubmission = true;
        }
        if (isset($_POST['chw'])) {
            updateArchive('archive',$_POST['chw'], $id, 'w_home', 'Home Win');
            $preventResubmission = true;
        }
        if (isset($_POST['chd'])) {
            updateArchive('archive',$_POST['chw'], $id, 'd_home', 'Home Draw');
            $preventResubmission = true;
        }
        if (isset($_POST['chl'])) {
            updateArchive('archive',$_POST['chl'], $id, 'l_home', 'Home Loss');
            $preventResubmission = true;
        }
        if (isset($_POST['chgf'])) {
            updateArchive('archive',$_POST['chgf'], $id, 'gf_home', 'Home Goals Forward');
            $preventResubmission = true;
        }
        if (isset($_POST['chga'])) {
            updateArchive('archive',$_POST['chga'], $id, 'ga_home', 'Home Goals Against');
            $preventResubmission = true;
        }
        if (isset($_POST['amp'])) {
            updateArchive('archive',$_POST['amp'], $id, 'mp_away', 'Away Total Matches');
            $preventResubmission = true;
        }
        if (isset($_POST['caw'])) {
            updateArchive('archive',$_POST['caw'], $id, 'w_away', 'Away Win');
            $preventResubmission = true;
        }
        if (isset($_POST['caw'])) {
            updateArchive('archive',$_POST['cad'], $id, 'd_away', 'Away Draw');
            $preventResubmission = true;
        }
        if (isset($_POST['cal'])) {
            updateArchive('archive',$_POST['cal'], $id, 'l_away', 'Away Loss');
            $preventResubmission = true;
        }
        if (isset($_POST['cagf'])) {
            updateArchive('archive',$_POST['cagf'], $id, 'gf_away', 'Away Goals Forward');
            $preventResubmission = true;
        }
        if (isset($_POST['caga'])) {
            updateArchive('archive',$_POST['caga'], $id, 'ga_away', 'Away Goals Against');
            $preventResubmission = true;
        }
    }
    else{
        $emsg = "You can only update your record";
    }
}

if(isset($_POST['updateClub'])){
    $id = intval($_GET['id']);
    if($id > 0) {
        $cEdit = trim(intval($_POST['cEdit']));
        if ($cEdit == 0) {
            $errs[] = $cEditErr = "";
            $emsg = "club not selected/valid";
        } else {
            $club = getDBVal('archive', $id, 'club');
            $season = getDBVal('archive', $id, 'season');
            $cOldName = getDBVal('clubs', getDBVal('archive',$id,'club'));
            $cNewName = getDBVal('clubs', $cEdit);
            $rowCnt = checkDuplicates('archive', "club=$cEdit AND season=$season AND id<>$id");
            $rowCnt2 = checkDuplicates('archive', "club=$cEdit AND id=$id");
            if ($rowCnt > 0) {
                $errs[] = $archiveExistErr = "";
                $emsg = "record for club $cNewName exists for the selected season";
            }
            if ($rowCnt2 > 0) {
                $errs[] = $archiveExistErr = "";
                $emsg = "Modification is required to continue";
            }
        }
        if (count($errs) == 0) {
            $q = dbUpdate("archive", ['club' => $cEdit, 'du' => $now], "id=" . $id);
            if ($q) {
                $smsg = "'$cOldName' updated to '$cNewName' successfully";
                jsRefresh($url,5000);
            } else {
                $emsg = "Action not successful. Try again later";
            }
        }
    }else{
        $emsg = "invalid record encountered";
    }
}

if(isset($_POST['updateSeason'])){
    $id = intval($_GET['id']);
    if($id > 0) {
        $seasonEdit = trim(intval($_POST['seasonEdit']));
        if ($seasonEdit == 0) {
            $errs[] = $cEditErr = "";
            $emsg = "season not selected/valid";
        } else {
            $league = getDBVal('archive', $id, 'league');
            $club = getDBVal('archive', $id, 'club');
            $clubName = getDBVal('clubs', $club);
            $rowCnt = checkDuplicates('archive', "season=$seasonEdit AND club=$club AND league=$league AND id<>$id");
            $rowCnt2 = checkDuplicates('archive', "season=$seasonEdit AND id=$id");
            if ($rowCnt > 0) {
                $errs[] = $archiveExistErr = "";
                $emsg = "record for club $clubName exists for the selected season";
            }
            if ($rowCnt2 > 0) {
                $errs[] = $archiveExistErr = "";
                $emsg = "Modification is required to continue";
            }
        }
        if (count($errs) == 0) {
            $q = dbUpdate("archive", ['season' => $seasonEdit, 'du' => $now], "id=" . $id);
            if ($q) {
                $smsg = "season updated successfully";
                jsRefresh($url,5000);
            } else {
                $emsg = "Action not successful. Try again later";
            }
        }
    }else{
        $emsg = "invalid record encountered";
    }
}

if(isset($_GET['d']) && isset($_GET['id'])){
    $d = $_GET['d'];
    $id = $_GET['id'];
    $hClub = getDBVal('archive',$id, 'c1');
    $hClubNm = getDBVal('clubs',$hClub);
    $aClub = getDBVal('archive',$id, 'c2');
    $aClubNm = getDBVal('clubs',$aClub);
    if($d == 'dlt-entry'){
        $dltItem = true;
        $dltmsg = "Are you sure you want to delete the H2H between $hClubNm and $aClubNm?";

        if(isset($_POST['doDlt'])){
            $dltItem = false;
            $q = dltRow('archive',$id);
            if($q){ $smsg = "H2H entry between $hClubNm and $aClubNm deleted successfully"; jsRefresh($url,5000); }else{ $emsg = "something went wrong."; }
        }
    }
}

include("../inc/head.php");
?>

<body>

    <!--*******************
        Preloader start
    ********************-->
    <?php include("../inc/preloader.php"); ?>
    <!--*******************
        Preloader end
    ********************-->

    <!--**********************************
        Main wrapper start
    ***********************************-->
    <div id="main-wrapper" class="menu-toggle">

        <!--**********************************
            Nav header start
        ***********************************-->
        <?php include("../inc/nav-header.php"); ?>
        <!--**********************************
            Nav header end
        ***********************************-->


        <!--**********************************
            Header start
        ***********************************-->
        <?php include("../inc/header.php"); ?>
        <!--**********************************
            Header end ti-comment-alt
        ***********************************-->

        <!--**********************************
            Sidebar start
        ***********************************-->
        <?php include("../inc/sidebar.php"); ?>
        <!--**********************************
            Sidebar end
        ***********************************-->

        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <div class="container-fluid">
                <?php include("../inc/page-header.php"); ?>

                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-inline-block ml-3">
                                    <form action="" method="get">
                                        <div class="input-group">
                                            <div class="input-group-prepend">
                                                <span class="input-group-text bg-white-900 text-primary border border-right-0">Continent</span>
                                            </div>
                                            <select class="form-control default-select w-input-300" id="" name="ct" onChange="getCountry(this.value);">
                                                <option value="" selected>Select</option>
                                                <?php
                                                $q = getRows('continents',"*","status='active'");
                                                while($row = mysqli_fetch_array($q)){
                                                    ?>
                                                    <option <?php if(isset($continent) && $continent == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                <?php }?>
                                            </select>
                                            <div class="input-group-append">
                                                <span class="input-group-text bg-white-900 text-primary border border-right-0">Country</span>
                                            </div>
                                            <select class="form-control w-input-300" id="countryBox2" name="cr">
                                                <?php if($country > 0):
                                                    $q = dbSelect("countries","*", "continent=$continent", "name");
                                                    while($row = mysqli_fetch_assoc($q)){
                                                        ?>
                                                        <option <?php if($country == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                    <?php } endif ?>
                                                <?php if(isset($country)){ echo "<option>".getDBVal('countries',$country)."</option>"; } ?>
                                            </select>
                                            <div class="input-group-append">
                                                <button type="submit" class="btn btn-xs btn-primary mr-3 submitButton">Go</button>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                                <a href="<?= $adminRoot ?>archive<?= isset($_GET['c']) ? '&c='.$_GET['c'] : '' ?>" class="btn btn-xs btn-outline-primary float-right" title="Refresh Page"><i class="fa fa-refresh"></i></a>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row gy-3">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title d-inline">Add New</h4>
                            </div>
                            <div class="card-body">
                                <form action="" method="post" enctype="multipart/form-data">
                                    <div class="form-row" id="new-archive">
                                        <div class="col-md-12">
                                            <div class="row gy-3">
                                                <div class="form-group col-md-3">
                                                    <label>Season</label>
                                                    <select class="form-control" id="" name="season" required>
                                                        <option value="" selected>Select</option>
                                                        <?php
                                                        $q = getRows('seasons',"*","status='active'");
                                                        while($row = mysqli_fetch_array($q)){
                                                            ?>
                                                            <option <?php if(isset($_POST['season']) && $_POST['season'] == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['sy']."/".$row['ey']." ".getDBVal('season_types',$row['type']) ?></option>
                                                        <?php }?>
                                                    </select>
                                                    <?php if(isset($seasonErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $seasonErr; ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-3">
                                                    <label>Club</label>
                                                    <select class="form-control" id="clubBox" name="club" autofocus>
                                                        <?php if($country > 0):
                                                            echo '<option value="">select</option>';
                                                            $q = dbSelect("clubs","*", "country=$country", "name");
                                                            while($row = mysqli_fetch_assoc($q)){
                                                                ?>
                                                                <option <?php if(isset($_POST['club']) && $_POST['club'] == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                            <?php } endif ?>
                                                    </select>
                                                    <?php if(isset($clubErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubErr; ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-3">
                                                    <label>League</label>
                                                    <select class="form-control default-select" id="" name="league" required>
                                                        <option value="" selected>Select</option>
                                                        <?php
                                                        $q = getRows('leagues',"*","status='active' AND country=$country");
                                                        while($row = mysqli_fetch_array($q)){
                                                            ?>
                                                            <option <?php if(isset($leagueFrm) && $leagueFrm == $row['id']){ echo 'selected'; } ?> value="<?= $row['id'] ?>"><?= $row['name'] ?></option>
                                                        <?php }?>
                                                    </select>
                                                    <?php if(isset($leagueErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $leagueErr; ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-3">
                                                    <label>Position</label>
                                                    <input type="number" class="form-control" min="0" name="position" value="<?= $_POST['position'] ?? '' ?>" required>
                                                    <?php if(isset($positionErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $positionErr ?></span><?php endif ?>
                                                </div>
                                            </div>
                                            <div class="row gy-3 pt-3 mt-3 border-top">
                                                <div class="form-group col-md col-sm-12">
                                                    <label>HM</label>
                                                    <input type="number" class="form-control bg-primary text-white" min="0" name="clubHM" value="<?= $_POST['clubHM'] ?? '' ?>" required>
                                                    <?php if(isset($clubMErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubMErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>HW</label>
                                                    <input type="number" class="form-control" min="0" name="clubHW" value="<?= $_POST['clubHW'] ?? '' ?>" required>
                                                    <?php if(isset($clubWErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubWErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>HD</label>
                                                    <input type="number" class="form-control" min="0" name="clubHD" value="<?= $_POST['clubHD'] ?? '' ?>" required>
                                                    <?php if(isset($clubHDErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubHDErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>HL</label>
                                                    <input type="number" class="form-control" min="0" name="clubHL" value="<?= $_POST['clubHL'] ?? '' ?>" required>
                                                    <?php if(isset($clubLErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubLErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>HGF</label>
                                                    <input type="number" class="form-control" min="0" name="clubHGF" value="<?= $_POST['clubHGF'] ?? '' ?>" required>
                                                    <?php if(isset($clubHGFErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubHGFErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>HGA</label>
                                                    <input type="number" class="form-control" min="0" name="clubHGA" value="<?= $_POST['clubHGA'] ?? '' ?>" required>
                                                    <?php if(isset($clubHGAErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubHGAErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>AM</label>
                                                    <input type="number" class="form-control bg-primary text-white" min="0" name="clubAM" value="<?= $_POST['clubAM'] ?? '' ?>" required>
                                                    <?php if(isset($clubMErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubMErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>AW</label>
                                                    <input type="number" class="form-control" min="0" name="clubAW" value="<?= $_POST['clubAW'] ?? '' ?>" required>
                                                    <?php if(isset($clubWErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubWErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>AD</label>
                                                    <input type="number" class="form-control" min="0" name="clubAD" value="<?= $_POST['clubAD'] ?? '' ?>" required>
                                                    <?php if(isset($clubADErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubADErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>AL</label>
                                                    <input type="number" class="form-control" min="0" name="clubAL" value="<?= $_POST['clubAL'] ?? '' ?>" required>
                                                    <?php if(isset($clubLErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubLErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>AGF</label>
                                                    <input type="number" class="form-control" min="0" name="clubAGF" value="<?= $_POST['clubAGF'] ?? '' ?>" required>
                                                    <?php if(isset($clubAGFErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubAGFErr ?></span><?php endif ?>
                                                </div>
                                                <div class="form-group col-md-2 col-sm-12">
                                                    <label>AGA</label>
                                                    <input type="number" class="form-control" min="0" name="clubAGA" value="<?= $_POST['clubAGA'] ?? '' ?>" required>
                                                    <?php if(isset($clubAGAErr)): ?><span class="bg-danger text-white px-2 rounded-sm"><?= $clubAGAErr ?></span><?php endif ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="form-row mt-3">
                                        <div class="col-md-12">
                                            <button type="submit" name="saveArchive" class="btn btn-primary mr-3">Add</button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Manage All</h4>
                            </div>
                            <div class="card-body">
                                <?php if(count($leagueIds) > 0): ?>
                                <table class="table table-responsive table-borderless table-striped table-hover dtTable">
                                    <thead>
                                        <tr>
                                            <th scope="col">S/N</th>
                                            <th scope="col"><i class="bi bi-toggles"></i></th>
                                            <th scope="col"><i class="bi bi-person-plus-fill text-secondary"></i></th>
                                            <th scope="col" style="width:20%;">Club</th>
                                            <th scope="col" style="width:<?php if(isset($_GET['do']) && $_GET['do'] == 'edit-season'){ echo 20; }else{ echo 8; } ?>%;">Season</th>
                                            <th scope="col" style="width:6%;">Position</th>
                                            <th scope="col" style="width:6%;">MPH</th>
                                            <th scope="col" style="width:6%;">HW</th>
                                            <th scope="col" style="width:6%;">HD</th>
                                            <th scope="col" style="width:6%;">HL</th>
                                            <th scope="col" style="width:6%;">HGF</th>
                                            <th scope="col" style="width:6%;">HGA</th>
                                            <th scope="col" style="width:6%;">MPA</th>
                                            <th scope="col" style="width:6%;">AW</th>
                                            <th scope="col" style="width:6%;">AD</th>
                                            <th scope="col" style="width:6%;">AL</th>
                                            <th scope="col" style="width:6%;">AGF</th>
                                            <th scope="col" style="width:6%;">AGA</th>
                                            <th scope="col"><i class="bi bi-calendar-plus-fill text-primary"></i></th>
                                            <th scope="col"><i class="bi bi-calendar-check-fill text-primary"></i></th>
                                            <th scope="col" style="width:8%;">League</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    <?php
                                    $no = 1;
                                    $q = dbSelect("archive", "*", "league IN (".implode(',',$leagueIds).") AND user=$currUserId", "dc DESC", "20");
                                    while($row = mysqli_fetch_array($q)){
                                        $id = $row['id'];
                                        $club = $row['club'];
                                        $league = $row['league'];
                                        $clubCtry = getDBVal('clubs',$club,'country');
                                        $sy = getDBVal('seasons',$row['season'],'sy');
                                        $ey = getDBVal('seasons',$row['season'],'ey');
                                        $type = getDBVal('seasons',$row['season'],'type');
                                        $typeName = ($type > 0) ? getDBVal('season_types',$type) : "";
                                    ?>
                                        <tr>
                                            <th><?= $no++ ?></th>
                                            <td>
                                                <div class="btn-group">
                                                    <div class="dropdown">
                                                        <button type="button" class="btn btn-outline-primary btn-xs" data-toggle="dropdown" title="Add New">
                                                            <i class="fa fa-gears"></i>
                                                        </button>
                                                        <ul class="dropdown-menu">
                                                           <li><a class="dropdown-item" href="<?= $adminRoot ?>archive?id=<?= $id ?>&d=dlt-entry<?= isset($_GET['ct']) ? '&ct='.$_GET['ct'] : '' ?><?= isset($_GET['cr']) ? '&cr='.$_GET['cr'] : '' ?><?= isset($_GET['clb']) ? '&clb='.$_GET['clb'] : '' ?>">Delete</a></li>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </td>
                                            <td><?= ($row['user'] == $currUserId) ? 'me' : getDBVal('users',$row['user'],'username') ?></td>
                                            <td>
                                                <?php if(isset($_GET['do']) && $_GET['do'] == 'edit-club' && $_GET['id'] == $id): ?>
                                                    <form action="" method="post">
                                                        <div class="input-group input-primary input-group-sm">
                                                            <select class="form-control" name="cEdit">
                                                                <?php
                                                                $q2 = dbSelect("clubs","*", "country=$country", "name");
                                                                while($row2 = mysqli_fetch_assoc($q2)){
                                                                    ?>
                                                                    <option <?php if($club == $row2['id']){ echo 'selected'; } ?> value="<?= $row2['id'] ?>"><?= $row2['name'] ?></option>
                                                                <?php } ?>
                                                            </select>
                                                            <div class="input-group-append">
                                                                <button class="btn btn-success submitButton" type="submit" name="updateClub"><i class="bi bi-check"></i></button>
                                                            </div>
                                                            <div class="input-group-append">
                                                                <a href="<?= $url ?>" class="btn btn-danger submitButton" title="Close"><i class="bi bi-x"></i></a>
                                                            </div>
                                                        </div>
                                                    </form>

                                                <?php else: ?>
                                                    <?= getDBVal('clubs',$club) ?>
                                                    <a href="<?= $adminRoot ?>archive?id=<?= $id ?>&do=edit-club<?= isset($_GET['ct']) ? '&ct='.$_GET['ct'] : '' ?><?= isset($_GET['cr']) ? '&cr='.$_GET['cr'] : '' ?><?= isset($_GET['season']) ? '&season='.$_GET['season'] : '' ?>" title="Edit Club"><i class="bi bi-pencil text-blue"></i></a>
                                                <?php endif ?>
                                            </td>
                                            <td>
                                                <?php if(isset($_GET['do']) && $_GET['do'] == 'edit-season' && $_GET['id'] == $id): ?>
                                                    <form action="" method="post">
                                                        <div class="input-group input-primary input-group-sm">
                                                            <select class="form-control" name="seasonEdit">
                                                                <?php
                                                                $q2 = dbSelect("seasons","*", null,"sy");
                                                                while($row2 = mysqli_fetch_assoc($q2)){
                                                                    ?>
                                                                    <option <?php if($row['season'] == $row2['id']){ echo 'selected'; } ?> value="<?= $row2['id'] ?>"><?= $row2['sy']."/".$row2['ey']." ".getDBVal('season_types',$row2['type']) ?></option>
                                                                <?php } ?>
                                                            </select>
                                                            <div class="input-group-append">
                                                                <button class="btn btn-success submitButton" type="submit" name="updateSeason"><i class="bi bi-check"></i></button>
                                                            </div>
                                                            <div class="input-group-append">
                                                                <a href="<?= $url ?>" class="btn btn-danger submitButton" title="Close"><i class="bi bi-x"></i></a>
                                                            </div>
                                                        </div>
                                                    </form>

                                                <?php else: ?>
                                                    <?= "$sy - $ey $typeName" ?>
                                                    <a href="<?= $adminRoot ?>archive?id=<?= $id ?>&do=edit-season<?= isset($_GET['ct']) ? '&ct='.$_GET['ct'] : '' ?><?= isset($_GET['cr']) ? '&cr='.$_GET['cr'] : '' ?><?= isset($_GET['season']) ? '&season='.$_GET['season'] : '' ?>" title="Edit Season"><i class="bi bi-calendar2 text-primary"></i></a>
                                                <?php endif ?>
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="position" data-prev="<?= $row['position'] ?>" data-table="archive" data-action="update" data-col="position" class="form-control table-input-update" value="<?= $row['position'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home matches" data-prev="<?= $row['mp_home'] ?>" data-table="archive" data-action="update" data-col="mp_home" class="form-control table-input-update" value="<?= $row['mp_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home wins" data-prev="<?= $row['w_home'] ?>" data-table="archive" data-action="update" data-col="w_home" class="form-control table-input-update" value="<?= $row['w_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home draws" data-prev="<?= $row['d_home'] ?>" data-table="archive" data-action="update" data-col="d_home" class="form-control table-input-update" value="<?= $row['d_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home loss" data-prev="<?= $row['l_home'] ?>" data-table="archive" data-action="update" data-col="l_home" class="form-control table-input-update" value="<?= $row['l_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home goals forward" data-prev="<?= $row['gf_home'] ?>" data-table="archive" data-action="update" data-col="gf_home" class="form-control table-input-update" value="<?= $row['gf_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home goals against" data-prev="<?= $row['ga_home'] ?>" data-table="archive" data-action="update" data-col="ga_home" class="form-control table-input-update" value="<?= $row['ga_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away matches" data-prev="<?= $row['mp_away'] ?>" data-table="archive" data-action="update" data-col="mp_away" class="form-control table-input-update" value="<?= $row['mp_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away wins" data-prev="<?= $row['w_away'] ?>" data-table="archive" data-action="update" data-col="w_away" class="form-control table-input-update" value="<?= $row['w_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away draws" data-prev="<?= $row['d_away'] ?>" data-table="archive" data-action="update" data-col="d_away" class="form-control table-input-update" value="<?= $row['d_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away loss" data-prev="<?= $row['l_away'] ?>" data-table="archive" data-action="update" data-col="l_away" class="form-control table-input-update" value="<?= $row['l_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away goals forward" data-prev="<?= $row['gf_away'] ?>" data-table="archive" data-action="update" data-col="gf_away" class="form-control table-input-update" value="<?= $row['gf_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away goals against" data-prev="<?= $row['ga_away'] ?>" data-table="archive" data-action="update" data-col="ga_away" class="form-control table-input-update" value="<?= $row['ga_away'] ?>">
                                            </td>
                                            <td><?= getTimeAgo(strtotime($row['dc'])) ?></td>
                                            <td><?php if($row['du'] != ""){ echo getTimeAgo(strtotime($row['du'])); } ?></td>
                                            <td><?= getDBVal('leagues',$league) ?></td>
                                        </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>

                                <?php if($currUserId == 2): ?>
                                <table class="table table-responsive table-borderless table-striped table-hover dtTable mt-10">
                                    <thead>
                                        <tr>
                                            <th scope="col">S/N</th>
                                            <th scope="col"><i class="bi bi-person-plus-fill text-secondary"></i></th>
                                            <th scope="col" style="width:20%;">Club</th>
                                            <th scope="col" style="width:8%;">Season</th>
                                            <th scope="col" style="width:6%;">Position</th>
                                            <th scope="col" style="width:6%;">MPH</th>
                                            <th scope="col" style="width:6%;">HW</th>
                                            <th scope="col" style="width:6%;">HD</th>
                                            <th scope="col" style="width:6%;">HL</th>
                                            <th scope="col" style="width:6%;">HGF</th>
                                            <th scope="col" style="width:6%;">HGA</th>
                                            <th scope="col" style="width:6%;">MPA</th>
                                            <th scope="col" style="width:6%;">AW</th>
                                            <th scope="col" style="width:6%;">AD</th>
                                            <th scope="col" style="width:6%;">AL</th>
                                            <th scope="col" style="width:6%;">AGF</th>
                                            <th scope="col" style="width:6%;">AGA</th>
                                            <th scope="col"><i class="bi bi-calendar-plus-fill text-primary"></i></th>
                                            <th scope="col"><i class="bi bi-calendar-check-fill text-primary"></i></th>
                                            <th scope="col" style="width:8%;">League</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    <?php
                                    $no = 1;
                                    $q = dbSelect("archive", "*", "user<>$currUserId", "dc DESC", "20");
                                    while($row = mysqli_fetch_array($q)){
                                        $id = $row['id'];
                                        $club = $row['club'];
                                        $league = $row['league'];
                                        $clubCtry = getDBVal('clubs',$club,'country');
                                        $sy = getDBVal('seasons',$row['season'],'sy');
                                        $ey = getDBVal('seasons',$row['season'],'ey');
                                        $type = getDBVal('seasons',$row['season'],'type');
                                        $typeName = ($type > 0) ? getDBVal('season_types',$type) : "";
                                    ?>
                                        <tr>
                                            <th><?= $no++ ?></th>
                                            <td><?= ($row['user'] == $currUserId) ? 'me' : getDBVal('users',$row['user'],'username') ?></td>
                                            <td>
                                                <?php if(isset($_GET['do']) && $_GET['do'] == 'edit-club' && $_GET['id'] == $id): ?>
                                                    <form action="" method="post">
                                                        <div class="input-group input-primary input-group-sm">
                                                            <select class="form-control" name="cEdit">
                                                                <?php
                                                                $q2 = dbSelect("clubs","*", "country=$country", "name");
                                                                while($row2 = mysqli_fetch_assoc($q2)){
                                                                    ?>
                                                                    <option <?php if($club == $row2['id']){ echo 'selected'; } ?> value="<?= $row2['id'] ?>"><?= $row2['name'] ?></option>
                                                                <?php } ?>
                                                            </select>
                                                            <div class="input-group-append">
                                                                <button class="btn btn-success submitButton" type="submit" name="updateClub"><i class="bi bi-check"></i></button>
                                                            </div>
                                                            <div class="input-group-append">
                                                                <a href="<?= $url ?>" class="btn btn-danger submitButton" title="Close"><i class="bi bi-x"></i></a>
                                                            </div>
                                                        </div>
                                                    </form>

                                                <?php else: ?>
                                                    <?= getDBVal('clubs',$club) ?>
                                                    <a href="<?= $adminRoot ?>archive?id=<?= $id ?>&do=edit-club<?= isset($_GET['ct']) ? '&ct='.$_GET['ct'] : '' ?><?= isset($_GET['cr']) ? '&cr='.$_GET['cr'] : '' ?><?= isset($_GET['season']) ? '&season='.$_GET['season'] : '' ?>" title="Edit Club"><i class="bi bi-pencil text-blue"></i></a>
                                                <?php endif ?>
                                            </td>
                                            <td>
                                                <?php if(isset($_GET['do']) && $_GET['do'] == 'edit-season' && $_GET['id'] == $id): ?>
                                                    <form action="" method="post">
                                                        <div class="input-group input-primary input-group-sm">
                                                            <select class="form-control" name="seasonEdit">
                                                                <?php
                                                                $q2 = dbSelect("seasons","*", null,"sy");
                                                                while($row2 = mysqli_fetch_assoc($q2)){
                                                                    ?>
                                                                    <option <?php if($row['season'] == $row2['id']){ echo 'selected'; } ?> value="<?= $row2['id'] ?>"><?= $row2['sy']."/".$row2['ey']." ".getDBVal('season_types',$row2['type']) ?></option>
                                                                <?php } ?>
                                                            </select>
                                                            <div class="input-group-append">
                                                                <button class="btn btn-success submitButton" type="submit" name="updateSeason"><i class="bi bi-check"></i></button>
                                                            </div>
                                                            <div class="input-group-append">
                                                                <a href="<?= $url ?>" class="btn btn-danger submitButton" title="Close"><i class="bi bi-x"></i></a>
                                                            </div>
                                                        </div>
                                                    </form>

                                                <?php else: ?>
                                                    <?= "$sy - $ey $typeName" ?>
                                                    <a href="<?= $adminRoot ?>archive?id=<?= $id ?>&do=edit-season<?= isset($_GET['ct']) ? '&ct='.$_GET['ct'] : '' ?><?= isset($_GET['cr']) ? '&cr='.$_GET['cr'] : '' ?><?= isset($_GET['season']) ? '&season='.$_GET['season'] : '' ?>" title="Edit Season"><i class="bi bi-calendar2 text-primary"></i></a>
                                                <?php endif ?>
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="position" data-prev="<?= $row['position'] ?>" data-table="archive" data-action="update" data-col="position" class="form-control table-input-update" value="<?= $row['position'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home matches" data-prev="<?= $row['mp_home'] ?>" data-table="archive" data-action="update" data-col="mp_home" class="form-control table-input-update" value="<?= $row['mp_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home wins" data-prev="<?= $row['w_home'] ?>" data-table="archive" data-action="update" data-col="w_home" class="form-control table-input-update" value="<?= $row['w_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home draws" data-prev="<?= $row['d_home'] ?>" data-table="archive" data-action="update" data-col="d_home" class="form-control table-input-update" value="<?= $row['d_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home loss" data-prev="<?= $row['l_home'] ?>" data-table="archive" data-action="update" data-col="l_home" class="form-control table-input-update" value="<?= $row['l_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home goals forward" data-prev="<?= $row['gf_home'] ?>" data-table="archive" data-action="update" data-col="gf_home" class="form-control table-input-update" value="<?= $row['gf_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="home goals against" data-prev="<?= $row['ga_home'] ?>" data-table="archive" data-action="update" data-col="ga_home" class="form-control table-input-update" value="<?= $row['ga_home'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away matches" data-prev="<?= $row['mp_away'] ?>" data-table="archive" data-action="update" data-col="mp_away" class="form-control table-input-update" value="<?= $row['mp_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away wins" data-prev="<?= $row['w_away'] ?>" data-table="archive" data-action="update" data-col="w_away" class="form-control table-input-update" value="<?= $row['w_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away draws" data-prev="<?= $row['d_away'] ?>" data-table="archive" data-action="update" data-col="d_away" class="form-control table-input-update" value="<?= $row['d_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away loss" data-prev="<?= $row['l_away'] ?>" data-table="archive" data-action="update" data-col="l_away" class="form-control table-input-update" value="<?= $row['l_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away goals forward" data-prev="<?= $row['gf_away'] ?>" data-table="archive" data-action="update" data-col="gf_away" class="form-control table-input-update" value="<?= $row['gf_away'] ?>">
                                            </td>
                                            <td>
                                                <input type="text" data-id="<?= $id ?>" data-name="away goals against" data-prev="<?= $row['ga_away'] ?>" data-table="archive" data-action="update" data-col="ga_away" class="form-control table-input-update" value="<?= $row['ga_away'] ?>">
                                            </td>
                                            <td><?= getTimeAgo(strtotime($row['dc'])) ?></td>
                                            <td><?php if($row['du'] != ""){ echo getTimeAgo(strtotime($row['du'])); } ?></td>
                                            <td><?= getDBVal('leagues',$league) ?></td>
                                        </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>
                                <?php endif ?>
                                <?php endif ?>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row gy-3">
                                    <?php
                                    $q = dbSelect('users',"*","status='active'");
                                    while($row = mysqli_fetch_assoc($q)){
                                        $id = $row['id'];
                                        $totalEntries = cntRows('archive',"user=$id AND dc LIKE '$today%'");
                                    ?>
                                    <div class="col-xl-3 col-lg-6 col-sm-6">
                                        <div class="widget-stat card">
                                            <div class="card-body p-4">
                                                <h4 class="card-title"><?= strtoupper($row['username']) ?></h4>
                                                <h3><?= number_format($totalEntries) ?></h3>
                                                <div class="progress mb-2">
                                                    <div class="progress-bar progress-animated bg-primary" style="width: <?= getPercentage($totalEntries,1500) ?>"></div>
                                                </div>
                                                <small><?= getIncreasePercentage('archive', 1,0,'user='.$id) ?> Increase in 24 Hours</small>
                                            </div>
                                        </div>
                                    </div>
                                    <?php } ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->

        <!--**********************************
            Footer start
        ***********************************-->
        <?php include("../inc/footer.php"); ?>
        <!--**********************************
            Footer end
        ***********************************-->


    </div>
    <!--**********************************
        Main wrapper end
    ***********************************-->

    <?php include("../inc/foot.php"); ?>