Jump to content
  • 0
zmref

How to properly do a wipe out

Question

8 answers to this question

Recommended Posts

Do you only want to keep login accounts?

Then execute these queries to delete all other information:

TRUNCATE TABLE `auction`;
TRUNCATE TABLE `cart_inventory`;
TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
TRUNCATE TABLE `elemental`;
TRUNCATE TABLE `friends`;
TRUNCATE TABLE `global_reg_value`;
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 `interreg`;
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 `ragsrvinfo`;
TRUNCATE TABLE `sc_data`;
TRUNCATE TABLE `skill_homunculus`;
TRUNCATE TABLE `skill`;
TRUNCATE TABLE `sstatus`;
TRUNCATE TABLE `storage`;
  • Upvote 3
  • Like 1
Link to comment
Share on other sites

  • 0

Update ->
Delete all except login table
 

TRUNCATE TABLE `auction`;
TRUNCATE TABLE `cart_inventory`;
TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
TRUNCATE TABLE `elemental`;
TRUNCATE TABLE `friends`;
TRUNCATE TABLE `acc_reg_num`;
TRUNCATE TABLE `acc_reg_str`;
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`;
TRUNCATE TABLE `mail`;
TRUNCATE TABLE `mail_attachments`;

 

Link to comment
Share on other sites

Do you only want to keep login accounts?

Then execute these queries to delete all other information:

TRUNCATE TABLE `auction`;
TRUNCATE TABLE `cart_inventory`;
TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
TRUNCATE TABLE `elemental`;
TRUNCATE TABLE `friends`;
TRUNCATE TABLE `global_reg_value`;
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 `interreg`;
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 `ragsrvinfo`;
TRUNCATE TABLE `sc_data`;
TRUNCATE TABLE `skill_homunculus`;
TRUNCATE TABLE `skill`;
TRUNCATE TABLE `sstatus`;
TRUNCATE TABLE `storage`;

Hey @Brian this will only delete all items and chars of each account right? is like to reset all the accounts of the server but it wont delete any other files right?

if this is like that can i ask how to run this table please?

 

Edit: Solved, thank you this was awesome.

Edited by eboni001
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.