MySQL - What are rows and fields?

MySQL - What are rows and fields? - 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: MySQL - What are rows and fields? (/showthread.php?tid=572486)

MySQL - What are rows and fields? - Ciarannn - 28.04.2015

Код:

cache_get_field_content_int(row, const field_name[], connectionHandle = 1)

The above line of code is what I am using multiple times. Below is part of my code:

Код:

PlayerInfo[playerid][pSpawn] = cache_get_field_content_int(0, "Spawn");
PlayerInfo[playerid][pGender] = cache_get_field_content_int(0, "Gender");
PlayerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
PlayerInfo[playerid][pEntered] = cache_get_field_content_int(0, "Entered");
PlayerInfo[playerid][pMinutes] = cache_get_field_content_int(0, "Minutes");
PlayerInfo[playerid][pTMinutes] = cache_get_field_content_int(0, "TMinutes");
PlayerInfo[playerid][pHours] = cache_get_field_content_int(0, "Hours");
PlayerInfo[playerid][pAge] = cache_get_field_content_int(0, "Age");
PlayerInfo[playerid][pADMute] = cache_get_field_content_int(0, "ADMute");
PlayerInfo[playerid][pModel] = cache_get_field_content_int(0, "Model");
PlayerInfo[playerid][pModel1] = cache_get_field_content_int(0, "Model1");
PlayerInfo[playerid][pModel2] = cache_get_field_content_int(0, "Model2");
PlayerInfo[playerid][pModel3] = cache_get_field_content_int(0, "Model3");
PlayerInfo[playerid][pMapper] = cache_get_field_content_int(0, "Mapper");
PlayerInfo[playerid][pBanned] = cache_get_field_content_int(0, "Banned");
PlayerInfo[playerid][pNumber] = cache_get_field_content_int(0, "Number");
PlayerInfo[playerid][pKill] = cache_get_field_content_int(0, "Kill");
PlayerInfo[playerid][pDeath] = cache_get_field_content_int(0, "Death");
PlayerInfo[playerid][pInt] = cache_get_field_content_int(0, "Interior");
PlayerInfo[playerid][pVW] = cache_get_field_content_int(0, "Virtual World");

I have over 150 lines of the above code for all my different variables and strings. I set the row to 0 at first not knowing what it was, but since the code is not loading, I think it has something to do with that. Can someone help?

EDIT:
Also, is this the most efficient way of saving everything?

Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `VehVW`=%d, `WalkStyle`=%d, `Fac`=%d, `FacRank`=%d, `FacLeader`=%d, 'FacDiv'=%d, 'FacDivLeader'=%d, 'FacDuty'=%d, 'Weapon[0]'=%d, 'Weapon[1]'=%d WHERE `ID`=%d",
PlayerInfo[playerid][pVehVW], PlayerInfo[playerid][pWalkStyle], PlayerInfo[playerid][pFac], PlayerInfo[playerid][pFacRank], PlayerInfo[playerid][pFacLeader], PlayerInfo[playerid][pFacDiv], PlayerInfo[playerid][pFacDivLeader], PlayerInfo[playerid][pFacDuty], PlayerInfo[playerid][pWeapon][0], PlayerInfo[playerid][pWeapon][1], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
	
mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Weapon[2]`=%d, `Weapon[3]`=%d, `Weapon[4]`=%d, `Weapon[5]`=%d, `Weapon[6]`=%d, 'Weapon[7]'=%d, 'Weapon[8]'=%d, 'Weapon[9]'=%d, 'Weapon[10]'=%d, 'Weapon[11]'=%d, 'Weapon[12]'=%d WHERE `ID`=%d",
PlayerInfo[playerid][pWeapon][2], PlayerInfo[playerid][pWeapon][3], PlayerInfo[playerid][pWeapon][4], PlayerInfo[playerid][pWeapon][5], PlayerInfo[playerid][pWeapon][6], PlayerInfo[playerid][pWeapon][7], PlayerInfo[playerid][pWeapon][8], PlayerInfo[playerid][pWeapon][9], PlayerInfo[playerid][pWeapon][10], PlayerInfo[playerid][pWeapon][11], PlayerInfo[playerid][pWeapon][12], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");

Again, I use the code above multiple times as it has to cover all my variables.

Re: MySQL - What are rows and fields? - Konstantinos - 28.04.2015

When you select a player's data from the database, you know for sure that the max records exist for that player is 1 so the row is 0.

In case you'd select everything from a table and use a loop, the variable is used in the iterator would be the "rowid" instead.

About the not loading part, you'll need to explain more about what actually happens.

EDIT:

The first query is fine, if you remove `` around the fields you can then reduce the size of it.

About the second one, I've never used "name[x]" and I'm not sure if it's acceptable (check mysql logs) but there's a really good tutorial about how to save weapons: https://sampforum.blast.hk/showthread.php?tid=505081

Re: MySQL - What are rows and fields? - Ciarannn - 28.04.2015

The saving part only saves the first set. So, for example:

Код:

new query[518];
mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Admin`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d", PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pX], PlayerInfo[playerid][pY], PlayerInfo[playerid][pZ], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");

mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Gender`=%d, `Level`=%d, `Entered`=%d, `Minutes`=%d, `TMinutes`=%d, 'Hours'=%d, 'Age'=%d, 'Bank'=%d, 'Model'=%d, 'Model1'=%d WHERE `ID`=%d",
PlayerInfo[playerid][pGender], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pEntered], PlayeInfo[playerid][pMinutes], PlayerInfo[playerid][pTMinutes], PlayerInfo[playerid][pHours], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pModel1], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");

These two are at the top of the stock that saves all my variables when the player logs out. It only saves the first set, so like the Admin, posX, PosY ect... is saved, but the Gender, Hours, Level is not.

I'm having a problem with the Gender especially. When they select their gender, I do:

Код:

PlayerInfo[playerid][pGender] = 1; //male

And when they log out the stock above is called so that it saves it but when I check the database it's not saved.

Re: MySQL - What are rows and fields? - Konstantinos - 28.04.2015

"... 'Hours'=%d, 'Age'=%d, 'Bank'=%d, 'Model'=%d, 'Model1'=%d ..."

You used '' around the fields name instead of ``.

Re: MySQL - What are rows and fields? - Ciarannn - 28.04.2015

Quote:

Originally Posted by Konstantinos

"... 'Hours'=%d, 'Age'=%d, 'Bank'=%d, 'Model'=%d, 'Model1'=%d ..."

You used '' around the fields name instead of ``.

Shit. How do you do that little one?

EDIT: Got it.

Re: MySQL - What are rows and fields? - Konstantinos - 28.04.2015

No need to use any grave accent:

pawn Код:

"UPDATE users SET Gender=%d, Level=%d, Entered=%d, Minutes=%d, TMinutes=%d, Hours=%d, Age=%d, Bank=%d, Model=%d, Model1=%d WHERE ID=%d"

Re: MySQL - What are rows and fields? - Ciarannn - 28.04.2015

Код:

PlayerInfo[playerid][pSpawn] = cache_get_field_content_int(0, "Spawn");
PlayerInfo[playerid][pGender] = cache_get_field_content_int(0, "Gender");
PlayerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
PlayerInfo[playerid][pEntered] = cache_get_field_content_int(0, "Entered");
PlayerInfo[playerid][pMinutes] = cache_get_field_content_int(0, "Minutes");
PlayerInfo[playerid][pTMinutes] = cache_get_field_content_int(0, "TMinutes");
PlayerInfo[playerid][pHours] = cache_get_field_content_int(0, "Hours");
PlayerInfo[playerid][pAge] = cache_get_field_content_int(0, "Age");
PlayerInfo[playerid][pADMute] = cache_get_field_content_int(0, "ADMute");
PlayerInfo[playerid][pModel] = cache_get_field_content_int(0, "Model");
PlayerInfo[playerid][pModel1] = cache_get_field_content_int(0, "Model1");
PlayerInfo[playerid][pModel2] = cache_get_field_content_int(0, "Model2");
PlayerInfo[playerid][pModel3] = cache_get_field_content_int(0, "Model3");
PlayerInfo[playerid][pMapper] = cache_get_field_content_int(0, "Mapper");
PlayerInfo[playerid][pBanned] = cache_get_field_content_int(0, "Banned");
PlayerInfo[playerid][pNumber] = cache_get_field_content_int(0, "Number");
PlayerInfo[playerid][pKill] = cache_get_field_content_int(0, "Kill");
PlayerInfo[playerid][pDeath] = cache_get_field_content_int(0, "Death");
PlayerInfo[playerid][pInt] = cache_get_field_content_int(0, "Interior");
PlayerInfo[playerid][pVW] = cache_get_field_content_int(0, "Virtual World");

With using this, is there something I need to use to define what user to save it to? Like an ID for something?
I use an ID to define the saving, should it be the same for loading?

Like:

Код:

WHERE `ID`=%d"

Re: MySQL - What are rows and fields? - Konstantinos - 28.04.2015

When a player connects, the only thing you know is their name, not their unique ID to the database so you'll use the name for loading and ID for saving (like you have it most likely).

Re: MySQL - What are rows and fields? - Ciarannn - 28.04.2015

Quote:

Originally Posted by Konstantinos

When a player connects, the only thing you know is their name, not their unique ID to the database so you'll use the name for loading and ID for saving (like you have it most likely).

No, I dont. How do I add that? I have a unique ID for each account saved in PlayerInfo[playerid][ID]. How do I use it?

Re: MySQL - What are rows and fields? - Konstantinos - 28.04.2015

You already do. You save (UPDATE query) using the ID at WHERE clause.