[Tutorial] Zerando sua database 100% seguro e sem erros

MasterKr

Legendário XPZ
26 de Setembro de 2009
1,572
31
48
31
www.masterkrgames.com
[Tutorial] Zerando sua database 100% seguro e sem erros    <blockquote> Bom galera como muitos sabem, em praticamente todos os

server files de 2Moons/Dekaron, as databases vem lotadas de contas

e personagens, dentre outras coisas, facilitando para aqueles "fuçadores"

criar/logar-se na respectiva conta e pegar um personagem cheio de itens e fodástico.

Para evitar que isso ocorra, existe uma query desenvolvida por meio de vários estudos

por cientistas da NASA, matemáticos e físicos da MIT,
enfim, vamos ao que interessa.

[AVISO IMPORTANTE!]



Esse método irá limpar completamente sua database, ou seja,

todas suas modificações/informações de contas, siege, guild,

cash, personagens e todo o resto será apagado

permanentemente.



[1] Primeiramente abra o SQL Query Analyzer:

[2] Copie e cole o código a seguir:

[pre]USE [Account]; DELETE FROM C_IP_BAN; DELETE FROM C_IP_PERMIT; DELETE FROM C_IP_PWD; DELETE FROM C_LOGINIPBLOCK_LOG; DELETE FROM C_SEQUENCE; DELETE FROM CP_USER_PROFILE; DELETE FROM MB_USR_IP; DELETE FROM MB_USR_PUN; DELETE FROM Tbl_user; DELETE FROM USER_CONNLOG_KEY; DELETE FROM USER_PROFILE; GO USE [billing]; DELETE FROM bl_error_log; DELETE FROM c_sequence; DELETE FROM dba_online_daily; DELETE FROM dba_online_daily_notok; DELETE FROM Tbl_KeepId; DELETE FROM user_account; DELETE FROM user_account; DELETE FROM user_charge_log; DELETE FROM user_everyday_use_info; DELETE FROM user_give_log; DELETE FROM user_use_log; DELETE FROM user_use_log_bk; GO USE [Cash]; DELETE FROM bl_error_log; DELETE FROM Tbl_Cash_zj; DELETE FROM user_cash; DELETE FROM user_charge_log; DELETE FROM user_use_log; GO USE [Character]; DELETE FROM C_EVENT_ITEM_OP DELETE FROM c_restword; DELETE FROM char_connlog; DELETE FROM CHAR_CONNLOG_KEY; DELETE FROM DEL_USER_CHAR_LIST; DELETE FROM DEL_USER_CHAR_LIST_SECEDE; DELETE FROM GM_ITEM_MST; DELETE FROM GUILD_CHAR_INFO; DELETE FROM GUILD_INFO WHERE guild_code NOT LIKE 'MASTERCODE'; DELETE FROM GUILD_INFO_SECEDE; DELETE FROM GUILD_PEERAGE WHERE guild_code NOT LIKE 'MASTERCODE'; DELETE FROM MSSNGR_CHAR_LIST; DELETE FROM SIEGE_INFO; DELETE FROM SIEGE_RESULT_LOG; DELETE FROM user_bag WHERE character_no NOT LIKE 'DEKARON_000001'; DELETE FROM user_bag_copy; DELETE FROM user_bag_secede; DELETE FROM user_character WHERE character_no NOT LIKE 'DEKARON_000001'; DELETE FROM user_character_secede; DELETE FROM USER_POSTBOX; DELETE FROM USER_POSTBOX_SECEDE; DELETE FROM User_Quest_Doing; DELETE FROM user_quest_doing_secede; DELETE FROM User_Quest_Done; DELETE FROM user_quest_done_secede; DELETE FROM user_skill WHERE character_no NOT LIKE 'DEKARON_000001'; DELETE FROM user_skill_secede DELETE FROM user_slot WHERE character_no NOT LIKE 'DEKARON_000001'; DELETE FROM user_storage; DELETE FROM user_storage_copy; DELETE FROM USER_STORE; DELETE FROM USER_STORE_copy; DELETE FROM USER_STORE_SECEDE; DELETE FROM user_suit WHERE character_no NOT LIKE 'DEKARON_000001'; DELETE FROM user_suit_copy; DELETE FROM user_suit_secede; GO[/pre]
[3] Clique em Parse Query (Ctrl + F5) para verificar o código e logo em seguida Execute Query (F5)

[4] Pronto sua database está completamenta livre de contas e personagens desnecessários.

[Créditos]



@ Zombe pela Query 

@ C3PO pela revisão/teste e compartilhar aqui.

O post foi útil? Então comente e acima de tudo agradeça.   
Você não tem permissão para ver o link. Faça o login ou registre-se agora.
 

</blockquote>