🐚 WEB SHELL ACTIVATED

📁 File Browser

Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads

📄 Viewing: ./../../../../587164.klas4s23.mid-ica.nl/public_html/ELearner/setup_admin.php

<?php
include "db.php";

// Check if admin column exists in users table
try {
    $conn->query("SELECT is_admin FROM users LIMIT 1");
    $column_exists = true;
} catch (PDOException $e) {
    $column_exists = false;
}

// Add admin column if it doesn't exist
if (!$column_exists) {
    try {
        $conn->exec("ALTER TABLE users ADD COLUMN is_admin TINYINT(1) NOT NULL DEFAULT 0");
        echo "Added is_admin column to users table.<br>";
    } catch (PDOException $e) {
        echo "Error adding column: " . $e->getMessage() . "<br>";
    }
}

// Check if admin user exists
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->execute(['admin']);
$admin_exists = $stmt->fetch() ? true : false;

// Create admin user if it doesn't exist
if (!$admin_exists) {
    try {
        // Hash password 'admin'
        $hashed_password = password_hash('admin', PASSWORD_DEFAULT);
        
        $stmt = $conn->prepare("INSERT INTO users (username, password, is_admin) VALUES (?, ?, 1)");
        $stmt->execute(['admin', $hashed_password]);
        
        echo "Admin user created successfully!<br>";
        echo "Username: admin<br>";
        echo "Password: admin<br>";
    } catch (PDOException $e) {
        echo "Error creating admin user: " . $e->getMessage() . "<br>";
    }
} else {
    echo "Admin user already exists.<br>";
}

echo "<br>You can now <a href='login.php'>login</a> with username 'admin' and password 'admin'.";
?>

🎯 Available Actions