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

echo "<h1>🔍 Check Existing Lyrics in Database</h1>";

try {
    $pdo = getDBConnection();
    
    // Check for any tracks with lyrics
    $lyrics_query = "SELECT id, title, lyrics, created_at FROM music_tracks WHERE lyrics IS NOT NULL AND lyrics != '' ORDER BY created_at DESC LIMIT 10";
    $lyrics_stmt = $pdo->query($lyrics_query);
    $tracks_with_lyrics = $lyrics_stmt->fetchAll(PDO::FETCH_ASSOC);
    
    if (empty($tracks_with_lyrics)) {
        echo "<p style='color: orange; font-weight: bold;'>⚠️ No tracks with lyrics found in database</p>";
        echo "<p>This means either:</p>";
        echo "<ul>";
        echo "<li>API.Box hasn't sent lyrics data yet</li>";
        echo "<li>The callback wasn't extracting lyrics properly (now fixed!)</li>";
        echo "<li>Your tracks don't have lyrics available</li>";
        echo "</ul>";
    } else {
        echo "<p style='color: green; font-weight: bold;'>✅ Found " . count($tracks_with_lyrics) . " tracks with lyrics!</p>";
        
        foreach ($tracks_with_lyrics as $track) {
            echo "<div style='border: 1px solid #ccc; margin: 10px; padding: 15px; border-radius: 8px; background: #e8f5e8;'>";
            echo "<h3>Track ID: {$track['id']}</h3>";
            echo "<p><strong>Title:</strong> " . htmlspecialchars($track['title']) . "</p>";
            echo "<p><strong>Created:</strong> {$track['created_at']}</p>";
            echo "<p><strong>Lyrics Preview:</strong> " . htmlspecialchars(substr($track['lyrics'], 0, 200)) . "...</p>";
            echo "<p><strong>Lyrics Length:</strong> " . strlen($track['lyrics']) . " characters</p>";
            echo "<p><strong>Test Link:</strong> <a href='track.php?id={$track['id']}' target='_blank'>View Track Page</a></p>";
            echo "</div>";
        }
    }
    
    // Check recent tracks without lyrics
    echo "<h2>🚫 Recent Tracks Without Lyrics</h2>";
    $no_lyrics_query = "SELECT id, title, created_at FROM music_tracks WHERE (lyrics IS NULL OR lyrics = '') ORDER BY created_at DESC LIMIT 5";
    $no_lyrics_stmt = $pdo->query($no_lyrics_query);
    
    while ($track = $no_lyrics_stmt->fetch(PDO::FETCH_ASSOC)) {
        echo "<div style='border: 1px solid #ccc; margin: 10px; padding: 15px; border-radius: 8px; background: #ffe8e8;'>";
        echo "<p><strong>Track ID:</strong> {$track['id']}</p>";
        echo "<p><strong>Title:</strong> " . htmlspecialchars($track['title']) . "</p>";
        echo "<p><strong>Created:</strong> {$track['created_at']}</p>";
        echo "<p><strong>Status:</strong> ❌ No lyrics</p>";
        echo "</div>";
    }
    
} catch (Exception $e) {
    echo "<p style='color: red;'>❌ Database error: " . htmlspecialchars($e->getMessage()) . "</p>";
}

echo "<hr>";
echo "<h2>🎯 Next Steps</h2>";
echo "<p>1. <strong>Callback Fixed:</strong> Lyrics extraction now handles nested API.Box structure</p>";
echo "<p>2. <strong>Test:</strong> Create a new track or wait for next callback</p>";
echo "<p>3. <strong>Check:</strong> Look for 'Found lyrics' in callback log</p>";
echo "<p>4. <strong>Verify:</strong> Lyrics should now appear on track pages</p>";
?>