<?php
session_start();
 header('Content-type: text/html; charset=utf-8');
 date_default_timezone_set('Europe/Paris');

include("config/bdd.php");

if(isset($_POST['submit'])) {
    $id_server = 'MC-'.rand(1, 1000).'';
    $name_server = htmlspecialchars($_POST['name_server']);
    $ip_server = htmlspecialchars($_POST['ip_server']);

    $passwordLength = strlen($password);
    $mdp = sha1($_POST['password']);
    $date = time();
    $ip_register = $_SERVER['REMOTE_ADDR'];

    if((!(empty($_POST['username']))) && (!(empty($_POST['email']))) && (!(empty($_POST['password']))) && (!(empty($_POST['repeat_password'])))) {
            $checkEmail = $bdd -> prepare("SELECT COUNT(*) FROM `univers_server` WHERE `ip_server` = :ip_server");
            $checkEmail -> execute(array(':ip_server' => $email));
            $countEmail = $checkEmail -> fetchColumn(0);

            $checkUsername = $bdd -> prepare("SELECT COUNT(*) FROM `univers_server` WHERE `name_server` = :name_server");
            $checkUsername -> execute(array(':name_server' => $nom));
            $countUsername = $checkUsername -> fetchColumn(0);

            if ($countEmail > 0) {
                $message = '
                   <div class="failed" data-closable="">
                            Adresse déjà enregistrer.
                    </div>';
            } else if($countUsername > 0) {
                $message = '
                   <div class="failed" data-closable="">
                            Serveur déjà enregistrer.
                    </div>';
            } else if(filter_var($email, FILTER_VALIDATE_EMAIL)) {
                    if($password == $repeat_password) {
                        if($passwordLength < 31 && $passwordLength > 7) {
                            $req = $bdd->prepare('INSERT INTO univers_server( id_server, name_server, ip_server)
                                                      VALUES("", :id_server, :username, :name_server, :ip_server)');
                            $req -> bindParam(':id_server', $id_client, PDO::PARAM_STR);
                            $req -> bindParam(':name_server', $nom, PDO::PARAM_STR);
                            $req -> bindParam(':ip_server', $email, PDO::PARAM_STR);
                            $req -> execute();

                            $message = '
                            	<div class="success">
    							  Serveur inscrit !
    							  <META http-equiv="refresh" content="2;URL=index.php">
    							</div>';

        } else {
            $message = '
                	<div class="failed">
    					Remplissez tous les champs
    				</div>';
        }
}

?>