session_name("endoflex");
session_start();
include ("includes/mysql.inc.php");
include ("includes/functions.php");
include ("includes/functions.inc.php");
$login = filter_input(INPUT_POST, 'client', FILTER_SANITIZE_STRING);
$passwd = filter_input(INPUT_POST, 'passwd', FILTER_SANITIZE_EMAIL);
if (isset($client) && isset($passwd"]) {
        $sql = "SELECT *
        from base_users
        WHERE (code_client = '" . $login . "'
        AND passwd = '" . md5($passwd) . "')";
    $result = mysqli_query($mysqli, $sql);
    if (mysqli_num_rows($result) == '1') {
        if (check_var($_POST["remember"])) {
            setcookie('client', $login, time()+(84600*90), null, null, false, true);
            setcookie('passwd', md5($passwd), time()+(84600*90), null, null, false, true);
        }
        $user = mysqli_fetch_object($result);
        $user_id = $user->code_client;
        $ville = $user->ville;
        $level = $user->level;
        $_SESSION["user_id"] = $user_id;
        $_SESSION["ville"] = $ville;
        $_SESSION["level"] = $level;
        $_SESSION["auth"] = 1;
        mysqli_free_result($result);
        date_default_timezone_set('France/Paris');
        $last_connect = new Datetime('now');
        $last_connect = $last_connect->format('Y-m-d H:i:s');
        $sql = "UPDATE base_users set `last_connect` = '" . $last_connect . "' WHERE (`code_client` = '" . $_SESSION["user_id"] . "')";
        mysqli_query($mysqli, $sql) or die("mysqli Error T_T LOGIN POST".$mysqli->error);
    } else {
        $loginTentative = 1;
    }
}
$clogin = filter_input(INPUT_COOKIE, 'client', FILTER_SANITIZE_STRING);
$cpasswd = filter_input(INPUT_COOKIE, 'passwd', FILTER_SANITIZE_EMAIL);
if (isset($clogin) && isset($cpasswd) && $_SESSION["auth"] != 1) {
        $sql = "SELECT *
        from base_users
        WHERE (code_client = '" . $clogin . "'
        AND passwd = '" . $cpasswd . "')";
        $result = mysqli_query($mysqli, $sql);
    if (mysqli_num_rows($result) == '1') {
        $user = mysqli_fetch_object($result);
        $user_id = $user->code_client;
        $ville = $user->ville;
        $level = $user->level;
        $_SESSION["user_id"] = $user_id;
        $_SESSION["ville"] = $ville;
        $_SESSION["level"] = $level;
        $_SESSION["auth"] = 1;
        mysqli_free_result($result);
        date_default_timezone_set('France/Paris');
        $last_connect = new Datetime('now');
        $last_connect = $last_connect->format('Y-m-d H:i:s');
        $sql = "UPDATE base_users set `last_connect` = '" . $last_connect . "' WHERE (`code_client` = '" . $_SESSION["user_id"] . "')";
        mysqli_query($mysqli, $sql) or die("mysqli Error T_T LOGIN COOKIE".$mysqli->error);
        setcookie("client", $login, time()+(84600*90), null, null, false, true);
        setcookie("passwd", $passwd, time()+(84600*90), null, null, false, true);
    }
}

if (check_var($_POST["logout"])) {
    session_destroy();
    setcookie("client", "plouf", time()-42000, null, null, false, true);
    setcookie("passwd", "plouf", time()-42000, null, null, false, true);
    session_name("endoflex");
    session_start();
}