[Query] Delete all players information

[[Admin] tierrilopes]

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"

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;

 

 

[igoriap]

So corrigir a table account: 

 

TRUNCATE TABLE acount.account;

para:

TRUNCATE TABLE account.account; 

:)