Query to completely erase all character/account/inventories

[mrpsycho]

hi RZ

i was speaking to chump on irc and he told me to post is here as its a lot of stuff and might also be usefull for some other ppl..

my goal with this would be to erase all the db's of accounts/characters/inventories/items.

why would i want this? because its a handy and easy way to finish my server beta testing and that way i can erase all i gave my testers so i can start the server again keeping all config and edited stuff.

mkay thats all ^^

cheers for the help chumpy btw!

[MentaL]

[phiber]

on character

TRUNCATE TABLE GUILD
	TRUNCATE TABLE GUILDGROUP
	TRUNCATE TABLE GUILDMEMBER	
	TRUNCATE TABLE CHATBUDDY
	TRUNCATE TABLE CHATBUDDYGROUP
	TRUNCATE TABLE CHATBLACKLIST
	TRUNCATE TABLE CABAL_CHARACTER_TABLE
	TRUNCATE TABLE CABAL_EQUIPMENT_TABLE
	TRUNCATE TABLE CABAL_INVENTORY_TABLE
	TRUNCATE TABLE CABAL_QDDATA_TABLE
	TRUNCATE TABLE CABAL_QUESTDATA_TABLE
	TRUNCATE TABLE CABAL_QUICKSLOT_TABLE
	TRUNCATE TABLE CABAL_SKILLLIST_TABLE
	TRUNCATE TABLE CABAL_WAREHOUSE_TABLE
	TRUNCATE TABLE cabal_bbead_table
	TRUNCATE TABLE SPLIT_INVENTORY_TABLE
	TRUNCATE TABLE SPLIT_WAREHOUSE_TABLE
	TRUNCATE TABLE chat_buddy_table
	TRUNCATE TABLE cabal_event_singledg
	TRUNCATE TABLE cabal_craft_table
	TRUNCATE TABLE cabal_event_partydg
	TRUNCATE TABLE cabal_record_combo
	TRUNCATE TABLE deleted_cabal_character_table
	TRUNCATE TABLE chat_buddygroup_table
	TRUNCATE TABLE log_cheat
	TRUNCATE TABLE cabal_instantWar_statistics
	TRUNCATE TABLE Mail
	TRUNCATE TABLE log_nation
	TRUNCATE TABLE CABAL_ITEMSERIAL_TABLE
	
	DECLARE @GROUP INT
	SET @GROUP = 0
	WHILE ( @GROUP <= 32 )
	BEGIN 
		EXEC .MAKE_ITEMSERIAL_BASE @GROUP
		SET  @GROUP  =  @GROUP  + 1
	END

on account

	TRUNCATE TABLE cabal_auth_table
	TRUNCATE TABLE cabal_charge_auth
	TRUNCATE TABLE cabal_character_count_table
	TRUNCATE TABLE cabal_hackuser_list

on cash just delete the table who have items. :p


chears.