check_data.php

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

echo "<h2>📋 Verificação de Dados no Banco</h2>";
echo "<pre>";

try {
    // Competências
    $stmt = $pdo->query('SELECT COUNT(*) as count FROM competencies');
    $count = $stmt->fetch()['count'];
    echo "Competências: $count registros\n";

    if ($count > 0) {
        $stmt = $pdo->query('SELECT name, category FROM competencies LIMIT 5');
        $comps = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach ($comps as $comp) {
            echo "  - {$comp['name']} ({$comp['category']})\n";
        }
    } else {
        echo "  ⚠️ Nenhuma competência cadastrada!\n";
    }

    // Badges
    $stmt = $pdo->query('SELECT COUNT(*) as count FROM badges');
    $count = $stmt->fetch()['count'];
    echo "\nBadges: $count registros\n";

    if ($count > 0) {
        $stmt = $pdo->query('SELECT name, type FROM badges LIMIT 5');
        $badges = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach ($badges as $badge) {
            echo "  - {$badge['name']} ({$badge['type']})\n";
        }
    } else {
        echo "  ⚠️ Nenhum badge cadastrado!\n";
    }

    // Usuários
    $stmt = $pdo->query('SELECT COUNT(*) as count FROM user_accounts');
    $count = $stmt->fetch()['count'];
    echo "\nUsuários: $count registros\n";

    if ($count > 0) {
        // Mostrar estrutura da tabela
        echo "\nEstrutura da tabela user_accounts:\n";
        $stmt = $pdo->query('DESCRIBE user_accounts');
        $columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach ($columns as $col) {
            echo "  - {$col['Field']}: {$col['Type']}\n";
        }

        echo "\nPrimeiros usuários:\n";
        $stmt = $pdo->query('SELECT * FROM user_accounts LIMIT 2');
        $users = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach ($users as $user) {
            echo "  - Email: {$user['email']}\n";
        }
    }

} catch (Exception $e) {
    echo "❌ Erro: " . $e->getMessage() . "\n";
}

echo "</pre>";
?>