<?php
$conn = new mysqli("localhost", "tasmoybb_tracker", "3XT3RN4l!337", "tasmoybb_tracking");

if ($conn->connect_error) {
    die("DB Error");
}

$data = json_decode(file_get_contents("php://input"), true);

$ip = $_SERVER['REMOTE_ADDR'];

$stmt = $conn->prepare("
INSERT INTO visits 
(ip, latitude, longitude, city, region, country, isp, user_agent, browser, os, device, screen_resolution, language, cpu_cores, gpu)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
");

$stmt->bind_param("sssssssssssssis",
    $ip,
    $data['lat'],
    $data['lon'],
    $data['city'],
    $data['region'],
    $data['country'],
    $data['isp'],
    $_SERVER['HTTP_USER_AGENT'],
    $data['browser'],
    $data['os'],
    $data['device'],
    $data['screen'],
    $data['lang'],
    $data['cores'],
    $data['gpu']
);

$stmt->execute();

echo json_encode(["status" => "ok"]);