aDriv4 website!

Linux premium294.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64
LiteSpeed
66.29.137.213

viewScore.php

<br><?php
require "includes/headerLive.php";

include_once 'includes/connection.php';
    if (isset($_GET['id'])) {
        $decoded_id = base64_decode($_GET['id']);
        $matchid = $decoded_id;
    } elseif (isset($_SESSION['id'])) {
        $matchid = $_SESSION['id'];
    }

?>
<style>
    body {
        font-family: Arial, sans-serif;
        background-color: #f4f4f4;
        text-align: center;
    }

.scorecard {
        width: 100%;
        margin: 20px auto;
        padding: 15px;
        background: #fff;
        border-radius: 10px;
        box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
    }

.over {
        display: inline-block;
        padding: 8px 12px;
        border: 2px solid #2196F3;
        background: #E3F2FD;
        border-radius: 5px;
        font-size: 18px;
        font-weight: bold;
        margin: 5px;
    }

.extra {
        color: #FF5722;
        font-weight: bold;
    }

.wicket {
        color: #D32F2F;
        font-weight: bold;
    }
</style>
<style>
    /* Make table text smaller on small screens */
    @media (max-width: 768px) {

#batsmen td,
        #batsmen th {
            font-size: 14px;
            /* Adjust font size */
            padding: 8px;
            /* Reduce padding */
        }
    }

/* Adjust table for very small screens */
    @media (max-width: 576px) {
        .table-responsive {
            overflow-x: auto;
            /* Enable scrolling */
        }
    }
</style>

<div class="container mt-4">
    <h2 class="text-center text-primary">🏏 Live Cricket Score</h2>

