search

pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
198 stars 79 forks source link

Everything goes well, except in the vehicle and accessory loops. #244

Closed MatheusAgL closed 3 years ago

MatheusAgL commented 3 years ago

Everything goes well, except in the vehicle and accessory loops.

// MySQL:
    g_MysqlRaceCheck[playerid]++;

    // create orm instance and register all needed variables
    new ORM: ormid = PlayerInfo[playerid][ORM_ID] = orm_create("player", mySQL_Server);

    orm_addvar_int(ormid, PlayerInfo[playerid][pID], "id");
    orm_addvar_string(ormid, PlayerName[playerid], MAX_PLAYER_NAME, "nome");
    orm_addvar_string(ormid, PlayerInfo[playerid][pKey], 65, "senha");
    orm_addvar_int(ormid, PlayerInfo[playerid][pLevel], "level");
    orm_addvar_int(ormid, PlayerInfo[playerid][pExp], "respeitos");
    orm_addvar_int(ormid, PlayerInfo[playerid][pConnectTime], "horas_jogadas");
    orm_addvar_int(ormid, PlayerInfo[playerid][pCash], "dinheiro");
    orm_addvar_int(ormid, PlayerInfo[playerid][pConta], "dinheiro_banco");
    orm_addvar_int(ormid, PlayerInfo[playerid][pOuros], "ouros");
    orm_addvar_int(ormid, PlayerInfo[playerid][pCashVip], "cash");
    orm_addvar_int(ormid, PlayerInfo[playerid][pKills], "assassinatos");
    orm_addvar_int(ormid, PlayerInfo[playerid][pDeaths], "mortes");
    orm_addvar_int(ormid, PlayerInfo[playerid][pSkin], "skin");
    orm_addvar_int(ormid, PlayerInfo[playerid][pPayDay], "timer_payday");
    orm_addvar_int(ormid, PlayerInfo[playerid][pPegouVIP], "vip_pegou");

    new string_save[355];
    new string_read[18][60];
    new string[50];
    for(new carro; carro < MAX_PLAYER_CARROS; carro++)
    {
        // Veiculo informações
        format(string, sizeof string, "veiculo_%d", carro);
        orm_addvar_string(ormid, string_save, sizeof (string_save), string);

        split(string_save, string_read, '|');

        PlayerConce[playerid][carro][conce_valid]    = strval(string_read[0]);
        PlayerConce[playerid][carro][conce_model]    = strval(string_read[1]);
        PlayerConce[playerid][carro][conce_pos][0]   = floatstr(string_read[2]);
        PlayerConce[playerid][carro][conce_pos][1]   = floatstr(string_read[3]);
        PlayerConce[playerid][carro][conce_pos][2]   = floatstr(string_read[4]);
        PlayerConce[playerid][carro][conce_pos][3]   = floatstr(string_read[5]);
        PlayerConce[playerid][carro][conce_health]   = floatstr(string_read[6]);
        PlayerConce[playerid][carro][conce_color][0] = strval(string_read[7]);
        PlayerConce[playerid][carro][conce_color][1] = strval(string_read[8]);
        PlayerConce[playerid][carro][conce_preco]    = strval(string_read[9]);
        PlayerConce[playerid][carro][conce_gasolina] = strval(string_read[10]);
        PlayerConce[playerid][carro][conce_estacionado] = strval(string_read[11]);
        PlayerConce[playerid][carro][conce_seguro]   = strval(string_read[12]);
        PlayerConce[playerid][carro][conce_alarme]   = strval(string_read[13]);
        PlayerConce[playerid][carro][conce_date]     = strval(string_read[14]);
        PlayerConce[playerid][carro][conce_despesas] = strval(string_read[15]);
        format(PlayerConce[playerid][carro][conce_placa], 25, string_read[16]);
        format(PlayerConce[playerid][carro][conce_textol], 75, string_read[17]);

        // Tunning
        format(string, sizeof string, "tune_%d", carro);
        orm_addvar_string(ormid, string_save, 258, string);

        split(string_save, string_read, '|');

        for(new component; component != 15; component++) {
            PlayerConce[playerid][carro][conce_tune][component] = strval(string_read[component]);
        }
    }
    for(new index; index != MAX_PLAYER_ATTACHED_OBJECTS; index++) 
    {
        // Acessorios Informações
        format(string, sizeof string, "itens_%d", index);
        orm_addvar_string(ormid, string_save, sizeof(string_save), string);

        split(string_save, string_read, '|');

        format(acessorioInfo[playerid][index][acessorioNome], 75, string_read[1]);
        acessorioInfo[playerid][index][acessorioValid]  = strval(string_read[0]);
        acessorioInfo[playerid][index][acessorioModelo] = strval(string_read[2]);
        acessorioInfo[playerid][index][acessorioBone]   = strval(string_read[3]);
        // Coordenadas
        acessorioInfo[playerid][index][acessorioPos][0] = floatstr(string_read[4]);
        acessorioInfo[playerid][index][acessorioPos][1] = floatstr(string_read[5]);
        acessorioInfo[playerid][index][acessorioPos][2] = floatstr(string_read[6]);
        // Rotação
        acessorioInfo[playerid][index][acessorioRot][0] = floatstr(string_read[7]);
        acessorioInfo[playerid][index][acessorioRot][1] = floatstr(string_read[8]);
        acessorioInfo[playerid][index][acessorioRot][2] = floatstr(string_read[9]);
        // Tamanho
        acessorioInfo[playerid][index][acessorioTam][0] = floatstr(string_read[10]);
        acessorioInfo[playerid][index][acessorioTam][1] = floatstr(string_read[11]);
        acessorioInfo[playerid][index][acessorioTam][2] = floatstr(string_read[12]);
    }

    orm_setkey(ormid, "nome");

    // tell the orm system to load all data, assign it to our variables and call our callback when ready
    orm_load(ormid, "OnPlayerLoginCheck", "dd", playerid, g_MysqlRaceCheck[playerid]);