Jump to content
  • 0

[Request] Help with inactive players


Question

Posted

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.

5 answers to this question

Recommended Posts

  • 0
Posted

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'

  • 0
Posted

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...

  • 0
Posted

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.

  • 0
Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...