Jump to content
  • 0

[Help] Request SQL Query code


Kadaritas
 Share

Question

Hi guys, I have a request because I didn't find it anywhere, I need an SQL query code to delete characters and accounts who have been inactive for 1 month and all their data from the l2jdb, can someone help me?. Thanks in advance!!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Delete from Server All Data of Character that is not active more then 1 month.

Code:

 

DELETE FROM characters WHERE lastAccess < 155520000;

DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

 

Here you are my friend!

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock