<?php

require "db.php";

if(isset($_POST['api_key'], $_POST['cpu'])) {


    $sql_key = $connSettings->prepare('SELECT * FROM `api` WHERE `name`="api_key"');
    $sql_key->execute();
    $sql_key_res = $sql_key->get_result();

    if($sql_key_res->num_rows > 0) {
        $info = $sql_key_res->fetch_object();
        $key = $info->value;

        if ($_POST['api_key'] == $key) {

            $cpu = strtoupper($_POST['cpu']);


            $sql_dizzy = $connDizzy->prepare('SELECT * FROM `consoles` WHERE `cpukey`=?');
            $sql_dizzy->bind_param('s', $cpu);
            $sql_dizzy->execute();
            $sql_dizzy_res = $sql_dizzy->get_result();

            if($sql_dizzy_res->num_rows == 1) {

                $infoClient = $sql_dizzy_res->fetch_array();

                if(isset($_POST['unbanned'])) {

                    $unbanned_r = $infoClient['kvtime'];
                    $expire_time = strtotime($infoClient['expire']);

                    $unbanned_f = strtotime($unbanned_r);
                    $now = time();
                    $difference = $now - $unbanned_f;
                    $unbanned = $difference;
                    $seconds_unbanned = $unbanned % 60;
                    $minutes_unbanned = (($unbanned - $seconds_unbanned) / 60) % 60;
                    $hours_unbanned = (((($unbanned - $seconds_unbanned) / 60) - $minutes_unbanned) / 60) % 24;
                    $days_unbanned = floor(((((($unbanned - $seconds_unbanned) / 60)- $minutes_unbanned) / 60) / 24) );


                    $expires = $expire_time;
                    $seconds_expires = $expires % 60;
                    $minutes_expires = (($expires - $seconds_expires) / 60) % 60;
                    $hours_expires = (((($expires - $seconds_expires) / 60) - $minutes_expires) / 60) % 24;
                    $days_expires = floor(((((($expires - $seconds_expires) / 60)- $minutes_expires) / 60) / 24) );

                    if($expire_time > $now) {
                        $expire = 'Expired';
                    }
                    else {
                        $expire = $days_expires . "D " . $hours_expires . "H " . $minutes_expires . "M";
                    }

                    $response = array(
                        'unbanned' => $days_unbanned . "D " . $hours_unbanned . "H " . $minutes_unbanned . "M",
                        'name' => $infoClient['name'],
                        'expire' => $expire
                    );

                    echo json_encode($response, JSON_PRETTY_PRINT);

                }

            }
            else {
                echo "Wrong cpu";
            }
        }
        else {
            echo "Authentication-Key Error!";
        }
    }
    else {
        echo "Authentication Error!";
    }
}

?>