Hello, first of all perform a security backup <<<THIS IS VERY IMPORTANT
after that run the following commands to wipe all data excep accounts:
TRUNCATE TABLE `auction`;
TRUNCATE TABLE `cart_inventory`;
TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
TRUNCATE TABLE `elemental`;
TRUNCATE TABLE `friends`;
TRUNCATE TABLE `guild_alliance`;
TRUNCATE TABLE `guild_castle`;
TRUNCATE TABLE `guild_expulsion`;
TRUNCATE TABLE `guild_member`;
TRUNCATE TABLE `guild_position`;
TRUNCATE TABLE `guild_skill`;
TRUNCATE TABLE `guild_storage`;
TRUNCATE TABLE `guild`;
TRUNCATE TABLE `homunculus`;
TRUNCATE TABLE `hotkey`;
TRUNCATE TABLE `interlog`;
TRUNCATE TABLE `inventory`;
TRUNCATE TABLE `ipbanlist`;
TRUNCATE TABLE `mail`;
TRUNCATE TABLE `mapreg`;
TRUNCATE TABLE `memo`;
TRUNCATE TABLE `mercenary_owner`;
TRUNCATE TABLE `mercenary`;
TRUNCATE TABLE `party`;
TRUNCATE TABLE `pet`;
TRUNCATE TABLE `quest`;
TRUNCATE TABLE `sc_data`;
TRUNCATE TABLE `skill_homunculus`;
TRUNCATE TABLE `skill`;
TRUNCATE TABLE `storage`;
if you wish not to delete the characters remove
TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
before running the commands.
hello @sader1992 , how can i clear the ranking? Do you have a specific command? best regards,