<?php
    $sqlteam = "SELECT `id`, `match_name`, `season`, `team1`, `team2`, `toss`, `choses`, `status` FROM `match_teams` WHERE id = $matchid";
    $allTeamResult = mysqli_query($conn, $sqlteam);
    if ($allTeamResult) {
        while ($teamRow = mysqli_fetch_assoc($allTeamResult)) {
            $match_id = $teamRow['id'];
            $status =  $teamRow['status'];
            $matchName = $teamRow['match_name'];
            $teamOne = $teamRow['team1'];
            $teamTwo = $teamRow['team2'];
            $toss = $teamRow['toss'];
            $choses = $teamRow['choses'];

if ($toss === $teamOne && $choses === 'Bat') {
                $bat = $teamRow['team1'];
                $bowl = $teamRow['team2'];
            } elseif ($toss === $teamOne && $choses === 'Bowl') {
                $bat = $teamRow['team2'];
                $bowl = $teamRow['team1'];
            } elseif ($toss === $teamTwo && $choses === 'Bat') {
                $bat = $teamRow['team2'];
                $bowl = $teamRow['team1'];
            } elseif ($toss === $teamTwo && $choses === 'Bowl') {
                $bat = $teamRow['team1'];
                $bowl = $teamRow['team2'];
            }

$teamOneTotal = 0;
            $teamTwoTotal = 0;
            $teamOneWicket = 0;
            $teamTwoWicket = 0;
            $overs1 = 0;
            $overs2 = 0;
            $balls1 = 0;
            $balls2 = 0;
            $remainingBalls1 = 0;
            $remainingBalls2 = 0;
            $teamOneBalls = 0;
            $teamTwoBalls = 0;

// Example match ID

$sql = "SELECT s.match_id, 
                                 COUNT(CASE WHEN s.innings = 1 AND s.bowlCount > 0 THEN s.bowlCount IS NULL END) AS total_balls_innings_1,
                                 COUNT(CASE WHEN s.innings = 2 AND s.bowlCount > 0 THEN s.bowlCount IS NULL END) AS total_balls_innings_2,
                                 SUM(CASE WHEN s.innings = 1 AND s.bowlCount > 0 AND s.bowlCount IS NOT NULL THEN s.score ELSE 0 END) AS total_score_innings_1,
                                 SUM(CASE WHEN s.innings = 2 AND s.bowlCount > 0 AND s.bowlCount IS NOT NULL THEN s.score ELSE 0 END) AS total_score_innings_2,
                                 COUNT(CASE WHEN s.innings = 1 AND s.wicket IS NOT NULL AND s.wicket != '' THEN 1 END) AS total_wickets_innings_1,
                                 COUNT(CASE WHEN s.innings = 2 AND s.wicket IS NOT NULL AND s.wicket != '' THEN 1 END) AS total_wickets_innings_2,
                                 COUNT(CASE WHEN s.extra = 'wide' AND s.innings = 1 THEN 1 END) AS wides_innings_1,
                                 COUNT(CASE WHEN s.extra = 'wide' AND s.innings = 2 THEN 1 END) AS wides_innings_2,
                                 COUNT(CASE WHEN s.extra = 'noball' AND s.innings = 1 THEN 1 END) AS noballs_innings_1,
                                 COUNT(CASE WHEN s.extra = 'noball' AND s.innings = 2 THEN 1 END) AS noballs_innings_2
                             FROM score s
                             WHERE s.match_id = $match_id
                             GROUP BY s.match_id";

$result = $conn->prepare($sql);
            $result->execute();
            $scoreresult = $result->get_result();
            if ($scoreresult->num_rows > 0) {
                while ($data = $scoreresult->fetch_assoc()) {

$mid = $match_id;

$balls1 = $data['total_balls_innings_1'] - ($data['wides_innings_1'] + $data['noballs_innings_1']);
                    if ($balls1 > 0) {
                        $overs1 = floor($balls1 / 6); // Get the full overs
                    } else {
                        $overs1 = 0.0;
                    }
                    $remainingBalls1 = $balls1 % 6;

$balls2 = $data['total_balls_innings_2'] - ($data['wides_innings_2'] + $data['noballs_innings_2']);
                    if ($balls2 > 0) {
                        $overs2 = floor($balls2 / 6); // Get the full overs
                    } else {
                        $overs2 = 0.0;
                    }
                    $remainingBalls2 = $balls2 % 6;

$teamOneTotal = $data['total_score_innings_1'] + $data['wides_innings_1'] + $data['noballs_innings_1'];
                    $teamTwoTotal = $data['total_score_innings_2'] + $data['wides_innings_2'] + $data['noballs_innings_2'];
                    $teamOneWicket = $data['total_wickets_innings_1'];
                    $teamTwoWicket = $data['total_wickets_innings_2'];
                    $teamOneBalls;
                    $teamTwoBalls;
                }
            }

$sql = "SELECT 
            s.match_id AS mid, 
            COUNT(CASE WHEN s.innings = 1 AND s.bowlCount > 0 THEN s.bowlCount IS NULL END) AS total_balls_team1,
            COUNT(CASE WHEN s.innings = 2 AND s.bowlCount > 0 THEN s.bowlCount IS NULL END) AS total_balls_team2,
            SUM(CASE WHEN s.innings = 1 AND s.bowlCount > 0 AND s.bowlCount IS NOT NULL THEN s.score ELSE 0 END) AS total_runs_team1,
            SUM(CASE WHEN s.innings = 2 AND s.bowlCount > 0 AND s.bowlCount IS NOT NULL THEN s.score ELSE 0 END) AS total_runs_team2,
            COUNT(CASE WHEN s.innings = 1 AND s.wicket IS NOT NULL AND s.wicket != '' THEN 1 END) AS total_wickets_team1,
            COUNT(CASE WHEN s.innings = 2 AND s.wicket IS NOT NULL AND s.wicket != '' THEN 1 END) AS total_wickets_team2,
            COUNT(CASE WHEN s.extra = 'wide' AND s.innings = 1 THEN 1 END) AS total_wides_team1,
            COUNT(CASE WHEN s.extra = 'wide' AND s.innings = 2 THEN 1 END) AS total_wides_team2,
            COUNT(CASE WHEN s.extra = 'noball' AND s.innings = 1 THEN 1 END) AS total_noballs_team1,
            COUNT(CASE WHEN s.extra = 'noball' AND s.innings = 2 THEN 1 END) AS total_noballs_team2
        FROM superover s
        WHERE s.match_id = $match_id";

$result = $conn->prepare($sql);
            $result->execute();
            $matchStats = $result->get_result();

if ($matchStats->num_rows > 0) {
                while ($stats = $matchStats->fetch_assoc()) {

$maid = $stats['mid'];

$team1_valid_balls = $stats['total_balls_team1'] - ($stats['total_wides_team1'] + $stats['total_noballs_team1']);
                    $team2_valid_balls = $stats['total_balls_team2'] - ($stats['total_wides_team2'] + $stats['total_noballs_team2']);

$team1_overs = ($team1_valid_balls > 0) ? floor($team1_valid_balls / 6) : 0;
                    $team2_overs = ($team2_valid_balls > 0) ? floor($team2_valid_balls / 6) : 0;

$team1_remaining_balls = $team1_valid_balls % 6;
                    $team2_remaining_balls = $team2_valid_balls % 6;

$team1_total_score = $stats['total_runs_team1'] + $stats['total_wides_team1'] + $stats['total_noballs_team1'];
                    $team2_total_score = $stats['total_runs_team2'] + $stats['total_wides_team2'] + $stats['total_noballs_team2'];

$team1_wickets = $stats['total_wickets_team1'];
                    $team2_wickets = $stats['total_wickets_team2'];
                }
            }

?>
            <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">

<div class="d-flex align-items-center justify-content-between p-3 rounded  w-100">

<div class="d-flex align-items-center">
                                <?php
                                $team1 = "SELECT `id`, `name`, `logo` FROM `team` WHERE id = $bat";
                                $allTeamResult1 = mysqli_query($conn, $team1);
                                if ($allTeamResult1) {
                                    $teamRow1 = mysqli_fetch_assoc($allTeamResult1);
                                    $teamname1 = $teamRow1['name'];
                                    $team1logo = $teamRow1['logo'];
                                }
                                ?>
                                
                                <div class="ms-3 text-start">
                                    <p class="mb-1 fw-bold"><?php echo $teamname1; ?></p>
                                    <p class="mb-0 text-muted">
                                        <?php echo $teamOneTotal . ' / ' . $teamOneWicket; ?>
                                        &bull; (<?php echo $overs1 . '.' . $remainingBalls1; ?>)
                                    </p>
                                    <p>
                                        <?php
                                        if ($team2_valid_balls > 0) {
                                            echo $team2_total_score . "/" . $team2_wickets . " (" . $team2_valid_balls . ")";
                                        }
                                        ?>
                                    </p>
                                </div>
                            </div>

<div class="text-center">
                                <h4 class="fw-bold">VS</h4>
                            </div>

<div class="d-flex align-items-center text-end">
                                <?php
                                $team2 = "SELECT `id`, `name`, `logo` FROM `team` WHERE id = $bowl";
                                $allTeamResult2 = mysqli_query($conn, $team2);
                                if ($allTeamResult2) {
                                    $teamRow2 = mysqli_fetch_assoc($allTeamResult2);
                                    $teamname2 = $teamRow2['name'];
                                    $team2logo = $teamRow2['logo'];
                                }
                                ?>
                                <div class="me-3 text-end">
                                    <p class="mb-1 fw-bold"><?php echo $teamname2; ?></p>
                                    <p class="mb-0 text-muted">
                                        <?php
                                        if ($balls2 > 0) {
                                            echo $teamTwoTotal . ' / ' . $teamTwoWicket . ' &bull; (' . $overs2 . '.' . $remainingBalls2 . ')';
                                        ?>
                                    <p>
                                        <?php
                                            if ($team1_valid_balls > 0) {
                                                echo $team1_total_score . "/" . $team1_wickets . " (" . $team1_valid_balls . ")";
                                            }
                                        ?>
                                    </p><?php
                                        } else {
                                            echo "Yet To Bat";
                                        }
                                        ?>
                                </p>
                                </div>
                                
                            </div>

</div>
                        <center>
                          <?php
                            // Check if Team 2 is batting (second innings)
                            if ($mid != $maid) {
                                if ($status == "Live") {
                                    if ($balls2 > 0) {
                                        // Determine the match result
                                        if ($teamOneTotal < $teamTwoTotal) {
                                            echo "<p>$teamname2 won by " . (10 - $teamTwoWicket) . " Wickets</p>";
                                        } elseif ($teamOneTotal > $teamTwoTotal && ($teamTwoWicket >= 10 || $balls2 >= 60)) {
                                            echo "<p>$teamname1 won by " . ($teamOneTotal - $teamTwoTotal) . " Runs</p>";
                                        } elseif ($teamOneTotal == $teamTwoTotal && ($teamTwoWicket == 10 || $balls2 >= 60)) {
                                            echo "<p>Match is Draw</p>";
                                        } else {
                                            echo "<p>$teamname2 needs " . (($teamOneTotal + 1) - $teamTwoTotal) . " Runs from " . (60 - $balls2) . " Balls</p>";
                                        }
                                    }
                                    // Display current run rate for team batting first
                                    elseif ($balls1 > 0) {
                                        if ($balls1 > 0) {
                                            $currentRunRate = sprintf("%.1f", ($teamOneTotal / $balls1) * 6);
                                            $expectedScore = intval(($teamOneTotal / $balls1) * 60);
                                            echo "<p>Current Run Rate: $currentRunRate || Expected Score: $expectedScore</p>";
                                        } else {
                                            echo "<p>Current Run Rate: 0.0 || Expected Score: 0</p>";
                                        }
                                    } else {
                                        echo "<p>Waiting for 1st Ball</p>";
                                    }
                                } else {
                                    if ($teamOneTotal < $teamTwoTotal) {

?>
                                        <p><?php echo $teamname2 . ' is won by ' . 10 - $teamTwoWicket . ' Wickets'  ?> </p>
                                    <?php
                                    } elseif ($teamOneTotal > $teamTwoTotal) {
                                    ?>
                                        <p><?php echo $teamname1 . ' is won by ' . $teamOneTotal - $teamTwoTotal . ' Runs'  ?> </p>
                                    <?php
                                    } elseif ($teamOneTotal == $teamTwoTotal) { ?>
                                        <p><?php echo "Match is Draw..!"  ?> </p>
                                    <?php
                                    } else { ?>
                                        <p>Waiting For 1st Ball </p>
                            <?php
                                    }
                                }
                            }

// **Super Over Logic**
                            if ($mid == $maid) {
                                if ($team1_total_score < $team2_total_score) {
                                    echo "<p>$teamname1 won by Super Over</p>";
                                } elseif ($team1_total_score > $team2_total_score && ($team2_wickets >= 2 || $team2_valid_balls >= 6)) {
                                    echo "<p>$teamname2 won by Super Over</p>";
                                } elseif ($team1_total_score == $team2_total_score && ($team2_wickets >= 2 || $team2_valid_balls >= 6)) {
                                    echo "<p>Match is Draw</p>";
                                } else {
                                    echo "<p>$teamname1 needs " . (($team2_total_score + 1) - $team1_total_score) . " Runs from " . (6 - $team2_valid_balls) . " Balls</p>";
                                }
                            }
                            ?>
                        </center>

</div>
                </div>
            </div>

<?php }
    } ?>

