// ===== DATABASE CONFIG =====
$host = "localhost";
$db   = "audrprzy_ea_license_db";
$user = "audrprzy_licenseAdmin";
$pass = "Iamawinner2000$$";

$conn = new mysqli($host, $user, $pass, $db);
if ($conn->connect_error) {
    die("ERROR");
}

// ===== GET DATA FROM MT4 =====
$license_key   = $_GET['key'] ?? '';
$account_number = $_GET['account'] ?? '';
$broker_name    = $_GET['broker'] ?? '';

if(empty($license_key) || empty($account_number) || empty($broker_name)) {
    die("INVALID");
}

// ===== PREPARED STATEMENT =====
$stmt = $conn->prepare(
    "SELECT expiry_date, account_number, broker 
     FROM licenses 
     WHERE license_key = ?"
);

$stmt->bind_param("s", $license_key);
$stmt->execute();
$result = $stmt->get_result();

if($row = $result->fetch_assoc())
{
    // ===== CHECK ACCOUNT MATCH =====
    if($row['account_number'] != $account_number)
    {
        die("ACCOUNT_MISMATCH");
    }

    // ===== CHECK BROKER MATCH =====
    if(strtolower($row['broker']) != strtolower($broker_name))
    {
        die("BROKER_MISMATCH");
    }

    $expiry = strtotime($row['expiry_date']);

    if(time() > $expiry)
    {
        die("EXPIRED");
    }

    // SUCCESS RESPONSE
    echo "VALID|" . $row['expiry_date'];
}
else
{
    echo "INVALID";
}

$stmt->close();
$conn->close();
?>