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
// Diagnostic script to check track URLs and audio variations
session_start();
require_once 'config/database.php';

echo "<h2>Track URLs and Audio Variations Diagnostic</h2>";

$pdo = getDBConnection();
if (!$pdo) {
    echo "Database connection failed";
    exit;
}

// Check music_tracks table
echo "<h3>Music Tracks Table:</h3>";
$stmt = $pdo->query("SELECT id, task_id, title, audio_url, variations_count, status FROM music_tracks ORDER BY id");
$tracks = $stmt->fetchAll();

echo "<table border='1' style='border-collapse: collapse; width: 100%;'>";
echo "<tr><th>ID</th><th>Task ID</th><th>Title</th><th>Audio URL</th><th>Variations Count</th><th>Status</th></tr>";

foreach ($tracks as $track) {
    echo "<tr>";
    echo "<td>{$track['id']}</td>";
    echo "<td>{$track['task_id']}</td>";
    echo "<td>{$track['title']}</td>";
    echo "<td style='word-break: break-all;'>{$track['audio_url']}</td>";
    echo "<td>{$track['variations_count']}</td>";
    echo "<td>{$track['status']}</td>";
    echo "</tr>";
}
echo "</table>";

// Check audio_variations table
echo "<h3>Audio Variations Table:</h3>";
$stmt = $pdo->query("SELECT id, track_id, variation_index, audio_url, source_audio_url, title, duration FROM audio_variations ORDER BY track_id, variation_index");
$variations = $stmt->fetchAll();

if (empty($variations)) {
    echo "<p>No audio variations found in database.</p>";
} else {
    echo "<table border='1' style='border-collapse: collapse; width: 100%;'>";
    echo "<tr><th>ID</th><th>Track ID</th><th>Variation Index</th><th>Audio URL</th><th>Source Audio URL</th><th>Title</th><th>Duration</th></tr>";
    
    foreach ($variations as $variation) {
        echo "<tr>";
        echo "<td>{$variation['id']}</td>";
        echo "<td>{$variation['track_id']}</td>";
        echo "<td>{$variation['variation_index']}</td>";
        echo "<td style='word-break: break-all;'>{$variation['audio_url']}</td>";
        echo "<td style='word-break: break-all;'>{$variation['source_audio_url']}</td>";
        echo "<td>{$variation['title']}</td>";
        echo "<td>{$variation['duration']}</td>";
        echo "</tr>";
    }
    echo "</table>";
}

// Check for mismatches
echo "<h3>Potential Issues:</h3>";
$issues = [];

foreach ($tracks as $track) {
    if ($track['variations_count'] > 0) {
        $stmt = $pdo->prepare("SELECT COUNT(*) as count FROM audio_variations WHERE track_id = ?");
        $stmt->execute([$track['id']]);
        $actualVariations = $stmt->fetch()['count'];
        
        if ($actualVariations != $track['variations_count']) {
            $issues[] = "Track ID {$track['id']} (Task: {$track['task_id']}): Expected {$track['variations_count']} variations, found {$actualVariations}";
        }
    }
}

if (empty($issues)) {
    echo "<p>No obvious mismatches found.</p>";
} else {
    echo "<ul>";
    foreach ($issues as $issue) {
        echo "<li style='color: red;'>{$issue}</li>";
    }
    echo "</ul>";
}

// Check local audio files
echo "<h3>Local Audio Files Check:</h3>";
$audioDir = 'audio/';
if (is_dir($audioDir)) {
    $files = scandir($audioDir);
    $audioFiles = array_filter($files, function($file) {
        return pathinfo($file, PATHINFO_EXTENSION) === 'mp3';
    });
    
    if (empty($audioFiles)) {
        echo "<p>No local audio files found in {$audioDir}</p>";
    } else {
        echo "<p>Found " . count($audioFiles) . " local audio files:</p>";
        echo "<ul>";
        foreach ($audioFiles as $file) {
            echo "<li>{$file}</li>";
        }
        echo "</ul>";
    }
} else {
    echo "<p>Audio directory {$audioDir} not found.</p>";
}
?>