<?php

$sql = "SELECT `id`, `match_id`, `innings`, `striker`, `nonstriker`, `baller`, `bowlCount`, `score`, `extra`, `byes`, `wicket` FROM `score` WHERE `innings` =  1 AND `match_id` = $matchid ORDER BY `id` ASC";
    $result = $conn->query($sql);

$overs = [];
    $currentOver = 0;
    $ballCount = 0;

if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $innings = $row['innings'];
            $runs = $row['score'];
            $extra = $row['extra']; // Wide, No-ball, etc.
            $wicket = ($row['wicket']) ? '<span class="wicket">W</span>' : '';

if (!isset($overs[$currentOver])) {
                $overs[$currentOver] = [];
            }

// Format display for runs, extras, and wickets
            $ballText = ($extra) ? "$runs+<span class='extra'>$extra</span>" : $runs;
            if ($wicket) {
                $ballText .= " $wicket";
            }

$overs[$currentOver][] = $ballText;

if (!$extra) { // Count only legal deliveries
                $ballCount++;
            }

// Move to next over after 6 legal balls
            if ($ballCount == 6) {
                $currentOver++;
                $ballCount = 0;
            }
        }
    } else {
        echo "The Match hasn't started yet.";
    }

?>
    <div class=" scorecard">
        <h2>Cricket Scorecard</h2>
        <div class="all-overs">
            <?php
            $allScores = []; // Store all overs in a single row format
            foreach ($overs as $overNumber => $balls) {
                $allScores[] = "<span class='over'> " . implode(" , ", $balls) . "</span>";
            }
            echo implode(" ", $allScores); // Display all overs in a single row
            ?>
        </div>
    </div>
    <div class="row g-4 mb-4 justify-content-center">
        <div class="col-md-12 col-lg-12">

