OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📄 account_deletion.php	7.75 KB	03/26/2025 03:48:11 AM	rw-r--r--
📄 confirm_deletion.php	1.99 KB	03/26/2025 03:48:11 AM	rw-r--r--

Editing: confirm_deletion.php

<?
include '../assets/php/db_config.php';
header('Content-Type: application/json');

function update_deletion($request, $userId)
{
    global $creamdb;
    try {
        if ($request == "cancel") {
            $sql = "DELETE FROM acc_deletion WHERE userId = ?";
            $stmt = $creamdb->prepare($sql);

if ($stmt === false) {
                throw new mysqli_sql_exception("Error preparing the SQL statement: " . $creamdb->error);
            }
            $stmt->bind_param("i", $userId);
            $stmt->execute();
            if ($stmt->affected_rows > 0) {
                return ['status' => 'success', 'message' => 'Account Deletion is reverted successfully'];
            } else {
                throw new mysqli_sql_exception("No data found for the given credentials or deletion failed");
            }
        } else if ($request == "confirm") {
            $sql = "UPDATE acc_deletion SET status='confirmed' WHERE userId = ?";
            $stmt = $creamdb->prepare($sql);
            if ($stmt === false) {
                throw new mysqli_sql_exception("Error preparing the SQL statement: " . $creamdb->error);
            }
            $stmt->bind_param("i", $userId);

$stmt->execute();
            if ($stmt->affected_rows > 0) {
                return ['status' => 'success', 'message' => 'Account Deleted Successfully'];
            } else {
                throw new mysqli_sql_exception("No data found for the given credentials or deletion failed");
            }
        }
    } catch (mysqli_sql_exception $e) {
        return ['status' => 'error', 'message' => 'Error: ' . $e->getMessage()];
    } catch (Exception $e) {
        return ['status' => 'error', 'message' => 'Unexpected Error: ' . $e->getMessage()];
    } finally {
        if (isset($stmt)) {
            $stmt->close();
        }
    }
}

if (isset($_POST['request'], $_POST['userId'])) {
    echo json_encode(update_deletion($_POST['request'], $_POST['userId']));
}