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/.cursor-server/data/User/History/-167fa5dd/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
require_once 'config/database.php';

$pdo = getDBConnection();

// Check VIP tracks count
$stmt = $pdo->prepare("
    SELECT COUNT(*) as vip_count
    FROM music_tracks 
    WHERE status = 'complete' 
    AND audio_url IS NOT NULL 
    AND is_vip_sample = 1
");
$stmt->execute();
$vip_count = $stmt->fetchColumn();

echo "VIP tracks count: " . $vip_count . "\n";

// Get all VIP tracks with details
$stmt = $pdo->prepare("
    SELECT id, title, artist_name, is_vip_sample, status, audio_url
    FROM music_tracks mt
    JOIN users u ON mt.user_id = u.id
    WHERE mt.status = 'complete' 
    AND mt.audio_url IS NOT NULL 
    AND mt.is_vip_sample = 1
    ORDER BY mt.playlist_order ASC, mt.created_at DESC
");
$stmt->execute();
$vip_tracks = $stmt->fetchAll();

echo "VIP tracks details:\n";
foreach ($vip_tracks as $track) {
    echo "- ID: {$track['id']}, Title: {$track['title']}, Artist: {$track['artist_name']}\n";
}

// Check if there are any tracks that might be missing is_vip_sample flag
$stmt = $pdo->prepare("
    SELECT id, title, artist_name, is_vip_sample, status, audio_url, playlist_order
    FROM music_tracks mt
    JOIN users u ON mt.user_id = u.id
    WHERE mt.status = 'complete' 
    AND mt.audio_url IS NOT NULL 
    AND mt.playlist_order IS NOT NULL
    ORDER BY mt.playlist_order ASC
");
$stmt->execute();
$ordered_tracks = $stmt->fetchAll();

echo "\nTracks with playlist_order (potential VIP tracks):\n";
foreach ($ordered_tracks as $track) {
    $vip_flag = $track['is_vip_sample'] ? 'YES' : 'NO';
    echo "- ID: {$track['id']}, Title: {$track['title']}, VIP: {$vip_flag}, Order: {$track['playlist_order']}\n";
}
?>