[fireattack]

I'm doing a system where people have their own account with password, the problem is when they try to connect with the same account on two servers, they can clone stats so I thought of making a new security system:

User connect so flag on DB `online` put to "1" and I check that, so no more users can connect to this account.

The problem : If the User is playing and someone crash the server I can't put their flag on 0 when he disconnect so that account keep blocked and he can't join again.

I need ideas to fix this, I tried with plugin_end( ) and nothing. Thank you.

[lucas_7_94]

register_forward(FM_GameShutdown, "fw_Sys_Error")

?

[fireattack]

I'm going to try.

Edit: Not working, but thank you lucas_7_94. Autobuy bug used to test.

[Sylwester]

First assign unique identifiers to all your servers, then instead of flag in DB `online` make an INT that stores unique identifier of a server on which user has logged in or 0 if user is not logged in.
Second make another table that has 2 columns: server_unique_id int primary_key, last_seen datetime, and make every server update last_seen with current timestamp lets say every 15 seconds.

If user is trying to log in check if he is logged in on some server. If true then check if current timestamp - last_seen is greater than 30 seconds.
Also when server is starting do update of `online` table and set server unique id = 0 where server unique id = id of that server.

[fireattack]

Originally Posted by Sylwester First assign unique identifiers to all your servers, then instead of flag in DB `online` make an INT that stores unique identifier of a server on which user has logged in or 0 if user is not logged in. Second make another table that has 2 columns: server_unique_id int primary_key, last_seen datetime, and make every server update last_seen with current timestamp lets say every 15 seconds. If user is trying to log in check if he is logged in on some server. If true then check if current timestamp - last_seen is greater than 30 seconds. Also when server is starting do update of `online` table and set server unique id = 0 where server unique id = id of that server.

Nice idea, testing.
Edit : Done.