[Request] Help with inactive players

[[DEV]DjSt3rios]

Hello everyone, i would like to ask if there is anyway, or a program, to find and delete inactive characters/accounts. I searched on the forum, but i didn't find anything. If someone has an idea, please tell me. Thanks for your time.

[Matim]

Hello everyone, i would like to ask if there is anyway, or a program, to find and delete inactive characters/accounts. I searched on the forum, but i didn't find anything. If someone has an idea, please tell me. Thanks for your time.

 

You can create new SQL file.. with simple check.. 'lastactive'

[mogo]

The sql file wouldn't be so simple if you wanted to also delete the characters/items/macros/shortcuts/whatever of the unused account :)

[Alexi]

I think that i have what you asking for...

 

DELETE FROM characters WHERE lastAccess < 466560000;
DELETE FROM accounts WHERE lastactive < 466560000;

 

With this you will delete characters and accounts that  arent connected on your server for 3 months...

[kuba90]

The database has dependancies in its model. For example, a Character depends on the account, and items, skills etc depend on charId. To clean the db you will do the inverse process.

 

Delete skills, items bla bla based on charId, then delete the char, then the accounts. Thats one way to do your script.

[bobolover]

The database has dependancies in its model. For example, a Character depends on the account, and items, skills etc depend on charId. To clean the db you will do the inverse process.

 

Delete skills, items bla bla based on charId, then delete the char, then the accounts. Thats one way to do your script.

is enough to delete account and chars ... l2j have auto cleanup for other things like items or whatever:P if owner of item dont exist anymore