Player double in database --> spawning dead

[GolovaRaoul 221]

Hello all,

Sometimes, in the database a player excist twice. One is the dead character (damage=1), and the other one is the new 'Alive' character (damage=0). I can see this in the 'Player' table in the database. When this happens, a player cannot spawn normally, but spawns dead. Respawning is not an option, since the player will spawn dead again. The only solution is for an admin to go manually to the database and delete the dead character. Why is this happening? Could this be because of restarts? And is there a way to make the database delete dead characters automatically, or is there another workaround/solution?

Thanks for responding ^^
GolovaRaoul

 

[BetterDeadThanZed 1006]

This happens frequently. I set up an event that deletes players with damage "1" every 5 minutes. You can delete the dead player and they can log in after that.

[GolovaRaoul 221]

4 hours ago, BetterDeadThanZed said:

This happens frequently. I set up an event that deletes players with damage "1" every 5 minutes. You can delete the dead player and they can log in after that.

Would you mind sharing your sql event?

[BetterDeadThanZed 1006]

41 minutes ago, GolovaRaoul said:

Would you mind sharing your sql event?

DELETE FROM `player` WHERE damage = 1