clean database

[kakaroto2000]

can someone give me some simple command to delete all accounts created items and things linked accounts?
I used my database for a long time for testing and now this 100% as I wanted, only to have many accounts created. just want to clean WHAT can be cleaned without ruining my database


grateful

[MentaL]

[S37uP!Update]

First of all run this query:

Spoiler:

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].[toolz_vote]

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]

After that you must reset the Identify numbers like UserNum, CharIdx, run this query:

Spoiler:

/*Reset Identity on tables with identity column*/
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

First query should do the big part, i used on EPISODE 2 Database, but you can simply search in your DB if there's any table in plus with data in it.
And then just get this as a example:
DELETE FROM [db_name].[dbo].[table_name]
db_name could be : Server01, Account, CabalCash, NetcafeBilling, etc.
table_name could be : cabal_character_table, CashAccount, cabal_inventory_table, cabal _equip_table, etc.

[Drav3n]

why not running the dbo.cleanaccount etc etc. on stored procedure?

[kakaroto2000]

:dddd

[behbeh111]

or re restore the databases. its most simple.

[S37uP!Update]

or re restore the databases. its most simple.

If you do alot of changes in your databases is not so simple, because you have to much to work after that :)

[behbeh111]

If you do alot of changes in your databases is not so simple, because you have to much to work after that :)

its true, i just said easiest solution.

[Ericson Chan]

its true, i just said easiest solution.

restore database easiest solution

[Wataryx23]

why i cant create account USing GM Tools?

how to solve this?