SolidusZA 3 Report post Posted July 3, 2023 Hi everyone Does anyone know if theres a tool to deleting user accounts (the whole account, all characters etc) Or can I only do it in the SQL database? If so which table do I delete them in. Quote Share this post Link to post Share on other sites
kyleflow 35 Report post Posted July 4, 2023 14 hours ago, SolidusZA said: Hi everyone Does anyone know if theres a tool to deleting user accounts (the whole account, all characters etc) Or can I only do it in the SQL database? If so which table do I delete them in. Simply enter the AccountServer table and find account_login table. delete by line the account you want to delete. 1 Quote Share this post Link to post Share on other sites
SolidusZA 3 Report post Posted July 4, 2023 4 hours ago, kyleflow said: Simply enter the AccountServer table and find account_login table. delete by line the account you want to delete. If they have made characters. I would also need to delete them from the GameDB database as well if im correct. Quote Share this post Link to post Share on other sites
kyleflow 35 Report post Posted July 4, 2023 1 hour ago, SolidusZA said: If they have made characters. I would also need to delete them from the GameDB database as well if im correct. Not true as far as I know. Quote Share this post Link to post Share on other sites
MonkeyCode 453 Report post Posted July 4, 2023 Do not delete data from a database. These data are good for analysing and auditing. You need to become familiar with SQL and the schema. 3 hours ago, kyleflow said: Not true as far as I know. True, account data exists in accountdb? (Cant remember the name) and gamedb Quote Share this post Link to post Share on other sites
mkhzaleh 134 Report post Posted July 5, 2023 if its must to be deleted you have to delete all related table and reseed each table to current index otherwise u will have ids gap when creating new accounts, character first u must delete from accountserver_login and gamedb.account/ character /guild if player is leader in some guilds , resource, friend lists, boat table ,etc just follow account id and cha id Quote Share this post Link to post Share on other sites