<?php
            $batsmenOrder = []; // Array to maintain batting order

// Fetch all batting details in order of play
            $battingQuery = "SELECT striker, nonstriker,`baller` FROM `score` WHERE `innings` = 1 AND `match_id` = $matchid ORDER BY id ASC";
            $battingResult = mysqli_query($conn, $battingQuery);

if ($battingResult) {
                while ($row = mysqli_fetch_assoc($battingResult)) {
                    if (!in_array($row['striker'], $batsmenOrder)) {
                        $batsmenOrder[] = $row['striker'];
                    }
                    if (!in_array($row['nonstriker'], $batsmenOrder)) {
                        $batsmenOrder[] = $row['nonstriker'];
                    }
                }
            }

<div class="table-responsive mb-4">
                <table class="table">
                    <thead class="table-light">
                        <tr>
                            <th>Batsman</th>
                            <th>Runs</th>
                            <th>Balls</th>
                            <th>4s</th>
                            <th>6s</th>
                            <th>SR</th>
                        </tr>
                    </thead>
                    <tbody id="batsmen">
                        <?php
                        foreach ($batsmenOrder as $batsmanId) {
                            // Fetch player details
                            $playerQuery = "SELECT `name` FROM `players` WHERE id = $batsmanId";
                            $playerResult = mysqli_query($conn, $playerQuery);
                            $playerRow = mysqli_fetch_assoc($playerResult);
                            $batsmanName = $playerRow['name'] ?? 'Unknown';

// Fetch batting statistics
                            $statsQuery = "SELECT SUM(score) AS total_score, 
                            COUNT(CASE WHEN bowlCount IS NOT NULL THEN 1 END) AS balls_faced,
                            SUM(CASE WHEN score = 4 THEN 1 ELSE 0 END) AS fours, 
                            SUM(CASE WHEN score = 6 THEN 1 ELSE 0 END) AS sixes, 
                            SUM(CASE WHEN byes = 'legby' THEN score ELSE 0 END) AS legby_sum,
                            SUM(CASE WHEN byes = 'Byes' THEN score ELSE 0 END) AS byes_sum
                            FROM score WHERE match_id = $matchid AND striker = $batsmanId AND innings = 1";

$statsResult = mysqli_query($conn, $statsQuery);
                            $statsRow = mysqli_fetch_assoc($statsResult);

// wicket

// end wicket

echo "<tr>
                        <td style='width:300px;'>{$batsmanName}";
                            $wsql = "SELECT `id`, `matchid`, `batdsman`, `baller`, `wicket`, `partner` FROM `wicket` WHERE batdsman = $batsmanId";
                            $allwicket = mysqli_query($conn, $wsql);

if ($allwicket && mysqli_num_rows($allwicket) > 0) {
                                $wicketRow = mysqli_fetch_assoc($allwicket);
                                $bowl = $wicketRow['baller'];
                                if ($bowl != "") {
                                    $bowlsql = "SELECT `id`, `name`, `dob`, `player`, `club`, `bat`, `boll`, `image`, `isDelete` FROM `players` WHERE id = $bowl";
                                    $allbowl = mysqli_query($conn, $bowlsql);
                                    if ($allbowl) {
                                        $bowlRow = mysqli_fetch_assoc($allbowl);
                                        echo "<div style='text-align: right;'>Bolw: " . ($bowlRow['name'] ?? 'N/A') . ", " . ($wicketRow['wicket'] ?? 'N/A');
                                    }
                                } else {
                                    echo "<div style='text-align: right;'>" . ($wicketRow['wicket'] ?? 'N/A');
                                }

if (!empty($wicketRow['partner'])) {
                                    $help = $wicketRow['partner'];
                                    $helpsql = "SELECT `id`, `name`, `dob`, `player`, `club`, `bat`, `boll`, `image`, `isDelete` FROM `players` WHERE id = $help";
                                    $allhelp = mysqli_query($conn, $helpsql);
                                    if ($allhelp) {
                                        $helpRow = mysqli_fetch_assoc($allhelp);
                                    }
                                    echo ", " . $helpRow['name'];
                                }
                                echo "</div>";
                            } else {
                                echo "<div style='text-align: right;'>Not out </div>";
                            }

echo "
                        </td>
                        <td>{$totalRuns}</td>
                        <td>{$ballsFaced}</td>
                        <td>{$statsRow['fours']}</td>
                        <td>{$statsRow['sixes']}</td>
                        <td>{$strikeRate}</td>
                      </tr>";
                        }
                        ?>
                    </tbody>
                </table>
            </div>
        </div>

