enum InformationAccount {
    pID,
    pPassword[256],
    pLogged,
    pLevel,
    pScore,
}

script SaveAccountInfo(playerid)
{
    if(PlayerInfo[playerid][pLogged] == 0) return 1;
    new query[256], final[856];
    format(query, sizeof(query), "UPDATE `tbl_users` SET ");
    strcat(final,query);
    format(query, sizeof(query), "`Level` = '%d',",PlayerInfo[playerid][pLevel]);
    strcat(final,query);
    format(query, sizeof(query), " WHERE ID = %d", PlayerInfo[playerid][pID]);
    strcat(final,query);
    format(query, sizeof(query), "`Score` = '%d',",PlayerInfo[playerid][pScore] = GetPlayerScore(playerid));
    strcat(final,query);
    mysql_format(mysql, final, sizeof(final), "%s", final);
    mysql_query(mysql, final, false);
    return 1;
}

script LoadAccountInfo(playerid)
{
    PlayerInfo[playerid][pID] = cache_get_field_content_int(0, "ID");
    PlayerInfo[playerid][pLevel] =  cache_get_field_content_int(0, "Level");
    PlayerInfo[playerid][pScore] =  cache_get_field_content_int(0, "Score");
    cache_get_field_content(0, "Password", PlayerInfo[playerid][pPassword], mysql, 256);
    TogglePlayerSpectating(playerid, 0);
    CC(playerid, 10);
    format(str, sizeof(str), "SERVER: {FFFFFF}%s you have been logged!", GetName(playerid));
    SCM(playerid, COLOR_SERVER, str);
    format(str, sizeof(str), "SERVER: {FFFFFF}Your account is level %d.", PlayerInfo[playerid][pLevel]);
    SCM(playerid, COLOR_SERVER, str);
    PlayerInfo[playerid][pLogged] = 1;

}

script RegisterAccountInfo(playerid)
{
    PlayerInfo[playerid][pID] = cache_insert_id();
    PlayerInfo[playerid][pLevel] = 1;
    PlayerInfo[playerid][pScore] = 0;
    TogglePlayerSpectating(playerid, 0);
    CC(playerid, 10);
    format(str, sizeof(str), "SERVER: {FFFFFF}%s you have been registered!", GetName(playerid));
    SCM(playerid, COLOR_SERVER, str);
    PlayerInfo[playerid][pLogged] = 1;

}

script CheckingAccount(playerid)
{
    CC(playerid, 10);
    InterpolateCameraPos(playerid, 1804.1313,-1732.0179,21.7294, 1037.3715,-1732.7358,25.2859, GetSeconds(60), CAMERA_MOVE);
    InterpolateCameraLookAt(playerid,1441.6654,-1732.0317,18.0373,1037.3715,-1732.7358,25.2859, GetSeconds(60), CAMERA_MOVE);
    new rows, fields;
    cache_get_data(rows, fields, mysql);
    if(rows)
    {
        LoginSeconds[playerid] = 60;
        LoginTimer[playerid] = SetTimerEx("LoginRemains", 1000, true, "i", playerid);
        //INT
        PlayerInfo[playerid][pID] = cache_get_field_content_int(0, "ID");
        PlayerInfo[playerid][pLevel] =  cache_get_field_content_int(0, "Level");
        PlayerInfo[playerid][pScore] =  cache_get_field_content_int(0, "Level");
        //STRING
        cache_get_field_content(0, "Password", PlayerInfo[playerid][pPassword], mysql, 150);

        format(str,sizeof(str), "{FFFFFF}Welcome to the MySQL Server,\nPlease enter your password below!\nYou have {cc2a36}60{FFFFFF} seconds left to login. ");
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"SERVER: {FFFFFF}LOGIN",str,"Proceed","Quit");
    }
    else
    {
        format(str,sizeof(str), "{FFFFFF}Welcome to the MySQL Server,\n\nYou can register this account.\nPlease enter a password below!");
        ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"SERVER: {FFFFFF}REGISTER",str,"Proceed","Quit");
    }

}