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
// Check Adagio for Strings track
require_once 'config/database.php';

$pdo = getDBConnection();

// Find the track
$stmt = $pdo->prepare("SELECT * FROM music_tracks WHERE title LIKE '%Adagio%' LIMIT 5");
$stmt->execute();
$tracks = $stmt->fetchAll();

echo "<h1>Adagio for Strings Track Check</h1>";

foreach ($tracks as $track) {
    echo "<h2>Track ID: {$track['id']}</h2>";
    echo "<table border='1' style='border-collapse: collapse; margin: 20px 0;'>";
    echo "<tr><th>Field</th><th>Value</th></tr>";
    echo "<tr><td>Title</td><td>{$track['title']}</td></tr>";
    echo "<tr><td>Task ID</td><td>" . ($track['task_id'] ?: 'NULL') . "</td></tr>";
    echo "<tr><td>Audio URL</td><td>" . htmlspecialchars($track['audio_url'] ?: 'NULL') . "</td></tr>";
    echo "<tr><td>Status</td><td>{$track['status']}</td></tr>";
    echo "<tr><td>Is Public</td><td>" . ($track['is_public'] ?: 'NULL') . "</td></tr>";
    
    // Check if URL needs conversion
    $audioUrl = $track['audio_url'] ?? '';
    $taskId = $track['task_id'] ?? '';
    
    echo "<tr><td>Needs Conversion?</td><td>";
    if (!empty($audioUrl) && !empty($taskId)) {
        if (strpos($audioUrl, 'http') === 0 || 
            strpos($audioUrl, 'api.box') !== false || 
            strpos($audioUrl, 'apiboxfiles.erweima.ai') !== false) {
            echo "YES - External URL detected";
            $convertedUrl = '/utils/audiofiles.php?id=' . urlencode($taskId);
            echo "<br>Should be: " . htmlspecialchars($convertedUrl);
        } else {
            echo "NO - Already local/proxy";
        }
    } else {
        echo "CAN'T CONVERT - Missing task_id or audio_url";
    }
    echo "</td></tr>";
    
    echo "</table>";
    
    // Test the proxy URL
    if (!empty($taskId)) {
        $proxyUrl = '/utils/audiofiles.php?id=' . urlencode($taskId);
        echo "<p><a href='{$proxyUrl}' target='_blank'>Test Proxy URL</a></p>";
    }
}

?>