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
require_once 'config/database.php';

$pdo = getDBConnection();

echo "<h2>Enhancing Music Cards with Detailed Information</h2>";

// Get a sample track to see what metadata is available
$stmt = $pdo->query("
    SELECT id, title, prompt, status, audio_url, duration, metadata, created_at 
    FROM music_tracks 
    WHERE status = 'complete' AND metadata IS NOT NULL
    ORDER BY created_at DESC 
    LIMIT 3
");

$tracks = $stmt->fetchAll();

foreach ($tracks as $track) {
    echo "<h3>Track: " . htmlspecialchars($track['title']) . "</h3>";
    echo "<p>ID: " . $track['id'] . "</p>";
    echo "<p>Status: " . $track['status'] . "</p>";
    echo "<p>Audio URL: " . ($track['audio_url'] ?: 'None') . "</p>";
    echo "<p>Duration: " . $track['duration'] . "s</p>";
    
    if ($track['metadata']) {
        $metadata = json_decode($track['metadata'], true);
        echo "<p><strong>Metadata:</strong></p>";
        echo "<pre>" . json_encode($metadata, JSON_PRETTY_PRINT) . "</pre>";
        
        // Extract specific information
        if (isset($metadata['data']['data'][0])) {
            $audio_data = $metadata['data']['data'][0];
            echo "<p><strong>Extracted Info:</strong></p>";
            echo "<ul>";
            echo "<li>Title: " . ($audio_data['title'] ?? 'N/A') . "</li>";
            echo "<li>Prompt: " . ($audio_data['prompt'] ?? 'N/A') . "</li>";
            echo "<li>Tags: " . ($audio_data['tags'] ?? 'N/A') . "</li>";
            echo "<li>Model: " . ($audio_data['model_name'] ?? 'N/A') . "</li>";
            echo "<li>Duration: " . ($audio_data['duration'] ?? 'N/A') . "s</li>";
            echo "<li>Image URL: " . ($audio_data['image_url'] ?? 'N/A') . "</li>";
            echo "</ul>";
        }
    } else {
        echo "<p>No metadata available</p>";
    }
    
    echo "<hr>";
}

echo "<h3>Sample Enhanced Music Card HTML</h3>";

// Generate sample enhanced HTML for a track
if (!empty($tracks)) {
    $track = $tracks[0];
    $metadata = json_decode($track['metadata'], true);
    $audio_data = $metadata['data']['data'][0] ?? null;
    
    echo '<div class="music-card enhanced" data-type="music" data-status="complete">';
    echo '<div class="music-header">';
    echo '<div>';
    echo '<div class="music-title">' . htmlspecialchars($track['title']) . '</div>';
    echo '<div class="music-prompt">' . htmlspecialchars($track['prompt']) . '</div>';
    echo '</div>';
    echo '<div class="music-status status-complete">Complete</div>';
    echo '</div>';
    
    // Enhanced details section
    echo '<div class="music-details-enhanced">';
    echo '<div class="detail-row">';
    echo '<span><i class="fas fa-clock"></i> ' . $track['duration'] . 's</span>';
    echo '<span><i class="fas fa-calendar"></i> ' . date('M j, Y', strtotime($track['created_at'])) . '</span>';
    echo '</div>';
    
    if ($audio_data) {
        echo '<div class="detail-row">';
        echo '<span><i class="fas fa-tag"></i> ' . ($audio_data['tags'] ?? 'No tags') . '</span>';
        echo '<span><i class="fas fa-cog"></i> ' . ($audio_data['model_name'] ?? 'Unknown model') . '</span>';
        echo '</div>';
        
        echo '<div class="track-image">';
        echo '<img src="' . htmlspecialchars($audio_data['image_url'] ?: '/uploads/track_covers/track_45_1754191923.jpg') . '" alt="Track Artwork" style="width: 100%; height: 120px; object-fit: cover; border-radius: 8px; margin: 10px 0;">';
        echo '</div>';
    }
    echo '</div>';
    
    // Lyrics section (if available)
    if ($audio_data && !empty($audio_data['prompt'])) {
        echo '<div class="lyrics-section">';
        echo '<h4><i class="fas fa-music"></i> Lyrics/Prompt</h4>';
        echo '<div class="lyrics-content">';
        echo '<pre style="background: rgba(255,255,255,0.1); padding: 10px; border-radius: 8px; font-size: 12px; max-height: 100px; overflow-y: auto;">' . htmlspecialchars($audio_data['prompt']) . '</pre>';
        echo '</div>';
        echo '</div>';
    }
    
    // Actions
    echo '<div class="music-actions">';
    echo '<button class="btn btn-primary play-btn" onclick="playTrack(\'' . htmlspecialchars($track['audio_url']) . '\', \'' . htmlspecialchars($track['title']) . '\', \'SoundStudioPro\')">';
    echo '<i class="fas fa-play"></i> Play';
    echo '</button>';
    echo '<a href="' . htmlspecialchars($track['audio_url']) . '" class="btn btn-secondary" download>';
    echo '<i class="fas fa-download"></i> Download';
    echo '</a>';
    echo '<button class="btn btn-success" onclick="shareTrack(' . $track['id'] . ', \'' . htmlspecialchars($track['title']) . '\')">';
    echo '<i class="fas fa-share"></i> Share';
    echo '</button>';
    echo '</div>';
    echo '</div>';
}

echo "<h3>✅ Analysis Complete!</h3>";
echo "<p>I can see that the metadata contains rich information including:</p>";
echo "<ul>";
echo "<li>Original prompt/lyrics</li>";
echo "<li>Generated title</li>";
echo "<li>Tags and genre information</li>";
echo "<li>Model used</li>";
echo "<li>Track artwork</li>";
echo "<li>Duration and other metadata</li>";
echo "</ul>";
echo "<p>This information can be displayed in enhanced music cards!</p>";
?>