<?php

$hostdb = 'sql.alls-heberg.fr';
$databasedb = 'IlanC5404';
$userdb = 'IlanC5404';
$passworddb = 'L2fbUf004r';

$bdd = new PDO('mysql:host=' . $hostdb . ';dbname=' . $databasedb, $userdb, $passworddb, array(
	PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8',
	PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
));

function Hashage($str)
{
$config_hash = "xCg532%@%gdvf^5DGaa6&*rFTfg^FD4\$OIFThrR_gh(ugf*/";
$str = Securise(sha1($str . $config_hash));
return $str;
}

function Look($str)
{
    if($str == 'Garçon') {
        return '';
    } elseif($str == 'Fille') {
        return '';
    } else {
        return '';
    }
}

function Gender($str)
{
    if($str == 'Garçon') {
        return 'M';
    } elseif($str == 'Fille') {
        return 'F';
    } else {
        return 'M';
    }
}

if (isset($_POST['register'])) {
    $email = htmlspecialchars(trim($_POST['email']));
    $password = Hashage($_POST['password']);
    $username = htmlspecialchars(trim($_POST['username']));
    $genre = htmlspecialchars(trim($_POST['genre']));

    if(!empty($email)) {
        if(!empty($password)) {
            if(!empty($username)) {
                if(!empty($genre)) {
                    if($genre == 'Garçon' OR $genre == 'Fille') {
                        $Req1 = $bdd->prepare('SELECT mail FROM users WHERE mail = ?');
                        $Req1->execute(array($email));
                        $rowCount1 = $Req->rowCount();
                        if($rowCount1 == 0) {
                            $Req2 = $bdd->prepare('SELECT username FROM users WHERE username = ?');
                            $Req2->execute(array($username));
                            $rowCount2 = $Req2->rowCount();
                            if($rowCount2 == 0) {
                                $Good = $bdd->prepare('INSERT INTO users(username,password,mail,rank,look,ip_reg,gender,motto,credits,activity_points,last_offline,account_created) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');
                                $Good->execute(array($username, $password, $email, '1', Look($genre), $_SERVER['REMOTE_ADDR'], Gender($genre), '1000000', '100000', time(), time()));

                                $erreur = 'Inscription réussi';

                                $_SESSION['username'] = $username;
                                $_SESSION['mail'] = $email;

                                header('Refresh: 2; URL=me.php');

                            } else {
                                $errreur = 'Ce pseudonyme est déjà utilisé';
                            }

                        } else {
                            $erreur = 'Cette email est déjà utilisé';
                        }

                    } else {
                        $erreur = 'Veuillez indiquer un genre';
                    }


                } else {
                    $erreur = 'Veuillez indiquer un genre';
                }

            } else {
                $erreur = 'Veuillez entrer un pseudonyme';
            }

        } else {
            $erreur = 'Veuillez entrer un mot de passe';
        }

    } else {
        $erreur = 'Veuillez entrer une email';
    }
}

?>
<form method="post">
    <input name="email" placeholder="Email">
    <input name="password" type="password" placeholder="Mot de passe">
    <input name="username" placeholder="Pseudonyme">
    <select name="genre">
        <option value="Gar谮">Garçon</option>
        <option value="Fille">Fille</option>
    </select>
	<button type="submit" name="valide" style="outline: none;">Valider mon inscription</button>
</form>