ZinteliZ Posted August 30, 2020 Posted August 30, 2020 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. Quote
0 Poring King Posted August 30, 2020 Posted August 30, 2020 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'; Quote
0 Chaos92 Posted August 30, 2020 Posted August 30, 2020 cleanest way, remove the database (if u didnt use it anymore at all) and create new database+ run all sql scripts again. Quote
Question
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.
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.