How to delete accounts and players

[zapo]

How to safely remove all accounts with players (except a few) so that, for example, the player charms will also remove where lines is the player id.

 

[Azakelis]

forgottenserver/schema.sql at master · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

As you can see there every reference is "ON DELETE CASCADE" which means if you delete for example an account it will also drop all player characters this account has, player character deletion leads to deletion of all of the references too etc.
So you only need to delete the account and it will safely delete every reference from the database.

 

[monkeyy]

Thanks Ill try this soon!