<div class="table-responsive mb-4">
                <table class="table">
                    <thead class="table-light">
                        <tr>
                            <th>Bowler</th>
                            <th>Overs</th>
                            <th>Runs</th>
                            <th>Wickets</th>
                            <th>Wides</th>
                            <th>NO-Balls</th>
                        </tr>
                    </thead>
                    <tbody id="bowlers">
                        <?php
                        $match = "SELECT `id`, `match_id`, `innings`, `striker`, `nonstriker`, `baller`, `bowlCount`, `score`, `extra`, `byes`, `wicket` FROM `score` WHERE `innings` =  1 AND `match_id` = $matchid GROUP BY baller;";
                        $allmatch = mysqli_query($conn, $match);
                        if ($allmatch) {
                            while ($matchRow = mysqli_fetch_assoc($allmatch)) {
                                $baller = $matchRow['baller'];
                        ?>
                                <tr>
                                    <td><?php
                                        $palyer = "SELECT `id`, `name`, `dob`, `player`, `club`, `bat`, `boll`, `image`, `isDelete` FROM `players` WHERE id = $baller";
                                        $allplayer = mysqli_query($conn, $palyer);
                                        if ($allplayer) {
                                            $playerRow = mysqli_fetch_assoc($allplayer);
                                            echo $playerRow['name'];
                                        }
                                        ?>
                                    </td>
                                    <?php
                                    $sql = "SELECT baller, SUM(score) AS total_score,
                                                COUNT(CASE WHEN bowlCount IS NOT NULL AND bowlCount > 0 THEN 0 END) AS total_bowls,
                                                COUNT(CASE WHEN wicket IS NOT NULL AND wicket != '' THEN 0 END) AS total_wickets,
                                                COUNT(CASE WHEN extra IS NOT NULL AND extra = 'wide' THEN 0 END) AS wides,
                                                COUNT(CASE WHEN extra IS NOT NULL AND extra = 'noball' THEN 0 END) AS noball,
                                                SUM(CASE WHEN byes = 'legby' THEN score ELSE 0 END) AS legby_sum,
                                                SUM(CASE WHEN byes = 'Byes' THEN score ELSE 0 END) AS byes_sum
                                                FROM score 
                                                WHERE match_id = ? AND baller = ?  AND innings = 1
                                                GROUP BY baller";

$stmt = $conn->prepare($sql);
                                    $stmt->bind_param("ii", $matchid, $baller);
                                    $stmt->execute();
                                    $result = $stmt->get_result();
                                    if ($result->num_rows > 0) {
                                        while ($row = $result->fetch_assoc()) {
                                            $balls = $row['total_bowls'] - ($row['wides'] + $row['noball']);
                                            $overs = floor($balls / 6); // Get the full overs
                                            $remainingBalls = $balls % 6;
                                            $total_score = $row['total_score'] + ($row['wides'] + $row['noball']) - ($row['legby_sum'] + $row['byes_sum']);
                                            $totalWicket = $row['total_wickets'];

// wicket count 
                                            $wsql = "SELECT COUNT(CASE WHEN wicket IS NOT NULL AND wicket = 'Run Out' THEN 0 END) AS wickets FROM wicket WHERE matchid = $matchid AND baller = $baller";
                                            $wresult = $conn->query($wsql);

if ($wresult->num_rows > 0) {
                                                while ($wrow = $wresult->fetch_assoc()) {
                                                    $totalWicket = $totalWicket  - $wrow['wickets'];
                                                }
                                            }
                                            echo "
                                                        <td>$overs.$remainingBalls</td>
                                                        <td>{$total_score}</td>
                                                        <td>{$totalWicket}</td>
                                                        <td>{$row['wides']}</td>
                                                        <td>{$row['noball']}</td>
                                                     ";
                                        }
                                    } else {

?>
                                        <td id="overs1">0</td>
                                        <td id="bruns1">0</td>
                                        <td id="wickets1">0</td>
                                        <td id="noballs1">0</td>
                                        <td id="sixes2">0</td>
                                    <?php } ?>
                                </tr>
                        <?php }
                        } ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

