// ... existing code ...
    $table_licenses = $wpdb->prefix . 'cat_bkn_licenses';
    $sql_licenses = "CREATE TABLE $table_licenses (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        license_code varchar(50) NOT NULL,
        status varchar(20) DEFAULT 'active' NOT NULL,
        used_by varchar(100) DEFAULT '' NOT NULL,
        created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
        PRIMARY KEY  (id),
        UNIQUE KEY license_code (license_code)
    ) $charset_collate;";

    // 3. TABEL BARU: Tabel Bank Soal Asli
    $table_questions = $wpdb->prefix . 'cat_bkn_questions';
    $sql_questions = "CREATE TABLE $table_questions (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        category varchar(10) NOT NULL, /* TWK, TIU, TKP */
        question_text text NOT NULL,
        option_a text NOT NULL,
        option_b text NOT NULL,
        option_c text NOT NULL,
        option_d text NOT NULL,
        option_e text NOT NULL,
        correct_answer varchar(5) NOT NULL, /* A, B, C, D, atau E */
        explanation text NOT NULL,
        PRIMARY KEY  (id)
    ) $charset_collate;";

    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    dbDelta($sql_leaderboard);
    dbDelta($sql_licenses);
    dbDelta($sql_questions); // Eksekusi tabel soal
}// ... existing code ...
// MEMBUAT REST API (LEADERBOARD & VALIDASI LISENSI)
add_action('rest_api_init', function () {
    register_rest_route('cat-bkn/v1', '/leaderboard', array(
        array('methods' => 'GET', 'callback' => 'cat_bkn_get_leaderboard', 'permission_callback' => '__return_true'),
        array('methods' => 'POST', 'callback' => 'cat_bkn_post_score', 'permission_callback' => '__return_true')
    ));
    register_rest_route('cat-bkn/v1', '/verify-license', array(
        array('methods' => 'POST', 'callback' => 'cat_bkn_verify_license', 'permission_callback' => '__return_true')
    ));
    // Tambahkan baris ini di bawah route verify-license
    register_rest_route('cat-bkn/v1', '/questions', array(
        array('methods' => 'GET', 'callback' => 'cat_bkn_get_questions', 'permission_callback' => '__return_true')
    ));
});

