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>🔍 API Track Check</h1>";

// Your API key (replace with actual key)
$api_key = 'YOUR_API_KEY_HERE'; // Replace this with your actual API key

$url = 'https://api.box.com/v1/tracks';
$headers = [
    'Authorization: Bearer ' . $api_key,
    'Content-Type: application/json'
];

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

$response = curl_exec($ch);
$http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);

echo "<h2>API Response:</h2>";
echo "<p>HTTP Code: $http_code</p>";

if ($http_code === 200) {
    $data = json_decode($response, true);
    echo "<p style='color: green;'>✅ API connection successful!</p>";
    echo "<p>Total tracks in API: " . count($data['data'] ?? []) . "</p>";
    
    if (isset($data['data'])) {
        echo "<h3>Track Status Breakdown:</h3>";
        $status_counts = [];
        foreach ($data['data'] as $track) {
            $status = $track['status'] ?? 'unknown';
            $status_counts[$status] = ($status_counts[$status] ?? 0) + 1;
        }
        
        foreach ($status_counts as $status => $count) {
            echo "<p>$status: $count</p>";
        }
    }
} else {
    echo "<p style='color: red;'>❌ API connection failed!</p>";
    echo "<p>Response: $response</p>";
}

echo "<h2>Database Check:</h2>";
try {
    $pdo = getDBConnection();
    $stmt = $pdo->query("SELECT COUNT(*) as total FROM music_tracks");
    $result = $stmt->fetch();
    echo "<p>Total tracks in database: " . $result['total'] . "</p>";
    
    $stmt = $pdo->query("SELECT status, COUNT(*) as count FROM music_tracks GROUP BY status");
    while ($row = $stmt->fetch()) {
        echo "<p>" . $row['status'] . ": " . $row['count'] . "</p>";
    }
} catch (Exception $e) {
    echo "<p style='color: red;'>❌ Database error: " . $e->getMessage() . "</p>";
}

echo "<h2>Next Steps:</h2>";
echo "<p>1. Replace 'YOUR_API_KEY_HERE' with your actual API key</p>";
echo "<p>2. Run this script to see the difference</p>";
echo "<p>3. Use the admin sync tool to pull missing tracks</p>";
?>