<?php
include "../../function/connect.php";
include "../../main/API/functions.php";

$user = mysqli_real_escape_string($koneksi, $_POST['username']);

if ($user != "") {
    $q = mysqli_query($koneksi, "SELECT * FROM `tb_user` WHERE username = '$user'") or die(mysqli_error($koneksi));
    $user_data = mysqli_fetch_array($q, MYSQLI_ASSOC);
    
    if ($user_data) {
        $extplayer = $user_data['username']; // Pastikan ini sesuai dengan user_code di API
        $usersID = $user_data['username'];

        // Ambil saldo terbaru dari API
        $response1 = $SGX->userbalance($extplayer);

        if(isset($response1['status']) && $response1['status'] == 1) {
            $balance = (float)$response1['user']['balance'];

            // OPSI A: Hanya sinkronisasi ke database agar dashboard lokal update
            // Kami menghapus bagian $SGX->withdraw di sini agar saldo tetap ada di game
            mysqli_query($koneksi, "UPDATE `tb_saldo` SET active = $balance WHERE id_user = '$usersID'");
            
            echo json_encode(['status' => 'success', 'balance' => $balance]);
        } else {
            echo "Data pengguna tidak ditemukan di API.";
        }
    } else {
        echo "User tidak ditemukan di database.";
    }
}
?>