[THE_KNOWN]

how do you make mysql save data when the player crashes or server restarts?

[Macluawn]

onplayerdisconnect is called even if player crashes.

[THE_KNOWN]

but it doesnt seem to work

[Ash.]

You could just run a looping timer for, lets say, 5 minutes that would save the players data.

[Alex_Valde]

I think that OnPlayerDisconnect is not called on player crash.
You should to what funky1234 said.

[THE_KNOWN]

buti want it to save the players exact position on crash (i thought of useing a loop for everysecond but i think itll increase cpu usage)

[sabretur]

It's impossible.

[THE_KNOWN]

ok then can you guys help me how to set a timer for it?
here is the saving part which is called on player disconnect.

Код:

SavePlayer(playerid)
{
	if(!PlayerLogged[playerid])
	return 0;
   	Money[playerid] = GetPlayerMoney(playerid);
   	skin[playerid] = GetPlayerSkin(playerid);
   	GetPlayerPos(playerid, X[playerid],Y[playerid],Z[playerid]);
   	GetPlayerFacingAngle(playerid, Ang[playerid]);

	CheckMySQL();

   	new string[256];
   	format(string, sizeof(string), "UPDATE Users SET Money='%d',skin='%d',X='%f',Y='%f',Z='%f',Angle='%f',dlic='%d' WHERE Name='%s'", Money[playerid], skin[playerid],X[playerid],Y[playerid],Z[playerid],Ang[playerid],dlic[playerid], Name[playerid]);
   	mysql_query(string);
   	return 1;
}

[Alex_Valde]

Yeah, you can't actually do it (or I can't thing of a way to do this).
But you can start a timer with save time between 4<x secs what can save pos.
Every second loop will really drain your CPU.

[THE_KNOWN]

so can you help me with the timer?