<?php
$dbc = mysqli_connect("localhost", "root", "root", "flexiblelogin");
if(isset($_POST['submit'])){
    $username = mysqli_real_escape_string($dbc, trim($_POST['username']));
    $password1 = mysqli_real_escape_string($dbc, trim($_POST['password1']));
    $password2 = mysqli_real_escape_string($dbc, trim($_POST['password2']));
    $email = mysqli_real_escape_string($dbc, trim($_POST['email']));
    $lastlogin = "2017-12-31 00:00:00";
    $loginin = 0;
    if(!empty($username) && !empty($password1) && !empty($password2) && ($password1 == $password2) && !empty($email)) {
        $query = "SELECT Username FROM `flexiblelogin_users` WHERE Username = '$username'";
        $data = mysqli_query($dbc, $query);
        if(mysqli_num_rows($data) == 0) {
            $ip = $_SERVER['REMOTE_ADDR'];
            $json = file_get_contents('https://api.mojang.com/users/profiles/minecraft/'.$username);
            $json_data = json_decode($json);
            $uuid = $json_data -> id;
            $query = "INSERT INTO `flexiblelogin_users` (UUID, Username, Password, IP, LastLogin, Email, LoggedIn) VALUES ('$uuid', '$username', '$password1', '$ip', '$lastlogin', '$email', '$loginin')";
            mysqli_query($dbc, $query);
            echo "Всё готово, можете авторизоваться<br/>";
            echo $uuid;
            mysqli_close($dbc);
            exit();
        }
        else {
            echo 'Логин уже существует';
        }
    }
    error_reporting(E_ALL);
    set_error_handler('user_log');
}
?>