Deleting User Accounts

[SolidusZA 3]

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.

[kyleflow 35]

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.

[SolidusZA 3]

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.

[kyleflow 35]

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.

[MonkeyCode 453]

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

[mkhzaleh 131]

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