Using cache_get_row_float and other questions

Using cache_get_row_float and other questions - 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: Using cache_get_row_float and other questions (/showthread.php?tid=571000)

Using cache_get_row_float and other questions - Parallax - 15.04.2015

1.

Код:

    cache_get_row(0, 0, strr); pData[playerid][ID] = strval(strr);
    cache_get_row(0, 4, strr); pData[playerid][Level] = strval(strr);
    cache_get_row(0, 5, strr); pData[playerid][Colour] = strval(strr);
    cache_get_row(0, 6, strr); pData[playerid][RegTime] = strval(strr);
    cache_get_row(0, 7, strr); pData[playerid][OnlineTime] = strval(strr);
    cache_get_row(0, 8, strr); pData[playerid][Score] = strval(strr);
    cache_get_row(0, 9, strr); pData[playerid][Money] = strval(strr);
    
    pData[playerid][pX] = cache_get_row_float(0, 10);
    pData[playerid][pY] = cache_get_row_float(0, 11);
    pData[playerid][pZ] = cache_get_row_float(0, 12);

Are those correct? Anything off or missing?

2. How would I make a player spawn, wherein the data would be taken from the MySQL database? Should it be in :-

Under the same stock (stock which contains code being executed after player logs in after password check)?

Under OnPlayerSpawn or any other callback?

Thanks.

Re: Using cache_get_row_float and other questions - JeaSon - 15.04.2015

Код:

<parallx> what's the difference between cache_get_row_float and cache_get_field_content_float?

Cache_get_row_float means it load player float with row id and in cache_get_field_content_float it load player float with row name

example

Код:

pData[playerid][pX] = cache_get_row_float(0, 10); // row number is 10 its an example

Cache_get_field_content_float and it doesnt matter if px row is 10 or 12

Код:

 pData[playerid][pX] = cache_get_field_content_float(0,"px");

Код:

public OnPlayerSpawn(playerid)
{

    SetPlayerPos(playerid, pData[playerid][pX], pData[playerid][pY], pData[playerid][pZ]);
    return 1;
}

Re: Using cache_get_row_float and other questions - Awdratai - 15.04.2015

Quote:

Originally Posted by Parallax

Код:

    cache_get_row(0, 0, strr); pData[playerid][ID] = strval(strr);
    cache_get_row(0, 4, strr); pData[playerid][Level] = strval(strr);
    cache_get_row(0, 5, strr); pData[playerid][Colour] = strval(strr);
    cache_get_row(0, 6, strr); pData[playerid][RegTime] = strval(strr);
    cache_get_row(0, 7, strr); pData[playerid][OnlineTime] = strval(strr);
    cache_get_row(0, 8, strr); pData[playerid][Score] = strval(strr);
    cache_get_row(0, 9, strr); pData[playerid][Money] = strval(strr);
    
    pData[playerid][pX] = cache_get_row_float(0, 10);
    pData[playerid][pY] = cache_get_row_float(0, 11);
    pData[playerid][pZ] = cache_get_row_float(0, 12);

Are those correct? Anything off or missing?

2. How would I make a player spawn, wherein the data would be taken from the MySQL database? Should it be in :-

Under the same stock (stock which contains code being executed after player logs in after password check)?

Under OnPlayerSpawn or any other callback?

Thanks.

You should use cache_get_row_int or cache_get_field_content_int to get integer from MySQL.

Код:

pData[playerid][ID] = cache_get_row_int(0, 0);
pData[playerid][Level] = cache_get_row_int(0, 4);
pData[playerid][Colour] = cache_get_row_int(0, 5);
pData[playerid][RegTime] = cache_get_row_int(0, 6);
pData[playerid][OnlineTime] = cache_get_row_int(0, 7);
pData[playerid][Score] = cache_get_row_int(0, 8);
pData[playerid][Money] = cache_get_row_int(0, 9);

If you save it as integer in MySQL database, you should.

Re: Using cache_get_row_float and other questions - Konstantinos - 15.04.2015

1. cache_get_row_int and cache_get_row_float are slightly faster than using cache_get_row and strval/floatstr.

Also cache_get_row and cache_get_row_* functions are faster than using cache_get_field_content and cache_get_field_content_* functions.

2. After loading and storing the data to variables, you can use SetSpawnInfo to change the spawn position with the coordinates you loaded.

Re: Using cache_get_row_float and other questions - Parallax - 15.04.2015

Quote:

Originally Posted by JeaSon

-snip-

Someone did notice my IRC help msg, thanks man!

Quote:

Originally Posted by Awdratai

-snip-

Ah, thanks for the restructuring!

Quote:

Originally Posted by Konstantinos

-snip-

Where should I put the SetSpawnInfo code? On OnPlayerSpawn or?

Re: Using cache_get_row_float and other questions - Konstantinos - 15.04.2015

In the public function you assign the data to the player's variables.

pawn Код:

// assigning..
...
pData[playerid][pX] = cache_get_row_float(0, 10);
pData[playerid][pY] = cache_get_row_float(0, 11);
pData[playerid][pZ] = cache_get_row_float(0, 12);

SetSpawnInfo(playerid, ..., pData[playerid][pX], pData[playerid][pY], pData[playerid][pZ], ...);
SpawnPlayer(playerid);

Re: Using cache_get_row_float and other questions - Parallax - 15.04.2015

Quote:

Originally Posted by Konstantinos

In the public function you assign the data to the player's variables.

pawn Код:

// assigning..
...
pData[playerid][pX] = cache_get_row_float(0, 10);
pData[playerid][pY] = cache_get_row_float(0, 11);
pData[playerid][pZ] = cache_get_row_float(0, 12);

SetSpawnInfo(playerid, ..., pData[playerid][pX], pData[playerid][pY], pData[playerid][pZ], ...);
SpawnPlayer(playerid);

That did the trick! Thanks!