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/32646c3d/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
session_start();

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    echo "Not logged in";
    exit;
}

require_once 'config/database.php';

// Get user's tracks
$user_tracks = getUserMusicTracks($_SESSION['user_id']);

echo "<h1>Library Debug Test</h1>";
echo "<p>User ID: " . $_SESSION['user_id'] . "</p>";
echo "<p>Total tracks: " . count($user_tracks) . "</p>";

if (empty($user_tracks)) {
    echo "<p>No tracks found</p>";
    exit;
}

echo "<h2>Track Details:</h2>";
foreach ($user_tracks as $track) {
    echo "<div style='border: 1px solid #ccc; margin: 10px; padding: 10px;'>";
    echo "<h3>" . htmlspecialchars($track['title']) . "</h3>";
    echo "<p>Status: " . htmlspecialchars($track['status']) . "</p>";
    echo "<p>Audio URL: " . htmlspecialchars($track['audio_url']) . "</p>";
    echo "<p>Music Type: " . htmlspecialchars($track['music_type']) . "</p>";
    
    // Check variations
    $pdo = getDBConnection();
    $stmt = $pdo->prepare("SELECT COUNT(*) as variation_count FROM audio_variations WHERE track_id = ?");
    $stmt->execute([$track['id']]);
    $variation_count = $stmt->fetch()['variation_count'];
    echo "<p>Variations: " . $variation_count . "</p>";
    
    if ($variation_count > 0) {
        $stmt = $pdo->prepare("SELECT * FROM audio_variations WHERE track_id = ? ORDER BY variation_index");
        $stmt->execute([$track['id']]);
        $variations = $stmt->fetchAll();
        
        echo "<h4>Variations:</h4>";
        foreach ($variations as $variation) {
            echo "<div style='margin-left: 20px;'>";
            echo "<p>V" . ($variation['variation_index'] + 1) . ": " . htmlspecialchars($variation['title']) . "</p>";
            echo "<p>URL: " . htmlspecialchars($variation['audio_url']) . "</p>";
            echo "</div>";
        }
    }
    
    echo "</div>";
}

echo "<h2>Test Audio URLs:</h2>";
foreach ($user_tracks as $track) {
    if ($track['status'] === 'complete' && !empty($track['audio_url'])) {
        echo "<div style='margin: 10px;'>";
        echo "<h4>" . htmlspecialchars($track['title']) . "</h4>";
        echo "<audio controls style='width: 300px;'>";
        echo "<source src='" . htmlspecialchars($track['audio_url']) . "' type='audio/mpeg'>";
        echo "Your browser does not support the audio element.";
        echo "</audio>";
        echo "</div>";
    }
}
?>