How to easy wipe server

[maziqpl 5]

Hi guys, 

Do you have any tips how to easy wipe (reset server). I mean all tables as characters, items etc. I would like to save spawns. I read about to clean character table in sql but what will hapen with items etc?
Maybe do you have good tips how to do this?

[Vilmis 523]

48 minutes ago, maziqpl said:

Hi guys, 

Do you have any tips how to easy wipe (reset server). I mean all tables as characters, items etc. I would like to save spawns. I read about to clean character table in sql but what will hapen with items etc?
Maybe do you have good tips how to do this?

Hi,
Yes, it might help, then database will do a rest things, but not full, some tables can be stay uncleaned. So, if you want just to save your spawns.  Just create a new database (new name), install clean l2_database.sql and just move most important things like: spawns and custom_spawns, npc and custom_npc and all rest, depending what you want to save.

Later i will create .bat file which could to do this fully or i'm gonna update the code and to clean a characters table would be enough.