����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

<?php
header('Content-Type: application/json');
require_once 'api/db.php';

$tables = [
    'users', 'dealers', 'tour_packages', 'tours', 'bookings', 
    'booking_passengers', 'booking_addons', 'payments', 
    'community_members', 'tour_addons', 'tour_media', 
    'tour_blogs', 'dealer_wallets'
];

$results = [
    'database_connection' => true,
    'tables' => [],
    'summary' => [
        'total' => count($tables),
        'missing' => 0,
        'readable' => 0
    ],
    'environment' => [
        'php_version' => PHP_VERSION,
        'server_software' => $_SERVER['SERVER_SOFTWARE'] ?? 'Unknown',
        'api_base_auto' => 'Detected'
    ]
];

foreach ($tables as $table) {
    try {
        $query = $conn->query("SELECT COUNT(*) as count FROM `$table` LIMIT 1");
        if ($query) {
            $row = $query->fetch_assoc();
            $results['tables'][$table] = [
                'exists' => true,
                'readable' => true,
                'rows' => (int)$row['count']
            ];
            $results['summary']['readable']++;
        } else {
            $results['tables'][$table] = [
                'exists' => false,
                'readable' => false,
                'error' => $conn->error
            ];
            $results['summary']['missing']++;
        }
    } catch (Exception $e) {
        $results['tables'][$table] = [
            'error' => $e->getMessage()
        ];
        $results['summary']['missing']++;
    }
}

// Check for default admin
$admin_check = $conn->query("SELECT role FROM users WHERE email = 'admin@throtllr.com' LIMIT 1");
$results['admin_user'] = [
    'exists' => ($admin_check && $admin_check->num_rows > 0),
    'email' => 'admin@throtllr.com'
];

echo json_encode($results, JSON_PRETTY_PRINT);
?>