<?php

require_once "libs/configs/config.php";

$host = DB_HOST;
$dbname = DB_NAME;

$connSettings = "mysql:host=$host;dbname=$dbname;charset=utf8mb4";
$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

$data = json_decode(file_get_contents('php://input'), true);
//Проверить данные пользователя
if($data['AppID'] != 1596158210) {
  exit('Bye!');
}elseif($_SERVER['HTTP_X_API_KEY'] != 'ibE5BHmABRtLCkgjBRUMyYlItmPA0zSO') {
  exit('Bye');
}else{
  //Если все ок, то вынимаем переменные и апдейтим базу
  $ip = $_SERVER['REMOTE_ADDR'];
  $ref = urldecode($_SERVER['HTTP_USER_AGENT']);
  
  $uuid = ($data['UUID'] != '') ? strip_tags($data['UUID']) : NULL;
  $duration = ($data['Duration'] != '') ? strip_tags($data['Duration']) : NULL;
  $isPaying = ($data['IsPaying'] != '') ? strip_tags($data['IsPaying']) : NULL;
  
  $conn = new PDO($connSettings, DB_USER, DB_PASSWORD, $opt);
  
  $sql = "INSERT INTO `duration`(`UUID`, `Duration`, `IsPaying`, `UserIP`, `HTTPReferrer`)
          VALUES (:UUID, :Duration, :IsPaying, :UserIP, :HTTPReferrer)";
  $stmt = $conn->prepare($sql);	
  $stmt ->bindValue(':UUID', $uuid, PDO::PARAM_STR);
  $stmt ->bindValue(':Duration', $duration, PDO::PARAM_STR);
  $stmt ->bindValue(':IsPaying', $isPaying, PDO::PARAM_BOOL);
  $stmt ->bindValue(':UserIP', $ip, PDO::PARAM_STR);
  $stmt ->bindValue(':HTTPReferrer', $ref, PDO::PARAM_STR);
  $stmt ->execute();
  $conn = null;
  
  exit('Ok');
}

?>