[AiRaLoKa]

hei all...

i got one more problem here....

is there any callback like OnPlayerCrashed?
becouse when the player is disconnected becouse of crashed, his statistic will not saved....
any ideas?

P.S.: i used BlueG's MySQL R5

[Lordzy]

When the reason on OnPlayerDisconnect gets called as 0, it means the player had timedout or might have crashed. Instead of using the functions which gets the data from the game, store them on arrays. So when the player gets disconnected, you can send a 1 second delayed timer as if you're using R5 version of MySQL to save the data to the database. However, I suggest you to use threaded queries as it's faster and efficient on such cases.

pawn Код:

public OnPlayerDisconnect(playerid, reason)
{
    if(reason == 0) { //If it's a crash:
         //Instead of using GetPlayerMoney or GetPlayerScore, store them on an array earlier.
        //Stuffs.
    }
    return 1;
}

[AiRaLoKa]

Quote:

Originally Posted by Lordzy When the reason on OnPlayerDisconnect gets called as 0, it means the player had timedout or might have crashed. Instead of using the functions which gets the data from the game, store them on arrays. So when the player gets disconnected, you can send a 1 second delayed timer as if you're using R5 version of MySQL to save the data to the database. However, I suggest you to use threaded queries as it's faster and efficient on such cases. pawn Код: public OnPlayerDisconnect(playerid, reason) {     if(reason == 0) { //If it's a crash:          //Instead of using GetPlayerMoney or GetPlayerScore, store them on an array earlier.         //Stuffs.     }     return 1; }

how to use threaded mysql?

[Campbell-]

Quote:

Originally Posted by Lordzy When the reason on OnPlayerDisconnect gets called as 0, it means the player had timedout or might have crashed. Instead of using the functions which gets the data from the game, store them on arrays. So when the player gets disconnected, you can send a 1 second delayed timer as if you're using R5 version of MySQL to save the data to the database. However, I suggest you to use threaded queries as it's faster and efficient on such cases. pawn Код: public OnPlayerDisconnect(playerid, reason) {     if(reason == 0) { //If it's a crash:          //Instead of using GetPlayerMoney or GetPlayerScore, store them on an array earlier.         //Stuffs.     }     return 1; }

1. It doesn't matter whether the player crashes, gets kicked/banned, times out or disconnects. The functions GetPlayerScore(), GetPlayerMoney(), ... work at all times in the OnPlayerDisconnect()-Callback. There is no need to save any data at all times in other data structures just for the case that a player crashes.
2. Threaded queries are not faster at all. They just get processed on another thread of the process running to avoid the actual script to stop until the query is fully processed.
3. Why are you still using BlueG's MySQL R5? It is outdated, filled with bugs and less efficient with less functionality.
4. The code below works just fine ...

pawn Код:

public OnPlayerDisconnect(playerid, reason) {
    saveData(playerid);
    return 1;
}

saveData(playerid) {
    // BlueG's MySQL Plugin R38
    new query[100];
    mysql_format(handle, query, sizeof(query), "UPDATE `samp_users` SET `pScore` = %i, `pMoney` = %i WHERE `pID` = %i;", GetPlayerScore(playerid), GetPlayerMoney(playerid), playerDatabaseID);
    mysql_tquery(handle, query, "", "");
}

[AiRaLoKa]

Quote:

Originally Posted by Campbell- It doesn't matter whether the player crashes, gets kicked/banned, times out or disconnects. The functions GetPlayerScore(), GetPlayerMoney(), ... work at all times in the OnPlayerDisconnect()-Callback. There is no need to save any data at all times in other data structures just for the case that a player crashes. Threaded queries are not faster at all. They just get processed on another thread of the process running to avoid the actual script to stop until the query is fully processed. Why are you still using BlueG's MySQL R5? It is outdated, filled with bugs and less efficient with less functionality. The code below works just fine ... pawn Код: public OnPlayerDisconnect(playerid, reason) {     saveData(playerid);     return 1; } saveData(playerid) {     // BlueG's MySQL Plugin R38     new query[100];     mysql_format(handle, query, sizeof(query), "UPDATE `samp_users` SET `pScore` = %i, `pMoney` = %i WHERE `pID` = %i;", GetPlayerScore(playerid), GetPlayerMoney(playerid), playerDatabaseID);     mysql_tquery(handle, query, "", ""); }

thanks for your explaination.....
+REP for all