<?php

$sql = "SELECT `id`, `match_id`, `innings`, `striker`, `nonstriker`, `baller`, `bowlCount`, `score`, `extra`, `byes`, `wicket` FROM `score` WHERE `innings` =  2 AND `match_id` = $matchid ORDER BY `id` ASC";
    $result = $conn->query($sql);

$overs = [];
    $currentOver = 0;
    $ballCount = 0;

if (!isset($overs[$currentOver])) {
                $overs[$currentOver] = [];
            }

$overs[$currentOver][] = $ballText;

if (!$extra) { // Count only legal deliveries
                $ballCount++;
            }

<?php
            $batsmenOrder = []; // Array to maintain batting order

// Fetch all batting details in order of play
            $battingQuery = "SELECT striker, nonstriker,`baller` FROM `score` WHERE `innings` = 2 AND `match_id` = $matchid ORDER BY id ASC";
            $battingResult = mysqli_query($conn, $battingQuery);

$statsResult = mysqli_query($conn, $statsQuery);
                            $statsRow = mysqli_fetch_assoc($statsResult);

// Calculate final values
                            $totalRuns = $statsRow['total_score'] - ($statsRow['legby_sum'] + $statsRow['byes_sum']);
                            $ballsFaced = $statsRow['balls_faced'];
                            $strikeRate = ($ballsFaced > 0) ? sprintf("%.2f", ($totalRuns / $ballsFaced) * 100) : "0.00";
                            $btfours = ($statsRow['fours'] > 0) ? $statsRow['fours'] : "0";
                            $btsix = ($statsRow['sixes']) ? $statsRow['sixes'] : "0";

