Advertisement
Reynald0

L2jFrozen_1132_wipe

Jan 4th, 2018
365
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.88 KB | None | 0 0
  1. TRUNCATE TABLE accounts;
  2. TRUNCATE TABLE auction_bid;
  3. TRUNCATE TABLE auction_watch;
  4. TRUNCATE TABLE augmentations;
  5. TRUNCATE TABLE boxaccess;
  6. TRUNCATE TABLE boxes;
  7. TRUNCATE TABLE castle_doorupgrade;
  8. TRUNCATE TABLE castle_manor_procure;
  9. TRUNCATE TABLE castle_manor_production;
  10. TRUNCATE TABLE character_friends;
  11. TRUNCATE TABLE character_hennas;
  12. TRUNCATE TABLE character_macroses;
  13. TRUNCATE TABLE character_offline_trade;
  14. TRUNCATE TABLE character_offline_trade_items;
  15. TRUNCATE TABLE character_quests;
  16. TRUNCATE TABLE character_raid_points;
  17. TRUNCATE TABLE character_recipebook;
  18. TRUNCATE TABLE character_recommends;
  19. TRUNCATE TABLE character_shortcuts;
  20. TRUNCATE TABLE character_skills;
  21. TRUNCATE TABLE character_skills_save;
  22. TRUNCATE TABLE character_subclasses;
  23. TRUNCATE TABLE characters;
  24. TRUNCATE TABLE characters_custom_data;
  25. TRUNCATE TABLE clan_data;
  26. TRUNCATE TABLE clan_notices;
  27. TRUNCATE TABLE clan_privs;
  28. TRUNCATE TABLE clan_skills;
  29. TRUNCATE TABLE clan_subpledges;
  30. TRUNCATE TABLE clan_wars;
  31. TRUNCATE TABLE clanhall_functions;
  32. TRUNCATE TABLE cursed_weapons;
  33. TRUNCATE TABLE engraved_items;
  34. TRUNCATE TABLE engraved_log;
  35. TRUNCATE TABLE fortsiege_clans;
  36. TRUNCATE TABLE games;
  37. TRUNCATE TABLE grandboss_list;
  38. TRUNCATE TABLE heroes;
  39. TRUNCATE TABLE items;
  40. TRUNCATE TABLE itemsonground;
  41. TRUNCATE TABLE l2votes;
  42. TRUNCATE TABLE merchant_lease;
  43. TRUNCATE TABLE mods_buffer_schemes;
  44. TRUNCATE TABLE mods_wedding;
  45. TRUNCATE TABLE olympiad_nobles;
  46. TRUNCATE TABLE olympiad_nobles_eom;
  47. TRUNCATE TABLE paystream;
  48. TRUNCATE TABLE pets;
  49. TRUNCATE TABLE pkkills;
  50. TRUNCATE TABLE posts;
  51. TRUNCATE TABLE quest_global_data;
  52. TRUNCATE TABLE rebirth_manager;
  53. TRUNCATE TABLE seven_signs;
  54. TRUNCATE TABLE seven_signs_status;
  55. TRUNCATE TABLE siege_clans;
  56. TRUNCATE TABLE smsonline;
  57. TRUNCATE TABLE temporaryobjecttable;
  58. TRUNCATE TABLE topic;
  59. UPDATE clanhall SET ownerId=0;
  60. UPDATE seven_signs_festival SET members='';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement