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/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
session_start();
require_once 'config/database.php';

// Only allow admin to run this
if (!isset($_SESSION['user_id']) || !isset($_SESSION['is_admin']) || !$_SESSION['is_admin']) {
    die('Access denied. Admin only.');
}

$pdo = getDBConnection();

echo "<h1>🎉 Adding Private Password Party Columns</h1>";

try {
    // Check if columns exist
    $columns = $pdo->query("SHOW COLUMNS FROM events LIKE 'is_private_party'")->fetch();
    if (!$columns) {
        $pdo->exec("ALTER TABLE events ADD COLUMN is_private_party BOOLEAN DEFAULT FALSE AFTER is_featured");
        echo "<p>✅ Added is_private_party column</p>";
    } else {
        echo "<p>ℹ️ is_private_party column already exists</p>";
    }
    
    $columns = $pdo->query("SHOW COLUMNS FROM events LIKE 'party_password'")->fetch();
    if (!$columns) {
        $pdo->exec("ALTER TABLE events ADD COLUMN party_password VARCHAR(255) NULL AFTER is_private_party");
        echo "<p>✅ Added party_password column</p>";
    } else {
        echo "<p>ℹ️ party_password column already exists</p>";
    }
    
    echo "<p><strong>✅ Migration complete!</strong></p>";
} catch (Exception $e) {
    echo "<p style='color: red;'>❌ Error: " . htmlspecialchars($e->getMessage()) . "</p>";
}
?>