Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/soundstudiopro.com/private_html/utils/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
// Setup demo user for SoundStudioPro
require_once 'config/database.php';

echo "<h1>Setting up Demo User</h1>";

try {
    $pdo = getDBConnection();
    if (!$pdo) {
        echo "<p style='color: red;'>❌ Database connection failed!</p>";
        exit;
    }
    
    // Check if demo user already exists
    $stmt = $pdo->prepare("SELECT * FROM users WHERE email = ?");
    $stmt->execute(['demo@soundstudiopro.com']);
    $existingUser = $stmt->fetch();
    
    if ($existingUser) {
        echo "<p style='color: orange;'>⚠️ Demo user already exists!</p>";
        echo "<p>User ID: " . $existingUser['id'] . "</p>";
        echo "<p>Name: " . $existingUser['name'] . "</p>";
        echo "<p>Credits: " . $existingUser['credits'] . "</p>";
        echo "<p>Plan: " . $existingUser['plan'] . "</p>";
    } else {
        // Create demo user
        $demoName = 'Demo User';
        $demoEmail = 'demo@soundstudiopro.com';
        $demoPassword = 'demo123';
        
        if (createUser($demoName, $demoEmail, $demoPassword)) {
            echo "<p style='color: green;'>✅ Demo user created successfully!</p>";
            
            // Get the created user to show details
            $stmt = $pdo->prepare("SELECT * FROM users WHERE email = ?");
            $stmt->execute([$demoEmail]);
            $user = $stmt->fetch();
            
            echo "<p>User ID: " . $user['id'] . "</p>";
            echo "<p>Name: " . $user['name'] . "</p>";
            echo "<p>Credits: " . $user['credits'] . "</p>";
            echo "<p>Plan: " . $user['plan'] . "</p>";
        } else {
            echo "<p style='color: red;'>❌ Failed to create demo user!</p>";
        }
    }
    
    // Also create admin user
    $stmt = $pdo->prepare("SELECT * FROM users WHERE email = ?");
    $stmt->execute(['admin@soundstudiopro.com']);
    $existingAdmin = $stmt->fetch();
    
    if (!$existingAdmin) {
        $adminName = 'Admin User';
        $adminEmail = 'admin@soundstudiopro.com';
        $adminPassword = 'admin123';
        
        if (createUser($adminName, $adminEmail, $adminPassword)) {
            // Update admin to have more credits and pro plan
            $stmt = $pdo->prepare("UPDATE users SET credits = 100, plan = 'pro' WHERE email = ?");
            $stmt->execute([$adminEmail]);
            
            echo "<p style='color: green;'>✅ Admin user created successfully!</p>";
        }
    }
    
    echo "<h2>Available Demo Credentials:</h2>";
    echo "<ul>";
    echo "<li><strong>Demo User:</strong> demo@soundstudiopro.com / demo123</li>";
    echo "<li><strong>Admin User:</strong> admin@soundstudiopro.com / admin123</li>";
    echo "</ul>";
    
    echo "<p><a href='/auth/login.php'>Go to Login Page</a></p>";
    
} catch (Exception $e) {
    echo "<p style='color: red;'>❌ Error: " . $e->getMessage() . "</p>";
}
?>