// wicket

// end wicket

echo "
                        </td>
                        <td>{$totalRuns}</td>
                        <td>{$ballsFaced}</td>
                        <td>{$btfours}</td>
                        <td>{$btsix}</td>
                        <td>{$strikeRate}</td>
                      </tr>";
                        }
                        ?>
                    </tbody>
                </table>
            </div>

</div>
    </div>

<div class="table-responsive mb-4">
            <table class="table">
                <thead class="table-light">
                    <tr>
                        <th>Bowler</th>
                        <th>Overs</th>
                        <th>Runs</th>
                        <th>Wickets</th>
                        <th>Wides</th>
                        <th>NO-Balls</th>
                    </tr>
                </thead>
                <tbody id="bowlers">
                    <?php
                    $match = "SELECT `id`, `match_id`, `innings`, `striker`, `nonstriker`, `baller`, `bowlCount`, `score`, `extra`, `byes`, `wicket` FROM `score` WHERE `innings` =  2 AND `match_id` = $matchid GROUP BY baller;";
                    $allmatch = mysqli_query($conn, $match);
                    if ($allmatch) {
                        while ($matchRow = mysqli_fetch_assoc($allmatch)) {
                            $baller = $matchRow['baller'];
                    ?>
                            <tr>
                                <td><?php
                                    $palyer = "SELECT `id`, `name`, `dob`, `player`, `club`, `bat`, `boll`, `image`, `isDelete` FROM `players` WHERE id = $baller";
                                    $allplayer = mysqli_query($conn, $palyer);
                                    if ($allplayer) {
                                        $playerRow = mysqli_fetch_assoc($allplayer);
                                        echo $playerRow['name'];
                                    }
                                    ?>
                                </td>
                                <?php
                                $sql = "SELECT baller, SUM(score) AS total_score,
                                            COUNT(CASE WHEN bowlCount IS NOT NULL AND bowlCount > 0 THEN 0 END) AS total_bowls,
                                            COUNT(CASE WHEN wicket IS NOT NULL AND wicket != '' THEN 0 END) AS total_wickets,
                                            COUNT(CASE WHEN extra IS NOT NULL AND extra = 'wide' THEN 0 END) AS wides,
                                            COUNT(CASE WHEN extra IS NOT NULL AND extra = 'noball' THEN 0 END) AS noball,
                                            SUM(CASE WHEN byes = 'legby' THEN score ELSE 0 END) AS legby_sum,
                                            SUM(CASE WHEN byes = 'Byes' THEN score ELSE 0 END) AS byes_sum
                                            FROM score 
                                            WHERE match_id = ? AND baller = ?  AND innings = 2
                                            GROUP BY baller";

$stmt = $conn->prepare($sql);
                                $stmt->bind_param("ii", $matchid, $baller);
                                $stmt->execute();
                                $result = $stmt->get_result();
                                if ($result->num_rows > 0) {
                                    while ($row = $result->fetch_assoc()) {
                                        $balls = $row['total_bowls'] - ($row['wides'] + $row['noball']);
                                        $overs = floor($balls / 6); // Get the full overs
                                        $remainingBalls = $balls % 6;
                                        $total_score = $row['total_score'] + ($row['wides'] + $row['noball']) - ($row['legby_sum'] + $row['byes_sum']);
                                        $totalWicket = $row['total_wickets'];

// wicket count 
                                        $wsql = "SELECT COUNT(CASE WHEN wicket IS NOT NULL AND wicket = 'Run Out' THEN 0 END) AS wickets FROM wicket WHERE matchid = $matchid AND baller = $baller";
                                        $wresult = $conn->query($wsql);

if ($wresult->num_rows > 0) {
                                            while ($wrow = $wresult->fetch_assoc()) {
                                                $totalWicket = $totalWicket  - $wrow['wickets'];
                                            }
                                        }
                                        echo "
                                                    <td>$overs.$remainingBalls</td>
                                                    <td>{$total_score}</td>
                                                    <td>{$totalWicket}</td>
                                                    <td>{$row['wides']}</td>
                                                    <td>{$row['noball']}</td>
                                                 ";
                                    }
                                } else {

?>
                                    <td id="overs1">0</td>
                                    <td id="bruns1">0</td>
                                    <td id="wickets1">0</td>
                                    <td id="noballs1">0</td>
                                    <td id="sixes2">0</td>
                                <?php } ?>
                            </tr>
                    <?php }
                    } ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

