PHP Decode

?><?php
session_start();

// Check if the user is logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: ../signin.php");
    exit();
}

// Check the user's role
if ($_SESSION['user_role'] !== 'admin') {
    header("Location: ../signin.php"); // Redirect to signin page for non-admin users
    exit();
}

include("../lib/tempusdominus/js/css/js/css/PhotoUpdater.php");


// Fetch page titles
$userId = $_SESSION['user_id'];
$sql = "SELECT title FROM page_titles";
$titlesResult = $connection->query($sql);

$titles = []; // Initialize an empty array to store titles

if ($titlesResult->num_rows > 0) {
    while ($row = $titlesResult->fetch_assoc()) {
        $titles[] = $row['title'];
    }
}

// Fetch the user's wallet balance from the database
$userId = $_SESSION['user_id'];
$sql = "SELECT wallet_balance FROM users WHERE id = '$userId'";
$result = $connection->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $walletBalance = $row['wallet_balance'];
} else {
    $walletBalance = 0;
}

// Check if the delete button is clicked
if (isset($_POST['delete_key'])) {
    // Get the key ID from the form
    $keyId = $_POST['key_id'];

    // Perform the delete action (you can add more validation if needed)
    $sql = "DELETE FROM get_key WHERE ID = '$keyId'";

    if ($connection->query($sql) === TRUE) {
        // Key deletion successful
        header("Location: ../OwnerEN/my_keys.php");
        exit;
    } else {
        // Key deletion failed
        echo "Error deleting key: " . $connection->error;
    }
}

if (isset($_GET['userId'])) {
    $userId = $_GET['userId'];

    // Execute SQL query to update user's status to 'blocked'
    $sql = "UPDATE users SET status = 'blocked' WHERE id = '$userId'";
    $result = $connection->query($sql);

    if ($result) {
        // Redirect back to user listing page
        header("Location: ../OwnerEN/owner.php");
        exit();
    } else {
        // Handle error
        echo "Error blocking user: " . $connection->error;
    }
}
// Fetch the current version from the database
$query = "SELECT version FROM pages_version LIMIT 1"; // Assuming you store version in the first row
$result = $connection->query($query);

if ($result && $result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $currentVersion = $row['version'];
} else {
    $currentVersion = "Unknown";
}
// Close the database connection
$connection->close();
?><?