Doubt, Database

[ZinteliZ]

There is a Query to erase all my database, it is to do the famous Reset and I do not want them to keep anything they have in their accounts.

Regards and thanks from now.

[Poring King]

5 hours ago, ZinteliZ said:

There is a Query to erase all my database, it is to do the famous Reset and I do not want them to keep anything they have in their accounts.

Regards and thanks from now.

Do you mean properly wipe out ? I did not add the login for safety

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`;
TRUNCATE TABLE 'mail';
TRUNCATE TABLE 'mail_attachments';

 

[Chaos92]

cleanest way, remove the database (if u didnt use it anymore at all) and create new database+ run all sql scripts again.