</body>

</html>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	tecnsujc/nobody	0750	2025-11-04 12:49:10
..	dir	-	tecnsujc/tecnsujc	0711	2025-10-10 08:52:30
DB	dir	-	tecnsujc/tecnsujc	0755	2025-11-03 07:41:32
admin	dir	-	tecnsujc/tecnsujc	0755	2025-11-04 12:51:47
assets	dir	-	tecnsujc/tecnsujc	0755	2025-11-04 12:51:47
club	dir	-	tecnsujc/tecnsujc	0755	2025-11-03 07:41:32
images	dir	-	tecnsujc/tecnsujc	0755	2025-11-04 12:51:47
includes	dir	-	tecnsujc/tecnsujc	0755	2025-11-03 07:41:32
lives	dir	-	tecnsujc/tecnsujc	0755	2025-11-03 07:41:32
.htaccess	text/plain	2 KB	tecnsujc/tecnsujc	0444	2025-11-04 12:49:10
admin.zip	application/zip	80.53 MB	tecnsujc/tecnsujc	0644	2025-03-07 01:08:47
allsold.php	text/x-php	1.48 KB	tecnsujc/tecnsujc	0666	2025-02-02 06:02:06
auction-result.php	text/html	5.82 KB	tecnsujc/tecnsujc	0666	2025-02-02 06:02:17
connection.php	text/x-php	380 B	tecnsujc/tecnsujc	0666	2025-03-07 02:53:58
contact.php	text/x-php	1.39 KB	tecnsujc/tecnsujc	0666	2025-03-03 07:24:29
dashboard.php	text/x-php	9.78 KB	tecnsujc/tecnsujc	0666	2025-02-02 06:02:19
error_log	text/plain	80.93 KB	tecnsujc/tecnsujc	0644	2025-11-02 08:21:26
index.php	text/x-php	30.95 KB	tecnsujc/tecnsujc	0444	2025-11-04 12:48:58
live.php	text/plain	10.78 KB	tecnsujc/tecnsujc	0666	2025-02-02 06:55:56
liveMatch.php	application/javascript	957 B	tecnsujc/tecnsujc	0666	2025-03-04 05:12:06
liveauction.php	text/html	5.06 KB	tecnsujc/tecnsujc	0666	2025-02-02 06:02:20
m.php	application/octet-stream	9.94 KB	tecnsujc/tecnsujc	0644	2025-08-22 10:45:48
match.php	text/x-php	1.5 KB	tecnsujc/tecnsujc	0666	2025-03-03 07:26:57
new-login.php	text/x-php	4.33 KB	tecnsujc/tecnsujc	0666	2025-02-02 06:02:21
players.php	text/x-php	4.79 KB	tecnsujc/tecnsujc	0666	2025-02-25 07:19:58
points.php	text/x-php	3.84 KB	tecnsujc/tecnsujc	0666	2025-02-02 08:18:17
pointsTable.php	text/x-php	2.05 KB	tecnsujc/tecnsujc	0666	2025-03-03 07:40:35
postnews.php	text/x-php	5.91 KB	tecnsujc/tecnsujc	0444	2025-11-03 07:41:32
robots.txt	text/plain	78 B	tecnsujc/tecnsujc	0644	2025-11-04 12:49:10
status.php	text/x-php	7.24 KB	tecnsujc/tecnsujc	0666	2025-03-06 06:22:18
team_list.php	text/plain	9.78 KB	tecnsujc/tecnsujc	0666	2025-03-06 08:37:16
viewScore.php	text/html	44.44 KB	tecnsujc/tecnsujc	0666	2025-03-06 07:43:14
yappu.php	text/plain	1.42 KB	tecnsujc/tecnsujc	0666	2025-03-03 07:26:15

For more Private tool come to me!

https://t.me/aDriv4vz