SQLite functions! - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQLite functions! (/showthread.php?tid=387483)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQLite functions! (/showthread.php?tid=387483)
SQLite functions! - Youice - 25.10.2012
Hello There,
What is the difference between db_get_field_assoc and db_get_field ?
Note: please give examples with explanation (not defines)
Re: SQLite functions! - Emmet_ - 25.10.2012
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
Re: SQLite functions! - ReneG - 25.10.2012
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.
Re: SQLite functions! - Youice - 25.10.2012
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 |
Re: SQLite functions! - Youice - 25.10.2012
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;
}
Re: SQLite functions! - ReneG - 25.10.2012
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
Re: SQLite functions! - Youice - 25.10.2012
then what shall I do?
Re: SQLite functions! - ReneG - 25.10.2012
Change your fetching strings to.
PHP код:
new Field[30], x[30], y[30], z[30], a[30];
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);
Re: SQLite functions! - Youice - 25.10.2012
sorry, but still I receive a crash
Re: SQLite functions! - Kevin FOx - 25.10.2012
a ya 3am nawy t3ml a?