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 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;
}


    
    // Get the user ID from the session
$userId = $_SESSION['user_id'];

// 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'];
    }
}

// Handle form submission for updating titles
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $newTitles = $_POST['titles'];

    // Delete existing titles from the table
    $deleteSql = "DELETE FROM page_titles";
    $connection->query($deleteSql);

    // Insert new titles into the table
    foreach ($newTitles as $newTitle) {
        $insertSql = "INSERT INTO page_titles (title) VALUES ('$newTitle')";
        $connection->query($insertSql);
    }

    // Redirect or show success message
}

// Handle form submission for adding new title
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['newTitle'])) {
    $newTitle = $_POST['newTitle'];

    // Insert the new title into the table
    $insertSql = "INSERT INTO page_titles (title) VALUES ('$newTitle')";
    $connection->query($insertSql);

    // Redirect or show success message
}


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

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $_SESSION['profile_photo'] = $row['profile_photo']; // Update the session variable
}

// 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();
?>
<?