Worldofjimmy Posted August 16, 2019 Share Posted August 16, 2019 Hello,  MYSQL for player database.  How does database cleanup work when deleting a character? Deleting a character from the client it seems to automatically clean the database.  How would I correctly delete a character with a mysql query? Do I have to locate all the rows related to the character?  Thanks in advance  Link to comment Share on other sites More sharing options...
0 jcsnider Posted August 16, 2019 Share Posted August 16, 2019 You should wait until the functionality is safely provided through the Servers API. Editing the DB directly while the server is running will cause your server to crash.  But yes, you'd just locate all rows with the character id of the one your're deleting and remove them. Link to comment Share on other sites More sharing options...
0 Worldofjimmy Posted August 16, 2019 Author Share Posted August 16, 2019 Thanks @jcsnider for the explanation, Okay I understand, I'll wait for the Servers API   Link to comment Share on other sites More sharing options...
Question
Worldofjimmy
Hello,
Â
MYSQL for player database.
Â
How does database cleanup work when deleting a character?
Deleting a character from the client it seems to automatically clean the database.
Â
How would I correctly delete a character with a mysql query? Do I have to locate all the rows related to the character?
Â
Thanks in advance
Â
Link to comment
Share on other sites
2 answers to this question
Recommended Posts