~ Reset no Banco de Dados

Boas Cyber - Techers
Um pequeno  tutorial de como apagar dados de players mais rapido.
(Reseta apenas dados no Navicat)
Bom é apenas fazer o seguinte vai ate o navicat abre a guia "accont" clique em Query> New Query, dentro cole o seguinte:

DELETE FROM account;
DELETE FROM achievementshop_items;
DELETE FROM ban_log;
DELETE FROM bank;
-
Obs: em algumas files ainda nao tem o sistema "achievement" então ignore a linha.
-
Agora na tabela "player" o mesmo processo clica em Query> New Querydentro cole o seguinte:

DELETE FROM player;
DELETE FROM item;
DELETE FROM achievementshop_items;
DELETE FROM affect;
DELETE FROM guild_member;
DELETE FROM guild_grade;
DELETE FROM guild_comment;
DELETE FROM player_deleted;
DELETE FROM player_index;
DELETE FROM quest;
DELETE FROM safebox;
DELETE FROM new_petsystem;
DELETE FROM offline_shop_item;
DELETE FROM offline_shop_npc;
DELETE FROM change_empire;
DELETE FROM horse_name;
DELETE FROM land;
DELETE FROM marriage;
DELETE FROM messenger_list;
DELETE FROM monarch;
DELETE FROM monarch_candidacy;
DELETE FROM monarch_election;
DELETE FROM banword;
DELETE FROM guild;
DELETE FROM guild_war;
DELETE FROM guild_war_reservation;
-
Obs: Como citado acima acima talvez alguns sistemas nao tenham sido implementado caso o navicat apresente o error "[Err] 1146 - Table 'tabela.x' doesn't exist" ou algo do tipo quer dizer que a tabela nao existe então pule a linha. (Possivelmente as tabelas que nao existem "achievementshop_items" "new_petsystem" "offline_shop_item" "offline_shop_npc")
-
Agora na tabela "common" o mesmo processo clica em Query> New Querydentro cole o seguinte:

DELETE FROM gmlist;

Obs: Essa tabela eh de GM caso por algum motivo não saiba adicionar conta GM no game não delete as tabelas "gmlist" "player" "player_index" "account" apague manualmente as contas.


- Creditos Cyber-Games