Wiping

[OMEGAbuffer]

Does anyone have like a procedure or a query that would wipe everything?(Accounts, Characters, NP, Clans, Capes, all that fun stuff?)

Or can someone teach me how?

 

[spamman]

truncate table account_char
truncate table knights
truncate table knights_user
truncate table king_ballot_box
truncate table KING_CANDIDACY_NOTICE_BOARD
truncate table king_election_list
truncate table king_system
truncate table userdata
truncate table warehouse
truncate table hacktool_userlog
truncate table hero_user
truncate table PROGRAM_CHECK_USERLOG
truncate table rental_item
truncate table rental_item_list
truncate table term_item
truncate table user_rental_item
truncate table USER_SAVED_MAGIC
truncate table userdata_skillshortcut
truncate table web_itemmall
truncate table web_itemmall_log
truncate table user_knights_rank
truncate table user_personal_rank
truncate table user_mannerpoint_rank
truncate table knights_alliance
truncate table friend_list
truncate table BK_FRI_USERDATA
truncate table BK_SAT_USERDATA
truncate table BK_SUN_USERDATA
truncate table BK_MON_USERDATA
truncate table BK_TUE_USERDATA
truncate table BK_WED_USERDATA
truncate table BK_THU_USERDATA
truncate table BK_FRI_WAREHOUSE
truncate table BK_SAT_WAREHOUSE
truncate table BK_SUN_WAREHOUSE
truncate table BK_MON_WAREHOUSE
truncate table BK_TUE_WAREHOUSE
truncate table BK_WED_WAREHOUSE
truncate table BK_THU_WAREHOUSE

I think that's all of them. try that out.

 

[OMEGAbuffer]

Thanks

 

[blazekilla]

hi i have an issue with the king system when i use those commands it causes eben to give debug error but then when i restore db its fine any help with this would be great b/c right now king system not working

 

[melo717171]

CODE > truncate table XXX
go < CODE

this is simple wiping template in query.
xxx : table that you'll wipe.

 

[blazekilla]

CODE > truncate table XXX
go < CODE

this is simple wiping template in query.
xxx : table that you'll wipe.

i've tried that i get an error with eben eveytime and i have to restore back anything else i can do to fix my king system ?