<?php
#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|
#|                                                                        #|
#|                ♣ Habboworld CMS V4 FR 2018 par Mirlyn ♣                #|
#|                                                                        #|
#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|#|


/**
 * Fichier de la base de donnée nécessaire.
 */
require_once "includes/bdd_hwconnect.php";
require_once "includes/configuration.php";
/**
 * Connexion à la base de donnée.
 */

$bdd_hwconnect = new mysqli($bdd_hwconnect['host'], $bdd_hwconnect['username'], $bdd_hwconnect['password'], $bdd_hwconnect['name']);

if($bdd_hwconnect->connect_error)
{
    die('MySQL Connection Error');
}

/**
 * Nouvel inscription d'un utilisateur.
 */

if(isset($_POST['loginuser']) && isset($_POST['loginpass']))
{
    $username = $_POST['loginuser'];
    $password = $_POST['loginpass'];

    if($username == null || $password == null)
    {
        return '<div id="error" style="background:#A40101; color:#FFFFFF; width:750px;margin-left:auto;margin-right:auto; height:23px; line-height:23px; font-size:17px; text-align:center; margin-top:-4px;">
 Erreur: Vous devez entrer vos identifiants dans les emplacements vides.</div>';
    }

    $l_query = $bdd_hwconnect->query("SELECT * FROM users WHERE username = {$username} AND password = ".md5($password)." LIMIT 1");

    if($l_query == false || $l_query->num_rows == 0)
    {
        return '<div id="error" style="background:#A40101; color:#FFFFFF; width:750px;margin-left:auto;margin-right:auto; height:23px; line-height:23px; font-size:17px; text-align:center; margin-top:-4px;">
        Pseudo ou mot de passe incorrect.</div>';
    }

    $ban_query = $bdd_hwconnect->query("SELECT * FROM bans WHERE value = {$username} OR value = {$ip}");

    if(!$l_query || $l_query->num_rows > 0)
    {
        session_start();
        $_SESSION['loginuser'] = $username;
        header("Location: ".$config['hotelURL']."home/");
    }
    else
    {
        while($ban = $ban_query->fetch_assoc())
        {
            return '<div id="error" style="background:#A40101; color:#FFFFFF; width:750px;margin-left:auto;margin-right:auto; height:23px; line-height:23px; font-size:17px; text-align:center; margin-top:-4px;">
            Erreur: Tu as été exclu pour la raison suivante : '.$ban['reason'].' !
            </div>';
        }
    }
}
?>