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/.cursor-server/data/User/History/-2c006d7a/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * Quick script to check and enable public streaming for stations
 * Run this to see what stations exist and enable public streaming
 */

require_once __DIR__ . '/../config/database.php';

$pdo = getDBConnection();

echo "<h1>Radio Stations Status</h1>";
echo "<pre>";

// Get all stations
$stmt = $pdo->query("
    SELECT 
        id,
        station_name,
        call_sign,
        subscription_status,
        public_streaming_enabled,
        is_active
    FROM radio_stations
    ORDER BY id DESC
");

$stations = $stmt->fetchAll(PDO::FETCH_ASSOC);

if (empty($stations)) {
    echo "No stations found in database.\n";
    echo "You need to register stations first at /radio/register.php\n";
} else {
    echo "Found " . count($stations) . " station(s):\n\n";
    
    foreach ($stations as $station) {
        echo "ID: {$station['id']}\n";
        echo "Name: {$station['station_name']}\n";
        echo "Call Sign: " . ($station['call_sign'] ?: 'N/A') . "\n";
        echo "Status: {$station['subscription_status']}\n";
        echo "Public Streaming: " . ($station['public_streaming_enabled'] ? 'YES' : 'NO') . "\n";
        echo "Active: " . ($station['is_active'] ? 'YES' : 'NO') . "\n";
        echo "---\n";
    }
    
    echo "\n";
    echo "To enable public streaming for a station, run:\n";
    echo "UPDATE radio_stations SET public_streaming_enabled = 1 WHERE id = STATION_ID;\n";
    echo "\n";
    echo "Or use this form:\n";
    echo "<form method='POST'>";
    echo "Enable public streaming for Station ID: <input type='number' name='station_id' required>";
    echo "<button type='submit' name='enable'>Enable</button>";
    echo "</form>";
    
    if (isset($_POST['enable']) && isset($_POST['station_id'])) {
        $station_id = (int)$_POST['station_id'];
        $stmt = $pdo->prepare("UPDATE radio_stations SET public_streaming_enabled = 1 WHERE id = ?");
        $stmt->execute([$station_id]);
        echo "\n✅ Enabled public streaming for station ID: $station_id\n";
        echo "<meta http-equiv='refresh' content='2'>";
    }
}

echo "</pre>";
?>