[Micko123]

Can someone explain me this

PHP код:

cache_get_value_int(0, "id", PlayerInfo[playerid][ID]); 


I don't get what this '0' is??

[MerryDeer]

it's row

[Micko123]

But I don't get it.. If I have more than 1 player registered how its going to be??
I am newbie to MySQL so..

[Micko123]

Is this for assign player's data on spawn??

PHP код:

AssignPlayerData(playerid)
{
    cache_get_value_int(0, "id", PlayerInfo[playerid][ID]);
    cache_get_value_int(0, "kills", PlayerInfo[playerid][Kills]);
    cache_get_value_int(0, "deaths", PlayerInfo[playerid][Deaths]);
    cache_get_value_int(0, "interior", PlayerInfo[playerid][Interior]);
    cache_get_value_int(0, "money", PlayerInfo[playerid][Money]);
    cache_get_value_int(0, "score", PlayerInfo[playerid][Score]);
    cache_get_value_int(0, "admin", PlayerInfo[playerid][Admin]);
    cache_get_value_int(0, "vip", PlayerInfo[playerid][VIP]);
    return 1;
} 


It is called when player types his password. If it is for assigning it is not working. Values are written in database as they should be but ther are not assigned to player.. Any ideas??

[X337]

Код:

cache_get_value_int(row, column_name, &destination);

That function is to assign integer value returned from sql query into a variable.

Example, you have a query that returns these 2 rows.

Код:

+--------+----------+
| id     | name     | <!---- column/fields
+--------+----------+
|      1 | Fineman  | <!---- row 0
|      2 | Finemann | <!---- row 1
+--------+----------+

new value;
cache_get_value_int(0, "id", value); // This code will assign the value from "id" column at row 0 to "value" variable
printf("%d", value); // Output will be 1
cache_get_value_int(1, "id", value); // This code will assign the value from "id" column at row 1 to "value" variable
printf("%d", value); // Output will be 2

More explanation: https://sampwiki.blast.hk/wiki/MySQL/R40

[Micko123]

Thx for this explanation man

But one more question. How do I know when to use this

PHP код:

cache_get_value_int(0, "id", value); 


And when to use this

PHP код:

cache_get_value_int(1, "id", value); 


EDIT: I fixed not loading player's data. I didn't know that row name was case sensitive xD

[F1N4L]

Quote:

Originally Posted by Micko123 Thx for this explanation man But one more question. How do I know when to use this PHP код: cache_get_value_int(0, "id", value);  And when to use this PHP код: cache_get_value_int(1, "id", value);  EDIT: I fixed not loading player's data. I didn't know that row name was case sensitive xD

Correctly for int type:

Код:

new getvalueinteger = cache_get_value_int(1, "id");

[Konstantinos]

Quote:

Originally Posted by F1N4L Correctly for int type: Код: new getvalueinteger = cache_get_value_int(1, "id");

Not anymore, it is passed by reference: https://sampwiki.blast.hk/wiki/MySQL/R40...value_name_int

@Micko: When you select the data for a player, you know the max number of rows will be 1 so the rowid will be 0. For queries with multiple rows returned, you use a loop that goes from rowid 0 to rows_returned-1.

[X337]

Quote:

Originally Posted by F1N4L Correctly for int type: Код: new getvalueinteger = cache_get_value_int(1, "id");

In the newest MySQL plugin, the value passed by reference.

Edit: Too late

[Micko123]

Thank you all guys So much