GolovaRaoul

Player double in database --> spawning dead

4 posts in this topic

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

 

errorDB.PNG

Share this post


Link to post
Share on other sites

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.

1 person likes this

Share this post


Link to post
Share on other sites
Advertisement
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? :P

Share this post


Link to post
Share on other sites
41 minutes ago, GolovaRaoul said:

Would you mind sharing your sql event? :P

DELETE FROM `player` WHERE damage = 1

2 people like this

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.