Database wipe

[luis R]

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?

[MentaL]

[HeLLF]

google.com bro

[Dens666]

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?

How did you clean the database?
Using stored procedures?

[luis R]

I use query from this forum

- - - Updated - - -

can tell me what table should I wipe for account and character include the sub password?

[Dens666]

I use query from this forum

- - - Updated - - -

can tell me what table should I wipe for account and character include the sub password?

I still don't know which query u have used.
exec Account.dbo.clean_account
find stored procedure for all other databases they are smilar to this one.

[luis R]

I tried but still same problem

[Dens666]

I tried but still same problem

So you have tried it wrong.
I told you have to use it for every database but find correct procedure.

[xFly]

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]

reset usernum / idx

exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

[Dens666]

Do not clean it by this way, its kinda brute-force.
Use already existing stored procedures lol...
In every database u got them, they have similar name like.
dbo.clean_account, dbo.clean_server01 etc...