function cat_bkn_verify_license(WP_REST_Request $request) {
// ... existing code ...
function cat_bkn_post_score(WP_REST_Request $request) {
    global $wpdb;
    $table_name = $wpdb->prefix . 'cat_bkn_leaderboard';
    $params = $request->get_json_params();
    if (empty($params['userId']) || !isset($params['score'])) return new WP_Error('invalid_data', 'Data tidak lengkap', array('status' => 400));
    $wpdb->insert($table_name, array(
        'user_id' => sanitize_text_field($params['userId']), 'display_name' => sanitize_text_field($params['displayName']),
        'score' => intval($params['score']), 'twk' => intval($params['twk']), 'tiu' => intval($params['tiu']),
        'tkp' => intval($params['tkp']), 'finished_at' => current_time('mysql')
    ));
    return rest_ensure_response(array('success' => true));
}

// FUNGSI UNTUK MENGAMBIL SOAL DARI DATABASE
function cat_bkn_get_questions() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'cat_bkn_questions';
    
    // Ambil semua soal dari database
    $results = $wpdb->get_results("SELECT * FROM $table_name");
    
    $data = array();
    foreach ($results as $r) {
        // Format data agar sesuai dengan struktur yang diminta JavaScript lama
        $data[] = array(
            'id' => $r->category . '_' . $r->id,
            'category' => $r->category,
            'text' => $r->question_text,
            'options' => array(
                'A' => $r->option_a,
                'B' => $r->option_b,
                'C' => $r->option_c,
                'D' => $r->option_d,
                'E' => $r->option_e
            ),
            'correct' => $r->correct_answer,
            'explanation' => $r->explanation
        );
    }
    return rest_ensure_response($data);
}// ... existing code ...
// APLIKASI UTAMA (HTML & JS)
add_action('template_redirect', 'cat_bkn_serve_app');
function cat_bkn_serve_app() {
    if (isset($_GET['simulasi_cat']) && $_GET['simulasi_cat'] === 'app') {

        $is_logged_in = is_user_logged_in();
        $current_user = wp_get_current_user();
        $wp_api_url = rest_url('cat-bkn/v1/leaderboard');
        $wp_api_verify_url = rest_url('cat-bkn/v1/verify-license');
        $wp_api_questions_url = rest_url('cat-bkn/v1/questions');
        ?>
<!DOCTYPE html>
<html lang="id">
// ... existing code ...
    <script type="text/javascript">
        const WP_API_URL = '';
        const WP_API_VERIFY_URL = '';
        const WP_API_QUESTIONS_URL = '';
        const WP_IS_LOGGED_IN = false;
        const WP_USER_ID = '';
        const WP_USER_NAME = '';
// ... existing code ...
        window.saveGuestNameAndStart = function() {
            const inputEl = document.getElementById('guest-name-input');
            const inputName = inputEl.value.trim();
            if (inputName.length < 3) {
                inputEl.classList.add('border-red-500', 'ring-1', 'ring-red-500'); inputEl.value = ""; inputEl.placeholder = "Minimal 3 huruf!"; return;
            }
            userDisplayName = inputName; userId = 'GUEST_' + Math.random().toString(36).substring(2, 10).toUpperCase();
            localStorage.setItem(`cat_guest_name_${appId}`, userDisplayName);
            localStorage.setItem(`cat_guest_id_${appId}`, userId);
            setupIdentity(); closeNameInput();
            if (pendingAction === 'startExam') { pendingAction = null; startRandomExam(); }
        };

        let fullBank = [];

        // Fungsi baru untuk memanggil soal asli dari database WordPress
        async function fetchRealQuestions() {
            try {
                const response = await fetch(WP_API_QUESTIONS_URL);
                if (response.ok) {
                    fullBank = await response.json();
                    
                    // Validasi jika database masih kosong
                    if (fullBank.length === 0) {
                        console.warn("Database soal masih kosong. Silakan input soal melalui phpMyAdmin.");
                    }
                } else {
                    throw new Error("Gagal mengambil data soal dari server.");
                }
            } catch (error) {
                console.error("Error fetching questions:", error);
                document.getElementById('loading-text').innerText = "Gagal memuat bank soal. Hubungi Admin.";
                document.getElementById('loading-text').classList.replace('text-slate-700', 'text-red-600');
            }
        }

        let questions = [], currentIndex = 0, examState = { answers: {}, doubtful: [], startTime: null, status: "ongoing", questions: [] };
        let syncTimeout, timerInterval; const TOTAL_DURATION_SEC = 6000; 
        let learnCurrentPage = 1; const learnItemsPerPage = 50; const FREE_TRIAL_LIMIT = 20;
        const elLoader = document.getElementById('initial-loader'), elGridContainer = document.getElementById('grid-container');

        async function initApp() {
            try {
                setupIdentity(); checkSavedVIPStatus();
                
                // --- Tunggu soal di-download dari database ---
                await fetchRealQuestions(); 
                
                const savedSession = localStorage.getItem(`cat_session_data_${appId}`);
                if (savedSession) {
                    const parsed = JSON.parse(savedSession);
                    if(parsed.status === "ongoing") { examState = parsed; questions = examState.questions || []; await loadExamSession(false); return; }
                }
                elLoader.style.display = 'none'; 
            } catch (error) { elLoader.innerHTML = `<p class="text-red-600 font-bold p-4 bg-white rounded shadow text-center">Gagal Dimuat.</p>`; }
        }

        function checkSavedVIPStatus() {
            const savedStatus = localStorage.getItem(`cat_vip_status_${appId}`);
// ... existing code ...