- Joined
- Nov 13, 2015
- Messages
- 451
- Reaction score
- 21
I need help when I wipe my database I still have the input password even if new account created how to reset or wipe sub pass?
I need help when I wipe my database I still have the input password even if new account created how to reset or wipe sub pass?
I use query from this forum
can tell me what table should I wipe for account and character include the sub password?
I tried but still same problem
DELETE FROM [Account].[dbo].[cabal_auth_table]
DELETE FROM [Account].[dbo].[cabal_character_count_table]
DELETE FROM [Account].[dbo].[cabal_charge_auth]
DELETE FROM [Account].[dbo].[cabal_hackuser_list]
DELETE FROM [Account].[dbo].[cabal_sub_password_table]
DELETE FROM [Server01].[dbo].[cabal_bbead_table]
DELETE FROM [Server01].[dbo].[cabal_character_table]
DELETE FROM [Server01].[dbo].[cabal_craft_table]
DELETE FROM [Server01].[dbo].[cabal_equipment_table]
DELETE FROM [Server01].[dbo].[cabal_event_partydg]
DELETE FROM [Server01].[dbo].[cabal_event_singledg]
DELETE FROM [Server01].[dbo].[cabal_instantWar_nationRewardWarResults]
DELETE FROM [Server01].[dbo].[cabal_instantWar_results]
DELETE FROM [Server01].[dbo].[cabal_instantWar_statistics]
DELETE FROM [Server01].[dbo].[cabal_Inventory_table]
DELETE FROM [Server01].[dbo].[cabal_qddata_table]
DELETE FROM [Server01].[dbo].[cabal_questdata_table]
DELETE FROM [Server01].[dbo].[cabal_quickslot_table]
DELETE FROM [Server01].[dbo].[cabal_record_combo]
DELETE FROM [Server01].[dbo].[cabal_skilllist_table]
DELETE FROM [Server01].[dbo].[cabal_warehouse_table]
DELETE FROM [Server01].[dbo].[chat_buddy_table]
DELETE FROM [Server01].[dbo].[chat_buddygroup_table]
DELETE FROM [Server01].[dbo].[ChatBlacklist]
DELETE FROM [Server01].[dbo].[deleted_cabal_character_table]
DELETE FROM [Server01].[dbo].[Guild]
DELETE FROM [Server01].[dbo].[GuildGroup]
DELETE FROM [Server01].[dbo].[GuildMember]
DELETE FROM [Server01].[dbo].[Mail]
DELETE FROM [Server01].[dbo].[Mail]
DELETE FROM [CabalCash].[dbo].[CashAccount]
DELETE FROM [CabalCash].[dbo].[CashLog]
DELETE FROM [CabalCash].[dbo].[MyCashItem]
DELETE FROM [CabalCash].[dbo].[MyCashItem]
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'