[Youice]

Hello There,

What is the difference between db_get_field_assoc and db_get_field ?

Note: please give examples with explanation (not defines)

[Emmet_]

db_get_field gets a value from the specified field ID, while db_get_field_assoc gets a value from the specified field name.

https://sampwiki.blast.hk/wiki/Db_get_field
https://sampwiki.blast.hk/wiki/Db_get_field_assoc

[ReneG]

db_get_field fetches the field content passed by a field number.

db_get_field_assoc fetches the field that matches the fieldname you passed.

In theory, db_get_field_assoc should be slower than db_get_field, because db_get_field_assoc has to loop through the fields and compare names.

[Youice]

Quote:

Originally Posted by VincentDunn db_get_field fetches the field content passed by a field number. db_get_field_assoc fetches the field that matches the fieldname you passed. In theory, db_get_field_assoc should be slower than db_get_field, because db_get_field_assoc has to loop through the fields and compare names.

Quote:

Originally Posted by Emmet_ db_get_field gets a value from the specified field ID, while db_get_field_assoc gets a value from the specified field name. https://sampwiki.blast.hk/wiki/Db_get_field https://sampwiki.blast.hk/wiki/Db_get_field_assoc

Thank you both (rep++)

[Youice]

any one knows why this code crashes my server?

PHP код:

LoadData(playerid)
{
    new DBResult: query, szQuery[200], szPlayerName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);
    new Field[20], x[20], y[20], z[20], a[20];
    format(szQuery, sizeof(szQuery), "SELECT * from players WHERE NAME = '%s'", DB_Escape(szPlayerName));
    query = db_query(someDB, szQuery);
    if(db_num_rows(query))
    {
        db_get_field_assoc(query, "CASH", Field, 30);
        GivePlayerMoney(playerid, strval(Field));
        //---
        db_get_field_assoc(query, "ADMINLEVEL", Field, 30);
        pData[playerid][pAdminLevel] = strval(Field);
        //---
        db_get_field_assoc(query, "LEVEL", Field, 30);
        SetPlayerScore(playerid, strval(Field));
           //---
           db_get_field_assoc(query, "GENDER", Field, 30);
        pData[playerid][pGender] = strval(Field);
        //---
        db_get_field_assoc(query, "AGE", Field, 30);
        pData[playerid][pAge] = strval(Field);
        //---
        db_get_field_assoc(query, "SKIN", Field, 30);
        SetPlayerSkin(playerid, strval(Field));
        new    skin =  strval(Field);
        //---
          db_get_field_assoc(query, "GUN1", Field, 30);
        GivePlayerWeapon(playerid, strval(Field), pData[playerid][pAmmo1]);
         //---
          db_get_field_assoc(query, "GUN2", Field, 30);
        GivePlayerWeapon(playerid, strval(Field), pData[playerid][pAmmo2]);
         //---
         db_get_field_assoc(query, "GUN3", Field, 30);
        GivePlayerWeapon(playerid, strval(Field), pData[playerid][pAmmo3]);
         //---
          db_get_field_assoc(query, "AMMO1", Field, 30);
        SetPlayerAmmo(playerid, pData[playerid][pGun1],  strval(Field));
          //---
           db_get_field_assoc(query, "AMMO2", Field, 30);
        SetPlayerAmmo(playerid, pData[playerid][pGun2],  strval(Field));
        //---
        db_get_field_assoc(query, "AMMO3", Field, 30);
        SetPlayerAmmo(playerid, pData[playerid][pGun3],  strval(Field));
        //---
        db_get_field_assoc(query, "POS_X", x, 30);
        db_get_field_assoc(query, "POS_Y", y, 30);
        db_get_field_assoc(query, "POS_Z", z, 30);
        db_get_field_assoc(query, "POS_A", a, 30);
        pData[playerid][pPos_x] = strval(x);
        pData[playerid][pPos_y] = strval(y);
        pData[playerid][pPos_z] = strval(z);
        pData[playerid][pPos_a] = strval(a);
        SetSpawnInfo(playerid, 0, skin, pData[playerid][pPos_x], pData[playerid][pPos_y], pData[playerid][pPos_z], pData[playerid][pPos_a], pData[playerid][pGun1], pData[playerid][pAmmo1],pData[playerid][pGun2], pData[playerid][pAmmo2], pData[playerid][pGun3], pData[playerid][pAmmo3]);
        SpawnPlayer(playerid);
        //if(pData[playerid][pGun1] != 0 || pData[playerid][pGun2] != 0 || pData[playerid][pGun3] != 0) { return SendClientMessage(playerid, COLOR_YELLOW, "[TIPS]:"COL_GREEN" /getweapons to restore back your weapons");
    }
    else {
        SendClientMessage(playerid, COLOR_RED, "ERROR(001): Couldn't Load Your DatBase");
    }
    return 1;
} 


[ReneG]

I think it's because you're creating the string "Field" with a cell-size of 20, when the length in db_get_field_assoc is 30.

EDIT: try de-bugging

[Youice]

then what shall I do?

[ReneG]

Change your fetching strings to.

PHP код:

new Field[30], x[30], y[30], z[30], a[30]; 


and replace this in your script as well

PHP код:

pData[playerid][pPos_x] = floatstr(x); 
        pData[playerid][pPos_y] = floatstr(y); 
        pData[playerid][pPos_z] = floatstr(z); 
        pData[playerid][pPos_a] = floatstr(a); 


[Youice]

sorry, but still I receive a crash

[Kevin FOx]

a ya 3am nawy t3ml a?