// OnPlayerConnect
new query[256], name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, 24);
    mysql_format(mysql, query, sizeof(query),"SELECT `players_id`, `players_mdp`, `players_ban`, `players_register` FROM `players` WHERE `players_name` = '%e' LIMIT 1", name);
    mysql_tquery(mysql, query, "AccountCheck", "d", playerid);

// AccountCheck

forward AccountCheck(playerid);
public AccountCheck(playerid)
{
    new y, d, m, string[520];
    getdate(y, m, d);
    if(cache_num_rows() > 0)
    {
        if(Players[playerid][Ban] == 0)
        {
            cache_get_field_content(0, "players_pass", Players[playerid][Password], mysql, 129);
            Players[playerid][ID] = cache_get_field_content_int(0, "Players_id");
            format(string, sizeof(string), "Hello %s, today : %02d/%02d/%d, last version : %s \nEnter your password to join the server", GetName(playerid), d, m, y, VERSION);
            Dialog_Show(playerid, LOGIN, DIALOG_STYLE_PASSWORD, "Login", string, "Log me", "Cancel");
        }
        else
        {
            KickWithMessage(playerid, -1, ""jaune2"[Console]: "blanc"You're banned from this server.");
        }
    }
    else
    {
        Dialog_Show(playerid, REGISTER, DIALOG_STYLE_PASSWORD, "Register", "Welcome to the server.\nEnter password to create your account !", "Register", "Cancel");
    }
    return 1;
}

// Login dialog

Dialog:LOGIN(playerid, response, listitem, inputtext[])
{
    if(response) {
        new hpass[129], query[256], name[MAX_PLAYER_NAME];
        GetPlayerName(playerid, name, sizeof(name));
        WP_Hash(hpass, sizeof(hpass), inputtext);
        new annee, jour, mois;
        getdate(annee, mois, jour);
        if(!strcmp(hpass, Players[playerid][Password], false))
        {
            Players[playerid][Spawn][0] = 1747.35;
            Players[playerid][Spawn][1] = -1837.86;
            Players[playerid][Spawn][2] = 15.863;
            mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `players_name` = '%e'", name);
            mysql_tquery(mysql, query, "LoadAccount", "i", playerid);
        }
    }
    else {
        Kick(playerid);
    }
    return 1;
}

// LoadAccount

forward LoadAccount(playerid);
public LoadAccount(playerid)
{
    Players[playerid][Register] = cache_get_field_content_int(0, "players_register");
        Players[playerid][Admin] = cache_get_field_content_int(0, "players_admin");
        Players[playerid][Level] = cache_get_field_content_int(0, "players_level");
        Players[playerid][Spawn][0] = cache_get_field_content_float(0, "players_x");
        Players[playerid][Spawn][1] = cache_get_field_content_float(0, "players_y");
        Players[playerid][Spawn][2] = cache_get_field_content_float(0, "players_z");
    Players[playerid][Skin] = cache_get_field_content_int(0, "players_skin");


    SetPlayerScore(playerid, Players[playerid][Level]);
        SetPlayerSkin(playerid, Players[playerid][Skin]);
        SetSpawnInfo(playerid, -1, Players[playerid][Skin], Players[playerid][Spawn][0], Players[playerid][Spawn]   [1], Players[playerid][Spawn][2], Players[playerid][Spawn][3], -1, -1, -1, -1, -1, -1);
    SpawnPlayer(playerid);
    return 1;
}