[FelipeAndres]

Hello
I have two questions

when saving an account OnPlayerDisconnect,
It is better to use mysql_function_query or mysql_query?

I've never used this

PHP Code:

public SavePlayer(playerid)
{
    new query[100];
    mysql_format(db, query, sizeof(query), "UPDATE `players` SET money = %d, score = %d WHERE `nick` = '%e'", Money[playerid], Score[playerid], name(playerid));
    mysql_query(db, query, false);
    return 1;
} 


OR

I have always used this way, okay well?

PHP Code:

public SavePlayer(playerid)
{
    new query[100];
    mysql_format(db, query, sizeof(query), "UPDATE `players` SET money = %d, score = %d WHERE `nick` = '%e'", Money[playerid], Score[playerid], name(playerid));
    mysql_function_query(db, query, false, "", "");
    return 1;
} 


other question:
rarely (almost never), some players lose their statistics.
It happens 1 time in 10000 so to speak, this only happens with statistics that are saved when the player is disconnected, for example score, money, etc.

PHP Code:

new query[100];
mysql_format(db, query, sizeof(query), "UPDATE `players` SET money = %d, score = %d WHERE `nick` = '%e'", Money[playerid], Score[playerid], name(playerid));
mysql_function_query(db, query, false, "", ""); 


thanks

[Konstantinos]

1) Always use threaded queries.
2) The only reason I can think of it happen is if the query isn't executed in OnPlayerDisconnect and it is delayed which the variables eventually get reset.

[FelipeAndres]

thanks for answering

which of the two functions would be threaded?

[AndySedeyn]

Neither. mysql_tquery is the function for threaded queries.

[FelipeAndres]

mysql_function_query is not the same as mysql_tquery?

[Konstantinos]

mysql_function_query was a macro for mysql_tquery in R33+ versions.

[Rdx]

Quote:

Originally Posted by Konstantinos 1) Always use threaded queries.

Why? It is gonna work without threaded query too.

[Konstantinos]

Quote:

Originally Posted by Rdx Why? It is gonna work without threaded query too.

Sure it will but the question was which one (non-threaded queries vs threaded queries) is better and the answer is obvious as we all know.

[FelipeAndres]

you could suggest something to avoid the problem of losing OnPlayerDisconnect statistics?
I would thank you a lot