[DSASDFGH]

I wrote the simple level plugin for ZR with use SQL, But when server crash or type '_restart' command, informations are reset to 0 for people who still playing game or connected, How can i fix this? (Or how to do something before server crashing)

-------------------------------------------------------------------------
Cause was my wrong variable usage

[Miu]

Save stuff in OnPluginEnd or, preferably, as it gets set

[DSASDFGH]

Originally Posted by Miu Save stuff in OnPluginEnd or, preferably, as it gets set

OK, I changed connect db from OnPluginStart to OnConfigsExecuted and add save all clients stats on sql to OnPluginEnd, Seems working.
(Thanks for it, i was got cancer due to that)

But i wonder why only CS:GO works OnMapStart twice,
These are steps that i tried.

Run Server
OnMapStart fired once
Connect to server when hibernating
OnMapStart fired again

[Impact123]

Save the data periodically, say each 30 seconds or so. It depends on the plugin, but these are good times to save.

• OnMapEnd
• OnRoundEnd
• OnPlayerDisconnect
• OnPluginEnd
• OnPlayerDeath

[DSASDFGH]

Originally Posted by Impact123 Save the data periodically, say each 30 seconds or so. It depends on the plugin, but these are good times to save. OnMapEnd OnRoundEnd OnPlayerDisconnect OnPluginEnd OnPlayerDeath

Well, I cannot find reasons why players data reset to '0', Is it a bug?

And load the data when 'OnClientPostAdminCheck'

PHP Code:

public is_user_valid(id)
{
 if (id == 0)
  return false;
 if (!IsClientConnected(id))
  return false;
 if (!IsClientInGame(id))
  return false;
 if (IsFakeClient(id))
  return false;
 return true;
} 


and check valid player for load data

[Miu]

OnPluginEnd won't always fire so you should probably fix the bug. If the data is actually being set to 0 in the database, you could try turning on query logging for your SQL server and see what's causing it.

[DSASDFGH]

Originally Posted by Miu OnPluginEnd won't always fire so you should probably fix the bug. If the data is actually being set to 0 in the database, you could try turning on query logging for your SQL server and see what's causing it.

Thanks for you.

For now, bug has been fixed successfully.

Cause was my wrong variable usage