Jump to content

[Query] Delete all players information


tierrilopes
 Share

Recommended Posts

Query to delete all information about players, best used before server official opening.

  1. Go to Navicat and double-click no open connection
  2. Press Query (WITHOUT SELECTING ANY DATABASE) in the upper menu
  3. Paste the query bellow
  4. Press "Run"

imagem.png

Query:

Spoiler
TRUNCATE TABLE account.account;
TRUNCATE TABLE common.gmlist;
TRUNCATE TABLE log.attr_transfer;
TRUNCATE TABLE log.bootlog;
TRUNCATE TABLE log.change_name;
TRUNCATE TABLE log.command_log;
TRUNCATE TABLE log.cube;
TRUNCATE TABLE log.dragon_slay_log;
TRUNCATE TABLE log.dragonlair_dungeon;
TRUNCATE TABLE log.exo_bank_log;
TRUNCATE TABLE log.fish_log;
TRUNCATE TABLE log.gmhost;
TRUNCATE TABLE log.gmlist;
TRUNCATE TABLE log.goldlog;
TRUNCATE TABLE log.hack_crc_log;
TRUNCATE TABLE log.hack_log;
TRUNCATE TABLE log.ingame_ban_log;
TRUNCATE TABLE log.levellog;
TRUNCATE TABLE log.locale;
TRUNCATE TABLE log.locale_bug;
TRUNCATE TABLE log.log;
TRUNCATE TABLE log.loginlog;
TRUNCATE TABLE log.loginlog2;
TRUNCATE TABLE log.meley_dungeon;
TRUNCATE TABLE log.money_log;
TRUNCATE TABLE log.okay_event;
TRUNCATE TABLE log.pcbang_loginlog;
TRUNCATE TABLE log.quest_reward_log;
TRUNCATE TABLE log.refinelog;
TRUNCATE TABLE log.sash;
TRUNCATE TABLE log.shout_log;
TRUNCATE TABLE log.speed_hack;
TRUNCATE TABLE log.voucher_log;
TRUNCATE TABLE log.whisper_log;
TRUNCATE TABLE player.affect;
TRUNCATE TABLE player.guild;
TRUNCATE TABLE player.guild_comment;
TRUNCATE TABLE player.guild_grade;
TRUNCATE TABLE player.guild_member;
TRUNCATE TABLE player.guild_war;
TRUNCATE TABLE player.guild_war_bet;
TRUNCATE TABLE player.guild_war_reservation;
TRUNCATE TABLE player.horse_name;
TRUNCATE TABLE player.item;
TRUNCATE TABLE player.item_award;
TRUNCATE TABLE player.marriage;
TRUNCATE TABLE player.messenger_list;
TRUNCATE TABLE player.player;
TRUNCATE TABLE player.player_deleted;
TRUNCATE TABLE player.player_index;
TRUNCATE TABLE player.quest;
TRUNCATE TABLE player.safebox;

 

 

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...