aa

ResetarVariaveis(playerid)
{
    strclear(PlayerInfo[playerid][pNome]);
    strclear(PlayerInfo[playerid][pSenha]);

    PlayerInfo[playerid][pID] = -1;
    PlayerInfo[playerid][pDinheiro] = 25000;
    PlayerInfo[playerid][pTempoVip] = 0;
    PlayerInfo[playerid][pVip] = 0;
    PlayerInfo[playerid][pAdmin] = 0;
    PlayerInfo[playerid][pLevel] = 1;
    PlayerInfo[playerid][pExp] = 12;
    PlayerInfo[playerid][pSkin] = 0;

    PlayerInfo[playerid][pMatou] = 0;
    PlayerInfo[playerid][pMorreu] = 0;

    PlayerInfo[playerid][pDuelosWin] = 0;
    PlayerInfo[playerid][pDuelosLoose] = 0;

    PlayerInfo[playerid][pGangID] = 0;
    PlayerInfo[playerid][pGangExp] = 0;

    PlayerInfo[playerid][pHudColor] = 0;
    PlayerInfo[playerid][pHitmarkalpha] = 0;

    PlayerInfo[playerid][pAntiSpawnKill] = 0;
    PlayerInfo[playerid][pLogado] = false;

    PlayerInfo[playerid][pTimer] = 10;
    PlayerInfo[playerid][pWeather] = 10;
    PlayerInfo[playerid][pHitSound] = 1;

    PlayerInfo[playerid][pMaxArenaDmg] = 0;
    PlayerInfo[playerid][pWonArenas] = 0;
    return 1;
}

Kast:LoadAccount(playerid)
{
    new rows = cache_num_rows();
    if(rows)
    {
        cache_get_value_name_int(0, "ID", PlayerInfo[playerid][pID]);
        cache_get_value_name_int(0, "Senha", PlayerInfo[playerid][pSenha]);
        cache_get_value_name_int(0, "Dinheiro", PlayerInfo[playerid][pDinheiro]);
        cache_get_value_name_int(0, "TempoVip", PlayerInfo[playerid][pTempoVip]);
        cache_get_value_name_int(0, "Vip", PlayerInfo[playerid][pVip]);
        cache_get_value_name_int(0, "Admin", PlayerInfo[playerid][pAdmin]);
        cache_get_value_name_int(0, "Level", PlayerInfo[playerid][pLevel]);
        cache_get_value_name_int(0, "Score", PlayerInfo[playerid][pScore]);
        cache_get_value_name_int(0, "Exp", PlayerInfo[playerid][pExp]);
        cache_get_value_name_int(0, "Skin", PlayerInfo[playerid][pSkin]);
        cache_get_value_name_int(0, "Matou", PlayerInfo[playerid][pMatou]);
        cache_get_value_name_int(0, "Morreu", PlayerInfo[playerid][pMorreu]);
        cache_get_value_name_int(0, "Win", PlayerInfo[playerid][pDuelosWin]);
        cache_get_value_name_int(0, "Loose", PlayerInfo[playerid][pDuelosLoose]);
        cache_get_value_name_int(0, "GangID", PlayerInfo[playerid][pGangID]);
        cache_get_value_name_int(0, "GangExp", PlayerInfo[playerid][pGangExp]);
        cache_get_value_name_int(0, "HudColor", PlayerInfo[playerid][pHudColor]);
        cache_get_value_name_int(0, "HitmarkColor", PlayerInfo[playerid][pHitmarkalpha]);
        cache_get_value_name_int(0, "SpawnKill", PlayerInfo[playerid][pAntiSpawnKill]);
        cache_get_value_name_int(0, "Timer", PlayerInfo[playerid][pTimer]);
        cache_get_value_name_int(0, "Weather", PlayerInfo[playerid][pWeather]);
        cache_get_value_name_int(0, "HitSound", PlayerInfo[playerid][pHitSound]);
        cache_get_value_name_int(0, "MaxArenaDmg", PlayerInfo[playerid][pMaxArenaDmg]);
        cache_get_value_name_int(0, "WonA", PlayerInfo[playerid][pWonArenas]);
        ShowDialogLogin(playerid);
        return true;
    }
    ShowDialogRegister(playerid);
    return true;
}

SaveAccount(playerid)
{
    new query[1000];
    mysql_format(Conexao, query, sizeof(query), "UPDATE `usuarios` SET `Dinheiro` = '%i', `Tempovip` = '%i', `Vip` = '%i', `Admin` = '%i', `Score` = '%i', `Level` = '%i', `Exp` = '%i', `Skin` = '%i', `Matou` = '%i', `Morreu` = '%i', `Win` = '%i', `Loose` = '%i', `GangID` = '%i', `GangExp` = '%i', `HudColor` = '%i', `HitmarkColor` = '%i', `SpawnKill` = '%i', `Timer` = '%i', `Weather` = '%i', `HitSound` = '%i', `MaxArenaDmg` = '%i', `WonA` = '%'i WHERE `id` = '%i'",
    PlayerInfo[playerid][pDinheiro],
    PlayerInfo[playerid][pTempoVip],
    PlayerInfo[playerid][pVip],
    PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pScore],
    PlayerInfo[playerid][pLevel],
    PlayerInfo[playerid][pExp],
    PlayerInfo[playerid][pSkin],
    PlayerInfo[playerid][pMatou],
    PlayerInfo[playerid][pMorreu],
    PlayerInfo[playerid][pDuelosWin],
    PlayerInfo[playerid][pDuelosLoose],
    PlayerInfo[playerid][pGangID],
    PlayerInfo[playerid][pGangExp],
    PlayerInfo[playerid][pHudColor],
    PlayerInfo[playerid][pHitmarkalpha],
    PlayerInfo[playerid][pAntiSpawnKill],
    PlayerInfo[playerid][pTimer],
    PlayerInfo[playerid][pWeather],
    PlayerInfo[playerid][pHitSound],
    PlayerInfo[playerid][pMaxArenaDmg],
    PlayerInfo[playerid][pWonArenas],
    PlayerInfo[playerid][pID]);
    mysql_tquery(Conexao, query);
    return 1;
}

stock removeQuotesFromString(str[])
{
    for(new t = 0; t < 2; t++)
    {
        for (new i = 0; i < strlen(str); i++)
        {
            if (str[i] == '"' || str[i] == '\'')
            {
                strdel(str, i, i + 1);
            }
        }
    }

    return true;
}

Kast:InserirSQL(playerid)
{
    PlayerInfo[playerid][pID] = cache_insert_id();
}

stock ShowDialogRegister(playerid)
    return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "registro", "texto registro", "Enter", "Cancel");

stock ShowDialogLogin(playerid)
    return ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "login", "texto login", "Enter", "Cancel");